Interactive Excel Functions List

There are lots of Excel function tips and tutorials on my Contextures website, and here on the Contextures blog. To help me keep track of everything, I’ve created an interactive list of the Excel functions, that you can see here: Interactive Excel Functions List

functionslistinteractive01

Sort and Filter

On the web page, you can click the green button to open the interactive version of the list. Then, click on a heading to sort the list by that column, such as Category or Version Added.

To filter, click on a column name at the left, and select one of the items to filter. For example, in the screen shot above, the list is filtered to show the functions that were added in Excel 2010.

Click a Link

Some of the function names are hyperlinks – click those to go to my web page or blog post with an example for that function. For example, click the AGGREGATE link, to see the examples for this versatile new function in Excel 2010.

I’ll be adding more function examples over the coming months, and will update this list to include the new links.

Video Tutorials

I’ve also updated the Video Tutorials Index page. In addition to the video links, I’ve added video playlists, so you can see all the videos in a specific category, such as Data Validation.

In the sample playlist below – Excel Functions — click the “Playlist” list at the bottom left of the video screen. You should see a scrollable list of videos in that category, and click on any video to start the playlist.

There are currently 73 videos in this playlist, and the total time is 3 hours and 51 minutes.

_____________

You may also like...

5 Responses

  1. Jon says:

    I made a list of functions also. I put them in a text file, more for developers than for average users. It includes the link back to the MS website for the function, description, etc. Can’t remember everything, it’s been a while. It’s on my website if you are interested.

    How did you get all those functions? I scraped MS’s website for it. I probably did it the hard way though :)

  2. Khushnood Viccaji says:

    Very nice work Debra :)

    This may be a silly question but, is there any way to freeze the header (title) row when we scroll down beyond the first page ?

    • Thanks Khushnood, and that’s a good question! I don’t see any way to freeze the headings in the interactive view.

      If you click the workbook icon at the far left, you can go to the Excel Web view, and the headings will show when you scroll down the list. Or, download the file, and freeze the headings in Excel.

      • Khushnood Viccaji says:

        Thanks Debra… I had already downloaded the file, but was curious about this option in the interactive view.

        Excel Web view gives me the functionality I was looking for.

  3. nediva says:

    Friends, I am trying to create a formula without success. I need to determine is the numbers in a particular column(G) that are for example greater than 2,000,000 and less than 5,000,000. If the # in that column fits that description, I need to enter that number into the new column (H). Any ideas? You help is greatly appreciated!

Leave a Reply to nediva Cancel reply

Your email address will not be published. Required fields are marked *