ABOUT THIS COURSE

ECDL Level 3 Advanced Spreadsheets sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application. 

After completing this course you will be able to: 

  • Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets. 
  • Use functions such as those associated with logical, statistical, financial and mathematical operations. 
  • Create charts and apply advanced chart formatting. 
  • Work with tables and lists to analyse, filter and sort data. Create and use scenarios. 
  • Validate and audit spreadsheet data. 
  • Enhance productivity by working with named cell ranges and macros. 
  • Use linking, embedding and importing features to integrate data. 
  • Compare and merge spreadsheets. Apply spreadsheet security features 


Please note examinations are not included as part of the course fee. These need to be purchased and arranged with your nearest ECDL Testing Centre. Please click here to find your nearest BCS centre. 

COURSE CURRICULUM

  • 01

    Course Files

    • Course Files

  • 02

    Formatting

    • Conditional Formatting

      FREE PREVIEW
    • Custom Formatting

    • Table Styles

    • Moving and Copying Worksheets Between Workbooks

    • Splitting A Worksheet Window

    • Hiding and Unhiding Rows, Columns and Worksheets

  • 03

    Functions and Formulas

    • Database Functions

    • Date and Time Functions

    • Financial Functions

    • Lookup Functions

    • Mathematical Functions

    • Mixed References in Formulas

    • Nested Functions - 2 Levels

    • Statistical Functions

    • Sum Functions

    • Text Functions

  • 04

    Charts

    • Creating Charts

    • Formatting Charts

  • 05

    Analysis

    • Pivot Tables

    • Data Tables

    • Sorting Multiple Columns and Custom List Sort

    • Advanced Filtering

    • Sub Totalling

    • Scenarios

  • 06

    Validating and Auditing

    • Validating

    • Auditing

  • 07

    Enhancing Productivity

    • Naming Cells

    • Activate and deactivate the group mode

    • Paste Special

    • Templates

    • Importing From A Text File

    • Linking and Removing Links

    • Automation

  • 08

    Collaborative Editing

    • Compare and Merge Spreadsheets

    • Security

    • Track Changes

    • Hiding and Unhiding Formulas

MEET YOUR INSTRUCTOR

Richard Walters is one of NILC's senior level Microsoft Office trainer's and has more than a decade of experience in IT and Business Skills training. Richard has an advanced-level understanding of all Microsoft Office packages and specialises in Excel, Word, PowerPoint, Visio and Project.

Richard Walters

Senior Microsoft Application Instructor

FAQ's

  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.