273,331 views 329 on YTPak
386 36

#### Published on 20 Dec 2012 | over 4 years ago

Get my free 3 hour Introduction to Excel 2013 course. Get 17 training videos to help you learn MS Excel 2013. Click here to get the free course: simonsezit.leadpages.net/free-excel-2013-course/

During this Excel 2013 tutorial, the trainer explains formula tab in the ribbon interface. Moreover, you will discover the different functions within the formula tab which you can use in computing purposes in Excel 2013.

Get the full course on Excel 2013 course here: www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2013-training-tutorials/

Watch the Excel 2013 playlist: www.youtube.com/playlist

Stay in touch:

SimonSezIT.com : bit.ly/JEWqQA
The Simon Sez IT email newsletter: bit.ly/18bMwY0

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 2013. In this section, we’re going to finish looking at Formulas and Functions in general and I’m going to cover some of the general tools both to help you working with formulas and to locate the functions you might need in your workbooks. So, we’ll start by taking a quick look at Excel Options.

The key page here within Excel Options is the Formulas Page. And if you look at the very top there, Change options related to formula calculation performance and error handling. Now at the very top we have a section, Workbook calculation options. I can’t remember the last time I switched this off. But generally speaking what this means is that as you work on your workbook all the calculations are done for you.

If you change a cell and other cells depend on it, totals change, multiplications, other formula and function evaluations change. It all happens automatically, instantly and in the background. And that is really the way that the vast majority of people work all the time in Excel. The only situation you may come across where it will be worth switching this off and perhaps setting it to manual is if you’re dealing with a very large and complex workbook and the calculations are so complex that they significantly slow you down while you’re working.

So you’ve maybe got dozens of worksheets. You’ve got hundreds or thousands of calculations on each one using some very complex functions and every time you type, there’s a delay while it recalculates the contents of many cells and many worksheets. If that were the case and to be fair it doesn’t happen very often, it might be appropriate to switch automatic calculation and revert to manual calculation which means you could make all the changes you wanted to make and then click a button to say Calculate and wait for it all to happen. It’s quite unlikely. It could possibly happen, but it’s worth knowing that it is an option.

So moving on to the next section, Working with Formulas. We’ve already seen this what we can use to use the R1C1 Reference Style instead. The next one, Formula AutoComplete is also very important. It’s actually set on here and that is the thing that means that as I type, so when I’m entering a formula, as you saw earlier if I start to type the name of a function it will come up with suggestions about what that function name will be.

And, of course, when I’ve got names it will come up with names that match that as well. Now AutoComplete is a fairly consistent feature in Office 2013, as in earlier versions of Office, and if you’ve used any of the components of Office before you’ll understand AutoComplete. You can switch it off quite easily here and then as you type you won’t get those messages. Some people fine those suggestions rather annoying and I must admit that a lot of the time that I’m using it, I find the AutoComplete facility can be a bit annoying as well and I do occasionally switch it off. In case, you haven’t quite worked out how that would look. If I switch it off now, click on OK, I’ll start a new workbook.

Let me just a Control-N for a new empty workbook. Now let me say put a couple of cells, a couple of content in there. If I want to now put equals and then I’m going to say the sum of E2 and F2. I now put equals S, there’s no suggestion. U, there’s no suggestion. It’s not suggesting that that might be a sum function. So that’s really what I am eliminating if I switch off the AutoComplete feature.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.

Report video function is under development.