Master Excel Training

Master Excel Course Singapore

Master your Excel by learning Basic, Intermediate and Advanced Excel. This course will teach you Excel from Basic to Advanced level. You can create worksheet, manipulate data,  formating of data and Macros to automate the Excel data from different sheets.

Duration: 3 Days

Basic Excel Training

1 Day Training

Intermediate Excel Training

1 Day Training

Advanced Excel Training

1  Day Training

1st Day Master Excel Training

Getting Started

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Performing Calculations

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

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

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Printing Workbook Contents

  • Define the Basic Pag Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

2nd Day Master Excel Training

Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions

Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls

Applying Conditional Logic

  • Use Lookup Functions
  • Combine Functions

Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

3rd Day Master Excel Training

Getting master with Charts in Excel

  • Creation & Formatting a Chart
  • Adding Labels
  • Playing the Chart Type & Data Source
  • Updating Data Source
  • Changing the Chart Location

Hands-on with Worksheet Protection

  • 1. How to protect your Worksheets
  • 2. Using Consolidated Worksheets
  • 3. Consolidating by Category
  • 4. Consolidating by Position
  • 5. Practice – Consolidating Worksheets
  • 6. Protecting range with password
  • 7. How to protect your Workbook
  • 8. How to protect your Excel Files

Hands-on with Macros in Excel 2013

  • Recording a Macro
  • Display the Developers Tab
  • Changing Macro Security Setting
  • Using a Macro Button
  • Creating a Macro Button
  • Copying a Macro Button
  • Formatting a Macro Button
  • Moving/Sizing a Macro Button
  • Deleting a Macro Button
  • Running a Macro
  • Deleting a Macro

Sharing Workbook using Excel 2013

  • Opening and Editing a Shared Workbook
  • Tracking Changes
  • Resolving Conflicts in a Shared Workbook
  • Managing Conflicting Changes
  • Resolving Conflicting Changes
  • Setting Change History Options
  • Adding a History Worksheet
  • Reviewing Tracked Changes

Hands-on with Pivot Tables in Excel 2013

  • Creating a PivotTable & Filter Pages Report
  • Adding PivotTable Report Fields
  • Updating a PivotTable Report
  • Selecting a Report Filter Field Item
  • Changing the Summary Function
  • Publishing PivotTable Reports to the Web
  • Moving PivotTable Report Fields
  • Using Expand and Collapse Buttons
  • Hiding/Unhiding PivotTable Report Items
  • Practice – Creating/Revising PivotTables
  • Introducing Slicers
  • Using Slicers to Filter Data
  • Deleting PivotTable Report Fields
  • Formatting a PivotTable Report

Sample Text