This course is suitable for anyone who already has a good working knowledge of Excel and who would like to acquire additional skills & knowledge on using the many features & functions of this software package.

Course Outline

• LINKING WORKSHEETS & WORKBOOKS
  
• - Point and Click Approach
  - Managing and Editing Links
  
• GROUPING WORKSHEETS
  
• - Reasons for grouping
  - Grouping selected sheets and de-selecting
  - Grouping all sheets
  
• FUNCTIONS
  
• - Logical Functions
  - Nested Functions
  - Lookup and Reference Functions
  - The insert function option
  - Text functions
  
• WORKING WITH LISTS
  
• - List layout
  - Data forms
  - Sorting
  - Filtering
  - Sub totals
  
• DATA VALIDATION
  
• ADD GROUPING AND OUTLINING TO RANGES
  
• CONDITIONAL FORMATTING
  
• GOAL SEEK
  
• SCENARIOS
  
• TEMPLATES
  
• - Creating, using and editing
  
• CUSTOMISING EXCEL
  
• - Customising menus
  - Creating new menus
  - Customising Toolbars
  - Create, edit and run macros
  
• CREATING PIVOT TABLES
  
• WORKGROUP COLLABORATION
  
• - Modify passwords, protections and properties
  - Creating shared workbooks
  - Tracking changes
  - Merging Workbooks