Once you start using these top 10 Excel keyboard shortcuts, you will never look at your Excel spreadsheets the same way again. If you want to become more efficient with Excel, shortcuts are a good way to speed up your data entry, find your way around your spreadsheet...
Top 5 Reasons to Learn PowerPivot -Training for Results Hey there! Have you discovered the power or PowerPivot for Excel yet? Or are you stuck with boring old Excel sheets and formulas that quickly become cumbersome, inflexible and impossible to maintain without...
Not so long ago, I showed you how to insert comments using the N() function in Excel formulas. But can you get the comment out of that cell using a function, reader Dobrin asks? Thank you for this article - the N() funtion is very usefull and I use it often in my...
A tri-colour in Excel? Is feider linn. Contextures blog did it using a column chart, removing the gaps between bars and customising colours. A simple project with useful techniques thrown in. Happy St Patrick's Day from Business Brains. How To Make the...
Question: How to make a PivotTable automatically select new data as it is added to the source? Answer: Follow these steps - or even just the first one - to see your data source extend automatically for any PivotTable Step 1 - Convert your Source Data into a Table...
No better time to learn about the weird and wonderful: how Excel measures stuff. If you have ever tried to fit your spreadsheet columns to fit exact measurements in inches or centimetres and have failed before, this short post explains measurement units in Excel and...
Question: I'm trying to figure out how to use conditional formatting to check if the date column is in sequential order and highlight a cell if it is not. Answer: Here is how you can create a conditional formatting rule which would highlight dates or numbers out of...
Three-in-one today. That's right, today you will discover one shortcut to add a comment to an Excel formula, discover how to use the N() function to add a comment and learn about N(). Using comments provides potential users -and yourself- with additional information...
If you have to frequently enter the current date and time into your spreadsheet e.g. in a log or diary entry, there's a quick way to do it without having to type the date, time or even looking at your watch as shown in today's tip. In a cell Press [CTRL]+[;] to...
From data to chart - Monday's essential Excel shortcut Select the data. Include column and row labels in your selection and they will be used to label the chart. Press F11. Done! The chart is created on a separate sheet in full page mode instead of embedded where the...