This 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.
Date: This is a roll-on, roll-off course and learners can enrol at any time.
Tuition Time: 14 hours
Full Course Fee £250
Location: Riverside Innovation Centre, 1 Castle Drive, Chester CH1 1SL
This course can be offered as group training. Please click here for a quote.
You will receive an Academy certificate on completion of this course.
Date: This is a roll-on, roll-off course and learners can enrol at any time.
Tuition Time: 14 hours
Full Course Fee £250
Location: Riverside Innovation Centre, 1 Castle Drive, Chester CH1 1SL
This course can be offered as group training. Please click here for a quote.
Pre-Requisites
This 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 |
Course Objectives
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.
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:
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.
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.