Microsoft Excel – Advanced

REIM Training Solutions

Microsoft Excel – Advanced

27 27 people viewed this event.

Excel for the Real World:  Supercharge your Microsoft Excel Skills to the next level

 

Structuring the organisation of information in a workbook is crucial to developing powerful models.  Our Advanced course is designed to help attendees work with larger spreadsheet models.  This course will explore how existing data can be mined using different analysis techniques. The course will examine several real world problems and discuss how these can be tackled using techniques available in Excel.

 

Choice of Flexible Delivery Options:

 

~  1 Day of Training

~  2 Mornings  /  2 Afternoons  /   2 Evenings

 

Enquire Now

 

Date And Time

-
 

Location

Online event
 

Event Category

 
Download Events iCal

Share With Friends

Programme Benefits

There is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to make the most of Excel and what it has to offer.

Who should Attend

This class is for users familiar with primary Excel features but who need more powerful features like lookups, error-handling, macros and scenario analysis.

Learning Objectives

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

Prerequisites

  • Participants should be existing users of Microsoft Excel.
  • If you have attended or understand the concepts covered at the intermediate level, this course may be your next step.

Course Outline

  • Create multi-sheet spreadsheet models
  • Protect workbooks and worksheets
  • Use the tracking tool to debug spreadsheets
  • Creating Sparklines and Mapping Data
  • Learn lookup and conditional formulae
  • Customise graphs
  • Forecasting Data

Scroll to Top