Mastering Advanced Excel Skills

Course Overview:

Microsoft Excel is a spreadsheet program. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. This course focuses on imparting the skills of using advanced Excel functions and formulas that are useful while working with values and cell references, analysing data. 

Learning Outcome:

Upon completion of this course, you will be able to do many types of arithmetic functions, data validation & analysis, What If analysis, and create VBA codes, among others. Key topics covered include:

• Custom and Conditional Formats
• Advanced Table Options
• Using Formulas and Functions
• Working with Name Range
• Data Validation
• Working with Pivot Table
• What If Analysis
• Array Functions
• Working with Charts
• Basics of working with Macros and VBA