Master Excel Training Course

Microsoft Master Excel Course that will boost your Knowledge, Skills & Personal Growth.

Course Start Date

Master Excel Training Course in Singapore

Duration: 3 Days

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

About Course:  This Master Excel course will helps you to Master with Excel by learning Basic, Intermediate and Advanced Excel. This course will teach you Excel from Basic to Advanced level.

You will learn functions & Formulas used in Excel. You can create worksheet, manipulate data,  formatting of data and Macros to automate the Excel data from different sheets. 

You will learn Excel Formulas, Pivot Tables, Vlookup, Hlookup, Excel Charts, Sorting & Filtering data, Conditional formatting and many more tips and tricks in Excel

Target Student: All working professionals and students must know Microsoft Excel. 

microsoft excel master certification  1st Day: Basic Excel Course Outline

For beginners to get started with Excel (how to work with worksheet, workbook, cells, using simple formulas like sum, auto sum)

Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data Topic E: Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

microsoft excel master certification  2nd Day: Intermediate Excel Course Outline

For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table

 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 Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and Pivot Charts

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

microsoft excel master certification  3rd Day: Advanced Excel Course Outline

For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro

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

Creating Sparklines and Mapping Data

  • Create Sparklines
  • Map Data

Forecasting Data

  • Determine Potential Outcomes using Data Tables
  • Determine Potential Outcomes using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Our Clients