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
- Financial Management
- Store, sort and filter lists such as names and addresses
- Create financial templates such as invoices or expenses sheets
- Display your data on a chart
- Summarise large volumes of information in pivot tables
- Create sophisticated formulas to calculate information
- Link to external databases
Training Course Outline
- Name a Cell or Range
- Array Formulas
- Spreadsheet Security
- How to Use what You’ve Learnt
- XLookup, VStack and other Database Functions
- Functions to Tidy and Transform Data
- Date-Based Functions
- Dynamic Array Functions, and Virtual Arrays
- Conditional Formatting
- Print Options
- Customise Toolbars & Menus
- Templates
- Custom Views
- Validation
- Record and Manage Macros
- Scenarios
After the Course
You will be able to record macros, create templates to be used for future calculations, summarise information with pivot tables and use passwords to protect your work. You will also be able to combine powerful mathematical functions to automate tasks and use array formulas.