supported byvital.org
Call 6423 1183
  • Home
  • Courses
    • All Courses
    • IT Courses
      • Adobe Applications
      • Computer Literacy
      • Infocomm Security
      • Internet Related
      • Microsoft Office
      • Microsoft Windows
      • Student Enrichment
      • Video Editing
    • Corporate Courses
      • Business Writing
      • Customer Service
      • Personal Effectiveness
    • Evening/Weekend Courses
  • Training Calendar
  • Subsidy
  • Oaks Training Family
  • About Us
    • About Oaks Training
    • Training Location
    • Our Facilities
    • Testimonials
  • Contact Us

Microsoft Office IconMicrosoft Excel 2010 Advanced Course

Mastering Microsoft Excel.

Home / Courses / Microsoft Office

Microsoft Excel Advanced Course Banner
  • Brief
  • Outline
  • Details
  • Help
Excel 2010 Advanced Course Brief

A 2-day hands-on follow on course designed to equip users with features in Microsoft Excel 2010 that will enable you to perform better data analysis and create more complex and comprehensive reports to make better decisions.

Learn how to consolidate data and use Excel like a database to filter and retrieve data using Excel functions. You will also learn how to generate dynamic reports through data field selection and criteria quickly and easily.

Discover how to customise your ribbon (known as the Tool bar in versions 2003 and older) to suit your personal comfort to quickly access functions. This hands-on course coupled with exercises to allow you to practice on lessons taught to enforce understanding on Microsoft Excel and experience Excel’s ability to greatly reduce you time in scenario planning and data analysing.

I’m very experienced in using an earlier version of Microsoft Excel; can I sign up for this course without attending the Basic to Intermediate course?

Yes, you can but ONLY IF you are very familiar with the Excel 2010 or 2007 user interface.

Overview of Microsoft Excel 2010 Advanced
  • How to Create and Apply Templates in Excel 2010
  • How to Use Data Validation
  • How to Use the IF Function (Single and Multiple Conditions)
  • How to Perform Data Retrieval with Functions
  • How to Use Excel as a Database
  • How to Perform Data Retrieval with Basic and Advanced Filters
  • How to Sort Data in Excel
  • How to Obtain Subtotals from Your Data
  • How to Consolidate Multiple Data Tables into a Single Summary Report
  • How to Use Scenarios to Determine Different Projected Outcomes
  • How to Use the Analysis ToolPak to Perform Complex Statistical Analyses
  • How to Use the Auditing Feature in Excel
  • How to Use Goal Seek for Forecasting Results
  • How to Customise the Ribbon
  • How to Create and Manage Macros in Excel
  • How to Use a Pivot Table
  • How to Use Slicers to Filter PivotTable Data
  • How to Install Powerpivot Add-In into Excel 2010
Excel 2010 Advance Course Details
Skill Level For those who have attended our Microsoft Excel 2010 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Excel 2007.
Audience Public Sector - Division 1, 2, 3 & 4
Private Sector - Applicable to All
Course Fee S$280.00 (Before GST)
Subsidy available
Course Location Oaks Training Centre
Time 9.00am - 5.00pm
Course Duration 14 Hours
Other Details • Refreshments are provided for morning and afternoon tea breaks.
• A Certificate of Attendance will be given subject to 90% attendance.
Course Code VTLOKMEAX
Can't Find a Suitable Course Date or Syllabus?
Need to Customise a Course?


If you would like us to notify you whenever a new course date becomes available, simply fill up our Notify form and we will let you know the moment any new course dates are released.

If you are looking for a customised course or an in-house course, call us and speak to any of your representatives and we would be happy to assist you.

Call us at 6423-1183.

Past classes

Fellow participants, visit our Facebook to get a copy of your class photo [ click here ].

Microsoft Excel 2010 Advanced
   

Course Dates

Click on Month for dates
  • February

    15-16 Feb 2012
    Wed - Thu (9am - 5pm)
    27-28 Feb 2012
    Mon - Tue (9am - 5pm)

    March

    12-13 Mar 2012
    Mon - Tue (9am - 5pm)
    28-29 Mar 2012
    Wed - Thu (9am - 5pm)

    April

    11-12 Apr 2012
    Wed - Thu (9am - 5pm)
    19-20 Apr 2012
    Thu - Fri (9am - 5pm)

    May

    02-03 May 2012
    Wed - Thu (9am - 5pm)
    21-22 May 2012
    Mon - Tue (9am - 5pm)

    June

    06-07 Jun 2012
    Wed - Thu (9am - 5pm)
    28-29 Jun 2012
    Thu - Fri (9am - 5pm)

    July

    12-13 Jul 2012
    Thu - Fri (9am - 5pm)
    26-27 Jul 2012
    Thu - Fri (9am - 5pm)

    August

    21-22 Aug 2012
    Tue - Wed (9am - 5pm)

    September

    10-11 Sep 2012
    Mon - Tue (9am - 5pm)
    20-21 Sep 2012
    Thu - Fri (9am - 5pm)

    October

    08-09 Oct 2012
    Mon - Tue (9am - 5pm)
    24-25 Oct 2012
    Wed - Thu (9am - 5pm)

    November

    15-16 Nov 2012
    Thu - Fri (9am - 5pm)
    28-29 Nov 2012
    Wed - Thu (9am - 5pm)

    December

    06-07 Dec 2012
    Thu - Fri (9am - 5pm)
    20-21 Dec 2012
    Thu - Fri (9am - 5pm)

SDF Subsidy Available


Testimonials

The Trainer is very good.
Khairin Nadira (ITE)

Thank you very much! The knowledge for my Excel is definitely better and beneficial to me!
Karen Lim (Modec Offshore)

The Trainer is clear and always seek feedback from the class.
Jocelyn Teh (IDA)

Very clear and well organised training. Thanks! Learnt a lot.
Thomas Lu (Nalco Pacific)

An excellent trainer who is very clear in explanation. Keep it up!
Hui Fun (MOM)

Related Courses

  • Excel 2010 Basic to Intermediate
Adobe Applications
  • Dreamweaver CS5
  • Fireworks CS5 Mastering Mobile Website Design
  • Flash CS5
  • Photoshop CS5 Fundamentals
  • Photoshop CS5 Advanced
  • Photoshop CS5 for Photographers
  • Photoshop CS5 for Print Design

Video Editing
  • Video Editing for Beginners
Infocomm Security
  • Black Belt Security White Tip

Internet Related
  • Creating Web Pages with HTML
  • Enhancing Web Pages with HTML
  • PHP and MySQL for Beginners
  • e-Newsletter Design
  • Internet Training
Microsoft Office 2007
  • Office 2007 Introduction
  • Access 2007 Bsc/Imd
  • Access 2007 Advanced
  • Excel 2007 Bsc/Imd
  • Excel 2007 Advanced
  • Excel 2007 Power Functions S1
  • Excel 2007 Power Functions S2
  • Outlook 2007
  • PowerPoint 2007 Bsc/Imd
  • PowerPoint 2007 Advanced
  • PowerPoint 2007 High Impact
  • Word 2007 Bsc/Imd
  • Word 2007 Advanced
Microsoft Office 2010
  • Office 2010 Overview
  • Excel 2010 Bsc/Imd
  • Excel 2010 Advanced
  • Outlook 2010 Bsc/Imd
  • PowerPoint 2010 Bsc/Imd
  • PowerPoint 2010 Advanced
  • Word 2010 Bsc/Imd
  • Word 2010 Advanced

Microsoft Office 2003
  • Office 2003
Microsoft Windows
  • Windows Vista Essentials

Computer Literacy
  • Computer Literacy

IT Enrichment
  • for School Holiday
Customer Service
  • EI Skills for Handling Difficult Customers
  • Telephone Skills for Service Professionals

Grammar and Writing
  • Essential Grammar for Effective Writing
  • Effective Business Writing

Personal Effectiveness
  • Improve Personal Effectiveness At Work

Evening Courses
  • Evening/Weekend Courses
© 2011 Oaks Training. All Rights Reserved