- Location: Central Area - Central
- Duration: 2 days (14 hours)
- Timings: Monday-Friday 9am-5pm
Course details
Learn how to consolidate data and use Excel like a database to filter and retrieve data using Excel functions. With the use of Pivot table, you will learn how to generate dynamic reports through data field selection and criteria quickly and easily.
What will I learn?
- Working with Templates
- Working with Data Validation
- Using Advanced Functions
- Working with Database
- Filtering Data
- Using Database Functions
- Consolidating Data
- Working with Charts
- Auditing Worksheets
- Working with Pivot Table
Who is this course for?
Learners who have completed our Microsoft Excel 2007 Foundation module or are very well versed with the Excel features covered from that module.
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 Access Advanced One EducationSGD 30
SGD 626Duration: Upto 4 Hours - Microsoft Teams Essentials Course CentralSGD 30
SGD 245Duration: Upto 1 Hour
