Course Curriculum Of Microsoft Excel Bundle
** Microsoft Excel 2019 Introduction **
Getting Started
- Microsoft Excel: Introduction
- Microsoft Excel: Navigating the Interface
- Microsoft Excel: Selecting Data
- Microsoft Excel: Using Commands
- Microsoft Excel: Creating a New Workbook
- Microsoft Excel: Entering Cell Data
- Microsoft Excel: Using AutoFill
- Microsoft Excel: Using Flash Fill
- Microsoft Excel: Using Excel Help
Performing Calculations
- Microsoft Excel: Creating Formulas
- Microsoft Excel: Inserting Functions
- Microsoft Excel: Copying Formulas & Functions
- Microsoft Excel: Using Absolute References
Modifying Worksheets
- Microsoft Excel: Inserting and Deleting Cells
- Microsoft Excel: Searching and Replacing
- Microsoft Excel: Using Proofing and Researching Tools
Formatting Worksheets
- Microsoft Excel: Applying Text Formats
- Microsoft Excel: Applying Number Formats
- Microsoft Excel: Customissng Number Formats
- Microsoft Excel: Aligning Cell Contents
- Microsoft Excel: Applying Cell Styles
- Microsoft Excel: Applying Themes
- Microsoft Excel: Inserting Hyperlinks
And more.
Printing Workbooks
- Microsoft Excel: Printing Workbooks
- Microsoft Excel: Setting the Page Layout
- Microsoft Excel: Inserting Page Breaks
- Microsoft Excel: Configuring Headers and Footers, Part 1
- Microsoft Excel: Configuring Headers and Footers, Part 2
Managing Workbooks
- Microsoft Excel: Managing Worksheets, Part 1
- Microsoft Excel: Managing Worksheets, Part 2
- Microsoft Excel: Creating a Custom View
- Microsoft Excel: Managing Worksheet Views
- Microsoft Excel: Managing Workbook Views
- Microsoft Excel: Managing Workbook Properties
Customising Options
- Microsoft Excel: Customising General Options
- Microsoft Excel: Customising the Ribbon
- Microsoft Excel: Customising the Quick Access Toolbar
** Microsoft Excel 2019 Intermediate **
Unit 01: Intro to Excel Functions
- Microsoft Excel: Excel Functions Explained
- Microsoft Excel: The SUM() Function
- Microsoft Excel: The MIN() & MAX() Function
- Microsoft Excel: The AVERAGE() Function
- Microsoft Excel: COUNT() Functions
Unit 02: Visually Pleasing Cell Formatting
- Microsoft Excel: Formatting Fonts and Cell Background Color
- Microsoft Excel: Adding Cell Borders
- Microsoft Excel: Formatting Data Appropriately
- Microsoft Excel: The Magic behind Excel’s Format Painter
- Microsoft Excel: Creating Styles for Formatting Efficiency
And more.Microsoft Excel: Merging Cells for a Cleaner Look
- Microsoft Excel: The Power of Conditional Formatting
Unit 03: How to Insert Images & Shapes!
- Microsoft Excel: Grab User’s Attention using Illustrations
- Microsoft Excel: Customising Icons
- Microsoft Excel: Create Compelling Graphics with SmartArt
Unit 04: Visualise Data with Charts
- Microsoft Excel: The Commonly Used Column Chart
- Microsoft Excel: Changing the Chart Design
- Microsoft Excel: Formatting Elements of a Chart
- Microsoft Excel: Modifying the Data, Type & Location of a Chart
Unit 05: Working with Excel Datasets
- Microsoft Excel: How to Prepare Data for Analysis
- Microsoft Excel: How to Sort Data in Excel
- Microsoft Excel: Multi-Level Sorting
- Microsoft Excel: Custom Sorting Datasets in Excel
- Microsoft Excel: Applying Filters to Datasets
And more.
Unit 06: Excel Database Functions
- Microsoft Excel: The SUMIF() Function
- Microsoft Excel: The DSUM() Function
- Microsoft Excel: The DSUM() Function Cont.
- Microsoft Excel: The SUBTOTAL() Function
Unit 07: Excel PivotTables
- Microsoft Excel: Creating an Excel Pivot Table
- Microsoft Excel: Modifying Excel PivotTables
- Microsoft Excel: Grouping & Filtering PivotTable Data
- Microsoft Excel: Drilling Down into PivotTable Data
- Microsoft Excel: Creating Pivot Charts & Utilising Slicers
Unit 08: Excel’s PowerPivot Add-In
- Microsoft Excel: What is PowerPivot?
- Microsoft Excel: Activating the Excel PowerPivot Add-In
- Microsoft Excel: Creating Relationships between Data Tables
- Microsoft Excel: Using Data Models to Create PivotTables
- Microsoft Excel: How to Create PowerPivot KPI’s
Unit 09: Excel’s Conditional Functions
- Microsoft Excel: Excel’s IF() Function
- Microsoft Excel: IF() Function with AND() Criteria
- Microsoft Excel: IF() Function with OR() Criteria
- Microsoft Excel: Nesting Multiple IF() Functions
- Microsoft Excel: The COUNTIF() Function
- Microsoft Excel: Key Benefits of Named Ranges
Unit 10: Excel’s Lookup Function
- Microsoft Excel: VLOOKUP() Function
- Microsoft Excel: The Beauty of Excel’s IFERROR() Function
- Microsoft Excel: HLOOKUP() Function
- Microsoft Excel: INDEX() Function
- Microsoft Excel: MATCH() Function
And more.
Unit 11: Text Based Functions in Excel
- Microsoft Excel: LEFT(), RIGHT() and MID() Function
- Microsoft Excel: Extracting Specific Text using LEN() & SEARCH()
- Microsoft Excel: Combining Text with CONCATENATE()
- Microsoft Excel: Quick Tips & Other Text Based Functions
** Microsoft Excel 2019 Advanced **
Working with Functions
- Microsoft Excel: Introduction
- Microsoft Excel: Using Named Ranges, Part 1
- Microsoft Excel: Using Named Ranges, Part 2
- Microsoft Excel: Using Named Ranges, Part 3
- Microsoft Excel: Working with Date Functions, Part 1
And more.
Working with Lists
- Microsoft Excel: Sorting Data, Part 2
- Microsoft Excel: Filtering Data, Part 1
- Microsoft Excel: Filtering Data, Part 2
- Microsoft Excel: Filtering Data, Part 3
- Microsoft Excel: Querying with Database Functions
- Microsoft Excel: Using the Subtotal Function
- Microsoft Excel: Using the Subtotal Feature
- Microsoft Excel: Creating Tables
Analysing Data
- Microsoft Excel: Modifying Table Styles
- Microsoft Excel: Summarising Data in Tables
- Microsoft Excel: Using the Quick Analysis Shortcut
- Microsoft Excel: Customising Conditional Formatting
- Microsoft Excel: Using Formulas with Conditional Formatting
- Microsoft Excel: Creating Charts
Visualising Data with Charts
- Microsoft Excel: Using Chart Types
- Microsoft Excel: Changing Chart Data Source
- Microsoft Excel: Adding Chart Elements
- Microsoft Excel: Formatting a Chart
- Microsoft Excel: Using Advanced Chart Features
- Microsoft Excel: Applying Trendlines
- Microsoft Excel: Creating a Chart Template
- Microsoft Excel: Inserting Graphics
Inserting Graphics
- Microsoft Excel: Modifying Graphics, Part 1
- Microsoft Excel: Modifying Graphics, Part 2
- Microsoft Excel: Creating a PivotTable
Using PivotTables and Pivot Charts
- Microsoft Excel: Summarising Data in a PivotTable
- Microsoft Excel: Grouping Data in a PivotTable
- Microsoft Excel: Formatting a PivotTable
- Microsoft Excel: Selecting & Moving PivotTables
And more.
** New Functions In Excel 2021 **
- Microsoft Excel: Introduction and Agenda
- Microsoft Excel: RANDARRAY
- Microsoft Excel: UNIQUE
- Microsoft Excel: SEQUENCE
- Microsoft Excel: SORT and SORTBY
- Microsoft Excel: SORT A Practical Example
- Microsoft Excel: FILTER
And more.
** Diploma in Excel Vlookup Xlookup Match and Index **
- Microsoft Excel: Excel vlookup
- Microsoft Excel: Excel xlookup
- Microsoft Excel: Excel vlookup
- Microsoft Excel: Excel vlookup
- Microsoft Excel: Excel vlookup
- Microsoft Excel: Excel vlookup
- Microsoft Excel: Excel vlookup
** Microsoft Excel: Automated Dashboard **
- Microsoft Excel: Introduction
- Microsoft Excel: Prepaid Expenses Models: Resources Download
- Microsoft Excel: Accounting for Prepaid Expenses
And more.
Certification
Once you have successfully completed the Microsoft Excel 2019 Bundle, you will be awarded 5 Hardcopy & 5 PDF certificates for FREE as evidence of your achievement.
Note: Delivery of the hardcopy certificates inside the UK is £4.99 each; international students have to pay a total of £14.99 to get a hardcopy certificate.
