Microsoft Excel Masterclass

REASONS TO CHOOSE

  • Learn Top 10 Excel Shortcuts with our Excel Masterclass Training. Happy Learners: 275,441+
  • Gain Knowledge of highlighting Excel data cells containing Values, Text, and Duplicate values.
  • Develop your Skillset using Formulas, VLOOKUP, and Pivot Tables. Rated Outstanding!

Microsoft Excel Masterclass

Become the master of Microsoft Excel

Microsoft Excel Masterclass

Microsoft Excel Masterclass Course Outline

 

Module 1: Navigation of the Excel Interface

  • Understanding the Excel Start Screen
  • Excel Tab Interface
  • Introduction to Microsoft Excel
  • Excel Workbook Screen
  • Ribbon
  • Name Box
  • Formula Bar
  • Worksheet Tab
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Changing the Location of the Bar
  • Understanding the Status Bar
  • Exercise

Module 2: Use of Lists and Tables

  • Understanding Lists
  • Applying a Filter
  • Clearing a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming Tables
  • Resizing Tables
  • Converting a Table to a Range
  • Deleting a Table
  • Exercise

Module 3: Conditional Formatting

  • Understanding Conditional Formatting
  • Highlighting Cells Containing Values
  • Highlighting Cells Containing Text
  • Highlighting Duplicate Values
  • Using Top and Bottom Rules
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • Conditional Formatting Rules Manager
  • Clearing Rules
  • Exercise

Module 4: Using Formulas and Creating Pivot Tables

  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Insert Function Button
  • Working with Names and Ranges
  • IF Formulas
  • AVERAGE Function
  • COUNT Function
  • Common Logical Functions
  • Create a PivotTable from an Excel Data List
  • Add/Remove/Reorganise Data Fields
  • Refresh Data/Change Data Source
  • Changing the PivotTable Design
  • Creating and Modifying a Pivot Chart
  • VLOOKUP
  • Undo, Redo, and Repeat with Keystrokes
  • Exercise