Course details
Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut-from simple data entry to complicated financial models and analysis.
This course adds on to the participants’ knowledge of Microsoft Excel. Formulae form an integral part of the course and participants will learn how to use complex functions to model their data and to generate a variety of answers and reports.
Key Benefits
- Learn how to build a pivot table and learn about the uses of a pivot table
- Learn how to do data analysis using Excel
Course Content
- Using Range Names
- Advanced Functions
- Data Validation
- Database/ List Operations
- Data Consolidation
- Data Anaysis
- Auditing Worksheets
- Collaborating
Learning Methodology
Participants will benefit from the hands-on practical sessions during the course.
Who Should Attend
Those who are seeking to further their knowledge of Excel would benefit from this course. Those who need to create spreadsheet models and data analysis are especially encouraged to attend.
A good foundation in Excel is essential for this course. Participants should be familiar with the program and be able to write basic formulae. Having attended an essentials course is advantageous.
Updated on 08 November, 2015Course Location
About Service Quality Centre
Established in 1990, We_They rich heritage is derived from founding partners, Singapore Airlines (SIA), one of the world’s leading carriers listed in Fortune 500 and an internationally respected brand; and SPRING Singapore (the former Standards, Productivity and Innovation Board), a government enterprise development agency that develops and promotes internationally recognised standards and quality assurance.
With the best of SIA’s service philosophy infused with SPRING’s experience in setting standards for business excellence and innovation, We_They delivered the business advantage that organisations – public and private, large and small – needed to provide outstanding customer value, quality and performance.
See all Service Quality Centre courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- The Microsoft Office Diploma New Skills AcademySGD 33
SGD 406Duration: Upto 90 Hours - Microsoft Office Complete Guide St. Paul's CollegeSGD 17Duration: Upto 4 Days
