Excel Tips

Sandra, from Phoenix asks, "I'd like to use information from Excel in a PowerPoint presentation. Is there a way to capture a specific cell in Excel as a picture?"

Excel Paste Special has an option called "Skip blanks." The skip blanks allows users to copy entire sections of data (even with blank columns) and paste the data within another area without overwriting the existing data with blanks.

Validation allows the creator to setup specific cells to contain a list. The list is the only allowable input into that specific cell.

Steve from Phoenix is looking for a way of ranking his sales representatives by revenue for a local company. Excel's Rank formula works perfectly for this.

Using the Series auto-fill in Microsoft Excel will speed up many tasks and will keep you from typing in series of data. It's built in and very easy to use.