Understand:
Data entry best practices
Basic excel functions and formulas
Including commands
Advanced excel functions and formulas
Including VLOOKUPs, pivot tables and charts
How to use available resources
Practice:
Formatting
Using basic excel functions and formulas
Using VLOOKUPs and pivot tables
Creating charts
In this module, we’ll first discuss data entry and then will focus on excel – given the amount it is used in our role as accountants / finance professionals
Session will be interactive, so laptops will be required. The best way for us to learn this type of material is through hands-on practice.
We won’t be going through the very basics, such as setting up new tabs, using the tool bar, scrolling through exercise materials but feel free to ask any specific questions on these during the break.