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.
You will receive support not only during the training, but also prior to it. A complete set of training material and equipment will be delivered to you by mail beforehand. This will allow you to receive high-quality training with minimum preparation time.
With the concept of "More Training", we make the courses available at a clear fixed price, even for a customized single-company training program that provides an excellent training environment.
We offer various training formats with no additional charge, whether it be in-person, online, or a hybrid of both(partially web-based). Please feel free to contact us regarding your needs.
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 provide tailored training programs for an entire company at a fixed rate. We will send you a quotation based on estimated training duration and number of participants.
No particular requirements
Online and in-person training are available worldwide.
This page is about Advanced Excel Training course planned for a single company. Please see below for other training courses and related training programs.
