Microsoft Excel Intermediate 2016

Video Description

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

About This Video

  • Discover the power of dynamic formulas and how to use them
  • Get advanced-level tips for creating awesome charts and graphs
  • Work with and analyze your data using data slicers, PivotTables, Power Query, and PivotCharts
  • Practice what you learned with the accompanying exercise files

In Detail

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.

Publisher Resources

Download Example Code

Table of Contents

  1. Chapter 1 : Excel Intermediate Introduction
    1. Course Introduction 00:02:52
    2. Reviewing Excel Terminology 00:08:56
    3. Tips and Tricks in the Ribbon 00:04:54
    4. Escaping the "Mouse" Trap 00:06:31
    5. Common Hotkeys 00:04:33
    6. Special Hotkey Commands 00:06:52
    7. Defining Your Excel View 00:06:27
  2. Chapter 2 : Indexing and Lookups
    1. Defining Lookups and Arrays 00:03:39
    2. Using VLOOKUP and HLOOKUP 00:08:09
    3. Using MATCH 00:05:56
    4. Using INDEX 00:06:28
    5. Mixing LOOKUPS, INDEX, and MATCH 00:07:41
  3. Chapter 3 : Named Ranges
    1. What is Important to You? 00:03:42
    2. Simple and Quick Name Definitions 00:06:32
    3. Accessing and Using the Name Manager 00:03:47
    4. What can Names do? 00:09:27
  4. Chapter 4 : Dynamic Formula
    1. What is a Reference? 00:04:12
    2. Using Indirect 00:09:27
    3. Using Offset 00:06:46
    4. Using Row, Column, and Cell 00:05:23
    5. Creating Dynamic Named Ranges 00:09:42
    6. Best Practices Regarding Dynamic Functions 00:09:30
  5. Chapter 5 : Charts and Graphs
    1. Charts and Graphs Terminology 00:10:47
    2. Line, Scatter, and Bar Charts 00:11:31
    3. Radar and Surface Plots 00:03:42
    4. Waterfall, Pie, and Sunburst Charts 00:07:31
    5. The Box and Whisper Plot and Histograms (Statistical) 00:06:26
    6. Chart Formatting In Detail 00:08:28
    7. Mixing Chart Types 00:03:57
    8. The Bing Maps App 00:03:53
  6. Chapter 6 : Working with Data
    1. How Do You Know If You're Working With Data? 00:10:32
    2. Introducing Data Tables 00:09:15
    3. Excel Data Model Relationships 00:07:08
    4. Data Slicers 00:06:41
    5. Pivot Tables 00:11:34
    6. Power Query / Get And Transform 00:10:23
    7. Pivot Charts 00:05:40
    8. The GETPIVOTDATA Function 00:06:37
    9. Course Conclusion 00:03:09

Product Information

  • Title: Microsoft Excel Intermediate 2016
  • Author(s): Simon Sez IT
  • Release date: July 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839216718