Intermediate Microsoft Excel

Having got to grips with the basics of using an Excel spreadsheet, many of us are required to create or extract a little more complex information. Our Intermediate Microsoft Excel training course is designed to help you do exactly that.

On this course you will be able to create and work on several Excel spreadsheets at the same time, use and understand formulas and formatting, learn how to extract relevant data from your spreadsheet by filtering the information required and effectively convert data into a professional chart.

The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned. This course is the ideal stepping stone for our Advanced Microsoft Excel course.
To get the most out of this course, a basic knowledge of using spreadsheets is recommended and ideally you should be comfortable with the Microsoft Windows environment.

Course Duration

1 Day

Course Content

Download Course Content PDF

  • Revision
    • Review of Introduction day
    • Revision Exercise
  • More about Calculations
    • Absolute References
    • Using Functions
    • Simple Statistical Functions
    • The IF Function
  • More Features
    • Using Comments
    • Using Zoom
    • Splitting and Freezing
  • Printing Worksheets
    • Fitting a Spreadsheet on a Page
    • Altering Page Margins
    • Adding Headers & Footers
    • Setting the Print Area
    • Using Print Titles
    • Controlling Page Breaks
  • Charting Features
    • Creating Charts
    • Revising a Chart
    • Formatting Chart Elements
    • Adding Data to an Existing Chart
  • Working with Multiple Worksheets
    • Selecting Multiple Worksheets
    • The Worksheets Context Menu
    • Navigating Multiple Worksheets
    • Calculations between Worksheets
  • Data Commands
    • Working with Lists
    • Sorting a List
    • Sub-Totalling a List
    • Filtering a List

Download Full Course Schedule PDF

Ask a question

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.
 

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk