Microsoft Excel Beginners 2016

Video Description

Master Excel 2016 for complete beginners in this helpful, info-packed video course

About This Video

  • Learn the new features in Microsoft Excel 2016 in a step-by-step format
  • A practical course (with exercise files) to help you learn and use Excel 2016

In Detail

This course assumes you've never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you at the very beginning: installing the program, creating your first workbook, and entering data. Before you know it, you'll be using Excel 2016 like a pro, including its advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.

This course starts with where to find Microsoft Excel and installing the program. Then you learn, step-by-step, simple 1-2-3 methods for getting up-and-running with Excel 2016.

It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation, we discuss what is new with 2016, using the touchscreen, opening a workbook, and how to use Help to get additional answers when you need them.

Then we show you how to personalize Excel for your own use with exciting Excel options. We discuss all the ribbons and toolbars, entering and editing data, backup and recovery, fills and series, and printing your projects. We also work with worksheets and formulas/functions.

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

Publisher Resources

Download Example Code

Table of Contents

  1. Chapter 1 : Introduction
    1. Acquiring Excel 2016 and Information on Installation and Upgrade 00:12:02
    2. Exercise Files 00:02:28
  2. Chapter 2 : What's New
    1. New and Improved Features in Excel 2016 00:02:56
  3. Chapter 3 : Using Touch
    1. Overview of Principles of Using Touchscreen 00:05:36
  4. Chapter 4 : Getting Started
    1. Creating and Saving a Workbook 00:15:16
    2. Opening a Workbook 00:10:13
  5. Chapter 5 : Using Help
    1. Online Help and Contextual Help 00:06:28
  6. Chapter 6 : Excel Options
    1. Personalizing your use of Excel 00:10:50
  7. Chapter 7 : The Ribbon and Toolbars
    1. Basics of using the Ribbon 00:14:56
    2. Quick Access Toolbar 00:05:46
    3. Tell Me Feature 00:06:50
    4. Mini Toolbars and Contextual Menus 00:03:47
    5. Status Bar 00:05:03
  8. Chapter 8 : Entering and Editing Data
    1. Basics of Entering and Editing Data in a Workbook 00:13:30
    2. Exercise 01 00:01:51
    3. Formatting Dates 00:12:36
    4. Formatting Numbers 00:13:48
    5. Exercise 02 00:01:43
  9. Chapter 9 : Backup and Recovery
    1. AutoSave, Recover Unsaved Workbook, and Create a Backup Copy 00:07:35
  10. Chapter 10 : Fill and Series
    1. Working with Fill and Series 00:09:09
    2. Flash Fill 00:04:05
  11. Chapter 11 : Viewing and Printing
    1. Workbook Views, Zoom, and Freeze 00:08:42
    2. Printing 00:14:30
    3. Exercise 03 00:02:56
  12. Chapter 12 : Cut, Copy, and Paste
    1. Methods of Cutting, Copying, and Pasting 00:13:32
  13. Chapter 13 : Formatting a Worksheet
    1. Delete and Clear 00:13:45
    2. Insert, Hide, Column Width and Row Height, and Merge 00:12:47
    3. Alignment 00:12:05
    4. Themes and Styles 00:11:19
    5. Exercise 04 00:01:44
  14. Chapter 14 : Formulas and Functions
    1. Basics of Formulas and Functions 00:11:15
    2. Complex Examples of Formulas 00:13:37
    3. Exercise 05 00:03:26
  15. Chapter 15 : Managing Worksheets
    1. Worksheet 00:08:40
  16. Chapter 16 : Working with Multiple Workbooks
    1. Working with Multiple Workbooks 00:15:49
  17. Chapter 17 : Saving Workbooks
    1. Saving in Different File Types 00:12:59
  18. Chapter 18 : Proofing
    1. The Spell Checker 00:13:12
  19. Chapter 19 : Inserting Comments
    1. Inserting Comments 00:04:55
    2. Exercise 06 00:03:02
  20. Chapter 20 : Basic Functions in Excel
    1. The VLOOKUP Function 00:14:07
    2. Text Functions 00:08:17
    3. Date and Time Functions 00:06:48
    4. Logical Functions 00:15:51
  21. Chapter 21 : Graphs and Charts
    1. Creating Graphs and Charts 00:12:10
    2. Customizing a Cluster Column Chart 00:15:42
    3. Customizing a Pie Chart 00:13:36
    4. New Chart Types in Excel 2016 00:02:01
    5. Exercise 7 00:02:28
  22. Chapter 22 : Sorting and Filtering Data
    1. Managing Data by Sorting 00:09:39
    2. Managing Date by Filtering 00:11:59
    3. Customizing Tables 00:13:24
  23. Chapter 23 : Shapes and Pictures
    1. Inserting Shapes and Pictures 00:15:01
    2. Exercise 08 00:00:47
  24. Chapter 24 : Formatting Cells Based on Content
    1. Conditional Formatting 00:15:32
  25. Chapter 25 : Protection and Security
    1. Protecting Worksheets 00:09:36
    2. Protecting Workbooks 00:10:21
  26. Chapter 26 : Naming Items
    1. Giving Items Names 00:06:31
    2. Exercise 09 00:02:11
  27. Chapter 27 : Finding and Replacing Words
    1. Find and Replace 00:07:10
  28. Chapter 28 : Borders
    1. Adding Borders 00:10:44
  29. Chapter 29 : Workbook Inspection
    1. Inspecting a Workbook 00:06:08
  30. Chapter 30 : Privacy Options
    1. Trust Center Privacy Options 00:05:46
  31. Chapter 31 : Sharing Options
    1. Sharing a Workbook 00:08:31
  32. Chapter 32 : Conclusion
    1. Conclusion and Close 00:00:30

Product Information

  • Title: Microsoft Excel Beginners 2016
  • Author(s): Simon Sez IT
  • Release date: August 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839216732