Learn Microsoft Advanced Excel Course

Excel Training Advanced Objectives

The Microsoft Advanced Excel Course in Singapore spans a single day and delves into the advanced features, functions, and formulas of Microsoft Excel.

Participants will receive intensive training on VLookup, HLookup, data consolidation, worksheet and workbook protection, basic macros, and a plethora of additional Excel techniques.

This hands-on training ensures practical learning through live exercises on each topic covered.

Course Outline For Advanced Excel

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.

Working With Multiple Worksheets And Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Using Lookup Functions And Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Sharing And Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Creating Sparklines And Mapping Data

• Create Sparklines
• Map Data

Forecasting Data

• Determine Potential Outcomes using Data Tables
• Determine Potential Outcomes using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends