Level 3 Spreadsheet Software

£250.00

Level 3 Spreadsheet Software course examines the more advanced, powerful features of the Microsoft Excel application giving learners the digital skills to enhance their work, improve productivity and save time.

You will receive an Academy certificate on completion of this course.

By the end of Level 3 Spreadsheet Software you will be able to:

  • Produce professional spreadsheets using powerful features
  • Have an increased knowledge and expertise sort by employers
  • Demonstrate advanced methods to integrate different types of data.

Download the full course details

Tuition Time:

14 hours

Date:

This is a roll-on, roll-off course and learners can enrol at any time

Course Location:

Riverside Innovation Centre, 1 Castle Drive, Chester CH1 1SL
Delegates:
Book this course

​This course can be offered as group training, please click here for a quote.

Pre-Requisite
Level 3 Spreadsheet Software course is suitable if you are an experienced user of Excel and would have already attended our Level 2 Spreadsheet Software course or use the features listed on our level 2 course content on a weekly basis.
Course Content

Advanced Functions
• Nested IF statements
• Nesting IF with AND, OR
• ISERROR and IFERROR
• SUMIF and SUMIFS
• COUNT and COUNTIFS

Date Functions
• DATEIF
• Date Functions

Lookup and Information Functions
• Advanced Lookup (True and False)
• Creating Multiple Column Lookups
• Match Function
• Index Function
• OFFSET Function
• Advanced List Management
• Advanced Filter
• Database Functions

SubTotals
• Creating Subtotals
• Outline View

Advanced Pivot Tables
• Inserting Calculated Fields
• Manipulating Fields
• Changing Value Field Settings
• Grouping Data containing Dates and Numbers
• Formatting Pivot Tables
• Showing and Hiding the Grand Totals
• Changing the Scope of the Data Source
• Summarising Values by Sum, Count, Average, Max
and Product
• Show Values as % of Grand Total, Column Total or
Row Total
• Creating Pivot Table Reports and Pivot Chart
Reports
General Analysis Tools
• Scenarios
• Custom Views
• Goal Seek
• Solver
• Data Tables, One Input, Two Input

Protecting and Sharing
• Sharing a File
• Track Changes
• Protecting Cells, Worksheets
• Password Protect a File/Read Only

Formulae Auditing
• Formula View
• Tracing Precedents
• Tracing Dependents
• Use Watch Window
• Go to Special

Introduction to Macros
• Displaying the Developer Tab
• Recording a Macro
• Where to Save Macros – Personal, Existing or New

Workbook
• Absolute and Relative Recording
• Introduction to Form Control Buttons
• Creating Macro Buttons

 

About the Provider

​We are two highly qualified teachers with extensive experience of working in further education and can provide a range of digital training opportunities. We offer a high quality customised service that recognises each organisation’s challenges. We will also provide digital skills training for individuals so they can reap the benefits of long-term success.

We offer:

  • Upskilling ‘non-qualification’ training
  • Flexible Delivery
  • Cost and time effective
  • Delivered by ‘Outstanding Treachers’ as recently identified by Ofsted
  • Consultation to identify your specific training needs

Want to know more

To find out more about our tailored Digital Skills Training for Businesses, Groups and Individuals, please email: info@cdsacademy.co.uk or telephone us for an initial informal chat on 01244 515525 to discuss your requirements.