Mastering Excel 2016 - Advanced
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Excel 2016 - Advanced to your Wishlist.

Add to Wishlist

Mastering Excel 2016 - Advanced

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others W
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Chip Reaves
Last updated 6/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Work with Macros
  • Trace Precedent and Dependent Cells
  • Compare and Merge Workbooks
  • Use 3D References
  • Use Data Forms and Form Controls
View Curriculum
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 is the target audience?
  • Excel Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
02:53:13
+
Excel 2016
25 Lectures 02:53:13

02: Using 3D References
08:57

03: Consolidating Data
06:15

04: Using Lookup Functions, Part 1
12:00

05: Using Lookup Functions, Part 2
05:59

06: Tracing Precedent and Dependent Cells
06:23

07: Watching and Evaluating Formulas
05:29

08: Comments and Track Changes
08:22

09: Comparing and Merging Workbooks
04:47

10: Accessibility Checker
04:19

11: Protecting Worksheets and Workbooks
09:51

12: Applying Data Validation
09:33

13: Search for Invalid Data
06:41

14: Working with Macros, Part 1
11:27

15: Working with Macros, Part 2
07:20

16: Creating Sparklines
04:42

17: 3D Maps
06:31

18: Data Tables
06:32

19: Using Scenarios
04:54

20: Goal Seek
02:42

21: Forecasting Data Trends
03:00

22: Changing your Display
04:16

23: Importing Delimited Text Files
03:42

24: Data Forms and Form Controls
14:21

25: Calculated Fields and Cube Functions
04:55
About the Instructor
Chip Reaves
4.4 Average rating
839 Reviews
8,532 Students
40 Courses
Bigger-Brains

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.