Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

header-right

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote 2016
      • Outlook
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • PowerPoint
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • VBA
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Visio 2016
        • Visio 2013
        • Visio 2010
      • Windows
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks Pro
      • QuickBooks
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
      • Dreamweaver
      • Bootstrap
      • Html/CSS
      • Java
      • MySql
      • PHP
      • XML
    • Mac
      • OS
  • Contact Us
  • FAQ
  • Sign In
  • Sign Up
Home > Courses> Excel > Excel 2016 Intermediate
Share
Share this course
Facebook Linkedin Twitter

Excel 2016 Intermediate

Chapter name: Lesson name

Excel 2016 Intermediate

Ready to watch the complete course?

Become a member and get unlimited access to the entire software training library of over 5,000 video tutorials

Start Your Membership
Loading the player ...

Contents

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

Excel 2016 Intermediate

  • DURATION: 4.28 hours
  • VIDEOS: 39
  • LEVEL: Intermediate

Greater skills for job, home business, or personal interests. Learn tips and tricks to make Excel faster and easier. If you already know the basics of Excel, this is the intermediate knowledge that will help you become an Excel power user. Course objectives:

  • Discover the power of Dynamic Formulas and how to use them.
  • Get advanced level tips for creating awesome charts and graphs.
  • How to work with and analyze your data using data slicers, PivotTables, Power Query and PivotCharts.
  • Discover how to use named ranges.
  • Effectively learn common Excel hotkeys.
  • Learn advanced use of working with data.
  • Discover how to how to use named ranges.
  • Practice with included exercise files.
  • An optional online quiz to test what you’ve learned.

Excel 2016 Intermediate

The course support files consist of a single .ZIP file. You will need to download the Excel 2016 Intermediate Course Instructor Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.

  • Excel 2016 Intermediate Exercise Files
  • Excel 2016 Intermediate Support Files

Get immediate access to the entire library!

ANNUAL Membership - 100% Money Back Guarantee

$ 197 /per year

This is an annual membership to SimonSezIT.com with access to all online training courses. You will be charged again when your membership expires. You can cancel at any time.

Sign Up

MONTHLY Membership - 100% Money Back Guarantee

$ 25 /per year

This is a monthly membership to imonSezIT.com which includes access to all online training courses. You will be charged each month as long as you are a member. You can cancel at any time.

Sign Up

Related courses

Excel_2016_Advanced

Excel 2016 Advanced

Microsoft Excel 2016 online courses

Excel 2016 Beginners

Excel-2013

Excel 2013

Excel-2013-Advanced

Excel 2013 Advanced

Excel-2010-Advanced

Excel 2010 Advanced

Excel-2010-Beginners

Excel 2010 Beginners

Excel 2007

What people are saying

"Everything is well explained and detailed plus the pre-prepared downloadable exercises are a great help."

Kenneth Kludjeson

"I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners."

David F. Wilson

"I enjoyed to course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you."

John Brown

"The instructor goes slow, covers everything (even how to save, print, etc) and gives relevant examples. Great course for someone who has never used excel before or for people who want to make sure they know how to use every feature. Well worth the money as you will become more productive and efficient with Excel."

Leigh Ann Cross

"Course is well done and since you can go back and review at any time or after the course is done is helpful for us slow learners"

Rick Clarke

"The overall course has a nice progressive layout and the presenter knows what he is teaching."

Eric Cobb

"This material is very easily laid out and relevant. I have obtained many tips that will help me to become much more productive in my Excel use!"

Mark Carson

"I have some experience with Excel, but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly, so the student can follow along and master the details. "

Vikram Hegde

"I like the way the teacher structured the course and again for making the files available, so we could work on them together with him."

Brandon Silva

"Generally, I wouldn't find this type of course all that interesting. However, I have found in my current job search that it is a necessary part of my tech skill set in which to become proficient. So, I'm very appreciative that courses like this are offered, and taught by an extremely knowledgeable instructor, who explains lessons clearly and offers opportunities to practice the theme which he has just gone over. He was thorough, and not in the least bit condescending, which I can't say for instructors I have had in the past. So, thank you."

Mary Price

"It's informative & detailed enough without being overly drawn out. The presenter has given a thorough introduction to Excel for the prescribed audience. Although I am far beyond the audience level targeted by this Course, from this position, I can appreciate better the thoroughness and layout. Well done."

Christopher Cole

Trusted by

  • Guitar Center
  • Honeywell
  • Charter
  • SIU carbondale
  • College of
  • Clean Harbors
  • Wyle
  • fareva

Start Your Membership

Simon Sez: “Let’s make you a software superstar!”

From Excel to photo editing, experience quality courses that ensure easy learning.

START YOUR MEMBERSHIP
Learn More

Course Categories

  • Development
  • Business
  • Office Productivity
  • IT & Software
  • Photography
BBB logo

About Us

  • About Us
  • Blog
  • Affiliates
  • Became an Instructor

Products

  • Our Plans
  • Business Licensing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

Twitter Youtube Facebook Google Plus
© 2018 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)