Microsoft Excel: Advanced
This course is ideal if you have existing knowledge of Microsoft Excel and want to build upon your skills.
To begin this course you should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2010 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
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
On completion of this course you could study another of our Microsoft Excel courses to discover more advanced techniques, such as Microsoft Excel: Managing Data Using Pivot Tables, Microsoft Excel: Automating Your Spreadsheets with Forms & Macros, and Microsoft Excel: What If Analysis.
This course will be delivered using Microsoft Office 2013 and will also be suitable for users of Microsoft Office 2010 and 2007. If you are using Microsoft Office 2003 or any other version, please contact us to discuss further.