Course Details
This Remote Worker Microsoft Excel Advanced module is aimed at those who work within an office and want to learn more or refresh their advanced skills. This is particularly true if your role has elements of finance, accounts or bookkeeping involved. The more financial aspects your role entails, the higher level of skill you will require in Excel.
The course format is ideal for anyone looking to learn advanced excel online.
This Remote Worker Microsoft Excel Advanced module also forms part of the Remote Worker Certificate, an ideal way of putting a development package together.
Benefits to you
At the end of this module delegates will be able to
- Understand some of the advanced features of Microsoft Excel
- Be able to use more functions in their Excel worksheets
Course Contents
- Relative & Absolute Addressing
- Text functions
- Logical Functions
- Sorting & Filtering
- Conditional Formatting
- Linking
- Standard & Combined Charts
- Sharing & Tracking
- Subtotals
- Further Functions
- Vlookup & Hlookup
- Date Functions
- Rank Function
Who should attend?
People who wish to enhance their skills and knowledge of the Microsoft Excel programme