San Francisco, California
London, United Kingdom
Our Excel Intermediate course will build on your basic Excel skills and show you more complex formalae, how to build formalae across worksheets, linking data and charting your data. We also cover protecting your sheets and workbooks.
After the course, you will be able to:
- Use Logical Functions, Financial and Statistical Functions
- Nest Functions
- Multiple Worksheet Management and Formulae
- Build Charts
- Protect Worksheets & Workbooks
Course Prerequisite - To get the most from this course, you must be at a basic Excel level, equivalent of our introduction course content
Lesson 1: Creating Advanced Formulas
- Apply Range Names
- Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
- Leverage Questions and Testing to Write Formulas
- Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3: Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Use Summary and Database Functions to Calculate Data
Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Filter Data Using Slicers
- Analyze Data Using PivotCharts
Lesson 6: Inserting Graphics
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
Lesson 7: Enhancing Workbooks
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
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!