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 where you can access Help in this version of Microsoft Excel. You will find that Help is not available offline in Excel 2016.

Check out 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 ;-)

Hello again and welcome back to our course on Excel 2016.
In this section, we’re going to take a look at Help and there is actually a lot of very useful help available when you’re using Excel 2016 but virtually all of it is online help which means you do need to be connected to the internet in order to take advantage of the help.
Now first of all very simply to access the Help system you will normally see somewhere around about the top right hand corner of the screen a little question mark icon, Microsoft Excel Help, takes me into Help.

Now the Help system is a browser-based system. So it runs in a little web browser. As you can see there Excel 2016 Help little Search box. I’m just going to make that a little bit bigger.

Now let’s suppose I want help on Series Fill, something that we did a little bit earlier on in the course. Type the term in there, click on the little Search button and it comes up with a number of topics related to filling data automatically in worksheet cells. I go to the first one. It takes me to a Help page. What do you want to do? It gives me a list of all the things I might want to do in relation to Series Fill. If I choose one of those it will either take me to a point on this page or sometimes to another page within the Help system. And then I can use the Browse buttons to go backwards and forwards through the available help.

There is a Home button that takes me back to the Help home. There is a Print button where I can print a particular Help topic and there’s also this button which will give me larger text on Help. So if you have a problem reading to Help of a particular size, let’s try that Series Fill again. At the larger size all of the help appears larger and then of course I can shrink it down again if I want to.
So that’s the basics of using Help in Excel 2016. When I finished using Help I can click on Close.

Now there is a keyboard shortcut for bringing up Help in Excel 2016
and you use the F1 key. So let me press the F1 key now and that’s an alternative way of bringing up Excel 2016 Help.
So let’s see what happens now if I try to get help when I’m not connected to the internet. I’ve disconnected. I’m going to click on Help and the message I get is: Help is only available online. If you’ve used an earlier version of Excel there was always some kind of offline help available but there is now virtually nothing available with Excel 2016. So you really do need to be connected to the internet in order to get any significant amount of help.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.