Learn new skills and develop your professional knowledge with the Microsoft Excel and learn from home at a pace that suits you. The Microsoft Excel has been expertly designed for you to complete through distance e-learning and achieve a professional qualification all without leaving your own home!
Successful completion of the Microsoft Excel will see you achieve a CPD certified qualification which will add significant weight to your CV and impress potential employers when applying for new jobs.
Once you enrol on the Microsoft Excel, you will have full course access for one year, meaning you are free to complete the Microsoft Excel at a pace that suits you. Enrol on the Microsoft Excel now and start studying using any internet-enabled device including computers, tablets, and smartphones.
With 24/7 student support offered to you on the Microsoft Excel, you can be sure of quick and comprehensive assistance whenever you need it.
Enrol now on the Microsoft Excel and get access to top-quality training modules which will cover the essential topics you need to excel in your chosen field and help push you towards your dream job!
Why Choose Microsoft Excel?
- Get full tutor support and learning assistance
- Complete the Microsoft Excel at a pace that suits you
- Gain a professional certified qualification
- Great value, high-quality training course
Showcase Your Accomplishment of New Skills: Get a Certification of Completion
Upon passing the course, you will receive proper certification that is accredited by IAO and CPD and universally accepted. You can order your certificate at a cost of £10 for PDF and £29 for hardcopy certificate or both for £39.
Who Is This Course For?
The Microsoft Excel has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Excel.
Enrol on the Microsoft Excel and learn a new professional skill from anywhere, at any time!
Enrol on the Microsoft Excel with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Excel without any delay.
We only ask that all students have a passion for learning and literacy, and be over the age of 16.
Complete the Microsoft Excel online from your computer, tablet, or smartphone, and learn in a way that suits you.
|Microsoft Excel 2019 New Features|
|Introduction to Microsoft Excel 2019 New Features||00:07:00|
|Pivot Table Enhancements||00:02:00|
|Power Pivot Updates||00:01:00|
|Getting Started with Microsoft Office Excel|
|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|
|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:16: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:08:00|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:09:00|
|Configure Headers and Footers||00:07:00|
|Manage Workbook and Worksheet Views||00:07:00|
|Manage Workbook Properties||00:06:00|
|Working with Functions|
|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|
|Working with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09: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|
|Working with Multiple Worksheets and Workbooks|
|Use Links and External References||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- MS Office 2016 Excel for Beginners||00:20:00|
|Final Exam- MS Office 2016 Excel for Beginners||00:20:00|
No Reviews found for this course.