Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
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!Â
Â
The learners have to successfully complete the assessment of this course to achieve the CPD 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.
Â
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 | ||
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 | ||
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 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17: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 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:09:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05: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 | |||
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 | ||
Analyzing Data | |||
Apply Intermediate Conditional Formatting | 00:07:00 | ||
Apply Advanced Conditional Formatting | 00:05:00 | ||
Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
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 | ||
Consolidate Data | 00:05:00 | ||
Using Lookup Functions and Formula Auditing | |||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09: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 | |||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
Forecasting 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 | ||
Excel Templates | |||
Excel Templates | 00:00:00 | ||
Resources | |||
Microsoft Excel 2019 | 00:00:00 | ||
Mock Exam | |||
Mock Exam – Microsoft Excel 2019 | 00:20:00 | ||
Final Exam | |||
Final Exam – Microsoft Excel 2019 | 00:20:00 |
3699
4.5
£25
3629
4.7
£25