Microsoft Excel is a spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections.
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
- Import and link information from the web
- Complex formulas
- Simple method to create complex formulas
- Analyse complex formulas
- 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 Template data types
- 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.