Mastering Excel 2016 - Advanced
What you'll learn
- Work with Macros
- Trace Precedent and Dependent Cells
- Compare and Merge Workbooks
- Use 3D References
- Use Data Forms and Form Controls
Requirements
- The student will need basic computer knowledge.
- A copy of Excel is recommended.
Description
If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel and teaches you how to use links, lookup functions, macros, data tables, and more.
This is our most requested training course! If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are an experienced Excel user, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through some advanced tools that will expand the usefulness of your Microsoft Excel 2016.
Over 2 hours of high quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher/Learner style!
Who this course is for:
- Excel Users
Course content
- Preview10:15
- 08:5702: Using 3D References
- 06:1503: Consolidating Data
- 12:0004: Using Lookup Functions, Part 1
- 05:5905: Using Lookup Functions, Part 2
- 06:2306: Tracing Precedent and Dependent Cells
- 05:2907: Watching and Evaluating Formulas
- 08:2208: Comments and Track Changes
- 04:4709: Comparing and Merging Workbooks
- 04:1910: Accessibility Checker
- 09:5111: Protecting Worksheets and Workbooks
- 09:3312: Applying Data Validation
- 06:4113: Search for Invalid Data
- 11:2714: Working with Macros, Part 1
- 07:2015: Working with Macros, Part 2
- 04:4216: Creating Sparklines
- 06:3117: 3D Maps
- 06:3218: Data Tables
- 04:5419: Using Scenarios
- 02:4220: Goal Seek
- 03:0021: Forecasting Data Trends
- 04:1622: Changing your Display
- 03:4223: Importing Delimited Text Files
- 14:2124: Data Forms and Form Controls
- 04:5525: Calculated Fields and Cube Functions
Instructor
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.