Excel 2013 Tutorial - Advanced Functions- Part 1 - Learn Excel Training Tutorial

In this video, get an overview of the lists of functions and how you can use them in Microsoft Excel 2013.

Stay in touch:

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 Advanced. In this section we’re going to start looking at functions and in fact functions are the first area of Excel that we’re going to look at in detail in this advanced course.

Now I think it’s true to say that functions have traditionally been one of the main strengths of Excel since the very earliest versions. And in Excel 2013 not only do we have a few dozen new functions but we also have some great improvements to existing ones. Now the number of functions in Excel 2013 is in the hundreds and I’m certainly not going to go through all of them on this course, but I am going to start by pointing you at a couple of places in online Help that are really going to be able to help you to find the functions that you need.

So let’s start with this online Help entry, Excel Functions by category. Now in there we get a categorized list of the functions. With each of those if you click on the link, it takes you down to the functions, a list of the functions. With each of the items in the list, there’s a description of that function. As I say I’m not going to go through all of these now. We’re going to use many examples on the course. Let’s go back up to the top of this page though. Right at the top here, there’s a note that says Important and that’s exactly what it is.

Some of you will be using Excel on devices with ARM processors. So you may be running Windows RT using Excel. In that case, the level of accuracy, the calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC, a 32-bit or a 64-bit PC and a Windows RT device using ARM architecture. Now to be fair, the differences are going to be very slight and they’re going to be in certain specific circumstances and there is a link here that takes you through to explain more about what those differences are. It’s also the case, although it’s not mentioned here, that some values generated by some Excel functions in Excel 2013 are actually slightly improved, slightly different from ones that are generated in earlier versions of Excel. In the process of continual improvement of functions, Microsoft have made some improvements to a number of functions. You may find that if you are using Excel 2013 on a device and you call a function to get a value and if you called an earlier version of the same function in an older version of Excel, it is possible in some specific circumstances to get slightly different values even using the same PC. Now these differences are slight.

They’re in very specific situations and to a large extent we can ignore them from this point onwards. In fact, none of the examples that we’re using on this course should show any of these differences. However, if in your normal use of Excel, you do find differences like this, perhaps you’ve got a particular complex calculation that you’ve been running in an older version of Excel for some time, you’re upgrading to Excel 2013 and suddenly the values you get just seem to be that little bit different from how they used to be. This could well be explained by changes to, improvements to Excel functions in Excel 2013. That’s something to be aware of but it’s not something that I’m going to go into any further on this course.

Now let me just point out one or two specific things about the Help facility here. As it says there, Worksheet functions are categorized by their functionality. If you know the category you can choose a category and find it. There’s also a Search facility here. As it says, Control-F brings up a Find function. Let’s suppose you’re looking for a standard deviation function, you can start typing Standard, S-T-A-N-D, and so on.

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

[CreativeCollectiveHub]

I'm in 8th grade and this really helped me with my work

[innovativetechnologysoluti]

this is basic function my friend. If you are going to advanced excel start from Macros or VBA

[sunilkumar-bwim]

Hello sir,
I used excel the most in my work, please suggest me a way in which I can give preset command in excel and the data will be changed accordingly.
along with this also guide me - how to set your own commands in excel so that similar changes can be made regularly.

[ankitsharma]

i have excel 2007 in that column is showing in 1, 2, 3, 4 and many but it should be A, B, C, D. how to change this? Please reply

[pawanblogs]

YE ADVANCE FUNCTION HAI ISSE TO ALT + KARKE SUM KAR DUNGA

[jeuneroi]

You kidding me 13min to find out he only shows how to use the SUM good thing i skipped through

[faizanakey]

i've been using excel half my life...i din know total sum is an advance. lol

[randomizedgaming]

no where near advanced. what a waste of time

[DeExiledMartian]

Not advanced excel. This is for beginners.

[teresawilk]

really Simon, this is advenced... thats must be something wrong with you or me...

[islamsalman]

This content is not advanced. it was waste of our time and waste of his effort. I like the scope of this tutorial but there are several videos are not helpful at all. The content need to be improved.