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.
Training Agenda
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
