Advanced Spreadsheets
Course Aims
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
- Review of Basic Microsoft Excel course
- Inserting data
- Inserting Formulas and Functions
- Formatting and Editing Data
- Formatting the layout of the spreadsheet
- Relative and Absolute Referencing
- Advanced Formatting
- Styles
- Conditional Formatting
- Organising and Analysing data
- Name Manager
- Protecting your Workbook
- Sorting Data
- Filtering Data
- Using advanced Functions e.g.; If Function, Nested If Functions using AND/OR, VLookup, HLookup
- What-If Analysis
- Scenario Manager
- Goal Seek
- Data Table
- Creating Reports
- Subtotal
- Consolidate Scenarios
- Analysing Data using Pivot Tables and Pivot Charts
- Linking between worksheets and workbooks
- Sharing data between Microsoft Excel and Microsoft Word
- Working with Templates
- Charts
- Create, Edit and Format a Chart
- Adding Chart Elements
- Inserting Illustrations: Pictures, Shapes and SmartArt
Duration/Start
Thursday and Friday, 10am – 3pm
Entry Requirements
Completion of the Basic Microsoft Excel course or knowledge of the content of our Basic Microsoft Excel course.
Fee
€185