
Mastering Excel 2016
The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were
Teacher : Barbara Evers Learner : Christina Tankersley
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 is your path to first learning, then even mastering Excel.
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. You may have a rudimentary knowledge of how Excel works, but if you want to learn to get the most of it, then take this course. Let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through everything you’ve ever wanted to know about Microsoft Excel 2016, including:
- How to customize Microsoft Excel 2016 to work better for you
- Easily creating & modifying pivot tables
- The best way to create easy-to-view charts & graphs
- Using conditional formatting and sparklines to highlight data trends
- Excel 2016 tips & tweaks for over 120 functions & features!
We also have similar courses for Mastering Excel 2013 and Mastering Excel 2010
Objectives – You will be able to:
- Demonstrate how to navigate the ribbon
- Discuss the compatibility issues between Excel 2016 and older versions of Excel
- Explain the importance of named ranges
- Write nested functions
- Demonstrate advanced functions
- Define and develop macros
Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn
Over two hours of high quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher/Learner style!
What You'll Learn
Lessons Include:
02: Selecting and Navigating (7:55)
03: Keyboard Navigation and Basic Data Entry (9:18)
04: The Ribbon (5:23)
05: The Quick Access Toolbar (4:28)
06: Creating a New Spreadsheet (9:08)
07: Compatibility Issues (5:26)
08: Cell Data & Data Types (12:41)
09: Accessing Help (3:11)
10: Creating Worksheet Formulas (11:11)
11: Insert Functions (11:28)
12: Re-using Formulas and Functions (12:00)
13: Insert, Delete, & Adjust Columns & Rows (7:22)
14: Find and Replace (9:52)
15: Use Proofing and Research Tools (11:21)
16: Apply Text Formats (14:14)
17: Apply Number Formats (7:00)
18: Align Cell Contents (8:45)
19: Applying Styles and Themes (11:43)
20: Conditional Formatting (11:42)
21: Creating and Using Templates (6:13)
22: Preview and Print a Notebook (8:48)
23: Page Layout (15:44)
24: Configure Headers and Footers (12:37)
25: Managing Worksheets (6:32)
26: View Options (10:54)
28: Working with Named Ranges (11:40)
29: Using Named Ranges in Formulas (3:53)
30: Using Specialized Functions (14:13)
31: Working with Logical Functions (13:56)
32: Displaying Formulas (4:29)
33: Nesting Functions (5:29)
34: Date and Time Functions (3:38)
35: Text Functions (14:34)
36: Sorting Data (5:35)
37: Filtering Data (9:18)
38: Using Database Functions (7:49)
39: Using Subtotals (9:42)
40: Create and Modify Tables (8:16)
41: Manipulating Table Data (3:51)
42: Conditional Formatting Rules (3:52)
43: Using Logical Functions with Conditional Formatting (5:20)
44: Creating Charts (8:37)
45: Modifying and Formatting Charts (9:38)
46: Creating a Dual Axis Chart (7:21)
47: Chart Templates (2:59)
48: Formatting Shapes and Objects (7:05)
49: Creating a PivotTable (7:15)
50: Analyzing PivotTable Data (9:47)
51: Pivot Charts (6:26)
53: Using Links and External References (10:16)
54: Using 3D References (8:58)
55: Consolidating Data (6:15)
56: Using Lookup Functions, Part 1 (12:01)
57: Using Lookup Functions, Part 2 (5:59)
58: Tracing Precedent and Dependent Cells (6:24)
59: Watching and Evaluating Formulas (5:30)
60: Comments and Track Changes (8:23)
61: Comparing and Merging Workbooks (4:48)
62: Accessibility Checker (4:20)
63: Protecting Worksheets and Workbooks (9:51)
64: Applying Data Validation (9:33)
65: Search for Invalid Data (6:41)
66: Working with Macros, Part 1 (11:27)
67: Working with Macros, Part 2 (7:21)
68: Creating Sparklines (4:42)
69: 3D Maps (6:32)
70: Data Tables (6:32)
71: Using Scenarios (4:55)
72: Goal Seek (2:42)
73: Forecasting Data Trends (3:00)
74: Changing Your Display (4:16)
75: Importing Delimited Text Files (3:42)
76: Data Forms and Form Controls (14:22)
77: Calculated Fields and Cube Functions (4:56)
Course Length
Course Length
Produced by : Bigger Brains
Modules : 27
Seat Time : 4 Hours
Modules : 25
Seat Time : 3 Hours
Modules : 25
Seat Time : 3 Hours
Modules : 75
Seat Time : 10 Hours