Blog Directory  >  Microsoft Excel, Word and Outlook Online Training Courses - Blog  > 

Microsoft Excel, Word And Outlook Online Training Courses Blog


myonlinetraininghub.com/blog
Is this your blog? Claim It!
Learn Excel, Word and Outlook from anywhere. On demand courses you can watch again and again. Instant access, start now.
Excel IFS Function
2016-10-18 01:17
This tutorial is applicable to Excel 2016* onwards. In Excel 2016 there are a load of new functions, one of which is the IFS Function. Given last week’s topic, ‘When to say no… Read More
Excel SWITCH Function
2016-10-18 01:17
This tutorial is applicable to Excel 2016* onwards. New in Excel 2016 is the SWITCH function. It looks up a value in a list of values, and returns the result corresponding to the first matc… Read More
Excel Expression Definition
2016-10-14 02:29
A couple of days ago I sent out a survey about the name of an argument in one of the new Excel 2016 functions. The response was huge and I’m so grateful to the 1300+ members who manag… Read More
When To Say No To Excel Nested IFs
2016-10-07 01:18
In Excel 2007, Microsoft thought it would be a good idea to increase the number of times you can nest IF functions from 7 to 64. S I X T Y – F O U R! Are you kidding me? If you need t… Read More
Excel Styles
2016-09-28 06:40
Using Excel Styles in your workbooks can not only make formatting them quicker and easier, but also result in more professional and easier to use workbooks. What are Excel Styles Excel Sty… Read More
2016-09-20 22:56
My last post looked at creating a simple user defined function (UDF). This post looks at a little more advanced subject of combining multiple functions into one. Sometimes you’ll wri… Read More
Excel PivotTable Show Values As
2016-09-07 10:32
The Excel PivotTable Show Values As menu has a load of handy instant calculations you can use. For example you can choose to show the values as: Percentages of the row, column or grand total… Read More
Excel Table Running Total Formula
2016-09-01 08:18
You’ve probably seen a running total formula like this before: = SUM($E$3:E4) You know the one, where the first cell reference is absolute and the second isn’t so that when you… Read More

Share the post

Microsoft Excel, Word and Outlook Online Training Courses

×

Subscribe to Microsoft Excel, Word And Outlook Online Training Courses

Get updates delivered right to your inbox!

Thank you for your subscription

×