Microsoft Archives » Page 2 of 9

Checking that dates are in sequential order with Excel Conditional Formatting Formula

by François Auerbach | Microsoft Excel

Are the dates in your Excel spreadsheet in the right order? Use conditional formatting to make sure they are.

Shortcut: change font size in Word, Outlook and PowerPoint

by François Auerbach | Microsoft

Increase and decrease font size quick and easy with a shortcut in Word, Outlook and PowerPoint

Comment Excel formulas with the N() function

by François Auerbach | Microsoft Excel

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...

Hop hop hop across slides with this PowerPoint trick

by François Auerbach | Microsoft Powerpoint

Bored with linear PowerPoint? Can’t find the slide you need while presenting? Create dynamic presentations and hop around effortlessly.

Insert the current date or time quickly without looking at your watch with today’s Excel tip

by François Auerbach | Microsoft Excel

What’s today’s date? What time is it? Did you have to look at your calendar and clock? The keyboard shortcut and functions in this article will make your date and time entry in Excel fast, easy and accurate.

Delete Outlook Messages before they Arrive

by François Auerbach | Microsoft Outlook

Too popular at work? For some reason, your Outlook inbox is where everybody else's conversations converge. From now on, instead of deleting messages that you are not interested in, why not delete messages which you will not be interested in? Yes. Delete the future...

From data to chart in Excel in one move

by François Auerbach | Microsoft Excel

A graph is worth a thousand data points. Excel turns your tables into charts and graphs, pie charts, line charts, column charts, with just a selection and a click. Dive in with us.

Troubleshoot Excel Formulas Like a Pro – Part 1

by François Auerbach | Microsoft Excel

Have you ever had to reopen an old workbook – or worse, a workbook that was set up by someone else – and figure out what was going on in it, update it without being sure that you weren’t going to break some of the calculations?

Add a new Slide in PowerPoint with a Shortcut

by François Auerbach | Microsoft Powerpoint

Another time-saving shortcut for PowerPoint users

Troubleshoot Excel Formulas with a Shortcut

by François Auerbach | Microsoft Excel

Review all the formulas in your workbook quickly. On Friday, a longer article will tell you about troubleshooting worksheets. Here's how to get started: Switch from values to formulas with CTRL+`(that's single quote, the key just above the tab key on your Irish /...

Build interactive Excel spreadsheets with developer tools

by François Auerbach | 28 March 2022 | Uncategorized | 0 Comments

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 Microsoft Project schedule

by François Auerbach | 20 July 2020 | Microsoft Project | 0 Comments

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

by François Auerbach | 5 November 2018 | Articulate Storyline, E-Learning | 0 Comments

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...

Fix Microsoft Project Error: ‘Excel 2003 or Later Required’

by François Auerbach | 22 June 2018 | Microsoft Project | 0 Comments

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

by François Auerbach | 22 May 2018 | Microsoft Excel | 0 Comments

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!

by François Auerbach | 3 January 2017 | General, Uncategorized | 15 Comments

Have your Tasks or Reminders gone missing from your Google Calendar? It may be due to one of your extensions. Firstly, if you aren't already using Reminders in Google Now and Google Calendar - you are missing out. If you are an Android user, you can speak reminders...

Kill fewer trees when printing a Gantt Chart

by François Auerbach | 22 August 2016 | Microsoft Project | 0 Comments

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

by François Auerbach | 30 June 2015 | Microsoft Excel | 0 Comments

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

by François Auerbach | 23 April 2014 | Microsoft Excel | 0 Comments

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...