Preloader spinner

Microsoft Excel Intermediate

Image of laptop displaying an image containing the words Microsoft Excel

COURSE AIMS

This Microsoft Excel intermediate course is for attendees who want to expand their knowledge to work with larger spreadsheets, create formulas across multiple worksheets and workbooks, manage tables of data, and use advanced formatting techniques.

Our Microsoft Excel course is delivered using the latest version available through Microsoft 365. This ensures that our demonstrations include the most up-to-date features and functions. While many of the concepts and techniques covered are applicable to earlier versions of Excel, there may be some differences in the user interface and available features. If you are using an older version of Excel, our trainers are happy to provide guidance on how to access similar functionalities within your version.

COURSE PRE-REQUISITES

Attendees who wish to attend this course must have knowledge of Excel and feel comfortable with creating, formatting, and editing spreadsheets. They should be able to write formulas using multiplication, addition, subtraction, division and use the basic functions, sum, average, max, min and count.

COURSE OBJECTIVES

On completion of this course, delegates will be able to:

  • Create formulas across multiple worksheets
  • Copy formats and values across multiple worksheets
  • Copy and link information across multiple workbooks
  • Manipulate text and use Text functions
  • Apply, edit, and delete conditional formatting
  • Create and modify data tables
  • Create sub totals and group & ungroup data

COURSE CONTENT

Introduction and Objectives

 

Working with Multiple Worksheets

  • Selecting multiple worksheets
  • Creating formulas across worksheets
  • Using grouped worksheets
  • Referencing cells across sheets
  • Hyperlinking between sheets

 

Using Multiple Workbooks (Files)

  • Opening, activating & tiling workbooks
  • Copying data between workbooks
  • Creating formulas across workbooks
  • Editing workbook links

 

Using Paste Special

  • Copying values & formulas between worksheets
  • Transpose a table

  

Working with Excel Data Tables

  • Converting existing data into a table
  • Using the Quick Analysis button to add totals to a table

Working with Outlines

  • Applying, expanding & collapsing an outline
  • Modifying and clearing outline
  • Using Auto Outline

 

Manipulating Text

  • Use Text to columns to split a single column of data into multiple columns
  • Using Text Functions (Upper, Lower, Proper, Trim, Left, Right and Concatenate)

 

Using Conditional Formatting

  • Applying a comparative conditional formatting rule
  • Managing conditional formatting rules (editing, formatting, and deleting)
  • Applying built-in data bars and colour scales to numeric data

 

 Creating Subtotals in a List

  • Creating subtotals for groups of data
  • Creating multiple subtotals
  • Copying visible data to a new worksheet
  • Removing subtotals

 

Hints and Tips

Related Courses

Download PDF Outline

CLIENT TESTIMONIALS

"Really enjoyed the training, all content was explained thoroughly."

"I thoroughly enjoyed this course, it was pitched at just the right level for me. I wanted a refresher, and that's what I got!"

"Informative, helpful, and explained well by the trainer."

"The course covered everything it said it will cover and content was presented in a clear manner."

"The trainer was very personable and engaging and was very knowledgeable and able to answer any questions."

"I really enjoyed the course, very informative."

Public Schedule

RRP:  
£225 per delegate
Our price:  
£150 per delegate

Virtual Private Training

Contact us for pricing

Onsite Training

Contact us for pricing

Note

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

You may also like...

Microsoft Visio Intermediate

Enhance your skills with our Microsoft Visio Intermediate course. Learn advanced diagramming techniques and streamline your workflow efficiently.

An icon of a clock
Duration:

1 Day

Microsoft Visio Introduction

If you are interested in learning how to use Microsoft Visio to help you create visually engaging diagrams, then this course is perfect for you.

An icon of a clock
Duration:

1 Day

Copilot for Microsoft 365 for Business Users

Enhance your productivity with the Copilot for Microsoft 365 course for business users. Learn to leverage AI across Word, Excel, PowerPoint, Teams, and Outlook.

An icon of a clock
Duration:

1 day

Enquire about this course

Microsoft Excel Intermediate
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.