In business, it is important that the data stored by an organisation is accessed, manipulated and analysed in a secure and robust manner. Integration with other applications and sharing data between users is now commonplace, making security an essential consideration in spreadsheet design.
You will learn how to implement advanced functions and features such as macros and will be familiar with the basics of Visual Basic for Applications (VBA).
During the course you will learn how data can be successfully and securely exchanged with outside sources and how it can be shared between multiple users. Advanced data analysis and functions are considered, along with an introduction to macros and VBA. The course is designed as a practical course enabling you to receive hands-on experience of all topics covered.
The content will be relevant to Excel 2007, 2010 and 2016 and will cover the following topics:
SESSION 1 (2HR) - SUBTOTAL/PIVOT TABLES & AUDITING
- Subtotal
- Pivot Tables
- Pivot Charts
- Precdents/Dependants
- Error Checking
- Calculate Formula
- Watch Window
SESSION 2 (2 HR) - NESTED IF/LOOKUPS
- IF Functions Recap
- Nested IF
- Lookup
- Match/Index
SESSION 3 (2 HR) - LINKING & CHARTS
- Linking Sheets
- Linking Files
- Managing Links
- Chart Types
- Chart Elements
- Modifying Chart Elements
- Combo Charts
