Search courses 👉
Professional Training
5.0 (32 Reviews)

Excel Intermediate

Future Savvy, In London (+4 locations)
Length
1 day
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Length
1 day
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Leave your details so the provider can get in touch

Course description

Excel Intermediate

This course is designed for learners who already have foundational knowledge and skills in Microsoft Excel and who wish to take advantage of some of the higher-level functionality in Excel to analyze and present data. Upon completion of this course, you will be able to leverage the power of data analysis and presentation to make better informed, intelligent organizational decisions.

Upcoming start dates

Choose between 4 start dates

Enquire for more information

  • Classroom
  • Birmingham

Enquire for more information

  • Classroom
  • London

Enquire for more information

  • Classroom
  • Manchester

Enquire for more information

  • Classroom
  • Reading

Suitability - Who should attend?

Learners should have used Excel before and be familiar with creating basic formulas, using Autofill along rows or columns and working with Absolute Cell References (e.g. $C$5) to refer to fixed figures – such as VAT rates or performance targets.

Outcome / Qualification etc.

What You Will Learn

In particular you will be able to:

  • Create advanced formulas
  • Work with named ranges
  • Analyze data by using functions and conditional formatting
  • Organize and analyze datasets and tables
  • Manipulate worksheets

Training Course Content

Excel Setup & Printing Issues

  • Headers and Footers
  • Scaling Your Worksheet to Fit Page(s)
  • Printing Titles on Every Page
  • Previewing a Worksheet

Excel Functions and Formulas

  • Getting Help with Functions
  • Nested Functions
  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas

Excel Most Used Functions

  • Inserting the Current Time and Date
  • Today Function
  • Now Function
  • Round Function
  • Sumif Function
  • If Function
  • Trim Function
  • Concatenate Function
  • Vlookup Function

Excel Named Ranges

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions

Excel Cell Formatting

  • Conditional Formatting
  • Custom Number Formats

Manipulating Worksheets within Excel

  • Copying or Moving Worksheets between Workbooks
  • Hiding Rows
  • Hiding Columns
  • Un-Hiding Rows
  • Un-Hiding Columns

Paste Special Options within Excel

Using Paste Special ‘Values’

Tables

  • Preparing data for a table
  • Creating a table
  • Formatting a table
  • Display the table total row
  • Adding a row to a table
  • Deleting a row from a table
  • Inserting a column in a table
  • Deleting a column in a table
  • Renaming a table
  • Advantages of a table
c

Reviews

Average rating 5

Based on 32 reviews.
Reviews are published according to our review policy.
Write a review!
Sophie
5/5
08 Nov 2023

Claire was very knowledgable and a fantastic trainer for the course

Amy
5/5
11 Oct 2023

Excellent course provided by Lee

Mark
5/5
20 Sep 2023

Excellent course at the correct level for me personally to increase my undestanding and capability when using excel

Request info

Contact form

Fill out your details to find out more about Excel Intermediate.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Future Savvy

Welcome to Future Savvy, your gateway to a world of boundless learning and professional growth! At Future Savvy, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals...

Read more and show all courses with this provider

Ads