SOLUTION: Learn the shortcut key that will allow you to create a charThis tip will make life a little easier for you.
SOLUTION: Start using the IFERROR function Continue reading Excel – Hiding errors using the IFERROR function
If you have recently upgraded to Office 2013 you will have noticed that the Ribbon is collapsed by default, and only the Ribbon tabs are visible. As a result one of the first questions I get asked when doing upgrade training is “why are the Ribbon commands hidden and how do I get them back”? Continue reading Upgrading to Office 2013 – Why are the Ribbon commands hidden?
In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet. Continue reading Excel – hiding, unhiding and finding hidden Columns and Rows
I’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue reading Excel – Copying or moving entire worksheets between workbooks
Ever tried to centre a heading over the top of a number of columns? It can be a little frustrating, especially when you can’t quite get it to sit as you would like. Last month saw me running multiple Stage 1 Excel courses and it reminded me that this problem frustrates so many. I love hearing the “oh wows” when I show the class how the Merge and Center command allows you to easily centre headings over tables of data. Continue reading Excel – Working with merged cells (merging and fixing problems)
Following on from my previous post on the Excel Consolidate feature I’ve created the following video tutorial to demonstrate how you can use this feature to summarize data from multiple sources using the Pivot Table command. Continue reading Excel – How to summarize data from multiple worksheets (Part 2 of 2)
I recently ran an Advanced Excel course where I was asked “what is the quickest way to pull data from multiple worksheets into a summary worksheet?” Excel offers several solutions for consolidating and summarizing data from different worksheets and workbooks. Continue reading Excel – How to summarize data from multiple worksheets (Part 1 of 2)