Microsoft Excel Intermediate 2016

Microsoft Excel Intermediate 2016

English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 4h 34m | 1.52 GB

If you already know the basics of Excel, this intermediate-level course will help you become an Excel power user

This course gives take your mastery of Excel to the next level. Rather than being limited to a few functions, this intermediate course lets you go much deeper into the remarkable power and functionality of MS Excel. The course starts by explaining terminology and providing ribbon tips and tricks); it then explains hotkeys and shows how to define Excel views. This approach gets learners off on the right foot. You will gain a better understanding of how to find your way around Excel.

A glimpse of topics that’s will cover are:

  • Take your mastery of Excel to the next level
  • Work with data in a more advanced way
  • Master charts and graphs
  • Dynamic formulas and named ranges
  • Data tables, data slicers, and PivotTables
  • Practice what you learned with the accompanying exercise files

The next few sections present interesting video tutorials that fully explain Indexing and lookups. The various functions are illustrated and discussed, and case study lookups are explored. Additional chapters talk about intermediate chart and graph creation, working with data, data tables, data slicers, PivotTables, and much more.

Learn

  • Review Excel terminology
  • Learn cool tips and tricks in the Ribbon
  • Discover common Excel hotkeys
  • How to use VLOOKUP and HLOOKUP
  • Learn how to use popular functions
  • Discover how to use named ranges
Table of Contents

Excel Intermediate Introduction
1 Course Introduction
2 Reviewing Excel Terminology
3 Tips and Tricks in the Ribbon
4 Escaping the Mouse Trap
5 Common Hotkeys
6 Special Hotkey Commands
7 Defining Your Excel View

Indexing and Lookups
8 Defining Lookups and Arrays
9 Using VLOOKUP and HLOOKUP
10 Using MATCH
11 Using INDEX
12 Mixing LOOKUPS, INDEX, and MATCH

Named Ranges
13 What is Important to You
14 Simple and Quick Name Definitions
15 Accessing and Using the Name Manager
16 What can Names do

Dynamic Formula
17 What is a Reference
18 Using Indirect
19 Using Offset
20 Using Row, Column, and Cell
21 Creating Dynamic Named Ranges
22 Best Practices Regarding Dynamic Functions

Charts and Graphs
23 Charts and Graphs Terminology
24 Line, Scatter, and Bar Charts
25 Radar and Surface Plots
26 Waterfall, Pie, and Sunburst Charts
27 The Box and Whisper Plot and Histograms (Statistical)
28 Chart Formatting In Detail
29 Mixing Chart Types
30 The Bing Maps App

Working with Data
31 How Do You Know If You’re Working With Data
32 Introducing Data Tables
33 Excel Data Model Relationships
34 Data Slicers
35 Pivot Tables
36 Power Query Get And Transform
37 Pivot Charts
38 The GETPIVOTDATA Function
39 Course Conclusion