Intermediate Microsoft Excel 2010 Course
- Duration:1 Day
- Cost:£199 + VAT
- Ref:MIDE10
Who is it for
This course is suitable for people who have attended the
Introduction to Microsoft Excel 2010 course or have sufficient knowledge and understanding of the basics in Excel.
Not sure if this course is the right level for you? Call our team on 0800 170 7777 to find out now.
What is it about
A natural progression from our introductory 2010 courses that provides expert guidance through more complex functions and plenty of practice and examples to build confidence using them.
Course Overview
- Review of Excel fundamentals
- Building 3-dimensional worksheets
- Utilising IF Statements
- Vlookup & Hlookup
- Creating worksheet templates
- Protecting your formulas
- Workbook security
- Group editing
- Database features
- Filtering data with slicers
- Sorting data
- Adding filters
- Utilising conditional formatting
- Adding Sparklines
- New data bar enhancements
- Charts - a recap
- Adding trend lines
What will I get out of it?
- Get the skills to create templates for commonly used worksheets and protect data using the security features
- Gain insight into data tables and using the Excel look up features to automate worksheets
- Learn how to create, build and customise graphs including plotted trend lines
- Discover how to use the new Sparklines features and data bar enhancements
- Free course refresher
- The skills and confidence to move on to the Advanced Microsoft Excel 2010 course