01 Excel Intermediate Introduction

  002 Essential Information for a Successful Training Experience.html

  004 Course Support Files.html

  006 Tips and Tricks in the Ribbon.mp4

  008 Common Hotkeys.mp4

  010 Defining Your Excel View.mp4

  attached files

   004 Excel-E6-Intermediate-Support-Files.zip

 02 Indexing and Lookups

  012 Using VLOOKUP and HLOOKUP.mp4

  014 Using INDEX.mp4

 03 Named Ranges

  017 Simple and Quick Name Definitions.mp4

  019 What can Names do.mp4

 04 Dynamic Formula

  021 Using Indirect.mp4

  023 Using Row Column and Cell.mp4

  025 Best Practices Regarding Dynamic Functions.mp4

 05 Charts and Graphs

  028 Line Scatter and Bar Charts.mp4

  030 Waterfall Pie and Sunburst Charts.mp4

  032 Chart Formatting In Detail.mp4

  034 The Bing Maps App.mp4

 06 Working with Data

  036 Introducing Data Tables.mp4

  038 Data Slicers.mp4

  040 Power Query Get And Transform.mp4

  042 The GETPIVOTDATA Function.mp4

  044 Bonus Lecture - Next Steps.html