Microsoft Excel is the world’s leading spreadsheet, used for carrying out a vast range of office administrative duties. This program allows you to automate tasks, manage and present data, make calculations, and much more. To stand out to prospective employers, aspiring professionals must have excellent proficiency in Excel. It is easy to get a solid understanding from Beginner to Advanced level key functions from this Microsoft Excel Course.
The Complete Microsoft Excel : Beginner to Advanced Training course, is the ultimate training program for anyone looking to develop their administrative skills in Excel. Designed for learners of all levels, it covers key topics such as how to create worksheet formulas, modify tables, and use macros – with step-by-step guidance. You will learn how to navigate the Excel user interface and use Excel commands with confidence, sort and filter data and automate everyday work tasks.
In addition, this course will walk you through each feature of Excel 2019, developing your proficiency and skill to take you from complete beginner to expert in no time. For instance, gain valuable transferable skills required for roles. After that, get a certificate in just 20/30 hours.
The course is suitable for both part-time and full-time students. Learn with the freedom to study at your own pace, from any device with an internet connection.
Learning Outcomes of Complete Microsoft Excel Training:
- Fully familiarise with the new features and functions of Microsoft Excel 2019
- Know how to navigate the Excel user interface and use Excel commands
- Get step-by-step guidance on how to create worksheet formulas and manage workbook properties
- Understand how to insert, delete, and adjust cells, column and rows
- Learn how to apply conditional formatting and work with ranges and charts
- Discover how to sort, filter and query data with database functions
- Understand how to create and modify tables, use lookup functions and apply data validation
- Learn how to automate everyday work tasks using the macro recorder
Assessment and Certification
At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. However, if you fail the exam, you can retake it for £1.99.
Career Path
Lastly, when you have successfully completed this course, you will receive a recognised certificate of achievement. This certificate will add valuable credentials to your CV and boost your earning potential in any administrative role. So, you get the in-demand transferable skills required for a range of professions, such as the following:
- Administrative Assistant
- Data Administrator
- Accountant/Bookkeeper
- Information Analyst
- Data Entry Clerk
In conclusion, a recommendation for you to learn Microsoft Excel: Enrol this Microsoft Excel Course. What are you waiting for?
- 1 year
- Advanced, Beginner, Intermediate
- Course Certificate
- Number of Units73
- Number of Quizzes2
- 11 hours, 32 minutes Gift this course
Course Curriculum
Microsoft Excel 2019 New Features | |||
Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
CONCAT | 00:02:00 | ||
IFS | 00:01:00 | ||
MAXIFS | 00:01:00 | ||
MINIFS | 00:01:00 | ||
SWITCH | 00:02:00 | ||
TEXTJOIN | 00:01:00 | ||
Map Chart | 00:02:00 | ||
Funnel Chart | 00:01:00 | ||
Better Visuals | 00:06:00 | ||
Pivot Table Enhancements | 00:02:00 | ||
Power Pivot Updates | 00:01:00 | ||
Beginner Level | |||
Navigate the Excel User Interface | 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 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
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 | ||
Apply Text Formats | 00:17:00 | ||
Apply Number Formats | 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 Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:05:00 | ||
Intermediate Level | |||
Work with Ranges | 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 | ||
Sort Data | 00:10:00 | ||
Filter Data | 00:10:00 | ||
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 | ||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features | 00:12:00 | ||
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 | ||
Advanced Level | |||
Use Links and External References | 00:12:00 | ||
Use 3-D References | 00:06:00 | ||
Consolidate Data | 00:05:00 | ||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09:00 | ||
Watch and Evaluate Formulas | 00:08:00 | ||
Collaborate on a Workbook | 00:19:00 | ||
Protect Worksheets and Workbooks | 00:08:00 | ||
Apply Data Validation | 00:13:00 | ||
Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
Work with Macros | 00:18:00 | ||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
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 | |||
Mock Exam- Complete Microsoft Excel : Beginner to Advanced Training | 00:20:00 | ||
Final - Exam | |||
Final Exam- Complete Microsoft Excel : Beginner to Advanced Training | 00:20:00 | ||
Order your Certificate | |||
Order your Certificate | 00:00:00 | ||
Give us your Feedback | |||
Feedback Form | 00:00:00 |
Course Ratings
No Ratings found for this course.