• LOGIN
  • No products in the basket.

Course Overview

Learn how to make a genuine difference in your life by taking our popular Microsoft Excel 2019 – Beginner To Advance. Our commitment to online learning and our technical experience has been put to excellent use within the contents of these educational modules. By enrolling today, you can take your knowledge of Microsoft Excel 2019 – Beginner To Advance
to a whole new level and quickly reap the rewards of your study in the field you have chosen.

We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.

Please note that Microsoft Excel 2019 – Beginner To Advance provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practices. Always check details with the appropriate authorities or management.

Learning Outcomes

  • Instant access to verified and reliable information
  • Participation in inventive and interactive training exercises
  • Quick assessment and guidance for all subjects
  • CPD accreditation for proof of acquired skills and knowledge
  • Freedom to study in any location and at a pace that suits you
  • Expert support from dedicated tutors committed to online learning

Your Path to Success

By completing the training in Microsoft Excel 2019 – Beginner To Advance you will be able to significantly demonstrate your acquired abilities and knowledge of  Microsoft Excel 2019 – Beginner To Advance. This can give you an advantage in career progression, job applications, and personal mastery in this area.

Is This Course Right for You?

This course is designed to provide an introduction to Microsoft Excel 2019 – Beginner To Advance and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported and it can take just 20 to 30 hours to gain accreditation, with study periods being entirely customisable to your needs.

Assessment Process

Once you have completed all the modules in the Microsoft Excel 2019 – Beginner To Advance course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

Show off Your New Skills with a Certification of Completion

The learners have to successfully complete the assessment of this Microsoft Excel 2019 – Beginner To Advance course to achieve the CPD & IAO accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.

Course Curriculum

Downloadable Resources
Resources – Microsoft Excel 2019 – Beginner to Advance 00:00:00
***Excel 2019 Introduction***
Introduction
Introduction 00:01:00
Section 01
What is Excel 00:04:00
Opening Excel 00:07:00
Navigating the Excel User Interface 00:10:00
Using the Excel Ribbon 00:07:00
Understanding Excel Worksheet Components 00:07:00
Using the Backstage View 00:09:00
Section 02
Creating a New Workbook 00:06:00
Creating Workbooks Using Templates 00:03:00
Saving an Excel Workbook 00:05:00
Using the Accessibility Checker 00:04:00
Section 03
Navigating a Worksheet by Mouse or Keyboard 00:05:00
Understanding Excel Data Types 00:06:00
Using the Inking Tools 00:06:00
Working with Cell and Range Addressing 00:03:00
Using various Data Selection Techniques 00:03:00
Working with Common Excel Commands 00:05:00
Using the Autofill Handle 00:04:00
Using Flash Fill 00:02:00
Section 04
What are Formulas and Functions 00:04:00
Understanding the Components of a Formula 00:06:00
Understanding Calculation Hierarchy and the Order of Operations 00:03:00
Creating Basic Formulas 00:03:00
Working with Basic Functions and AutoSum 00:06:00
Using Cell References 00:05:00
Using the Quick Analysis Tools 00:03:00
Section 05
Modifying Columns and Rows 00:06:00
Hiding and Unhiding Columns and Rows 00:04:00
Section 06
Formatting and Aligning Data 00:11:00
Merging Data 00:08:00
Wrapping Text and Adjusting Orientation 00:07:00
Formatting Numbers 00:08:00
Using Borders and Shading 00:07:00
Using the Format Painter 00:04:00
Removing Formatting Quickly 00:05:00
Section 07
Using Cell Styles 00:06:00
Applying Themes 00:04:00
Section 08
Inserting and Formatting Images 00:06:00
Inserting and Formatting Shapes 00:06:00
Inserting and Formatting SmartArt 00:09:00
Working with Icons 00:06:00
Working with 3-D Models 00:05:00
Inserting Screenshots 00:05:00
Inserting Hyperlinks 00:05:00
Inserting Symbols and Equations 00:05:00
Inserting WordArt and Text Boxes 00:08:00
Inserting Other Excel Objects 00:06:00
Arranging Objects 00:05:00
Section 09
Using Find and Replace 00:03:00
Using Go To and Go To Special 00:03:00
Using the Spell Checker 00:05:00
Using the Thesaurus and Translation Features 00:05:00
Section 10
Printing and Previewing Excel Files 00:05:00
Creating Custom Margins and Scaling 00:05:00
Adding Headers and Footers 00:05:00
Exporting to PDF and XPS 00:04:00
Section 11
Renaming and Coloring Worksheet Tabs 00:04:00
Adding, Deleting, and Navigating Worksheets 00:05:00
Section 12
Viewing Workbooks 00:05:00
Using Zoom Tools 00:02:00
Configuring Sheet Options 00:04:00
Using the Freeze Panes and Split Commands 00:06:00
Working with Window Commands 00:03:00
Adjusting Workbook Properties 00:06:00
Recap
Recap 00:01:00
***Excel 2019 Intermediate***
Intro
Introduction 00:01:00
Section 01
Linking Worksheets and Workbooks 00:07:00
Linking Worksheets with 3D References 00:05:00
Understanding the Consolidate Feature 00:06:00
Section 02
What are Range Names 00:06:00
Creating Range Names Using the Name Box and Define Name 00:06:00
Creating Range Names Using Create from Selection 00:03:00
Section 03
Understanding the Differences Between Sorting and Filtering 00:03:00
Sorting Lists 00:07:00
Filtering Lists 00:06:00
Creating Subtotals 00:05:00
Section 04
Creating Tables and Understanding the Benefits 00:06:00
Understanding the Elements of a Table 00:05:00
Formatting a Table 00:05:00
Sorting and Filtering Tables 00:04:00
Filtering with Slicers 00:07:00
Calculating with Tables 00:06:00
Removing Erroneous Table Data 00:05:00
Exporting, Refreshing, and Converting Tables 00:05:00
Section 05
Applying Conditional Formatting to a PivotTable 00:04:00
Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00
Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00
Using Custom Fonts and Colors 00:03:00
Using Custom Conditional Formatting 00:05:00
Modyfing or Removing Conditional Formatting 00:04:00
Section 06
What are Charts 00:06:00
Forecasting with Trendlines 00:05:00
Creating a Chart Template 00:04:00
Displaying Trends with Sparklines 00:08:00
Creating Charts 00:05:00
Understanding Chart Elements 00:05:00
Modifying Chart Elements 00:05:00
Changing and Moving Charts 00:03:00
Filtering a Chart 00:04:00
Formatting Charts 00:13:00
Adjusting Numbering 00:06:00
Creating Dual Axis Charts 00:05:00
Section 07
What is a PivotTable 00:05:00
Creating a PivotTable 00:07:00
Working with the PivotTable Fields Pane 00:10:00
Basic Data Organization and Analysis with PivotTables 00:08:00
Formatting PivotTables 00:05:00
Creating a PivotChart 00:04:00
Modifying and Formatting a PivotChart 00:04:00
Using Slicers and Timeline Slicers 00:08:00
Section 08
Using the PivotTable and PivotChart Wizard 00:03:00
Adding a Calculated Field 00:04:00
Adding a Calculated Item 00:04:00
Applying Conditional Formatting to a PivotTable 00:04:00
Creating Filter Pages for a PivotTable 00:04:00
Enabling the PowerPivot Add-in 00:11:00
Recap
Recap 00:02:00
***Excel 2019 Advanced***
Introduction
Introduction 00:01:00
Section 01
Customizing the Ribbon 00:07:00
Customizing the Quick Access Toolbar 00:05:00
Customizing the General and Formula Options 00:05:00
Customizing the AutoCorrect Options 00:03:00
Customizing the Save Defaults 00:03:00
Customizing Advanced Excel Options 00:03:00
Section 02
Working with Common Logical Functions 00:02:00
Understanding IF Functions 00:03:00
Evaluating Data with the AND Function 00:05:00
Evaluating Data with the OR Function 00:03:00
Creating a Nested IF Function 00:06:00
Using the IFS Function 00:03:00
Summarizing Data with SUMIF 00:04:00
Summarizing Data with AVERAGEIF 00:02:00
Summarizing Data with COUNTIF 00:02:00
Summarizing Data with COUNTIF 00:02:00
Summarizing Data with MAXIFS and MINIFS 00:03:00
Using the IFERROR Function 00:05:00
Section 03
What are Lookup Functions 00:02:00
Using VLOOKUP 00:07:00
Using HLOOKUP 00:02:00
Using VLOOKUP with TRUE 00:04:00
Using HLOOKUP with TRUE 00:01:00
Using the INDEX Function 00:03:00
Using the MATCH Function 00:02:00
Combining INDEX and MATCH 00:05:00
Comparing Two Lists with VLOOKUP and ISNA 00:05:00
Section 04
What are Text Functions 00:02:00
Using Concat Concatenate and Textjoin 00:06:00
Using Text to Columns 00:02:00
Using Left Right and Mid 00:03:00
Using UPPER, LOWER, and PROPER Functions 00:02:00
Using the LEN Function 00:03:00
Using the TRIM Function 00:02:00
Using the SUBSTITUTE Function 00:03:00
Section 05
What are Date and Time Functions 00:01:00
Using TODAY, NOW, and DAY Functions 00:03:00
Using NETWORKDAYS and YEARFRAC Functions 00:04:00
Section 06
Showing Formulas 00:02:00
Tracing Precedents and Dependents 00:03:00
Adding a Watch Window 00:03:00
Error Checking 00:03:00
Section 07
Using The Scenario Manager 00:05:00
Using Goal Seek 00:03:00
Analyzing with Data Tables 00:03:00
Section 08
Understanding Protection 00:03:00
Encrypting Files with Passwords 00:06:00
Allowing Specific Worksheet Changes 00:03:00
Adding Protection to Selected Cells 00:03:00
Section 09
What are Macros 00:03:00
Displaying the Developer Tab 00:03:00
Creating a Basic Formatting Macro 00:07:00
Running a Macro 00:03:00
Assigning a Macro to a Button 00:03:00
Creating Complex Macros and Editing the VBA Code 00:09:00
Adding a Macro to the Quick Access Toolbar 00:02:00
Section 10
What are Form Controls 00:03:00
Adding Spin Buttons and Check Boxes 00:05:00
Adding a Combo Box 00:04:00
Section 11
What is Data Validation 00:02:00
Restricting Data Entry to Whole Numbers 00:02:00
Restricting Data Entry to a List 00:02:00
Restricting Data Entry to a Date 00:02:00
Restricting Data Entry to a Specific Text Length 00:01:00
Composing Input Messages 00:02:00
Composing Error Alerts 00:02:00
Finding Invalid Data 00:02:00
Editing and Deleting Validation Rules 00:02:00
Section 12
Working with Comments 00:03:00
Printing Comments and Errors 00:02:00
Sharing a Workbook 00:03:00
Tracking Changes in a Workbook 00:04:00
Working with Versions 00:02:00
Sharing Files 00:02:00
Section 13
Importing a Text File 00:04:00
Exporting Data to a Text File 00:01:00
Recap
Recap 00:01:00
Review

COURSE REVIEWS

Course Reviews

N.A

0
0 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Microsoft Excel 2019 - Beginner To Advance
PRIVATE PRIVATE COURSE

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.