Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
During this Microsoft Excel 2016 training tutorial video, we will show you how to open a saved workbook. Other points also discussed are using Autosum, Series Fill, Undo and Redo, and Zooming in and out.
Checkout some of our other training on YouTube:
VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ
Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh
Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX
Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O
Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF
SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge
PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq
Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)
Welcome back to this second section on getting started with Excel 2016.
In this section I’m going starting off exactly from where I left off in the previous section. I closed the workbook that I just created but left Excel running. If I now wanted to reopen that same workbook, if I go into Backstage View and click on the Open option you’ll see that this particular page in Backstage View, the Open page, features on the right a list of recently opened workbooks. And of course my list of recently opened workbooks now has one workbook in it. So in order to open Demo 1 again I just select it and the workbook is opened and the cursor is exactly where I left it when I closed this workbook earlier on.
What I’m going to do now is to select a number of cells and I’m actually going to select from the cell G7, the one with 23 in it, across to J7 which is where the cursor currently is. Now there are a number of ways of doing this and one of the ways is to click in G7 and then just move the cursor across with the mouse held down and then let go when the cursor is over J7. And I now have multiple selection. I have selected four cells. And one of the options on the Ribbon in the Editing Group, now the Ribbon is this big rectangle of commands here, and there’s a group on the right, Editing, and one of the options in there is AutoSum. And if I click on the right hand arrow to the right of AutoSum and select Sum watch what happens. What happens that is in that fourth cell, J7, I see the sum of the contents of the other three cells. So you can now see Excel doing something useful for me. It is now storing the total of the contents of the other three cells.
Now one very important aspect of what’s just happened is that if I change the number in any one of the first three cells it will automatically update the total. So let’s click into that 19 cell again, H7 that contains 19, and I’m going to change the value from 19 to 79. Now in many ways the simplest way to change 19 to 79 is to select the cell and just type 79. Having entered that if I now click elsewhere, anywhere else within the sheet, my 79 value is accepted and note that the total, the sum, has been changed from 104 to 164. So the value in J7 has been updated. And in fact the value of any other cell that depends on the value in H7 will be updated automatically as well.
Now one of the things you may not be happy about is you may be squinting at the screen saying, “I can barely see those numbers. They’re so small.” If you refer now to the bar at the bottom of the screen, it’s called the Status Bar, I mentioned it earlier on. At the right hand end of there is a Zoom control and the zoom control takes the form of a bar. It’s got a minus at the end and a plus at the right and it says 100%. I can actually zoom in on my worksheet to make everything look bigger. Now this is only how things look. It doesn’t physically change the size of the cells. It just makes them appear bigger or smaller. And of course you can adjust this zoom control to suite the particular situation that you’re in.
Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.