Booking options
£12
£12
On-Demand course
11 hours
All levels
The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs.
Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it.
Why Choose Microsoft Office Essentials - 3 Course Bundle?
Opportunity to boost your CV/Resume with CPD accredited proficiency
Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery)
Certificates available in both PDF and hard copy format
Interactive, high-quality course content with 24/7 online access
Full tutor support and learning assistance included
Course Curriculum Breakdown:
Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course:
Microsoft Excel 2022 New Features
Introduction to Microsoft Excel 2019 New Features
CONCAT
IFS
MAXIFS
MINIFS
SWITCH
TEXTJOIN
Map Chart
Funnel Chart
Better Visuals
Pivot Table Enhancements
Power Pivot Updates
Getting Started with Microsoft Office Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
Formatting a Worksheet
Apply Text Formats
Apply Number Format
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties
Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions
Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data
Analyzing Data
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features
Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Creating Sparklines and Mapping Data
Create Sparklines
MapData
Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends
Excel Templates
Excel Templates
11 CPD hours / points Accredited by CPD Quality Standards
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 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.
CPD Accredited Certificate
Digital certificate - Included
CPD Accredited Certificate
Hard copy certificate - £29