This Microsoft Excel 2019 online training bundle has been designed by industry experts and will give you an in-depth understanding of this topic. The Microsoft Excel 2019 bundle features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.
If you want to work in this rapidly growing sector and stand out from the competition, then our Microsoft Excel 2019 bundle is the perfect place to kickstart your dream career.
On the Microsoft Excel 2019 bundle, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you’ll achieve after completing the Microsoft Excel 2019 bundle will help you land the job you want in a related field.
Enjoy a pleasant and professional 100% online learning experience and enrol in our Microsoft Excel 2019 today and take control of your career!
Course Curriculum:
Here is a curriculum breakdown of the Microsoft Excel 2019 course:
***Microsoft Excel 2019 Introduction***
Microsoft Excel - Introduction
- Microsoft Excel - Introduction
Microsoft Excel - Section 01
- Microsoft Excel - What is Excel
- Microsoft Excel - Opening Excel
- Microsoft Excel - Navigating the Excel User Interface
- Microsoft Excel - Using the Excel Ribbon
Microsoft Excel - Section 02
- Microsoft Excel - Creating a New Workbook
- Microsoft Excel - Creating Workbooks Using Templates
- Microsoft Excel - Saving an Excel Workbook
- Microsoft Excel - Using the Accessibility Checker
Microsoft Excel - Section 03
- Microsoft Excel - Navigating a Worksheet by Mouse or Keyboard
- Microsoft Excel - Understanding Excel Data Types
- Microsoft Excel - Using the Inking Tools
- Microsoft Excel - Using the Autofill Handle
- Microsoft Excel - Using Flash Fill
Microsoft Excel - Section 04
- Microsoft Excel - What are Formulas and Functions
- Microsoft Excel - Understanding the Components of a Formula
- Microsoft Excel - Using Cell References
- Microsoft Excel - Using the Quick Analysis Tools
Microsoft Excel - Section 05
- Microsoft Excel - Modifying Columns and Rows
- Microsoft Excel - Hiding and Unhiding Columns and Rows
Microsoft Excel - Section 06
- Microsoft Excel - Formatting and Aligning Data
- Microsoft Excel - Merging Data
- Microsoft Excel - Using the Format Painter
- Microsoft Excel - Removing Formatting Quickly
Microsoft Excel - Section 07
- Microsoft Excel - Using Cell Styles
- Microsoft Excel - Applying Themes
Microsoft Excel - Section 08
- Microsoft Excel - Working with 3-D Models
- Microsoft Excel - Inserting Screenshots
- Microsoft Excel - Inserting Hyperlinks
- Microsoft Excel - Arranging Objects
Microsoft Excel - Section 09
- Microsoft Excel - Using Find and Replace
- Microsoft Excel - Using Go To and Go To Special
- Microsoft Excel - Using the Spell Checker
Microsoft Excel - Section 10
- Microsoft Excel - Printing and Previewing Excel Files
- Microsoft Excel - Creating Custom Margins and Scaling
- Microsoft Excel - Adding Headers and Footers
- Microsoft Excel - Exporting to PDF and XPS
Microsoft Excel - Section 11
- Microsoft Excel - Renaming and Coloring Worksheet Tabs
- Microsoft Excel - Adding, Deleting, and Navigating Worksheets
Microsoft Excel - Section 12
- Microsoft Excel - Viewing Workbooks
- Microsoft Excel - Using Zoom Tools
- Microsoft Excel - Configuring Sheet Options
- Microsoft Excel - Working with Window Commands
- Microsoft Excel - Adjusting Workbook Properties
Microsoft Excel - Recap
***Microsoft Excel 2019 Intermediate***
Microsoft Excel - Introduction
- Microsoft Excel - Introduction
Microsoft Excel - Section 01
- Microsoft Excel - Linking Worksheets and Workbooks
- Microsoft Excel - Linking Worksheets with 3D References
- Microsoft Excel - Understanding the Consolidate Feature
Microsoft Excel - Section 02
- Microsoft Excel - What are Range Names
- Microsoft Excel - Creating Range Names Using Create from Selection
Microsoft Excel - Section 03
- Microsoft Excel - Sorting Lists
- Microsoft Excel - Filtering Lists
Microsoft Excel - Section 04
- Microsoft Excel - Formatting a Table
- Microsoft Excel - Filtering with Slicers
- Microsoft Excel - Calculating with Tables
Microsoft Excel - Section 05
- Microsoft Excel - What is Conditional Formatting
- Microsoft Excel - Using Custom Fonts and Colors
Microsoft Excel - Section 06
- Microsoft Excel - What are Charts
- Microsoft Excel - Forecasting with Trendlines
- Microsoft Excel - Creating a Chart Template
- Microsoft Excel - Creating Charts
- Microsoft Excel - Modifying Chart Elements
Microsoft Excel - Section 07
- Microsoft Excel - What is a PivotTable
- Microsoft Excel - Creating a PivotTable
- Microsoft Excel - Creating a PivotChart
Microsoft Excel - Section 08
- Microsoft Excel - Adding a Calculated Field
- Microsoft Excel - Adding a Calculated Item
Microsoft Excel - Recap
***Microsoft Excel 2019 Advanced***
Microsoft Excel - Introduction
- Microsoft Excel - Introduction
Microsoft Excel - Section 01
- Microsoft Excel - Customizing the Ribbon
- Microsoft Excel - Customizing the Save Defaults
Microsoft Excel - Section 02
- Microsoft Excel - Understanding IF Functions
- Microsoft Excel - Creating a Nested IF Function
- Microsoft Excel - Using the IFS Function
Microsoft Excel - Section 03
- Microsoft Excel - Using VLOOKUP
- Microsoft Excel - Using HLOOKUP
- Microsoft Excel - Using VLOOKUP with TRUE
Microsoft Excel - Section 04
- Microsoft Excel - Using Text to Columns
- Microsoft Excel - Using Left Right and Mid
- Microsoft Excel - Using the LEN Function
Microsoft Excel - Section 05
- Microsoft Excel - What are Date and Time Functions
- Microsoft Excel - Using TODAY, NOW, and DAY Functions
Microsoft Excel - Section 06
- Microsoft Excel - Showing Formulas
- Microsoft Excel - Error Checking
Microsoft Excel - Section 07
- Microsoft Excel - Using the Scenario Manager
- Microsoft Excel - Using Goal Seek
- Microsoft Excel - Analyzing with Data Tables
Microsoft Excel - Section 08
- Microsoft Excel - Understanding Protection
- Microsoft Excel - Encrypting Files with Passwords
Microsoft Excel - Section 09
- Microsoft Excel - What are Macros
- Microsoft Excel - Running a Macro
Microsoft Excel - Section 10
- Microsoft Excel - What are Form Controls
- Microsoft Excel - Adding a Combo Box
Microsoft Excel - Section 11
- Microsoft Excel - Composing Error Alerts
- Microsoft Excel - Finding Invalid Data
Microsoft Excel - Section 1
- Microsoft Excel - Sharing a Workbook
- Microsoft Excel - Sharing Files
Microsoft Excel - Section 13
- Microsoft Excel - Importing a Text File
- Microsoft Excel - Exporting Data to a Text File
Microsoft Excel - Recap
Method of Assessment
Students will have to take automated multiple-choice exams for the following courses to successfully complete the Microsoft Excel 2019 bundle. The exams will be online and you will need to score 60% or above in order to pass. After successfully passing each exam, you will be able to apply for your IAO-accredited certificate.
Certificate of Achievement
IAO Accredited Certification from One Education
Once you have finished the Microsoft Excel 2019 bundle, you will be eligible to apply for IAO-accredited certificates for each of the courses inside this bundle as proof of your new skills and your continued professional development. Certification is available in both PDF & hardcopy format, which can be received by paying —
- PDF Certificate: £9
- Hardcopy Certificate (within the UK): £15
- Hardcopy Certificate (international): £15 + £10 (postal charge) = £25
