San Francisco, California
London, United Kingdom
Our Advanced Excel course will benefit more experienced users, or users that have specific questions or tasks to perform. The course will cover list functions, what-if tools and basic macro recording. This will enable you take your spreadsheets to the next level! The course also covers PivotTables to analyse your data.
After the course, you will be able to:
- Use Lookup Functions
- Create Pivot Tables
- Use What-If Tools
- Sharing and Tracking Workbooks
- Record Basic Macros
Course Prerequisite - This course is aimed for experienced users of Excel and you must be equivalent of our Intermediate level.
Lesson 1: Functions
- Lookup Functions - H + VLookup, Index, Match
- Text Functions - Left, Right, Mid, Concatenate, Search + more
- Information Functions - IsError, InNull, IsBlank, IsDate, IsText + more
- Database Functions - DSum, DAverage, DCount + more
Lesson 2: Advanced Lists
- Advanced Filters
Lesson 3: Pivot Tables
- Create and Edit Pivot Tables
- Understanding Different Layouts
- Applying different calculations, e.g. Sum, Count, Average etc.
- Calculated Fields + Items
- Formatting PivotTables
Lesson 4: What If Analysis
- Goal Seek
- Data Tables
Lesson 5: Workbook Sharing and Reviewing
- Sharing Workbooks
- Tracking Changes, Accept and Reject Changes
- Workbook Protection Review
Lesson 6: Introduction to Macros
- Understanding the benefits of Macros
- Recording / Running macros
- Absolute and relative recording
- Running macros: Custom buttons, menu items, keyboard shortcuts
When & Where
Touchstone Training and Consulting
Touchstone Training and Consulting offers an extensive range of affordable application courses (including Microsoft Office 2003, 2007 and 2010) from Beginner to Advanced level.
All our courses can be customised to suit your specific needs and we also offer courses in small groups of up to 10 people or on a one to one basis.
Our course portfolio will help you build the skills, knowledge and techniques you need to advance your career or business.
Why Touchstone Training and Consulting?
• High Impact, Quality Training Delivered By Experts
• Perfectly Crafted Training Tailored to Suit You. All our course contents can be customised and delivered at a location of your choice!
• Small Class Sizes Up to 10 people so we deliver personalized and interactive courses
• Price Match Guarantee - If you find an identical training course at a cheaper price, let us know and we will match the price and offer you 10% off your next course with us!