future savvy logo
image

Microsoft Excel Training Courses For Intermediate

Excel Intermediate

Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.

  • Virtually Online Or On-Site

  • 1 Days

  • Next Running:

    6th November
UPCOMING COURSES
Wednesday

6th November 2024

Virtually Online
£275.00

EX. VAT

Monday

9th December 2024

Virtually Online
£275.00

EX. VAT

Wednesday

8th January 2025

Virtually Online
£275.00

EX. VAT

Thursday

6th February 2025

Virtually Online
£275.00

EX. VAT

Thursday

6th March 2025

Virtually Online
£275.00

EX. VAT

Thursday

10th April 2025

Virtually Online
£275.00

EX. VAT

Course Information

This 1-day Excel Intermediate training course is designed for learners who already have foundational knowledge and skills in Microsoft Excel.

Want to take you Excel skills to the next level?

We will teach you how to take advantage of some higher-level functionality in Excel in order to analyse and present data more effectively.

After just one day, you’ll be able to leverage the power of data analysis and presentation to make informed and intelligent decisions for your organisation.

Choose from our online public courses dates to book your course today.

Alternatively, contact us to arrange on-site training tailored to your needs!

Course requirements

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.


Still need to grasp the basics? Get started with our 1-day Excel Introduction course.

What you will learn

After completion of the Excel Intermediate training course you be will be able to:

  • Create advanced formulas
  • Work with named ranges
  • Analyse data by using functions and conditional formatting
  • Organise and analyse datasets and tables
  • Manipulate worksheets

By the end of this 1-day instructor-led Excel Intermediate course, you’ll know how to use things like conditional formatting, prepare and format all manner of Excel tables. Whats more, you will have an in-depth understanding of the most used Excel functions and formulas.

All with our 100% Money-Back Guarantee and Unlimited Email Support.

Course Outline

  • 1
    Excel Setup & Printing Issues
    • Headers and Footers
    • Scaling Your Worksheet to Fit Page(s)
    • Printing Titles on Every Page
    • Previewing a Worksheet
  • 2
    Excel Functions and Formulas
    • Getting Help with Functions
    • Nested Functions
    • Consolidating Data Using a 3-D Reference Sum Function
    • Mixed References within Formulas
  • 3
    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
  • 4
    Excel Named Ranges
    • Naming Cell Ranges
    • Removing a Named Range
    • Named Cell Ranges and Functions
  • 5
    Excel Cell Formatting
    • Conditional Formatting
    • Custom Number Formats
  • 6
    Manipulating Worksheets within Excel
    • Copying or Moving Worksheets between Workbooks
    • Hiding Rows
    • Hiding Columns
    • Un-Hiding Rows
    • Un-Hiding Columns
  • 7
    Paste Special Options within Excel
    • Using Paste Special ‘Values’
  • 8
    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

Private courses.

We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!

  • Tailored
  • Post Course Support
  • Cost Effective
Enquire

Reviews

  • Lee is excellent teacher

    Joanne
  • Lee is an excellent trainer

    Julie
  • Excellent course and very well delivered and explained by Lee

    Daren