Change your Word document into newspaper-style columns, complete with drop cap, to give your document a more interesting layout. It will draw the reader’s eye and make important text stand out. From plain text… … to newspaper-style columns and drop cap. Video:...
François Auerbach
Instant Productivity: Format all messages from a sender in a different colour – automatically – in Outlook [Free Tutorial]
When your email folders, such as your inbox, tend to get full quickly, you may want to use Automatic Formatting to display messages from specific senders in a colour of your choice automatically. Steps to Apply Automatic Formatting in Outlook Select one such email...
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...
Interesting picture shapes in PowerPoint slides
Inserting square pictures is out. Create interesting shapes for your pictures in PowerPoint and other Office applications.
Instant Productivity: Find records faster with a dropdown in Microsoft Access forms [Free Tutorial]
As your database grows, navigating through records using the built-in Navigation Buttons of Microsoft Access forms becomes tedious. Make finding records, such as your customers, much easier by adding a dropdown list on your Microsoft Access form. Watch the video below...
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...
Instant Productivity Tip: Modify the Subject Line of Messages in your Outlook Inbox [Free Tutorial]
Whether you use Microsoft Outlook for your messages or not, I keep telling you: it is good e-mail etiquette to summarise the content of your email in the Subject line. You listened but they didn’t and now you have messages in your Inbox with bad or, worse, no...
Crop a picture in PowerPoint
When you have a large image but only need to display some of it, you need the cropping tool. It works in PowerPoint and other applications too.
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.