You handle a lot of data manually and would like to save time on certain tasks?
Thanks to this customized training, you will learn to use Excel to:
- perform calculations and visualize them as charts
- lay at out reports efficiently
- analyze the data with filters, lookup functions and dynamic pivot tables.
Goals
- Review the basics of using Excel
- Perform calculations and create charts
- Lay out reports that can easily be updated
- Manage and analyze data, in connection with an ERP
- Be autonomous in using Excel
Course content
1. Excel basics
- Standard operations
- Performing calculations: example of cash-flow tracking
- Create and customize a chart
- Be autonomous: use Excel help and the internet
2. Managing data (with examples from your company)
- (on request) Extract data from your ERP
- Sort, filter and clean data
- Conditional formatting and lookup functions
- Analyze data: conditional calculations
3. Pivot tables: a powerful tool
- Prepare and validate data
- Analyze data: pivot tables
- Illustrate the analysis: pivot charts
- Prepare a report template that is easy to update
4. Adapt your use of Excel to the company’s needs
- Optimize your files: size and ergonomics
- Use Excel as a mail merge source
We study your needs with you beforehand, and adapt the content of the training to your needs, your data and the level of the participants.
