Advanced Excel
…Business Par Excel [lence]

Participants will be able to improve their productivity and maximize their time when producing complex spreadsheets. They can master some of the complex Excel functions bringing a new level to their ability to present, store and analyze data. The business benefits this can provide are wide ranging and can help improve overall business performance and customer satisfaction levels.

Prerequisite

Having achieved all the skills as listed in the Excel – White Belt and Excel – Green Belt trainings

Course Level

Advanced

Duration

2 Days

Who should attend?

Managers, analysts, financial personnel, Six Sigma professionals, and even CEOs can all benefit from learning the power of Excel. Even if you are already experienced in Microsoft Excel, you can become a true power user by attending this program.

Performance Focus

Being able to use the full power of Excel has important business advantages. Solutions to corporate problems are directly, more easily, and more quickly by hand when you are able to use features like:

• Pivot tables
• Data Filtering
• Advanced Formatting Techniques
• Advanced Charts

What You Will Learn

• Create and design complex charts
• Use Excel’s map feature
• Enter a range of financial, database and informational functions
• Create data tables and validate their data input
• Create consistent appearance throughout
• Create/use templates for speed and efficiency
• Use Excel’s automated error handling and auditing features
• Work efficiently with pivot tables
• Use goal seek, solver and scenario manager to create ‘what if’ scenarios
• Automate routine tasks through inbuilt macros
• Practice using our hints and tips for fun and efficiency

Content

Basic outline of the course:

▲