Excel Help Blog
Full of helpful tips to help you get the most from Excel
Excel Top Tips
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 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
5 Useful Functions in Excel
5 Useful Functions in Excel. Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel and it has not arrived in...
The Choose Function, the Alternative to the IF or Vlookup
The Choose function is categorized in the latest versions of Excel as a Lookup and Reference formula, it returns a value from a set list of arguments based on a given position. The function looks as follows: =Choose(Index_num, Value1, Value2, Value3,…Value 254) The...
How to find the minimum value in Excel (while ignoring the 0 value)
How to find the Minimum Value in Excel. In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third...
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.