Master Excel Training Course

Course Start Date

Master Excel Training is a package of 3-day training, 1 day for 1 level in Microsoft Excel Training from Basic to Advanced level. This 3-day course will cover all Basic to Advanced Features, Functions and Formulas of Microsoft Excel from the foundation knowledge to get started until the advanced techniques to master the tool. This is a hands-on Excel training where you will be working on live exercises of each topics, including but not limited to how to starting work with cell, worksheet, workbook in Excel as well as Pivot Table, VLookup, Hlook up, Filtering Data using Functions, Exporting and Importing data, Basic Macros and many more tricks in Microsoft Excel.

Claim 100% Fees From SkillConnect Credit, No Upfront fees for Singaporean

Course Duration: 3 Days


1st Day Basic Excel Course Outlines

Getting Started With Microsoft Excel

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Using Excel help

Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas & Functions

Modifying a Worksheet

  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

Formatting a Worksheet

  • Apply Font Text formate
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles
  • Apply style and Themes
  • Apply Basic Conditional Formating
  • Create and use Template

Printing Workbook

  • Preview an Print the Workbook
  • Refine the Page Layout and Apply Print Options
  • Configure Header and Footers

2nd Day Intermediate Excel Course Outlines

Working with Functions

  • Work with Ranges name
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create a PivotTable
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and Pivot Charts

  • Create and Modify Tables
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers

3rd Day Advanced Excel Course Outlines

Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

 Apply For Skill Future Credit to Claim Your Fee

Our Clients