Advanced Microsoft Excel Training

Advanced Excel Tips & Techniques Training

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

Advanced Excel Training 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
Merge Multiple Workbooks
Restrict Document Access

Advanced Excel Lesson 8:
Auditing Worksheets
Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas

Advanced Excel Lesson 9:
Analyzing Data
Create a Trendline

Advanced Excel Lesson 10:
Working with Multiple Workbooks
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 the Advanced Microsoft Excel workshop only 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.

Register for the 2 Day Advanced Microsoft Excel Class Today. Simply fill the form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at 9066-9991.

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Call Kamini at 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class.