Microsoft Excel 365 Intermediate Training

By using Excel 365 along with its new features, everyone attending this course will have greater confidence in using Excel features that are definitely beyond the basics.

In this Microsoft Excel Intermediate training course you will learn how to:

  • Create PivotTables
  • Create & use VLookup & IF Functions
  • Create Charts
  • Create Essential Date & Time Functions
  • Share a Spreadsheet

This 1-day course is available either at your premises or at the Cambourne training venue.  If you would like to book this course, please email us, and we'll let you know the available dates.  As soon as a date has been fixed the training day will be booked. 

Training Delivery: Live Online Instructor Led & Classroom Face to Face

Course Duration: 1 Day 09:30 - 16:30

    Excel Classes Online Instructor Led Online Training Course - All you need to know.

    Enquire Here

    What are the Benefits?

    • Hands on training 
    • Comprehensive online courseware for delegates to keep
    • Online certificate of completion for each delegate
    • 1 Month post training support

    Microsoft Excel Intermediate

    Lists, lists, lists it seems as if the whole world is a bundle of lists. It doesn't matter what industry you are associated with you will need to analyse and present data. You don't have to have attended the beginners Excel course to attend this one. However, being a little familiar with Excel will of course be a great help.

    Course Outline

    Introduction to Excel 365 and the Excel interface

    • Understanding rows, columns, and cells
    • Navigating and selecting data in a worksheet
    • Entering and editing data in cells
    • Basic formatting techniques (e.g. changing font size, colour, and alignment)

    Basic formulas and functions within Excel 365

    • Using basic arithmetic operators (e.g. +, -, *, /)
    • Understanding the difference between relative and absolute cell references
    • Using functions such as SUM, AVERAGE, MIN, and MAX

    Working with multiple worksheets and workbooks

    • Creating, renaming, and deleting worksheets
    • Moving and copying data between worksheets and workbooks
    • Linking data between worksheets and workbooks

    Sorting and filtering data

    • Sorting data alphabetically or numerically
    • Filtering data using criteria
    • Advanced filtering techniques (e.g. using AND/OR logic)

    Working with basic charts and graphs

    • Creating and formatting charts and graphs
    • Adding data labels and data tables to charts
    • Changing the chart type and style

    Importing and exporting data

    • Importing data from other sources (e.g. CSV files, databases)
    • Exporting data to other formats (e.g. PDF, CSV, HTML)

    Collaborating with others, including printing

    • Sharing workbooks and worksheets with others
    • Tracking and resolving conflicts in shared workbooks
    • Protecting worksheets and workbooks with passwords
    • Printing worksheets

    This Live Online Instructor led Microsoft Excel Intermediate training course is available from wherever you are.

    Looking for something specific?