Microsoft Excel 2016 - Training Season 1 Episode 1

Ep 1. Getting Started with Excel 2016

  • December 31, 2016
  • 33 min

Microsoft Excel 2016 - Training season 1 episode 1, "Getting Started with Excel 2016," is the perfect introduction to this powerful spreadsheet software. Whether you're a new user just starting out or a seasoned pro looking to brush up on your skills, this episode has everything you need to get up and running with Excel 2016.

The episode begins with an overview of the Excel interface, showing viewers how to navigate through the different menus and options. From there, the episode dives into the basics of creating a new workbook, including how to add data to cells, format that data, and apply simple formulas to it.

Throughout the episode, viewers will learn how to use Excel's powerful formatting features to customize their workbook and make it more visually appealing. This includes learning how to change the color and font of cells, apply conditional formatting to highlight data that meets certain criteria, and even add borders and shading to make the workbook stand out.

The episode also introduces viewers to some of Excel's most popular functions, including SUM, AVERAGE, and COUNT. Viewers will learn how to use these functions to quickly and easily calculate the total, average, or number of cells in their workbook.

As the episode progresses, viewers will be introduced to some of the more advanced features of Excel 2016, such as data validation and sorting. They'll learn how to set up rules to limit the data that can be entered in a cell, and how to sort their data based on different criteria, such as alphabetical order or numerical value.

Throughout the episode, there are plenty of helpful tips and tricks to help viewers get the most out of Excel 2016. For example, viewers will learn how to use the AutoFill feature to quickly populate cells with a series of values, and how to use the Freeze Panes feature to keep certain columns or rows visible at all times.

Finally, the episode wraps up with a discussion of some of the more advanced features of Excel, including charts and graphs. Viewers will learn how to use Excel's built-in chart wizard to quickly create a chart or graph based on their data, and they'll learn how to customize that chart or graph to suit their needs.

Overall, "Getting Started with Excel 2016" is an excellent introduction to this powerful spreadsheet software. Whether you're a complete beginner or an experienced Excel user, there's plenty of valuable information in this episode to help you get the most out of Excel 2016. So why not give it a watch and see what you can learn?

This episode doesn't appear to be available from any streaming services. Add this show to your Watchlist to get notified when new episodes are available.
Description
  • First Aired
    December 31, 2016
  • Runtime
    33 min
  • Language
    English