Mastering Excel 2016 - Intermediate
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.
0 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Mastering Excel 2016 - Intermediate

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.
0 students enrolled
Created by Chip Reaves
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
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 Named Ranges and Tables
  • Use Logical, Text, Date, and other Functions
  • Sort, Filter, and Summarize Data
  • Create PivotTables and Pivot Charts
  • Use Conditional Formatting
  • Add Slicers and Timelines to Analyze Information
View Curriculum
Requirements
  • The student will need basic computer knowledge.
  • We recommend that the student take our course "Mastering Excel 2016 - Basics" first if they are not yet familiar with Excel.
  • A copy of Microsoft 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 basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more. 


Who is the target audience?
  • Microsoft Excel users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
02:59:04
+
Functions
7 Lectures 01:07:21

Using Named Ranges in Formulas
03:53

Using Specialized Functions
14:12

Logical Functions
13:56

Nesting Functions
05:28

Date and Time Functions
03:38

Text Functions
14:34
+
Data
4 Lectures 32:22
Sorting Data
05:34

Filtering Data
09:18

Database Functions
07:49

Using Subtotals
09:41
+
Tables and Conditional Formatting
4 Lectures 21:16
Create and Modify Tables
08:15

Manipulating Table Data
03:50

Conditional Formatting Rules
03:51

Using Logical Functions with Conditional Formatting
05:20
+
Charts
4 Lectures 28:34
Creating Charts
08:37

Modifying and Formatting Charts
09:38

Creating a Dual Axis Chart
07:20

Chart Templates
02:59
+
PivotTables, Slicers, and Timelines
4 Lectures 29:31
Creating a PivotTable
07:14

Analyzing PivotTable Data
09:47

Pivot Charts
06:26

Slicers and Timelines
06:04
About the Instructor
Chip Reaves
4.4 Average rating
853 Reviews
9,164 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.