Microsoft Excel 2016 is an extremely useful tool that can make sense of almost any data you put into it once you learn how to use it. There are a few updates to the functionality and user interface in Excel 2016 that we will be reviewing so that you will be up to speed with all the latest features. In this video we will explore a few of the basic features such as how to open and use a workbook. First we will show you how to open multiple sheets inside of a workbook. Once you have the basics of the cells, columns and rows down, we will show you how to add, subtract, multiply and divide the numbers by their columns or rows.
Like any great peace of software, Excel 2016 has many shortcuts to make your life easier. Once you have learned how to add, subtract, multiply and divide your columns and rows, you will want to learn how to multiply your efforts by using the drag features. This will duplicate the chosen functions for each column or row so that you can see values for each row or column. If you are trying to add up numbers for a set of rows, all you will need to do is set the SUM function for one row. Once Excel understands the function you are trying to accomplish for that row, you will be able to drag and select all of the subsequent boxes to find the SUM values for the remaining rows without having to repeat the SUM process for each row.
Stay tuned for more great Microsoft Excel 2016 videos!