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
Training Course Outline
- Link Worksheets and Workbooks
- Functions
- XLookup, VStack and other Database Functions
- Excel’s new Dynamic Array Functions
- Name a Cell or Range
- Pivot Tables
- Conditional Formatting
- Record Macros
- Customise Toolbars and Menus
- Goal Seek
- Paste Special
- Auditing
- Validation
After the Course
You will be able to create formulas to model financial data, record macros, quickly enter large amounts of data, format your work neatly, create templates to be used for future calculations, summarise information with pivot tables and use passwords to protect your work.