• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
Microsoft Excel Training Course

Microsoft Excel Intermediate Overview

This page gives you a full overview of our Excel Intermediate Course, what’s included, the key topics we cover, and what you can expect to learn with developing Excel Skills.

    Microsoft Excel Intermediate Training Overview

    DURATION

    One full day: 9:30am – 4:30pm

    LOCATION

    Exeter, Devon, Cornwall, Somerset, Dorset, Onsite at your premise, Remote Live Session via Teams

    For onsite courses we can provide the rental of laptops with the software pre-installed.

    OVERVIEW AND OBJECTIVES

    This course is designed to help you to develop your skills in using the spreadsheet tool Microsoft Excel. You will learn to use more advanced functions and create more complex formulas. You will learn to manage and link together multiple worksheets.

    You will also learn to apply more advanced formatting to charts and use basic reviewing tools, such as the spelling checker and comments.

    TARGET AUDIENCE

    Those wanting to develop their skills in using Excel to design spreadsheets to solve basic accounting and data analysis tasks.

    WHATS INCLUDED

    🔹Professional instructor‑led training

    🔹Courseware included

    🔹Lunch provided

    🔹Free on‑site parking at our Exeter training suite

    🔹Certificate of completion

     

    COURSE PREREQUISITES

    Ideally, you will have completed the course “Microsoft Excel Introduction”. You should be able to use Microsoft Excel to create, edit, format, and print a spreadsheet incorporating simple formulas and charts.

    WHY CHOOSE OUR EXCEL TRAINING?

    With years of experience delivering Excel courses to businesses and individuals, we make learning Excel simple, practical, and enjoyable. The Intermediate course provides the ideal foundation for building your skills for work, study, and personal use.

    SUBJECT AREAS

    • Paste Special
    • Transposing data
    • Importing text and delimiting by space, comma or tab
    • What does naming a cell range mean?
    • Rules for naming cells and ranges
    • Naming cell range(s) in a worksheet
    • Named ranges within formulas
    • Navigating through workbooks using named ranges
    • Creating named ranges automatically based on cell values
    • Deleting named cells/ranges
    • Formatting tables
    • Formatting cell ranges using conditional formatting
    • Creating custom number formats
    • COUNTA
    • COUNTIF
    • SUMIF
    • COUNTIFS
    • SUMIFS
    • IF
    • TODAY
    • AND
    • OR
    • Nestied Functions
    • Sorting internal Excel databases
    • Custom sort options
    • Using AutoFilter to query data
    • Multiple queries
    • Removing filters
    • Top 10 AutoFilter
    • Filtering unique records
    • Advanced Filter
    • Creating and Removing subtotals
    • Creating a PivotTable
    • Dropping data into the Pivot Table
    • Modifying data and refreshing the Pivot Table
    • Grouping data within a Pivot table
    • Linking individual cells within a worksheet
    • Linking charts to data within a worksheet
    • Linking a cell range on one worksheet to another worksheet (within the same workbook)
    • Linking data on one worksheet to a chart in another worksheet (within the same workbook)
    • Linking data from one workbook to another
    • Linking a chart from one workbook to another
    • Copying data from Excel into a Word document
    • Linking data from Excel into a Word document
    • Copying a chart from Excel into a Word document
    • Linking a chart from Excel into a Word document
    • Consolidating data over several worksheets or worksheet pages
    • Changing a column, bar, line or pie slice colours
    • Changing the chart type
    • Modifying Charts using the Layout tab
    • Copying and moving charts within a worksheet
    • Copying and moving charts between worksheets
    • Copying and moving charts between workbooks
    • Changing the angle of pie chart slices
    • Formatting the chart axis fonts
    • Formatting the chart axis scales
    • Formatting the chart axis text orientation
    • Creating and positioning a chart title
    • Re-positioning a chart legend
    • Re-positioning chart data labels
    • Exploding the segments within a pie chart
    • Adding and Deleting a data series within a chart
    • Modifying the chart type for a defined data series
    • Widening the gap between columns / bars within a 2-D chart
    • Inserting an image into a 2D chart (as a background)
    • Inserting an image into a 2D chart (to format a column or bar of data)
    • Chart background colour
    • Specifying a password for opening a workbook
    • Using the “read-only recommended” option
    • Removing a password from an Excel workbook
    • Protecting a worksheet or worksheet elements
    • Removing workbook protection
    • Allowing selective editing of a protected worksheet
    Have Questions or Ready to Book?

    For more information, or to book onto our Microsoft Excel Intermediate training course, please get in touch.

    If there’s a Microsoft course you’re interested in that isn’t listed on our website, let us know we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    info@amesolutions.co.uk

    Name