Learn new skills and develop your professional knowledge with Microsoft Excel 2019 and learn from home at a pace that suits you. The Microsoft Excel 2019 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 2019 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 Microsoft Excel 2019, you will have full course access for one year, meaning you are free to complete the Microsoft Excel 2019 at a pace that suits you. Enrol on Microsoft Excel 2019 now and start studying using any internet-enabled device including computers, tablets, and smartphones.
With 24/7 student support offered to you on Microsoft Excel 2019, you can be sure of quick and comprehensive assistance whenever you need it.
Enrol now on Microsoft Excel 2019 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 2019?
- Efficient assessment system with instant results
- Get full tutor support and learning assistance
- Complete the Microsoft Excel 2019 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
The learners have to successfully complete the assessment of this course to achieve the CPD, CMA & IAO accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
Who Is This Course For?
The Microsoft Excel 2019 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 Microsoft Excel 2019.
Enrol on Microsoft Excel 2019 and learn a new professional skill from anywhere, at any time!
Enrol on the Microsoft Excel 2019 with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Excel 2019 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 2019 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|
|Microsoft Excel 2019||00:00:00|
|Mock Exam – Microsoft Excel 2019||00:20:00|
|Final Exam – Microsoft Excel 2019||00:20:00|
No Reviews found for this course.