Alan Murray
Contributing since January, 2019
-
34articles
Page 2
About Alan Murray
Alan is a freelance Microsoft Excel writer and trainer from the UK. When he is not writing, he can be found running, hiking or drinking real ale.
Latest Articles
How to Work with Trendlines in Microsoft Excel Charts
Adding a trendline to your Excel chart enables you to see the general direction of your data and forecast future values. This article shows you how.
How to Enter Zero Before a Number in Excel
Preserve the leading zeros when entering numbers into Excel. By default, Excel removes any zeros at the beginning of a number. This is unhelpful when entering numbers such as phone numbers and credit card numbers. This article demonstrates three different techniques to preserve the leading zeros.
How to Cross Reference Cells Between Microsoft Excel Spreadsheets
Cross referencing cells and ranges in other sheets and different workbooks in Excel can be daunting at first. What do all those characters mean in the formula? Why doesn't mine work? Learn how to create these references easily and fully understand the anatomy of a cross reference in this article.
How to Save Time with Excel Themes
Save yourself hours of formatting and frustration with Excel themes. A theme is a collection of colours, fonts and effects that can be applied with the click of a button. You can create your own custom themes for consistent and professional looking Excel reports.
How to Combine or Group Pie Charts in Microsoft Excel
Pie charts are very popular in Excel, but they are limited. They can only show one series of data, so sometimes you might need to produce multiple pie charts for the task. In this article we look at how to combine pie charts into a single figure.
How to Convert Text to Date Values in Microsoft Excel
How to convert text to date values using formulas, and other familiar Excel tools. This article explores different scenarios where you have dates on a spreadsheet being stored as text. We cannot analyse the data if Excel does not recognise its form. So we solve these scenarios using a variety of methods. Some quick, and some automated.
How to Get Microsoft Excel to Calculate Uncertainty
Calculate uncertainty in Excel using statistical formulas, and plot these values on charts. Excel provides many ways to calculate a margin of uncertainty in your values. This article presents the key statistical formulas. And then explores options provided with charts in Excel to plot these error margins.
How to Use Text to Columns Like an Excel Pro
Text to Columns in Excel is great. But are you getting the most out of it? Learn to use Text to Column like a pro.
How to Calculate Percentage Change with Pivot Tables in Excel
A common reporting requirement in business is to display the percentage change between date values over time. PivotTables make this easy in Excel. And in this article you will see exactly how this is done.
How to Use VLOOKUP on a Range of Values
Everyone is using VLOOKUP for exact matches. Using VLOOKUP to return from a range of values is also very useful.
How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT
Mastering logical functions will give you a big advantage as an Excel user.
How to Create a Radar Chart in Excel
A radar chart compares the values of three or more variables relative to a central point.
How to Change How Excel Displays Negative Numbers
Microsoft Excel displays negative numbers with a leading minus sign by default.
How (and Why) to Use the Outliers Function in Excel
An outlier is a value that is significantly higher or lower than most of the values in your data.