Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Arranging Workbooks
This quick video explains how to Switch and Arrange your Workbooks in Excel. Switching and Arranging workbooks allows us to work with multiple worksheets and workbooks at the same time. This is useful when comparing values on different sheets or viewing multiple sheet...
Freeze panes
This quick video will show you how you can Freeze a Row or a Column. As you scroll through your spreadsheet is often hard to know which row or column you are looking at. Freezing a row or column or both is a useful way to keep them onscreen and is a very useful...
Drop down lists
This quick video explains how to create a Drop Down List in Excel. Drop down lists are a useful way of presenting the user with a finite list of options. Learn how to create them Data Validation [et_social_follow icon_style="slide" icon_shape="rectangle"...
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
#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...
Named ranges in table format
This quick video explains a useful way of simplifying formula in Excel. Using named ranges from tables in formula is a useful way of simplifying formulae and ensuring that the formulae remain correct if the row count changes at a later time. [et_social_follow...
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.