Microsoft Excel – Intermediate

REIM Training Solutions

Microsoft Excel – Intermediate

31 31 people viewed this event.

Excel for the Real World:  Bring your Excel skills to a New Level

 

Our intermediate course is designed to introduce new features of Excel that will enable users to be understand more of Excel ‘s features

 

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

The objective of our Microsoft Excel Intermediate training course is to develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables.

Who should Attend

The Microsoft Excel Intermediate course is aimed at users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.

Learning Objectives

Upon successful completion of this course, you will deepen your understanding of Excel and be ready to custom formulas, apply built-in Excel functions and manipulate data to extract the insights you need.

Prerequisites

  • Participants should be existing users of Microsoft Excel who can create, edit, format and print a spreadsheet.
  • If you have attended or understand the concepts covered at the foundation level, this course may be your next step.

Course Outline

  • Create complex formulae incorporating relative and absolute cell addressing
  • Use a wide range of Excel functions such as Sumif, Countif, IF, Or, And, Lookups, ISError and many more
  • Build and apply Conditional Formatting
  • Link Sheets and Files
  • Manipulate Data – Sorting, Filtering, Validation
  • Create Pivot Tables
  • Create a wide range of Charts

Scroll to Top