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...
Microsoft Excel
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.
All about Microsoft Excel