Microsoft Excel Formulas: LEN

2 April 2017 in Excel Basics, Formula
0 comments 2 minutes 885 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 Tip: Watch Window

8 March 2017 in Excel Basics, How To
0 comments 2 minutes 1,091 views

A watch window will allow you to view the value within defined cells within your workbooks More...

Tags: , , , ,

Never Suffer from Print Area Error Again

8 February 2017 in Excel Basics, How To
0 comments 2 minutes 715 views

It is insanely annoying when printing someone else’s Excel file only to find that it isn’t formatted correctly and prints across multiple pages More...

Tags: , , , ,

Microsoft Excel Absolute and Relative Cell References

6 February 2017 in Excel Basics, Formula, How To
0 comments 2 minutes 1,057 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 634 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 651 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 486 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 736 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 534 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 550 views

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

Tags: , , ,

Use Conditional Formatting to Highlight the Minimum and Maximum Values

5 January 2017 in Excel Basics, How To
0 comments 2 minutes 908 views

Stop searching for the minimum and maximum values in your range and let Excel do the work for you by using conditional formatting This will take you all of two minutes to read and understand More...

Tags: , , , ,

Top 3 Articles From the Last 30 Days

31 December 2016 in Excel Basics, Formula, How To, List, Top 3
0 comments 2 minutes 413 views

Below are links to the Top 3 most read articles on the website over the last 30 days If you would like an article writing, please get in contact More...

Tags: , , , , , ,

Basic Microsoft Excel Functions: ROUND

21 October 2016 in Excel Basics
0 comments 2 minutes 703 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: , , ,

Basic Microsoft Excel Functions: MAX and MIN

in Excel Basics
0 comments 2 minutes 588 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 478 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: , , ,

Basic Microsoft Excel Functions: SUM and Operators

7 August 2016 in Excel Basics
0 comments 2 minutes 631 views

These are probably the most basic functions that will be used within your spreadsheets, but without them, your spreadsheets will not function correctly. Learning to use these functions will set... More...

Tags: , ,