Microsoft Excel 2010 Advanced
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.
Detail
| Date: |
21 May 2012 - 22 May 2012 06 Jun 2012 - 07 Jun 2012 28 Jun 2012 - 29 Jun 2012 12 Jul 2012 - 13 Jul 2012 26 Jul 2012 - 27 Jul 2012 21 Aug 2012 - 22 Aug 2012 |
| Duration: |
2, day(s) 9:00AM - 5:00PM |
| Fee: | $280.00 |
| Venue: | 12 Prince Edward Road
#03-03 (Podium A) Bestway Building
Singapore 079212 |
Fees are subjected to prevailing GST of 7%
For more information, please contact JobsDB Learning at 65788111 or email to learning@jobsdb.com.sg
Payment must be made before the commencement of the workshop. No cancellation is allowed 7 days prior to workshop.
A Certificate of Attendance will be given subject to 90% attendance.
Outline
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
Who Should Attend
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.
Public Sector - Division 1, 2, 3 & 4
Private Sector - Applicable to All
Testimonials
The Trainer is very good.
Khairin Nadira (ITE)
The Trainer is clear and always seek feedback from the class.
Jocelyn Teh (IDA)