Excel Intermediate

    Excel - Intermediate Training Course


    This course is designed for those who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.



    • Quickly summarise multiple sheets of data into one
    • Turn long lists and reports into easy to read tables
    • Formulas to check whether cells pass or fail your rules
    • Create links between cells so that they all update automatically
    • Highlight targets, trends, duplicates and errors with Conditional Formatting
    • Formatting and layout consistency by saving as a Template



    Hours per Week 3 Months 6 Months 9 Months 11 Months 12 Months
     15 £1,800 £3,000 £4,000 £4,720 £4,900
     9 £1,500  £2,500  £3,300  £3,900  £4,050 
     6 £1,190  £2,030  £2,750 £3,350  £3,500
     4 £860  £1,460  £1,940 £2,360  £2,465 

    Full time classes are 15 hours per week or more

    Course Syllabus

    • What's new in Excel

    Getting Started
    Spreadsheet terminology
    Exploring the Excel window
    Getting help
    Opening and navigating workbooks
    Closing workbooks

    • Entering and Editing data

    Creating workbooks
    Entering and editing labels and values
    Entering and editing formulas
    Saving and updating workbooks

    • Modifying a Worksheet

    Moving and copying data
    Moving and copying formulas
    Using absolute references
    Inserting and deleting ranges

    •  Using Functions

    Entering functions
    Using AutoSum
    Using AVERAGE, MIN, and MAX

    • Formatting Worksheets

    Formatting text
    Formatting rows and columns
    Number formatting
    Using Format Painter and AutoFormat

    • Printing

    Preparing to print
    Page Setup options
    Printing worksheets

    • Creating Charts

    Chart basics
    Modifying charts
    Printing charts

    • Using Sparklines


    Course Syllabus

    • Working with Large Worksheets

    Viewing options

    - Adjusting zoom
    - Using Freeze Panes
    - Using Split Window

    Hiding and displaying data

    - Hiding rows and columns
    - Creating an outline

    Printing large worksheets

    - Page Break preview
    - Working with page breaks
    - Printing multiple sheets

    • Working with Multiple Worksheets and Workbooks

    Using multiple worksheets

    - Navigating between sheets
    - Moving and copying sheets

    Linking worksheets

    - Creating 3-D formulas
    - Consolidating data

    Linking workbooks

    - Creating a formula to link workbooks
    - Using the Paste Link option
    - Maintaining links

    • Working with dates

    Entering date functions

    - TODAY function
    - NOW function

    Date and time formats
    Using dates in formulas

    • Conditional formulas and formatting

    The IF function
    Conditional formatting

    - Based on a cell value
    - Based on a formula
    - Identifying cells with conditional formatting
    - Copying conditional formats

    • List Management

    Working with lists

    - Structure of a list

    Sorting and filtering lists

    - Simple sorting
    - Sorting by multiple columns
    - Using AutoFilter

    Advanced filtering

    - Using custom filter
    - Using Advanced Filter
    Adding subtotals to a list

    • Documenting and Auditing


    - Viewing, adding, editing and deleting comments

    Auditing features

    - Tracing formula errors


    - Protecting a worksheet
    - Protecting cell ranges

    • Using Templates

    Built-in templates

    - Accessing and using Excel’s templates

    Creating and managing templates

    - Creating, using and modifying a custom template file


    Connect with us

    45 Wimbledon Hill Road, Wimbledon, London SW19 7NA, United Kingdom

    • dummy +44 (0) 208 947 1338

    • dummy +44 (0) 208 947 7704

    • dummy info@amitycollege.co.uk


    Enter your email and we'll send you more information