Get Lifetime Access to This Course & 1900+ Others for Only £149. Subscribe Now
Overview
Learn new skills and develop your professional knowledge with the Microsoft Office Essentials – 3 Course Bundle and learn from home at a pace that suits you. The Microsoft Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle, you will have full course access for one year, meaning you are free to complete the Microsoft Office Essentials – 3 Course Bundle at a pace that suits you. Enrol on the Microsoft Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle, you can be sure of quick and comprehensive assistance whenever you need it.
Enrol now on the Microsoft Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle?
- Get full tutor support and learning assistance
- Complete the Microsoft Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle.
Enrol on the Microsoft Office Essentials – 3 Course Bundle and learn a new professional skill from anywhere, at any time!
Requirements
Enrol on the Microsoft Office Essentials – 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials – 3 Course Bundle 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 Office Essentials – 3 Course Bundle online from your computer, tablet, or smartphone, and learn in a way that suits you.
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 | ||
| 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 | |||
| Resources – Microsoft Office Essentials – 3 Course Bundle | 00:00:00 | ||
| Certificate | |||
| Order Your Certificate. | 00:00:00 | ||
COURSE REVIEWS
Course Reviews
No Reviews found for this course.
- 1 year
- Number of Units73
- Number of Quizzes0
- 10 hours, 39 minutes Gift this course
COPYRIGHT © 2023 - ACADEMY FOR HEALTH & FITNESS TRADING AS MAYFAIR COLLEGE LTD (Company number 12389626). ALL RIGHTS RESERVED.