Microsoft Office Essentials - 3 Course Bundle

Description

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

CPD

Who is this course for?

Requirements

Certificates