How many times have you found a great scene from a video online that you wanted to show an audience in PowerPoint? Of those times how many of those desired scenes were located halfway between the video? Unless you know how to edit videos you probably sat your audience through 5 minutes of meaningless footage [...]
The other day I was working on a presentation in PowerPoint 2010 beta (which you can download for free from Microsoft) and found a Broadcast Slide Show button tucked away in the Share options under the File menu. I clicked on Broadcast Slide Show and found that PowerPoint now allows you to broadcast to [...]
The other day I decided to give Microsoft another try and ran Outlook 2010 which was already installed with the Office 2010 beta (which you can download for free from Microsoft). One of the things that quickly caught my eye was the default use of conversations for emails something I have always enjoyed while using [...]
If you’re like me and you’re not that great with the number pad on a standard keyboard, Excel’s ability to speak what you type as you enter it can make the difference between a couple of minutes in front of a spreadsheet or hours. The Speak Cells command will enable Excel to dictate the information [...]
One of Excel’s most powerful formatting tools is the Find and Replace command. Find and replace allows users to specify elements to locate in a spreadsheet. You can use this powerful command to locate a formula you wish to update, a set of values that have changed, and the formatting applied to cells. In this [...]
One of my favorite and frequently used toolbars is the Quick Access Toolbar located above the Office Ribbon. By default the toolbar has shortcuts for the Save, Undo, and Redo commands, fortunately Microsoft likes to make our lives easier and allowed users to customize this easy to access toolbar. The how-to below will walk you [...]
Data entry rules in Excel give users more control over the type of data that can be entered into cells in spreadsheets. We discussed how to use lists in a previous how-to, in this example we’ll show you how to specify the data type that can be entered and the different options available to you. [...]
Outlining and grouping rows or columns in Excel makes it easy to organize and declutter spreadsheets that have a ton of data on display. Say you have several rows with the sales figures by month and the last row is a summation of the data, rather than display all months you can group the data [...]
Get Daily Email Updates!