Did you mean
Microsoft Excel (3,385 results), Microsoft Excel 2003 (128 results), Microsoft Excel 2007 (114 results), Microsoft Excel 2002 (30 results), Microsoft Excel 97 (20 results)
Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Generate a list of unique entries in an Excel column
- When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done. by Jeff Davis
- Blog posts 2008-08-05
- Save effort by defining names for Excel 2007 formulas
- Simplify things for your Excel users: Name the formulas they'll need to use. That way, they won't have to create the formulas for themselves. by Mary Ann Richardson
- Blog posts 2008-08-04
- Export holidays from your Outlook 2007 Calendar to an Excel worksheet
- Bringing your holiday list into Excel enables you to work with various date functions, such as Workday. Here's a trick for quickly getting company holidays from Outlook 2007 to Excel. by Mary Ann Richardson
- Blog posts 2008-07-29
- Quick access to Excel formula bar via keyboard
- A quick keyboard shortcut puts you right into the Formula bar. You don't need the mouse at all! by Susan Harkins
- Blog posts 2008-07-25
- Use Excel's Workday function to determine delivery dates
- Your customers will appreciate knowing exactly when they can expect their orders to arrive -- and Excel makes it easy to set up a calculation that can tell them. by Mary Ann Richardson
- Blog posts 2008-07-22
- When Excel's AVERAGE function doesn't give true results, try AVERAGEA
- If your data includes text values, Excel's AVERAGE function won't give you an accurate picture. See how AVERAGEA can solve this problem. by Mary Ann Richardson
- Blog posts 2008-07-15
- How to keep others from printing an Excel worksheet
- Use a simple macro to inhibit printing in an Excel workbook. by Susan Harkins
- Blog posts 2008-07-14
- Use Excel to calculate the number of working days you have to complete your projects
- When you're trying to determine how many days you have left before reaching a project deadline, try this handy Excel technique. by Mary Ann Richardson
- Blog posts 2008-07-08
- Quickly document Excel formulas
- You can document an Excel worksheet easily by printing formulas. Store the hard copy with the application's documentation. by Susan Harkins
- Blog posts 2008-07-06
- Set a print area to keep Excel from printing what you don't want
- When you need to prevent Excel from printing certain cells, you can define a print area that excludes them. Here are the steps you need to follow. by Mary Ann Richardson
- Blog posts 2008-07-01
- Use VBA to bring in the range
- When you want to locate the last cell containing data in a worksheet, you can press Ctrl + End -- but that may take you beyond the range of data you're using. Here's a trick for resetting the used range so that Excel will take you to the right spot....
- Blog posts 2008-06-24
- Quickly control screen magnification in Excel
- Even if you don't use your mouse wheel for anything else, you might want to adopt this trick: With the help of the Ctrl key, you can zoom in and out of an Excel worksheet. by Susan Harkins
- Blog posts 2008-06-23
- Use an Excel spreadsheet to prototype your reports
- Prototyping is a tried and true method for capturing the design details of user interface design. Less-experienced developers sometimes overlook the output requirements of a system when designing it. Report prototyping often reveals holes in the design for both input functions and data processing functions. Joe Goss has discovered a...
- Image galleries 2008-06-19
- Use an Excel spreadsheet to prototype your reports
- Prototyping is a tried and true method for capturing the design details of user interface design. Joe Goss has discovered a very valuable electronic tool for prototyping reports -- Microsoft Excel. by Joe Goss
- Blog posts 2008-06-19
- Use Excel's Lookup functions to search a database
- With the help of Excel's Lookup functions, you can build a worksheet that will enable you to search a database table. Mary Ann Richardson steps you through the process. by Mary Ann Richardson
- Blog posts 2008-06-16
- How to add a drop-down list to an Excel cell
- Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets. by Susan Harkins
- Blog posts 2008-06-12
- Change the shape of Excel's comment box
- Excel displays comments in a square box. Using AutoShapes, you can change that square to any number of shapes. by Susan Harkins
- Blog posts 2008-06-11
- Use named ranges for absolute references in formulas
- There are a number of ways to design absolute references in formulas. For example, in an order form, you might use a Lookup function to determine the shipping charges from a shipping table, as shown here. If you use the cell range for...
- Blog posts 2008-06-10
- Named ranges make it easy to summarize year-to-date totals
- You have five sheets in your workbook. The first four sheets list the sales for each quarter by month and then total the sales for the quarter in cell N10. The last sheet calculates the year-to-date sales. To have your worksheet summarize the YTD total automatically, follow these steps: ...
- Blog posts 2008-06-03
- Save time reformatting by using Excel's Fill function across worksheets
- You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You've just made some changes to the font color and the background of the...
- Blog posts 2008-05-27
- << Previous
- page 1 of 170
- Next >>
Content Types
- Blog posts (161 results)
- Book chapters (26 results)
- Case studies (37 results)
- Discussion threads (665 results)
- Download resources (80 results)
- Image galleries (21 results)
- Q&A (271 results)
- Software downloads (1,615 results)
- Technical articles (282 results)
- Tools & templates (5 results)
- Webcasts (129 results)
- White papers (88 results)
Refining Tags
- Software (2,442 results)
- Microsoft Office (2,204 results)
- Office Suites (2,144 results)
- Microsoft Windows (1,478 results)
- Operating Systems (681 results)
- Microsoft Corp. (555 results)
- Microsoft Word (383 results)
- Enterprise Software (303 results)
- Productivity (289 results)
- Cell (268 results)
- Hardware (261 results)
- Data Management (201 results)
- Word Processors (196 results)
- Databases (192 results)
- Mary Ann Richardson (188 results)
- Finance (173 results)
- Software/Web Development (170 results)
- Spreadsheet (137 results)
- Management (128 results)
- Microsoft Excel 2003 (123 results)
- excel (121 results)
- Software Development (115 results)
- Microsoft Excel 2007 (112 results)
- windows (107 results)
- Microsoft Office Suite Excel Tips Newsletter (103 results)
- E-mail (99 results)
- Microsoft Access (97 results)
- Mobile (93 results)
- Programming (88 results)
- Microsoft Outlook (81 results)
- Apple Macintosh (81 results)
- Security (75 results)
- Tools & Techniques (75 results)
- Susan Harkins (74 results)
- Marketing (74 results)
- Internet (69 results)
- Online Communications (69 results)
- Programming Languages (69 results)
- Web Development (68 results)
- Financial Accounting (66 results)
- Sales (65 results)
- Excel Spreadsheet (59 results)
- Tool (54 results)
- Peripherals (53 results)
- XML (53 results)
- Webcast (51 results)
- Storage (49 results)
- Sales Strategy (49 results)
- TechRepublic Inc. (48 results)
- Sobolsoft (48 results)
