Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
#N/A instead of content
This quick video explains how to Remove this very common Error in Excel. The #N/A error – is very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from your worksheets [et_social_follow icon_style="slide" icon_shape="rectangle"...
#NULL!, #REF!, #NAME?, #VALUE! Errors
This quick video explains how to correct the other Error Values that may appear in your cell. The #NULL!, #REF!, #NAME?, #VALUE! are very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from your worksheets. [et_social_follow...
Adding text to a number format
This quick video explains how to add Text to a Number Format in Excel. Sometimes it is useful to be able to create a custom number format that displays units in the same cells as the number – e.g. 100Kgs, 100 units and ask Excel to treat that cell as a number. Learn...
Excel Foundations
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Formulas and Functions
SUMIFS and COUNTIFS
This quick video explains the SUMIFS and COUNTIFS Function in Excel. The SUMIFS and COUNTIFS functions allow us to add or count a range using multiple criteria – this is the function to use where multiple tests are required where usually an AND or OR function might be...
HLOOKUP
This quick video explains how to use the HLOOKUP Function in Excel. The HLOOKUP function is widely used to lookup values horizontally in an range of cells. Learn how to use it to find matches in columns on a worksheet [et_social_follow icon_style="slide"...
#DIV/0 instead of content
This quick video will show you how to remove the #DIV/0 Error. The #DIV/0 – Division by 0 error is quite a common error in Excel. Learn what causes it and how to remove them from your spreadsheet [et_social_follow icon_style="slide" icon_shape="rectangle"...
Excel Analyzing Data
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Charts
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Reporting and Dashboards
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Security and Design
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Recording Macros and VBA
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.