Advanced Microsoft Excel Training

Advanced Excel Tips & Techniques Training

SDF Funding of Available. Call 6296-2995 for Details.

Course Objectives:

• Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
   
• Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.

"The Advanced Excel training will help me get my job done very quickly and easily. The things that I used to take many hours will now take only a few minutes with the use of formulas, macros and other tricks I learnt in the Excel workshop" -  Carmen Leow, Pan Pacific Hotel, Singapore

Course Outline for Advanced Excel Tips & Techniques:

Day 1

Advanced Excel Lesson 1:
Calculating Data with Advanced Functions & Formulas
Manage Cell and Range Names
Calculate Data Across Worksheets
Using Special Functions like VLOOKUP
Analyze Data with Logical and Lookup Functions

Advanced Excel Lesson 2:
Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables in Excel
Sort or Filter Worksheet or Table Data

Advanced Excel Lesson 3:
Importing and Exporting Data
Export Excel Data
Import a Delimited Text File

Advanced Excel Lesson 4:
Presenting Data Using Charts
Create a Chart
Modify Charts to make information more presentable
Format Charts for Clarity

Advanced Excel Lesson 5:
Analyzing Data Using PivotTables and PivotCharts
Create a PivotTable Report
Analyze Data Using PivotCharts

Day 2

Advanced Excel Lesson 6:
Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting in Excel
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Advanced Excel Lesson 7:
Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Multiple Workbooks
Restrict Document Access

Advanced Excel Lesson 8:
Auditing Worksheets
Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Advanced Excel Lesson 9:
Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak

Advanced Excel Lesson 10:
Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Advanced Excel Training Course Prerequisites:

This course is not for Excel beginners. If you do not know how to copy information from one Excel worksheet cell to another, then this course is not for you... join our Excel for Beginners / Intermediate training program first. 

Join if you have been using Microsoft Excel for atleast 3 months, know the basics, and are ready to learn the more advanced functions, tricks and techniques of Microsoft Excel, then only join this Advanced Excel MasterClass

Register for the 2 Day Advanced Microsoft Excel Class Today. Simply fill the form on the top, and book your seat today. Or email training@intellisoft.com.sg for any questions