SOFTWARE: Microsoft Excel 2013
DURATION: 1 Session per level (8 hours per session)
Offered in Beginner, Intermediate and Advanced level. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. Take your Excel skills to the next level!
BEGINNER LEVEL
Areas of training:
- Getting Started with Excel
- Excel Selection Techniques
- Manipulating rows and columns
- Manipulating cells and cell content
- Sorting a Cell Range
- Excel Worksheets
- Freezing Row and Column Titles within Excel
- Font, Number and Alignment Formatting within Excel
- Excel Formulas
- Functions and Chart
- Customising Excel
INTERMEDIATE LEVEL
Areas of training:
- Excel Setup and Viewing Options
- Excel Functions and Formulas
- Excel Time and Date Functions
- Excel Mathematical, Logical and Statistical Functions
- Excel Financial, Lookup, and Database Functions
- Excel Named Ranges
- Excel Cell and Range Formatting
- Advanced Worksheet Manipulation within Excel
- Excel Templates
- Paste Special Options within Excel
- Proofing and Printing
ADVANCED LEVEL
Areas of training:
- Excel Pivot and Input Tables
- Excel Charts and Hyperlinks
- Linking within Excel
- Embedding within Excel
- Importing Text Files into Excel
- Sorting, Filtering and Totalling Data within Excel
- Tracking and Reviewing Changes in Excel
- Excel Scenarios
- Validating within Excel
- Auditing Techniques in Excel
- Macros within Excel
- Excel Passwords and Security Issues
