Training Outcomes

By the end of the program the participant will be able to;

• Be familiar with the Excel screen
• Use conditional formatting
• Perform goal seek analysis
• Import and export Excel data
• Sort data
• Use named cells and ranges
• Perform single workbook consolidation
• Perform multiple workbook consolidation
• Understand pivot tables
• Use absolute and relative cell addressing in formulas
• Use complex formulas
• Use inbuilt Excel functions, such as COUNT() and MAX()
• Debug erroneous formulas
• Use Macros to automate repetitive tasks
• Use Pivot tables and Pivot charts