Description:
In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners – Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Access 2013’s most sophisticated features. If you think you know all you need to know about Access 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Access tips and tricks out there.
Assessment:
- At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
- Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
Certification:
- After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
- Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
Microsoft Office 2013 Excel Beginners – Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
Requirements
Our Microsoft Office 2013 Excel Beginners – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Course Curriculum
| Getting Started with Microsoft Excel 2013 | |||
| Identify the Elements of the Excel Interface | 00:14:00 | ||
| Create a Basic Worksheet | 00:16:00 | ||
| Use the Help System | 00:04:00 | ||
| Performing Calculations | |||
| Create Formulas in a Worksheet | 00:15:00 | ||
| Insert Functions in a Worksheet | 00:13:00 | ||
| Reuse Formulas | 00:15:00 | ||
| Modifying a Worksheet | |||
| Manipulate Data | 00:13:00 | ||
| Insert, Manipulate, and Delete Cells, Columns, and Rows | 00:08:00 | ||
| Search for and Replace Data | 00:12:00 | ||
| Spell Check a Worksheet | 00:06:00 | ||
| Formatting a Worksheet | |||
| Modify Fonts | 00:11:00 | ||
| Add Borders and Color to Cells | 00:10:00 | ||
| Apply Number Formats | 00:10:00 | ||
| Align Cell Contents | 00:10:00 | ||
| Apply Cell Styles | 00:08:00 | ||
| Printing Workbook Contents | |||
| Define the Basic Page Layout for a Workbook | 00:16:00 | ||
| Refine the Page Layout and Apply Print Options | 00:13:00 | ||
| Managing Large Workbooks | |||
| Format Worksheet Tabs | 00:03:00 | ||
| Manage Worksheets | 00:09:00 | ||
| Manage the View of Worksheets and Workbooks | 00:10:00 | ||
| Customizing the Excel Environment | |||
| Customize General and Language Options | 00:08:00 | ||
| Customize Formula Options | 00:04:00 | ||
| Customize Proofing and Save Options | 00:04:00 | ||
| Customize the Ribbon and Quick Access Toolbar | 00:04:00 | ||
| Customize the Functionality of Excel by Enabling Add-Ins | 00:05:00 | ||
| Customize Advanced and Trust Center Options | 00:06:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Office 2013 Excel Beginners – Complete Video Course | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Office 2013 Excel Beginners – Complete Video Course | 00:20:00 | ||
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Course Reviews
No Reviews found for this course.
- PRIVATE
- 1 year
- Beginner
- Number of Units26
- Number of Quizzes2
- 4 hours, 47 minutes