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.
Basic Excel Training
1st Day Training
Intermediate Excel Training
2nd Day Training
Advanced Excel Training
3rd Day Training
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
+65 8421 2824
info@exceltraining.com.sg
Chat With Us