Remote Worker Microsoft Excel Advanced

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