Join Master Excel Course to become certified Excel Expert in Singapore

Physical 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.

UTAP

Union Training Assistance Programme

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

Learn Basic Excel Course in Singapore

aster your Excel by learning Basic, Intermediate and Advanced Excel. This Master Excel Course will teach you Excel from Basic to Advanced level.

You can create worksheet, manipulate data, formatting of data, Pivot table, Tips & Tricks for Excel and Macros to automate the Excel data from different sheets.

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