• 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 Advanced Overview

This page gives you a full overview of our Excel Advanced Course, what’s included, the key topics we cover, and what you can expect to learn as someone with existing knowledge.

    Microsoft Excel Advanced 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

    How to utilise the enhanced data handling, statistical, charting and presentation functions and apply them effectively to produce, manage and present spreadsheet data effectively. To manipulate and present data using the pivot table, query, outline and data interpretation functions.

    TARGET AUDIENCE

    Those wanting to obtain advanced skills in using a spreadsheet, such as functions, scenarios and macros.

    WHATS INCLUDED

    🔹Professional instructor‑led training

    🔹Courseware included

    🔹Lunch provided

    🔹Free on‑site parking at our Exeter training suite

    🔹Certificate of completion

     

    COURSE PREREQUISITES

    Delegates should have attended the Introduction to Excel course or be proficient in the use of an equivalent package.

    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 Advanced course provides the ideal foundation for building your skills for work, study, and personal use.

    SUBJECT AREAS

    • Excel Functions
    • Getting help about using a particular function
    • TODAY
    • DAY
    • MONTH
    • YEAR
    • SUMIF
    • ROUND
    • COUNT
    • COUNTA
    • COUNTIF
    • PROPER
    • UPPER
    • LOWER
    • CONCATENATE
    • FV
    • NPV
    • PMT
    • PV
    • RATE
    • HLOOKUP
    • VLOOKUP
    • IF
    • AND
    • OR
    • ISERROR
    • DSUM
    • DMIN
    • DMAX
    • DCOUNT
    • Nested functions
    • Using templates
    • Creating templates
    • Opening and editing templates
    • Using a one input Data Table command
    • Using a two input data table command
    • Scenario Manager – an example
    • Showing a scenario
    • Viewing an alternative scenario
    • Create a scenario summary
    • Goal Seek
    • Using the Goal Seek facility to make a formula reach a particular value
    • Tracing precedent cells
    • Tracing the dependants of a cell
    • Displaying all formulas within a worksheet
    • Adding comments
    • Displaying comments
    • Removing comments
    • Editing comments
    • Displaying the Developer tab
    • Recording and running macros
    • Lowering your macro security level
    • Customizing the Quick Access Toolbar
    • Changing the Quick Toolbar Macro icon
    • Removing a macro icon from the quick access toolbar
    • Raising your macro security level
    Have Questions or Ready to Book?

    For more information, or to book onto our Microsoft Excel Advanced 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