Select Page

# Microsoft Excel

## More easy subtotals in a Microsoft Excel database with the SUMIF function [Instant Productivity Free Tutorial]

One advantage of using the SUMIF function to get subtotals is that it is not necessary to modify the order of the records in the original database unlike the Subtotals feature as shown in Super easy subtotals in a Microsoft Excel database.   Video: More easy...

## Super easy subtotals in a Microsoft Excel database (no mathematical skills required) [Instant Productivity Free Tutorial]

The Subtotals command in Excel offers a very quick of getting, well, subtotals – sums, averages and more- without the use of functions and formulas. If you can read these instructions or watch the video, you will know how to calculate subtotals for the hugest, most...

## No programming: Create an interactive spreadsheet with conditional formatting and amaze your boss / your client [Instant Productivity Free Tutorial]

Want to know the impact of changing one cell in your spreadsheet on the rest of your data? Want to create interactive scenarios but don’t have time to learn scenarios or programming? Create an interactive spreadsheet with simple conditional formatting and watch cells...

## Four Essential Tools to make sure your formulas in Excel are correct [Instant Productivity Free Tutorial]

Troubleshooting formulas in Excel is easy thanks to the Formula Auditing Tools. Make sure to learn these tips and apply them as soon as today. Video: Four Essential Tools to make sure your formulas in Excel are correct Tip 1 – Display formulas instead of values  ...

## Instant Productivity: Use Auto Fill with Dates [Free Tutorial]

You already know that when you select a cell with a date and drag the Auto Fill handle, Excel creates a series of sequential dates by adding one day each time. Did you know that you can control how many days are added? A list of all the Mondays until December Type two...

## Instant Productivity: Excel can talk and read back to you. [Free Tutorial]

Excel can talk to you. Text-to-speech saves you time because you don’t need to look up at your screen while entering and checking data. Instant accuracy. Instant productivity. Let your ears do the reading. How to: Make Excel talk with text-to-speech. In the Tools...

## Calculate a Running Total with the Excel SUM function [Free Tutorial]

If, as I expect, you have a list of figures and need to calculate a running total (aka cumulative sum), use this super quick Excel formula tip which uses the Excel SUM function and combines it with absolute cell references (e.g. \$B\$1). The trick? Use the SUM function...

## References and Definitions for Microsoft Excel

A database is collection of data organised in a table or list form in Excel. In Excel, A database field is represented by a column. The field name is the column heading. Each database record is represented by a row.

## Build interactive Excel spreadsheets with developer tools

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

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

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’

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

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

## Supporting Equality

Business Brains, software skills to grow people and businesses, supports the YES EQUALITY campaign. Vote Yes for Equality on 22nd May. We treat everyone and all business equally.

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