|
Introduction Course Content
- Understand
the excel window
- Call
on help
- Open
and navigate through a worksheet
- Create
save and print worksheets and workbooks
- Edit
a worksheet
- Changing
the look of a worksheet
- Format
and manipulate data
- Perform
calculations with functions and formulas
- Apply
quick data entry techniques
- Draw
simple charts and graphs
Improver Course Content
- Create
links between worksheets and workbooks
- Create
a Data Table
- Use
the Vlookup and Hlookup functions
- Use
the “If” function to create a formula which
makes a decision
- Create
Graphs and charts
- Adopt
a level of security for your workbooks appropriate to
your needs
Advanced Course Content
- Use
the Count Functions effectively
- Incorporate
Text Functions into existing spreadsheets
- Combine
other functions to make advanced If Statements
- Perform
File Calculation Audit
- Use
Goal Seeking to work a calculation back with altered
parameters
- Use
Data Tables for simple “What if” questions
- Use
Data Projection to secure workbooks and worksheets
- Employ
Pivot Tables to see database information in simplified
views
- Use
Macros to automate repetitive tasks
|