Physical Classroom Excel Training Available

Learn Microsoft Master Excel Course

Learn Microsoft Master Excel Course to gain in-demand skills in data analysis, reporting, and automation. Perfect for boosting workplace productivity and advancing your professional career.

Who Should Attend This Microsoft Master Excel Course

Ideal for working professionals, managers, and data analysts seeking to master advanced Excel skills for efficient data handling, reporting, and decision-making in the workplace.

Training Professionals

Business professionals

Entrepreneur

Students

Why Choose Us

Hands-On Exercises
Attention to each participants
Interactive Class

Step-By-Step Course
100% Satisfactory Record
Trained more than 10000 Participants
20 Year Experienced Trainer

Master Excel Training Course in Singapore

About Course: This Master Excel course will help you to Master with Excel by learning Basic, Intermediate and Advanced Excel. This course will teach you Excel from Basic to Advanced level (Need help deciding if you can skip the basic class? You can take this Quiz here to decide).

What you will learn

Learn how to use functions & formulas in excel
Learn how to create worksheets
Learn how to manipulate data
Learn how to format a data
Learn how to automate the excel data from different sheets using Macros
Learn pivot Tables, Vlookup, Hlookup, Excel Charts, Sorting & Filtering data.

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

Requirements:

The course requires Basic Computer & Windows usage skills, including but not limited to Typing skills; File, Folder usage; Software launching; Email usage; etc. If you would like to check your computer level, kindly process the quiz: Entrance Quiz-Course Pre-requisite.

Master Excel Course Duration: 3 Days

1st Day Basic Excel Training

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

Lesson 1: Getting Started with Excel 2021

Topic A: Navigate the Excel User Interface
Topic B: Use Excel Commands
Topic C: Create and Save a Basic Workbook
Topic D: Enter Cell Data

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats
Topic B: Apply Number Formats
Topic C: Align Cell Contents
Topic E: Apply Basic Conditional Formatting
Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views

2nd Day Intermediate Excel Training

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

Lesson 1: Working with Functions

Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date and Time Functions
Topic E: Work with Text Functions

Lesson 2: Working with Lists

Topic A: Sort Data
Topic B: Filter Data
Topic D: Outline and Subtotal Data

<strong>Lesson 3: Analyzing Data</strong>

Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with Pivot Charts
Topic D: Filter Data by Using Timelines and Slicers

3rd Day Advanced Excel Training

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

Lesson 1: Working with Multiple Worksheets and Workbooks

Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros

Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing

Topic A: Use Lookup Functions
Topic B: Use Dynamic Arrays and Dynamic Array Functions
Topic C: Trace Cells

Lesson 5: Forecasting Data

Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends

Lesson 6: Creating Sparklines

Topic A: Create Sparklines

We also offer excel 2013 and Excel 2010 training courses. Register Now for quick enquiry to Find here a range of courses from Microsoft excel courses Singapore