Microsoft Excel Formulas: LEN

2 April 2017 in Excel Basics, Formula
0 comments 2 minutes 1,025 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 Functions: SUBTOTAL

14 March 2017 in Analysis, Formula
0 comments 2 minutes 1,182 views

The SUBTOTAL function returns the subtotal from a list or database in Excel. SUBTOTAL will give you instant answers for your filtered data More...

Tags: , , , , ,

Microsoft Excel Tip: Watch Window

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

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

Tags: , , , ,

Microsoft Excel Formulas: SUMIFS

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

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

Tags: , , , ,

Top 3 Most Read Articles This Week

20 February 2017 in Top 3
0 comments 2 minutes 419 views

Here are the 3 most read articles on our website over the last 7 days More...

Tags: , , , , , , ,

Microsoft Excel Functions: SUMPRODUCT

19 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 794 views

SUMPRODUCT is a function which multiplies the corresponding components in selected arrays, and returns the sum of those calculations More...

Tags: , , ,

Microsoft Excel Functions: HLOOKUP

13 February 2017 in Formula, Powerful Formula
0 comments 2 minutes 1,036 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: , , , ,

Never Suffer from Print Area Error Again

8 February 2017 in Excel Basics, How To
0 comments 2 minutes 822 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,190 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 729 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: , , ,

Free 30-60 Minute Consultation

27 January 2017 in Another Category
0 comments 2 minutes 1,683 views

Yes, you have read that correctly. How does a free consultation sound? More...

Tags: , ,

Basic Microsoft Excel Functions: COUNTA

25 January 2017 in Excel Basics, Formula
0 comments 2 minutes 746 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 567 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 819 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 613 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 632 views

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

Tags: , , ,

Fund Raising for @Mindcharity

Fund Raising for @Mindcharity

14 January 2017 in Another Category
0 comments 2 minutes 662 views

One in four of us experiences a mental health problem each year. By raising money for Mind, more people with mental health problems get the support they need and the respect they deserve. More...

Tags: , , , ,

Use Conditional Formatting to Highlight the Minimum and Maximum Values

5 January 2017 in Excel Basics, How To
0 comments 2 minutes 974 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... More...

Tags: , , , ,

How To: Shade Alternate Rows in Excel

2 January 2017 in Formula, How To
0 comments 2 minutes 706 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... 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 483 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: , , , , , ,

How To Use IFERROR

29 December 2016 in Formula, How To
0 comments 2 minutes 636 views

Do you get fed up when your formulas return #N/A when performing a VLOOKUP calculation?

Learning to use =IFERROR can help solve that
More...

Tags: , , ,

Powerful Excel Formula: INDEX MATCH

19 December 2016 in Powerful Formula
0 comments 3 minutes 712 views

In a previous article, we discussed the VLOOKUP formula and how one of its major flaws was that it will only search from left to right and adding new columns into your search array can break your... More...

Tags: , , , , , ,

Is Your New Product Worth Selling?

Is Your New Product Worth Selling?

15 December 2016 in Analysis, Case Study
0 comments 2 minutes 687 views

Is it? Really?

It can be surprising how many people and companies do not consider this point before embarking on the development phase of a product and then their marketing campaigns.... More...

Tags: , , , , , ,

Microsoft Excel Functions: IF

11 December 2016 in Powerful Formula
0 comments 2 minutes 670 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 499 views

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

Tags: , , , , , , ,

5 Reasons to use Excel for Data Analysis

16 November 2016 in List, Top 5
0 comments 2 minutes 5,835 views

Microsoft Excel is one of the most widely used software packages in the world, but why should you use it for data analysis within your business? More...

Tags: , ,

How To: Dynamic Chart Titles in Excel

24 October 2016 in How To
0 comments 2 minutes 682 views

Create charts in Excel with dynamic titles

Save time changing the title of your charts when adding new data to them by using a dynamic title More...

Tags: , , , ,

How To: Send an Email from Excel

22 October 2016 in How To
0 comments 2 minutes 695 views

Learn how to use the HYPERLINK function to send an email from an Excel file

Do you work on a file each day and then send an email to someone with data from the file? For example, the... More...

Tags: , , ,

Basic Microsoft Excel Functions: ROUND

21 October 2016 in Excel Basics
0 comments 2 minutes 786 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... More...

Tags: , , ,

Microsoft Excel Functions: SUMIF

in Powerful Formula
0 comments 2 minutes 583 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... More...

Tags: , ,

Microsoft Excel Functions: VLOOKUP

in Powerful Formula
0 comments 2 minutes 654 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... More...

Tags: , ,

Basic Microsoft Excel Functions: MAX and MIN

in Excel Basics
0 comments 2 minutes 658 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 553 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 722 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... More...

Tags: , ,