Step by Step – Named Ranges in Excel

Before we really get stuck into this article please go ahead and download the workbooks so that you can practice along step by step. There is no email or sign up to download the files.  This training is free for all and the best way to learn Excel is to practice along. Wanna learn more […]

Up and Running with Excel Form Controls

An Excel form control is a kind of user interface component that can be added to a worksheet. You can add a single form control to a worksheet, or a group of form controls. Some of the form controls that you can choose from include list boxes, check boxes, radio buttons, scroll bars, combo boxes, and […]

Find Hard coded values in Excel Formulas

Find Hard coded values in Excel Formulas

Finding hard coded values within Excel Formulas is something Excel users have struggled with for a long time. While I was researching this article, I am surprised that the solution I am about to offer you has not been widely covered so far. What exactly is a hard coded value? It would be common to […]

Document Entire Excel Workbook with the Click of a Button

Document Entire Excel Workbook with the Click of a Button

Why Document an Entire Excel Workbook You already know the story…. or do you…..? So the internal accountant produces a monthly pack for management, which contains financial information. These reports are fantastic.  Detailed Sales reports show sales against budget, against prior year, as a 12 month rolling total. They are also further sliced against sales […]

Quickly gather statistics for your data using Excels Descriptive Statistics

Excels Descriptive Statistics will quickly allow you calculate a number of statistics from multiple columns of data at a time. The statistics include Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count In this video you will learn how to activate the Data Analysis tool pac in Excel and how […]

stastics correlation coefficient excel

How to Calculate Correlation in Excel with the Data Analysis ToolPac

Correlation is a statistical measure that shows how two variable might move together.   For Example as the price goes down, the sales volume might go up, or as the weather gets warmer, sales volume might decrease.  These types of correlation might be obvious in some organisations, but looking at the correlation between different data sets […]

How to find the Nth Largest in Excel

Both MIN and MAX in Excel will return the Minimum or Maximum value from a list.  But what if you want to return a value that is the Nth smallest or the Nth largest in Excel? How would you go about this type of Ranking? You could use one of Excels Rank functions and sort by […]

Excels Rank Functions

Using Excels Rank functions

Excels Rank functions have evolved over time, and give you the ability to ranks values in a list or column based on their value compared to other values in the same list or column. In Excel 2007 and previous versions, the function you would use to rank value is Rank and the syntax is: =RANK(Number, […]

How to use SUMIF and SUMIFS in Excel

The SUM function in Excel is probably the most widely used function available.  In fact it is the only formula that has its own keyboard shortcut (Alt & =).  Therefore it should come as no surprise that this basic mathematical function has more powerful cousins available in Excel.  These functions are know as SUMIF and […]