• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Office Essentials - 3 Course Bundle

Microsoft Office Essentials - 3 Course Bundle

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 11 hours

  • All levels

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

11 CPD hours / points Accredited by CPD Quality Standards

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.

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.

Certificates

CPD Accredited Certificate

Digital certificate - Included

CPD Accredited Certificate

Hard copy certificate - £29

About The Provider

Tags

Reviews