MS Excel

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