Microsoft Excel Formulas: LEN

2 April 2017 in Excel Basics, Formula
0 comments 2 minutes 1,064 views

LEN is a simple formula that is not often used, however, used correctly it can be used to simplify your workbooks More...

Tags: , , , ,

Microsoft Excel Formulas: SUMIFS

6 March 2017 in Formula, Powerful Formula
0 comments 2 minutes 876 views

The SUMIFS function adds all the arguments that meet certain criteria More...

Tags: , , , ,

Microsoft Excel Functions: HLOOKUP

13 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 1,059 views

HLOOKUP is the lesser used cousin of VLOOKUP, but can be just as useful. Learning how to use HLOOKUP can help in situations where VLOOKUP will not work More...

Tags: , , , ,

Microsoft Excel Absolute and Relative Cell References

6 February 2017 in Excel Basics, Formula, How To
0 comments 2 minutes 1,236 views

Cell references in Excel are a big deal, getting them correct can mean the difference between time saved and time lost scratching your head. More...

Tags: , , , , , ,

Microsoft Excel Formulas: CHOOSE

29 January 2017 in Excel Basics, Formula
0 comments 2 minutes 766 views

The CHOOSE function can return a value from a list of up to 254 arguments. It can also be a good alternative to a nested IF statement More...

Tags: , , ,

Basic Microsoft Excel Functions: COUNTA

25 January 2017 in Excel Basics, Formula
0 comments 2 minutes 776 views

The COUNTA function counts the number of cells that are not empty in a range More...

Tags: , , ,

Weekly Roundup: Top 3 Most Read Articles

22 January 2017 in Excel Basics, List, Top 3
0 comments 2 minutes 596 views

Have you missed one of our articles this week? Fear not as these are the top 3 most read articles. Click the links to learn more More...

Tags: , , , , , ,

Basic Microsoft Excel Functions: COUNT

19 January 2017 in Excel Basics, Formula
0 comments 2 minutes 841 views

The COUNT function counts the number of cells in a range that contain a number More...

Tags: , , ,

Basic Microsoft Excel Functions: ROUNDDOWN

17 January 2017 in Excel Basics, Formula
0 comments 2 minutes 634 views

This article describes the =ROUNDDOWN formula and how to use it to round-down a set number of decimal places More...

Tags: , , ,

Basic Microsoft Excel Functions: ROUNDUP

15 January 2017 in Excel Basics, Formula
0 comments 2 minutes 653 views

This article describes the =ROUNDUP formula and how to use it to round-up a set number of decimal places. More...

Tags: , , ,

How To: Shade Alternate Rows in Excel

2 January 2017 in Formula, How To
0 comments 2 minutes 726 views

Help make your long data lists easier to read by shading alternate rows Below are two quick and easy methods to allow you to do just that which don’t involve manually shading the rows More...

Tags: , , , , ,

Microsoft Excel Functions: IF

11 December 2016 in Powerful Formula
0 comments 2 minutes 690 views

The IF function is a powerful function that can generate an answer based on set criteria IF tests a criteria and returns a value if the test is true, and another value if the test is... More...

Tags: , ,

Top 3 Most Read Articles This Week

21 November 2016 in List, Top 3
0 comments 2 minutes 513 views

Time to recap and review the three most read articles over the last week More...

Tags: , , , , , , ,

Basic Microsoft Excel Functions: ROUND

21 October 2016 in Excel Basics
0 comments 2 minutes 805 views

The ROUND function rounds a number to a specified number of digits. ROUND will take a number and round it to a user specified number of digits to either the left of right of the decimal... More...

Tags: , , ,

Microsoft Excel Functions: SUMIF

in Powerful Formula
0 comments 2 minutes 603 views

The SUMIF function combines the SUM and IF functions to make a powerful formula SUMIF will sum all the values in a list based on a single criterion, which removes the need for manipulating the... More...

Tags: , ,

Microsoft Excel Functions: VLOOKUP

in Powerful Formula
0 comments 2 minutes 675 views

The VLOOKUP function is a fantastic function that can save you lots of time searching through data for values VLOOKUP searches for a value within an array and returns a corresponding value from a... More...

Tags: , ,

Basic Microsoft Excel Functions: MAX and MIN

in Excel Basics
0 comments 2 minutes 671 views

Two more basic, yet powerful, Excel functions are MAX and MIN They do exactly what you would expect them to; return the MINimum and MAXimum values from a range of numbers More...

Tags: , , , ,

Basic Microsoft Excel Functions: AVERAGE

in Excel Basics
0 comments 2 minutes 574 views

Another basic, yet powerful, Excel function is AVERAGE It does exactly what you would expect it to; gives you the average of a range of numbers. More...

Tags: , , ,