Microsoft Excel is a spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections. This course is for advanced Excel users who want to quickly learn new tools that will save them time and produce extraordinary results.
Book this Course
To run this course for your team, email excel@WilliamCampbell.info, or call +49 30 2247 6097. See more information about training here.
Suggested Uses
- It will deliver the skills and ideas to automate time-consuming tasks
- Enable users to extract meaningful information from large data tables.
- This coaching is targeted at financial professionals who are experienced Excel users
Training Course Outline
- The essential shortcuts
- Complex formulas
- Simple method to create complex formulas
- Analyse complex formulas
- Dynamic Array formulas
- Advanced Combinations of Dynamic Array formulas
- Table design
- Layout data for best results
- Reorganise existing data into a workable table
- Record macros
- Create a macro to format a spreadsheet
- Create a macro to add data and run calculations on a datasheet
- Templates
- Create a template for data entry
- Secure the template to protect formulas
- Control the data types that can be input on the template
- Data analysis
- Advanced Pivot Tables
- Link sheets and files in Excel
- Question Time
After the Course
All attendees will receive a free USB drive with loads of examples, and a fully-illustrated manual with step-by-step instructions for the areas covered on the course.