Online and Classroom Master Excel Course

Master Excel Course

Both Online and Physical Training Available

Excel Expert Training Objectives

Master 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

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

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

Lesson 3: Analyzing Data

• 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

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