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...
François Auerbach
Get Excel charts and tables always up to date in your Microsoft PowerPoint presentation [Instant Productivity Free Tutorial]
You need two files to follow this tip: an Excel spreadsheet with a chart or some data in it and a PowerPoint presentation. Video: Get Excel charts and tables always up to date in your Microsoft PowerPoint presentation Copy the data or chart from Excel Switch to...
![Make Microsoft Access forms more user-friendly with big navigation controls [Instant Productivity Free Tutorial]](https://www.businessbrains.ie/wp-content/uploads/2015/10/Microsoft_Access_2013_logo_svg-400x250.png){kind=logo}
Make Microsoft Access forms more user-friendly with big navigation controls [Instant Productivity Free Tutorial]
Not everybody is as confident with Microsoft Access databases as you are. Most users feel intimidated and afraid – rightly so – to make mistakes. So make their use of the database easier with big navigation controls. In a previous tip, you learned how to Find records...
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...
Don’t type it all over again! Re-use text in Word documents and Outlook messages thanks to AutoText [Instant Productivity Free Tutorial]
Copy and Paste will only get you so far. Rather than type the same bits of text and pictures over and over again, be it your address, your terms and conditions, your disclaimer, your location map or logo, save them as AutoText entries in Word. AutoText entries work in...
Canned email answers in Microsoft Outlook [Instant Productivity Free Tutorial]
Why rewrite the same messages over and over again when you could click one button and reuse an existing email template? Perhaps you always send the same booking confirmation form all the time. Perhaps you send the same acknowledgement/refusal letter all the time? Save...
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...
Stop fumbling! Navigate your PowerPoint slides effortlessly thanks to hyperlinks [Instant Productivity Free Tutorial]
Use visuals with hyperlinks to effortlessly navigate your PowerPoint slides as you present – without being tied to the original order of your slides. Your presentation is now more flexible and ready for a range of purposes. Video: Navigate your PowerPoint slides...
Create and apply your own AutoFormat style to Microsoft Access forms [Instant Productivity Free Tutorial]
You spent some time making your form look nice and now you need to apply the same design to all the forms in your Microsoft Access database project. Use AutoFormat to save your design and to apply to other forms. Video: Create and apply your own AutoFormat style to...
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 ...
All about François Auerbach