“The VLookup & Pivot Table techniques I learned in Advanced Excel 2016 training have helped me in my work immensely. With automation using Excel Macros, manual steps have been reduced to a couple of keystrokes only.
The Advance Excel Formulas, Named Ranges, and keyboard shortcut tips are well worth the time and money spent training at Intellisoft for the Advanced Excel Class. The trainers are professional, patient, and the staff is very helpful. I’d definitely recommend it to all my colleagues to attend their Microsoft training at Intellisoft in Singapore. Absolutely must for every Excel warrior” – Marina Bay Sands
Practical hands-on training on how to use pivot table in excel, perform VLOOKUP in Excel, In-built Excel functions, Advanced Excel formula & more…
We also have Advanced Excel training on older versions of Microsoft like:
Advanced Excel 2016 Training in Singapore
Course Duration: Microsoft Excel 2016 Training is typically for 2 full days.
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details on the Training Fee funding available to companies.
SkillsFuture credits ready for Individual Singaporeans upgrading their skills in Excel Formulas and Functions.
UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.
Detailed Course Outline for Advanced Excel Training
Lesson 1: Using Custom & Conditional Formats
Lesson 2: Using Range Names
Lesson 3: Using Formulas & Functions
Lesson 4: Managing, Sorting & Filtering Tables
Lesson 5: Working with Charts in Excel 2016
|
Lesson 6: Working with Pivot Tables
Lesson 7: Working with Shared Workbooks
Lesson 8: Working with Multiple Workbooks
Lesson 9: Protecting Your Worksheet and Workbook
Lesson 10: Working with Excel Macros
|
What Are The Objectives of Advanced Excel Training
After Completing the Advanced Excel 2016 Training Course, Participants will be able to:
- Do complex computations with Advanced Excel Functions & Formulas.
- Organize worksheet and table data using multiple techniques.
- Summarize information quickly using excel pivot tables, and generate Summarized Management Reports Quickly & Easily
- Create and modify charts & graphs With Ease
- Use the Correct Type of Chart in Excel 2016 to Create Meaningful & Insightful Information
- Use Excel Tips & Tricks.
- Be able to create and use the New Charts in Excel 2016 like the Pareto chart to display 80-20 principle in action
- Analyze data using Excel Pivot Tables and Pivot Charts.
- Insert graphic objects to enhance your Excel sheets.
- Perform Lookup easily with Vlookup & HLookup Functions in Excel 2016.
- Customize and enhance workbooks and the Microsoft Office Excel 2016 environment.
They will learn to deploy Advanced Excel 2016 features to increase productivity and improve efficiency by streamlining the workflow. Learn to:
- collaborate with others using workbooks
- audit worksheets
- analyze data with Excel 2016 training
- Work with multiple worksheets & workbooks using Microsoft Excel 2016
- Import and export data in Excel
- Use Advanced Filters in Excel 2016
- Use Pivot tables in Excel
- Using the Quick Analysis Tools Within Excel 2016
Participants will learn to use advanced features and functions of Excel® 2016 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
- They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables, Conditional Formatting, Advanced Filtering, and Sorting options.
- Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.
What are the Pre-Requisites For Attending The Advanced Excel Training?
Basic knowledge of Microsoft Excel is sufficient for you to attend the Advanced Excel training program.
You must know how to start Excel program, key in numbers, text, and do simple formatting. You should know some of the the Basic Excel functions like Sum, Count, Average etc.
Advanced Functions and features of Excel would be taught in this Excel workshop.
A laptop with the right Excel version pre-loaded is provided for use in the Advanced Excel Tutorial class.
Notes in folders, along with multiple Exercise files to do practice and learn Advanced Excel Features and Functions are provided in the class too.
Who is this Advanced Excel Training Most Suitable For?
Microsoft Advanced Excel 2016 Training program is most suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel 2016.
The course is designed for participants who want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel. It will impart the necessary skills to create simple macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
In addition, the course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
What Are The Objectives of Advanced Excel Training
After Completing the Advanced Excel 2016 Training Course, Participants will be able to:
- Do complex computations with Advanced Excel Functions & Formulas.
- Organize worksheet and table data using multiple techniques.
- Summarize information quickly using excel pivot tables, and generate Summarized Management Reports Quickly & Easily
- Create and modify charts & graphs With Ease
- Use the Correct Type of Chart in Excel 2016 to Create Meaningful & Insightful Information
- Use Excel Tips & Tricks.
- Be able to create and use the New Charts in Excel 2016 like the Pareto chart to display 80-20 principle in action
- Analyze data using Excel Pivot Tables and Pivot Charts.
- Insert graphic objects to enhance your Excel sheets.
- Perform Lookup easily with Vlookup & HLookup Functions in Excel 2016.
- Customize and enhance workbooks and the Microsoft Office Excel 2016 environment.
They will learn to deploy Advanced Excel 2016 features to increase productivity and improve efficiency by streamlining the workflow. Learn to:
- collaborate with others using workbooks
- audit worksheets
- analyze data with Excel 2016 training
- Work with multiple worksheets & workbooks using Microsoft Excel 2016
- Import and export data in Excel
- Use Advanced Filters in Excel 2016
- Use Pivot tables in Excel
- Using the Quick Analysis Tools Within Excel 2016
Participants will learn to use advanced features and functions of Excel® 2016 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
- They will apply visual elements and advanced formulas to a worksheet to display data in various formats with Pivot Tables, Conditional Formatting, Advanced Filtering, and Sorting options.
- Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.
Who is this Advanced Excel Training Most Suitable For?
Microsoft Advanced Excel 2016 Training program is most suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel 2016.
The course is designed for participants who want to learn how to quickly analyze data, sort and filter data, import and export data sets, and understand data using the rich features provided in Excel. It will impart the necessary skills to create simple macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
In addition, the course is also for participants desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Detailed Course Outline for Advanced Excel Training
Lesson 1: Using Custom & Conditional Formats
Lesson 2: Using Range Names
Lesson 3: Using Formulas & Functions
Lesson 4: Managing, Sorting & Filtering Tables
Lesson 5: Working with Charts in Excel 2016
|
Lesson 6: Working with Pivot Tables
Lesson 7: Working with Shared Workbooks
Lesson 8: Working with Multiple Workbooks
Lesson 9: Protecting Your Worksheet and Workbook
Lesson 10: Working with Excel Macros
|
What are the Pre-Requisites For Attending The Advanced Excel Training?
Basic knowledge of Microsoft Excel is sufficient for you to attend the Advanced Excel training program.
You must know how to start Excel program, key in numbers, text, and do simple formatting. You should know some of the the Basic Excel functions like Sum, Count, Average etc.
Advanced Functions and features of Excel would be taught in this Excel workshop.
A laptop with the right Excel version pre-loaded is provided for use in the Advanced Excel Tutorial class.
Notes in folders, along with multiple Exercise files to do practice and learn Advanced Excel Features and Functions are provided in the class too.
Claim SDF Grant
Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.
Applicable for Company Sponsored Singaporeans & PRs.
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
Do You Have Any Questions or Need a Quotation?
Simple. Just tell us what you need. We’ll be glad to help you!
Some of the companies that experienced our trainings
How To Register
How To Register For The Advanced Excel 2 Day Course?
Register for the 2 Days Advanced Excel 2016 Training Class today by simply clicking on the chosen course date available at the top of this page.
Need Help in Registering for Advanced Excel Class?
- Call us at +65 6250-3575, SMS / WhatsApp: +65 9066-9991
- Send an email to training@intellisoft.com.sg OR
- Submit an online enquiry if you have any questions regarding Advanced Excel 2016 training.
We also offer Corporate Trainings for Advanced Excel 2016 version.
If you have a group of people, we can arrange to conduct the Advanced Excel 2016 training at your office location too. Just contact us for the quotation and suitable dates for the training.