Advanced Spreadsheets

Course details

The aim of this course is to give candidates a comprehensive training in the specialised features of this powerful spreadsheet software, focusing on practical business applications such as:

• sales figures, budgets, forecasts, etc.
• databases
• analysing statistical or numerical possibilities presenting statistical reports, etc.

Course Content

Creating spreadsheets

• Inserting data
• Inserting Formulas and Functions
• Formatting and Editing Data
• Formatting the layout of the spreadsheet

Relative and absolute cell address

Editing between worksheets and workbooks

Organising and analysing data

• Sorting data
• Filtering Data
• Database Functions
• Auditing a Worksheet
• Creating Reports using Subtotals, Consolidation Scenarios, Goal Seek and Solver Utilities, etc.
• Using advanced Functions e.g.; If Function, VLookup
• Advanced Formatting. e.g. Styles, Templates, Conditional Formatting
• Working with Pivot Tables
• Linking between worksheets and workbooks
• Sharing data between Microsoft Excel and Microsoft Word
• Charts
• Objects and Drawing