Microsoft Excel

This training workshop sheds the light on theadvanced Microsoft® Excel® Techniques. It will reveal tips and tricks that you may not have known.

Learning Outcomes:

  • Time-saving techniques that’ll allow you to get your work done faster with Excel
  • Adding and using the Analysis ToolPak to make complex data analysis a snap
  • How to create a PivotTable report to quickly analyse volumes of data, generate summary views, see comparisons and reveal patterns in your data
  • How to add power to your spreadsheets with Visual Basic® for Applications, including a quick way to learn VBA syntax

Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop.

Day One:

Session 1: Time-saving techniques

Session 2: Designing forms and formatting

Session 3: Data analysis and formulas

Session 4: Advanced charting and graphing functions

Day Two

Session 1: Getting the most out of PivotTable and PivotChart reports

Session 2: Maximizing the power of Excel with VBA and macros

Session 3: Excel and the Internet

Session 4: Validating and securing your data

Target Audience: All levels

Course Duration: 2 days