Microsoft Excel 2016 Training: Beginner to Intermediate

Visit Tutorial Page ( Report)


Learn Microsoft Excel 2016 Inside and Out

  • Includes 16 hours of high-quality training by your professional trainer
  • Practice along using exercise files
  • Watch and learn with demo project files
  • Progresses logically from beginning with an easy intro to advanced topics

This course includes:

  • 16 hours of video tutorials
  • Over 100 individual video lectures
  • Exercise files to practice what you learned
  • Demo files used by the trainer
  • Close captions to follow along
  • Certificate of completion

Contents and Overview

This course starts at the absolute beginning, from where to find Microsoft Excel to installing the program. From there, you'll learn step-by-step, simple 1-2-3 methods for getting started with Excel 2016. Watch just the first few videos for a basic knowledge of Excel, then continue through the detailed 32 chapters of video lessons and nine exercise files to gradually become a proficient user.

It's important to note that this course does not assume you know anything about Excel 2016. Rather, the course starts from the basics. After installation, your instructor will discuss what is new in the 2016 version, how to use the Touchscreen, open a Workbook, and use Help for additional answers when you need them.

You'll learn how to personalize Excel for your own needs using Excel Options. Explore the Ribbons and Toolbars, enter and edit data, backup and recovery, fill and series and print your projects. You'll also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Colorful charts, sleek graphs and cutting-edge databases that offer insight into financial information are made easy when you learn the secrets of creating sophisticated spreadsheets.

You'll explore Excel's array of detailed formatting tools and discover how to make these work for you when you're tackling graphing and charting financial information. Next, you'll explore the roles that trends, relationships, and differences play in charts, and how to work with Sparklines for data visualization and data bars. 

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.

* Includes quizzes, exercise files, demo files, close captions and certificate of completion.

Who is the target audience?

  • Users of earlier versions of Excel looking to update their skills.
  • Those new to using Microsoft Excel 2016.
  • Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge.
  • If you want to refresh your memory and understanding of Excel.
  • Introduction
  • What's New
    • New and Improved Features in Excel 2016
  • Using Touch
    • Overview of Principles of Using Touchscreen
  • Getting Started
    • Creating and Saving a Workbook
    • Opening a Workbook
  • Using Help
    • Online Help and Contextual Help
  • Excel Options
    • Personalizing your use of Excel
  • The Ribbon and Toolbars
    • Basics of using the Ribbon
    • Quick Access Toolbar
    • Tell Me Feature
    • Mini Toolbars and Contextual Menus
    • Status Bar
  • Entering and Editing Data
    • Basics of Entering and Editing Data in a Workbook
    • Exercise 01
    • Formatting Dates
    • Formatting Numbers
    • 13:48 Exercise 02
  • Backup and Recovery
    • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
  • Fill and Series
    • Working with Fill and Series
    • Flash Fill
Write Your Review