By topic
Business Brains Blog
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]](https://www.businessbrains.ie/wp-content/uploads/2015/10/Microsoft_Access_2013_logo_svg-400x250.png){kind=logo}
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]
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.