Microsoft Excel: Advanced
This course is ideal if you have existing knowledge of Microsoft Excel and want to build upon your skills.
Entry requirements
To begin this course you should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course content
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel tools and concepts in order to increase their knowledge and productivity.
Topics covered will include:
- Data Validation
- Conditional Formula
- Lookup Formulas
- Advanced Tables
- Advanced Charts
- Using Graphics in Excel
- Protecting Data
- Subtotalling Data
- What-If Analysis
- PivotTables & PivotCharts
- Macros
Assessment methods
There will be no assessments or exams for this course; at the end you will receive a Bedford College course completion certificate.
Further study and career options
Additional information
This course will be delivered using Microsoft Office 2013 and will also be suitable for users of Microsoft Office 2016, 2010 or 2007. If you are using Microsoft Office 2003 or any other version, please contact us to discuss further.