Swiss IT Academy Inc.

Swiss IT Academy Inc Logo

Advanced Excel

Learn Useful Formulas and Commands

Advanced Excel

Course Code



1 Day


For users of Excel, they will be able to improve their skills and knowledge to use this application in different useful ways. By learning advanced formulas and functions, they would be able to explore countless possibilities how Microsoft Excel can help them in their tasks.

With this 1-day training session, learners will be able to learn the advance excel formulas and functions that will help them be more productive and effective in their respective tasks.  They will also create a simple dashboard that will summarize raw data and provide visuals through Pivot tables, charts, and slicers.

Anyone that has basic knowledge in Microsoft Excel is welcome.

Course Outline

• Review on Excel Fundamentals
• Excel Functions
• Special Paste
• Lists
• Advanced Filter
• Basic Macros and VBA
• Pivot Tables and Charts
• Slicers
• Protecting Data
• Developer Ribbon Tab


March 13, 2020 - (9:00AM to 4:00PM)
March 20, 2020 - (9:00AM to 4:00PM)
March 27, 2020 - (9:00AM to 4:00PM)

Students' Reviews