PMP Exam Prep Tips

Receive PMP Exam Preparation Tips & Project Management Articles

Master Trainer Vinai's
articles are published in books,
magazines & newspapers

Our article in The Straits Times

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:


I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel

Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.

The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.

Able to apply VLookup, Macros and Pivot Tables easily - M1

Improved my job productivity by 75% - ITE

Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas

 


Intellisoft Training Calendar   
View the Latest Advanced Excel Training Schedule to reserve a seat.

Course Enquiry

Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Number of Participants*

 

Our Clients

Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.

Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE,  LTA, MOH and many more.

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

Advanced Excel Training - April 09  Advanced Excel Workshop Group

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.