• LOGIN
  • No products in the basket.

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
Review

COURSE REVIEWS

Course Reviews

4.9

4.9
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

microsoft office essentials - 3 course bundle
£25.00 TAKE THIS COURSE
  • 1 year
  • Number of Units73
  • Number of Quizzes0
  • 10 hours, 39 minutes

Let your e-learning become a life changing experience with the health, therapy and fitness courses from the Academy for Health & Fitness.

163 City Road, London, England, EC1V 1NR
02037446845
info@hfonline.org

Validate Your Certificate

top
COPYRIGHT © 2023 ACADEMY FOR HEALTH & FITNESS. ALL RIGHTS RESERVED.