Master Excel’s various features and functions, and take your basic Excel skills to the next level.
This training will further improve the skills of those who understand the basics of Excel. The training covers everything from checking functions that are commonly used in business scenes to using formulas and functions, creating double-digit graphs, and pivot tables.
Participants will learn advanced Excel skills by hands-on practice and working on Excel exercises provided in the training.
This will lead to improved productivity and efficiency.
We provide comprehensive support before, during, and after the training session to ensure a seamless experience for our clients. Training materials will be delivered directly to your office in advance, at no additional cost, ensuring the smooth, efficient, and enjoyable process.
Guided by the principle of "Train more. Pay less," our courses are offered at a clear and fixed price with no limit on the number of participants. This approach extends even to customized, instructor-led, in-company training programs, enabling organizations to create an optimal training environment while maintaining budget clarity.
To meet the diverse needs of our clients, we offer flexible training formats at no extra charge. Whether you prefer in-class sessions, online training, or a hybrid approach (partially web-based), we are here to accommodate your preferences. Please don’t hesitate to contact us to discuss the format that best suits your requirements.
Training Code: 100147 Information updated:
Participants will learn about various functions of Excel, tips, tricks to boost efficiency, utilizing database functions, and how to use pivot table.
The following is a general list of target participants for the training and can be adjusted upon review. Please contact us regarding your needs.
Suitable for those who understand the basics of Excel.
Learn frequently used functions such as IF function and VLOOKUP function. Understand how functions work to improve work efficiency.
Create a combo chart by combining line graph and bar graph to create a visually persuasive report.
Participants will be able to easily summarize, extract and sort a large amount of enumerated data using the database function of Excel. In addition, participants will be able to analyze data from different angles using pivot table.
6 hours (subject to change)
Other training content can be incorporated into the curriculum upon request at no additional charge.
1. Formulas and functions | [Goal] Understand how to do computations with Excel Functions & Formulas. |
---|---|
|
|
2. Advanced formatting | [Goal] Understand how to use advanced formatting |
|
|
3. Create a combo chart | [Goal] Understand how to create a combo chart |
|
|
4. How to use Excel like a Database | [Goal] Understand how to use Excel like a Database |
|
|
5. Pivot Table and Pivot Graph | [Goal] Understand Pivot Table and Pivot Graph |
|
|
6. Practice Exercise | [Goal] Practice exercises to test your understanding. |
|
We offer comprehensive customizable training programs for your entire team at a fixed rate, regardless of the number of participants. Whether you need in-class, online, or hybrid training, we can accommodate your specific needs without additional charges. Our pricing model ensures transparency and flexibility, allowing for last-minute adjustments without extra costs.
No particular requirements
We offer a variety of instructor-led training programs in Singapore, both online and in-person.
This is the instructor-led Advanced Excel Training course page.
Please see below for additional training courses and related training programs.
Office Hours
Mon-Fri 9:00 AM - 6:00 PM Local Time