Select Category
A button in your Excel spreadsheet to increase values and make all your formulas dynamic?
A user on Reddit asks I’m building a financial model in excel. I’d like to be able to insert a type of button which will apply different % increase to a range of cells. For example, I have 10 products in a list which have 10 different sales prices. I’d like to be able...
How to stop and restart your Project schedule after Covid-19?
Question: With Covid-19 and the lockdown, my project schedule is put on hold for a number of weeks. How can I reflect this in my Microsoft Project Gantt Chart? This is useful for tasks that haven't started yet - you don't want to change the start date of tasks that...
Top Keyboard Shortcuts in Articulate Storyline cheat sheet (free download)
Download the Top Keyboard Shortcuts in Articulate Storyline cheat sheet Do you need help to get started with your e-learning? Learn the shortcut way to designing professional e-learning that is engaging, fun and creative. We offer classroom training for your...
How to fix Microsoft Project error: “This operation requires that you have Excel 2003 or later installed on your computer”
If you try to create an Excel report in Microsoft Project but have a different version of Excel, then you will have come across this error: "This operation requires that you have Excel 2003 or later installed on your computer." In disbelief, you check that you have...
TOP 10 Keyboard Shortcuts for Excel Spreadsheets
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...
Help! Reminders are missing from Google Calendar!
Have your Tasks or Reminders gone missing from your Google Calendar? It may be due to one of your extensions.
Killing fewer trees when printing a Gantt Chart
How do I print just the Gantt chart in Microsoft Project without it being 50 million pages? I have tried every option possible and so far wasted about eleven trees of A3 paper but I just keep printing blank pages – is there some way to scale it without making it...
Top 5 Reasons to Learn PowerPivot – Training for Results
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...
Extract Comments Embedded in the N() Function
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...
Copy and Paste Webinar – Essential Skills for the Modern Office Worker
This April's Fools Day 2014 promotion is now over 😉 Thanks to all of you who did email with your witty comments! We are delighted to announce our exclusive new webinar. Since we started in the IT industry one trend we have seen increasing day after day at a...
A tri-colour in Excel? Is feider linn. Happy St Patrick’s Day
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...
A PivotTable that includes new data automatically? Good Question!
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...
Never Forget an Outlook Attachment Again when you Send a Message
Wonderful question from a very recent Time Management using Outlook course held on-site. Question: How can I make sure that I never forget an attachment when I send an email using Outlook? Answer: If you use Outlook 2013, the feature is built into the programme so all...
Why you will never size Excel columns correctly
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...
Checking that dates are in sequential order with Excel Conditional Formatting Formula
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...
That Friday Feeling
Celebrating that Friday feeling.No better way than with a comment from a satisfied customer. What makes you happy on a Friday afternoon?
Increase and decrease font size quick and easy with a shortcuts in Word, Outlook and PowerPoint
Let's talk about text, baby. Let's talk about Outlook, Word and PowerPoint, namely, because today's keyboard shortcut works in all three. So let me give you the shortcut now and then I will tell you about something extremely odd in relation to this particular issue of...
Comment Excel formulas with the N() function
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...
Friday Fun: Spreadsheet Heroes to the Rescue
You can't PivotTable stuff all day long! So here is a selection of three pieces of Excel art which will amuse you, amaze you, surprise you. Pow! Bang! #N/A! #N/A! #N/A! #N/A! Batman! This one will rescue you if your workbook is full of errors. Oh, oh, oh! Sweet file...
Hop hop hop across slides with this PowerPoint trick
No mouse! Need to edit or review PowerPoint slides? Press CTRL+ENTER to move from placeholder to placeholder. When you reach the last placeholder, press CTRL+ENTER to create a new slide. This magic trick is particulary useful when worky with those busy slides with...