Topics include
- Importing data
- Database functions
- Data validation and Consolidation
- Auditing tools and Scenarios
- Introduction to Pivot Tables
Topics include:
- Using date and time functions
- Linking data across spreadsheets
- Filtering, Sorting and Sub-totaling
- Lookup tables and Logical Functions
- Introduction to Macros
Topics include:
- Entering and editing data
- Formatting spreadsheets
- Designing formulas
- Creating editing and printing charts
- Page setup and printing of spreadsheets
Who is it for?
This course would benefit anyone who is working with numbers and data, who needs to be able to create spreadsheets and understand formulas.
What will I learn?
- Create simple spreadsheets to manage data
- Construct formulas to ensure data calculations work effectively
- Increase competency in working with larger spreadsheets
Course Overview
- Familiarisation with the Excel Interface
- Formatting spreadsheets
- Entering and editing data
- Designing formulas
- Absolute and relative cell references
- Creating editing and printing charts
- Page setup and printing of spreadsheets