Easy Excel Lessons – Transposing Data and Converting Text to Columns

Transposing Data This worksheet shows sales for each salesperson by month: Let’s say that you want to have the months appear as columns, while the sales associates appear as rows. Making this change manually would be a very time consuming process, but luckily Excel 2013 has a way to swap this data for you. To […]

Learn how to Group Data in Excel and use Subtotals

Grouping Data Last week we looked at the Outline feature in Excel. While the automatic outlining capabilities in Excel 2013 work very well with numerical data, it is not so effective when working with non-numerical values or data that has no distinctive totals. Luckily, you have the option to manually group data in Excel. In […]

Its rather simple to use the Outline feature in Excel

The Outline Feature in Excel Excel’s automatic outlining feature makes outlining a worksheet easy. Automatic outlining works best with numerical data organized into groups and sub groups by formulas or functions. For example, the sample image below contains monthly sales data, organized into quarterly and yearly totals using formulas: As you can see, it can […]

Resolve Errors in Excel Formula

How to Resolve Errors in Excel Formula

It is not uncommon to encounter errors in spreadsheets.  But thankfully Microsoft has equipped Excel with tools to help resolve errors in Excel formula.  This include the ability to evaluate formula and set error checking options. In this article we will cover step by step the options available to help resolve errors in Excel formula. […]

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 […]