Microsoft Excel Beginners 2016

Microsoft Excel Beginners 2016

by Simon Sez IT
Released August 2019
Publisher(s): Packt Publishing
ISBN: 9781839216732

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

What You Will Learn

  • How to get Excel and its installation requirements
  • A helpful discussion of the new features in 2016
  • Getting started with a workbook
  • Entering and editing data
  • Practice with the included exercise files

Audience

This course is designed for complete beginners who've never worked with Microsoft Excel.

About The Author

Simon Sez IT: Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

Table of contents

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

Product information

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