Do you need to future-proof your business? The Excel Forecast sheet may be the right tool for you! The Forecast sheet allows you to take your historical business data (sales, cash flow, etc.) and create more accurate forecasts for the future. You ar...

This is a tip that you're going to really enjoy if you love imagery and visualisations in your spreadsheet! It's not the most useful tip in the world, but for most people, especially the creative types—it will put a smile on your face because it's so...

When working with large data lists in Excel, you may need to know the extent of the data, i.e. the number of rows and columns.   If consistency of the data is important too, then you may need to identify whether there's any empty rows, columns o...

It's been well over 10 years since I started training Microsoft  Excel  to corporate clients. During training sessions, delegates would usually ask questions on how they can use Excel to help them become more effective in their wo...

Selecting data from a drop-down list is a convenient and accurate way of entering data into a range. It helps in ensuring that the correct data is entered quickly in Microsoft  Excel. However, a slicer provides a quicker, better and easier way o...

To complete an analytical review of the depreciation of your company's assets, you can calculate the average useful life of these assets. The average useful life, which is a measure of conditional central tendency, can be calculated using the AVERAGE...

In order to effectively analyze data, custom number formatting can be applied to your Microsoft  Excel  spreadsheet. Custom number formatting is used to easily identify values based on a set criteria. In a large Excel spreadsheet, you can e...

To have neat looking reports in Microsoft Excel, you may decide that you want to hide zero values. In this tip, we explain how to hide zero values for selected cells by using the custom number format. The hidden zero values appear in the formula bar ...

Sometimes when working in Excel and collaborating with your colleagues on a single document, you may wonder to yourself; how can I compare and merge a shared workbook? The answer is simple! You can do this by using the Compare and Merge Workbooks com...

In order to correctly show the movement and management of cash within a business, accountants use a cash flow statement. This statement will display a business's money coming in from'cash receipts' and where it has paid money out,'cash paid'. The cas...

The Scenario Manager is a feature in what-if analysis and you can use this to enhance your forecasting in Microsoft  Excel  . A scenario is a set of values that Excel saves and can automatically substitute in specific cells on a worksheet...

If you ever need to split data from one column in your Microsoft  Excel  worksheet into two or more columns, you can use the LEFT, MID and RIGHT Text functions. The LEFT function returns the first character or characters in a text string...

Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatt...

In a  previous  tip, we showed you how to set up a PivotTable using PowerPivot. You're now going to learn how you can easily calculate Sales Tax/ VAT using the Measures feature in the PowerPivot tab. If you're the business's accountant, you...

Monitoring budgets can be quite stressful and may often involve the use of formulas. Instead of complicated formulas, you can use custom formats within Microsoft Excel to easily determine if you are over or under budget. All it takes are a few steps...

For quick access to related information in another file, workbook or on a web page, you can insert a hyperlink in a Microsoft  Excel  worksheet cell. You can also insert hyperlinks in specific chart elements or images. If you struggle to...

You can quickly view or compare two or more worksheets in the same workbook, or in different workbooks, by viewing them side by side. You can also arrange multiple worksheets to view them all at the same time. In this tip, I show you how. Applies ...

Multiple users can effectively work on a spreadsheet by sharing it, and then collaborating on it. Edits can be made simultaneously by team members, thus having a continuously updated version of the spreadsheet available all the time. In this way, ver...

Sometimes when working in Excel, you may want to compare two versions of a workbook to see what was changed. It could be an issue such as totals that are manually entered instead of formula calculated that you want to check. You can use Microsoft ...

Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc. Applies To: Microsoft  Excel  for Windows 2013 and 2016. Excel ...

As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. In this tip, we explain how to remove blank cells between your data in Excel so that this happens. ...

When creating a pie chart and adding data labels to the slices, the wording can sometimes split into two lines—giving you wrapped data labels that aren't visually appealing. In the below example, Administration has been split into two words, each on ...

This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data. You are welcome to download the workbook to practice. Applies To: Microsoft  Excel  for Windows 2010, 2013, and 2016. Ex...

Instead of displaying values, you can actually display formulas as a way of reviewing the spreadsheet. In this  tip, we explain how that can be done. You are welcome to download the workbook to practice. Applies To: Microsoft  Excel&...

This tip shows you how to generate a barcode in Excel that will enable you to  track stock, sales, purchases or fixed assets. Applies To: Microsoft  Excel  for Windows 2010, 2013, and 2016. Excel has no built-in functionality t...