4       Internet links – Hyperlinks

4       Toolbar customise with VBA              

4       Workspaces                                      

4       New printing techniques             

4       Expert editing tips                             

4       Adding comments

4       View & Report Managers                 

4       Picture charts                                   

4       Graphing techniques                       

4       Formulas    

4       Absolute/Relative/Mixed cell addressing    

4       The Function Wizard

4       Macros – Visual Basic for Applications (VBA)

4       Using VBA as formulas    

4       Named Ranges                                  

4       Auto & Conditional formatting            

4      Styles                                                 

4       Sharing work files/tracking the changes

4       Protecting data                                    

4       Filtering data – setting criteria            

4       Working with input forms                   

4       Data validation                                      

4       Using tables                                        

4       Working with input forms                   

4       Data validation                                      

4       Using tables                                        

4       Converting text data to column format 

4       Consolidate data from different sources / linking  

4       3D formulas in sheets & other WorkBooks  

4       Grouping data                                         

4       Pivot Table models                                   

4       The Add-in Tools:

4       Goal Seek                                                

4       Scenario Manager                                    

4       Auditing                                                    

4       Solver

4       Array formulas – memory benefits for large spreadsheets                                             

4       Microsoft Query – getting external data   

4       Using Excel with other Office programs           

4       Designing spreadsheets for others to use

Assumptions:

Ø          Sound basic knowledge of program, navigation, simple formulas and formatting

Ø          Basic charting techniques