Excel Intermediate | 13 Dec 2021

Intermediate Course on Microsoft Excel

This is a 1-day course helping you to continue to unlock the maximum potential of this popular data-analysis tool. After completing the course, you will have increased understanding of the Excel toolset and know which function or feature to use for your work.

If you are not sure , contact us to assist you choosing the relevant level of training and we can work with your live files in order to achieve maximum productivity.


Intermediate

Refreshing the Basics


Advanced Functions

  • IF function
  • Creating multiple IF statements

Look ups

  • Information functions
  • Data calculations
  • Testing for errors
  • Naming ranges

Working with multiple sheets

  • Creating a new workbook
  • Selecting cells across worksheets
  • Entering formulae across worksheets
  • Using paste link
  • Splitting the worksheet into panes
  • Fixing worksheet titles
  • Copying and moving between worksheets
  • Copying and linking between workbooks
  • Insert, delete and group worksheets

Working with lists

  • Sorting data
  • Using the automatic filter
  • Flash Fill

Tools

  • Spell check
  • AutoCorrect
  • Find and replace
  • Cell and workbook protection
  • Using Zoom

Introduction to Pivot tables


Charts and Drawing

  • Creating a chart
  • Changing the chart type
  • Chart options
  • Formatting a chart
  • 3D View
  • Printing
  • Using the drawing tool

To introduce you to how we work here is a

Video on Index and Match
https://youtu.be/TLxAzrL-Y_Q

Testimonials

Training at the intermediate level, covering advance functions such as if statements, VLOOKUP's and pivot tables

"Thanks for the training provided yesterday. The feedback I received from the team was positive and they now feel better equipped in using excel.”

Dave
Accounts & Finance Manager, UK & Ireland, AS 24 Distribution

Delivery: Online (live)
Level: Intermediate
Course Dates : 13 Dec 2021
Day & Time:
Week Days
Weekend
Daytime
Evening
What is included:
VAT
Breakfast
Lunch
Refreshments
Digital courseware
Digital Recording
Printed courseware
Accommodation
Extra revision sessions
Venue: Virtual Live Meeting
Training Instructor accredited by: Microsoft (MCT)
Style:
Authoritative
Challenging
Inspiring
Methodical
Starts: December 2021
Duration: 1 day or less

Public discussion (0)

You must log in to send a new comment.