This Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) is best a combination of Microsoft Excel Beginners , Intermediate and Advanced which is designed to make the most in-depth, bestselling value for money Complete Excel Course on the market and you are getting this best selling course on only £25!
Microsoft Excel is one of the most widely used programmes in the world for visualising and analysing. This software is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualise data, and innumerable other tasks.
As you participate in each of the 3 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
You can learn at your own pace, as there is no time limit, nor deadline to complete the courses. You can access the course material with any device that allows you to access the internet, and you will receive online support while you train, which means it is available whenever and wherever you require it.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace.
Key features of the course:
- Lifetime access to the course
- No hidden fees, only pay the price of the course which includes exam fees.
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Affordable and engaging e-learning study materials
- Study at your own pace from tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Assessment and Certification
The course is assessed online with a multiple-choice test, which is marked automatically. You will know instantly whether you have passed or not. Those who pass this test will have the qualification of Microsoft Excel Complete Course (Beginner, Intermediate, Advanced). Certificate will be produced in PDF format at an additional cost of £8.99 and Printed Hardcopy at £12.99.
|Microsoft Excel Beginners|
|Getting Started with Microsoft Office Excel 2016|
|Navigate the Excel User Interface||FREE||00:28:00|
|Use Excel Commands||00:10:00|
|Create and Save a Basic Workbook||00:19:00|
|Enter Cell Data||00:12:00|
|Use Excel Help||00:05:00|
|Create Worksheet Formulas||00:15:00|
|Reuse Formulas and Functions||00:17:00|
|Modifying a Worksheet|
|Insert, Delete, and Adjust Cells, Columns, and Rows||00:10:00|
|Search for and Replace Data||00:09:00|
|Use Proofing and Research Tools||00:07:00|
|Formatting a Worksheet|
|Apply Text Formats||00:17:00|
|Apply Number Format||00:08:00|
|Align Cell Contents||00:09:00|
|Apply Styles and Themes||00:12:00|
|Apply Basic Conditional Formatting||00:11:00|
|Create and Use Templates||00:07:00|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:08:00|
|Configure Headers and Footers||00:07:00|
|Manage Workbook and Worksheet Views||00:07:00|
|Manage Workbook Properties||00:05:00|
|Microsoft Excel Intermediate|
|Working with Functions|
|Work with Ranges||FREE||00:18:00|
|Use Specialized Functions||00:11:00|
|Work with Logical Functions||00:23:00|
|Work with Date & Time Functions||00:08:00|
|Work with Text Functions||00:11:00|
|Working with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|Create and Modify Tables||00:15:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:05:00|
|Visualizing Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:12:00|
|Using PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:07:00|
|Filter Data by Using Timelines and Slicers||00:11:00|
|Microsoft Excel Advanced|
|Working with Multiple Worksheets and Workbooks|
|Use Links and External References||FREE||00:12:00|
|Use 3-D References||00:06:00|
|Using Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:12:00|
|Watch and Evaluate Formulas||00:08:00|
|Sharing and Protecting Workbooks|
|Collaborate on a Workbook||00:19:00|
|Protect Worksheets and Workbooks||00:08:00|
|Automating Workbook Functionality|
|Apply Data Validation||00:13:00|
|Search for Invalid Data and Formulas with Errors||00:04:00|
|Work with Macros||00:18:00|
|Creating Sparklines and Mapping Data|
|Determine Potential Outcomes Using Data Tables||00:08:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:05:00|
|Mock Exam- Microsoft Excel Complete Course (Beginner, Intermediate, Advanced)||00:30:00|
|Final Exam- Microsoft Excel Complete Course (Beginner, Intermediate, Advanced)||00:30:00|