Accounting & Finance

IntroductionAdvanced Excel is for people who already can create moderately complex spreadsheets and still want to add more sophistication and automation.

This course will equip participants with relevant tools and functions in MS Excel for the development of automated systems to replace certain manual and repetitive processes.
Learning Objectives
By the end of this course participants will be able to:
•    Use outlines, range names, databases and the data form
•    Use AutoFilter & advanced filters
•    Work with Data Series
•    Use advanced functions
•    Modify charts 
•    Use Scenarios & Goal Seek
•    Use templates, data tables & solve problems
•    Use automatic formatting & styles
•    Work with views, consolidate worksheets
•    Create & revise PivotTables
•    Use, record & edit macros 

Participants should already be using Excel on a regular basis. Alternatively, they must have a good knowledge of Excel introduction topics.

Location & Date

No Schedules!

Please contact us if you have any question

Contact Us



Course Outline

Fill the form below and the full course content will be sent to you

Your Name
Enter a valid email address
Phone number