Description

Our Intermediate Microsoft Excel Course is designed for learners who already have a basic understanding of Excel and want to develop more advanced skills. This CPD-accredited online Excel course provides practical training to help you work more efficiently, analyse data with confidence, create professional spreadsheets and perform many more functions for business use.

Intermediate Excel Training

Microsoft Excel is an essential application across many careers and industries. Professionals in administration, finance, sales, HR, bookkeeping, customer service and management will all require at least proficiency in using Excel. This course helps learners enhance their existing knowledge and build skills and confidence using more advanced functions in Excel.

Upon successful completion, learners will receive a CPD-accredited Microsoft Excel Certificate at Intermediate level.

Microsoft Excel Intermediate Course

Course Format

Training is delivered entirely online through an interactive virtual tutor. The interactive learning system demonstrates each task, provides step-by-step guidance, marks practical exercises in real time and offers feedback throughout the course. This state-of-the-art learning system is managed by Microsoft Learning Partners and creates an engaging learning experience, similar to having your own personal IT trainer. Meanwhile, you can study at your own pace from any location, with flexible access that fits around work and personal commitments.

Course Content

  • Working with Cells and Formatting

    • Wrap text and display multiple lines in a cell
    • Date and custom number formats
    • Improve worksheet presentation
    • Format cells for professional spreadsheets

  • Formulas and Functions

    • Relative and absolute cell references
    • Using the Formula Wizard
    • The IF function
    • Working with functions and cell ranges
    • Editing and copying formulas

  • Data Validation and Conditional Formatting

    • Create data validation rules
    • Build drop-down lists
    • Apply conditional formatting
    • Manage formatting rules
    • Create and use named ranges

  • Charts and Data Visualisation

    • Create and modify charts
    • Format chart elements
    • Manage chart layouts and templates
    • Create Sparklines and Map Charts
    • How to print professional charts

  • Illustrating Your Data

    • Drawing objects and shapes
    • Text boxes and images
    • Formatting and arranging objects
    • Rotate, align and group objects

  • Working with Excel Tables

    • Create and manage tables
    • Sort and filter data
    • Add calculations
    • Remove duplicates
    • Filter using Slicers

  • PivotTables and PivotCharts

    • Create and edit PivotTables
    • Summarise and analyse data
    • Filter and group information
    • Create PivotCharts
    • Work with calculated fields and multiple data sources

Dates and Duration

You can start your course at any time and study when you prefer. The training is flexible and will fit your schedule. We recommend that you take your assessment within 6 months to obtain a CPD-accredited Microsoft Certificate (included in the price). You have access to the training program for 1 year.

Course Requirements

You should ideally have Beginner Level skills already; if you do not, please consider taking the Beginner Excel Course.

Benefits of the Intermediate Excel Course

  • Gain a CPD-accredited Intermediate Microsoft Excel Certificate
  • Strengthen your CV with a recognised professional qualification
  • Develop workplace Excel skills that will be valued by employers
  • Prepare for Excel assessments that are used by recruiters and employers
  • Work more efficiently in your job when using Excel
  • Improve confidence using Excel at work
  • Learn through an interactive learning system that includes work-simulated practical exercises
  • Study online at your own pace with one year’s course access

Outcome

On successful completion of the course, you will receive a CPD-accredited Microsoft Excel Intermediate Certificate.