Microsoft Excel Advanced

Overview

Microsoft Excel Advanced is designed for users who are keen to learn about more of the advanced features and techniques of Excel. It concentrates on improving current knowledge through the use of more advanced and complex techniques and spreadsheet automation.

Microsoft Excel Advanced assumes some prior experience in using the software to create worksheets and charts and Windows OS environment.

HOW will you benefit

  • Use a range of formula techniques
  • Use a range of lookup and reference functions
  • Apply conditional formatting
  • Filter data in a table
  • Use a range of techniques to enhance charts
  • Modify Excel options
  • Create and use labels and names in a workbook

SECURE your seat or REQUEST a proposal!

WHO should enroll

Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

WHAT you will learn

  • Working with Multiple Worksheets and Workbooks
  • Working with Financial and Date Functions
  • Working with Logical Functions
  • Working with Lookup and Reference Functions
  • Working with Data
  • Creating and Working with PivotTables
  • Introduction to Macros

What our Delegates Say

Meet Your Instructors

Our International Instructors have extensive EXPERIENCE & EDUCATION in their areas of EXPERTISE, which also makes them Inspirational Role Models for those who learn from them.

SECURE your seat or REQUEST a proposal!

Featured Courses