Log in
Log inBook a demo

Microsoft Excel 2016 Beginners

COURSE
Simon Sez IT
9 hrs

Microsoft Excel 2016 Beginners

COURSE
Simon Sez IT
9 hrs
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free

Course Overview

Start your Microsoft Excel journey with Excel 2016 beginners course. If you've been meaning to improve your Excel skills but weren't sure where to start, our expert authors make this complex subject easy to digest. This course includes over 9 hours of video instruction and practice downloadable exercise files.

Target Audience

Administrators, Graduates, people in Financial Services, Accountancy.

Learning Objectives

In this course you will learn:

  • Step-by-step, simple 1-2-3 methods for getting started with Excel 2016
  • The ribbon and how to personalise Excel in the options tab
  • What's new in Excel 2016
  • Working with a touchscreen in Excel
  • Entering data in Excel
  • Backing up, recovering and saving your workbooks
  • How to print (the thing you want!) in Excel
  • How formulas work and the basic formulas you need to know
  • How to sort and filter data to see what you want
  • Creating Tables
  • Creating graphs and charts to bring your data to life
Learning
Chapter 1: Introduction
Acquiring Excel 2016 and Information on Installation and Upgradevideo
Course Exercise Filestext
Course Demonstration Filestext
Chapter 2: What's New
New and Improved Features in Excel 2016video • 3 mins
Chapter 3: Using Touch
Overview of Principles of Using Touchscreenvideo • 6 mins
Chapter 4: Getting Started
Creating and Saving a Workbookvideo • 16 mins
Opening a Workbookvideo • 11 mins
Chapter 5: Using Help
Online Help and Contextual Helpvideo • 7 mins
Chapter 6: Excel Options
Personalizing your use of Excelvideo • 11 mins
Chapter 7: The Ribbon and Toolbars
Basics of using the Ribbonvideo • 15 mins
Quick Access Toolbarvideo • 6 mins
Tell Me Featurevideo • 7 mins
Mini Toolbars and Contextual Menusvideo • 4 mins
Status Barvideo • 6 mins
Chapter 8: Entering and Editing Data
Basics of Entering and Editing Data in a Workbookvideo • 14 mins
Exercise 01video
Formatting Datesvideo • 13 mins
Formatting Numbersvideo • 14 mins
Exercise 02video
Chapter 9: Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copyvideo • 8 mins
Chapter 10: Fill and Series
Working with Fill and Seriesvideo • 10 mins
Flash Fillvideo • 5 mins
Chapter 11: Viewing and Printing
Workbook Views, Zoom, and Freezevideo • 9 mins
Printingvideo • 15 mins
Exercise 03video
Chapter 12: Cut, Copy, and Paste
Methods of Cutting, Copying, and Pastingvideo • 14 mins
Chapter 13: Formatting a Worksheet
Delete and Clearvideo • 14 mins
Insert, Hide, Column Width and Row Height, and Mergevideo • 13 mins
Alignmentvideo • 13 mins
Themes and Stylesvideo • 12 mins
Exercise 04video
Chapter 14: Formulas and Functions
Basics of Formulas and Functionsvideo • 12 mins
Complex Examples of Formulasvideo • 14 mins
Exercise 05video
Chapter 15: Managing Worksheets
Rename, Insert, Move, and Reference a Worksheetvideo • 9 mins
Chapter 16: Working with Multiple Workbooks
Working with Multiple Workbooksvideo • 16 mins
Chapter 17: Saving Workbooks
Saving in Different File Typesvideo • 13 mins
Chapter 18: Proofing
The Spell Checkervideo • 14 mins
Chapter 19: Inserting Comments
Inserting Commentsvideo • 5 mins
Exercise 06video
Chapter 20: Basic Functions in Excel
The VLOOKUP Functionvideo • 15 mins
Text Functionsvideo • 9 mins
Date and Time Functionsvideo • 7 mins
Logical Functionsvideo • 16 mins
Chapter 21: Graphs and Charts
Creating Graphs and Chartsvideo • 13 mins
Customizing a Cluster Column Chartvideo • 16 mins
Customizing a Pie Chartvideo • 14 mins
New Chart Types in Excel 2016video • 3 mins
Exercise 7video
Chapter 22: Sorting and Filtering Data
Managing Data by Sortingvideo • 10 mins
Managing Date by Filteringvideo • 12 mins
Customizing Tablesvideo • 14 mins
Chapter 23: Shapes and Pictures
Inserting Shapes and Picturesvideo • 15 mins
Exercise 08video
Chapter 24: Formatting Cells Based on Content
Conditional Formattingvideo • 16 mins
Chapter 25: Protection and Security
Protecting Worksheetsvideo • 10 mins
Protecting Workbooksvideo • 11 mins
Chapter 26: Naming Items
Giving Items Namesvideo • 7 mins
Exercise 09video
Chapter 27: Finding and Replacing Words
Find and Replacevideo • 8 mins
Chapter 28: Borders
Adding Bordersvideo • 11 mins
Chapter 29: Workbook Inspection
Inspecting a Workbookvideo • 7 mins
Chapter 30: Privacy Options
Trust Center Privacy Optionsvideo • 6 mins
Chapter 31: Sharing Options
Sharing a Workbookvideo • 9 mins
Chapter 32: Conclusion
Conclusion and Closevideo