Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
Importing MS Access Data
This quick video will show you how to Import File Information from Access. Access tables can be imported and linked to Excel so that we can run reports or build charts based on that data. Learn how to link and import data from Microsoft Access. [et_social_follow...
Developer Toolbar Ribbon
This quick video will show you how to view the Developer Tab or Ribbon in Excel. Since Excel 2007 – the traditional Visual BASIC options have moved to a new Developer Tab. This Tab is not visible by default. Learn how to view the developer tab or ribbon in Excel....
#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 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
MATCH and INDEX
This quick video explains how to use The MATCH Function and The INDEX Function in Excel. The MATCH Function and The INDEX Function work well together to provide a powerful lookup function in Excel [et_social_follow icon_style="slide" icon_shape="rectangle"...
OFFSET
This quick video will show you how to use The OFFSET Function in Excel. The OFFSET function is used to retrieve a value based on an ‘offset’ or index from a reference or range of cells. This can be very useful when we wish our spreadsheet to automatically reference a...
SUMPRODUCT
This quick video explains how to use The SUMPRODUCT Function in Excel. The SUMPRODUCT function will add and multiply a range of items in one step – useful when trying to simplify formulae and save spreadsheet space. [et_social_follow icon_style="slide"...
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.