- Location: Central Area - Central
- Duration: 2 days (14 hours)
- Timings: Monday-Friday 9am-5pm
Course details
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.
What will I learn?
- 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
Who is this course for?
Learners 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 / Excel 2010.
Updated on 08 November, 2015Course Location
About Oaks Training
Oaks Training operates as a closely knitted family with a team that is passionate in sharing knowledge and has a love for teaching. Our team's experience in training began as early as 1990. Oaks Training considers everyone (admin staff, trainers, management) who works in the company as a family member. Our philosophy is “Everyone is indispensable. Everyone plays a crucial part in the success of the company and for the benefit of our customers.
See all Oaks Training courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Essentials - CPD Certified Academy for Health & FitnessSGD 296Duration: Upto 90 Hours
- Microsoft Office Advanced Level Alpha AcademySGD 34
SGD 381Duration: Upto 3 Days
