Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- How to quickly color code values based on criteria
- Excel can filter a list by criteria using AutoFilter or Advanced Filter. For instance, you can use either feature to filter a list of orders to a particular product or salesperson. Or you can use both features to filter a list of orders to a particular product sold by a...
- Tags: Result, List, Cell, AutoFilter, Advanced Filter Criteria Method, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-02-23
- Search for invalid data in your Excel file
- Less elegant but very quick way to validate dataGood tip! It may be "too much work" for some situations. For a "quick and dirty" way to check data validity, one can turn on the AutoFilter (Data|Filter|AutoFilter). Clicking the "down arrow" at the top of each column will...
- Tags: validation, excel, data validation, AutoFilter, CMB from Omaha, hardware, Microsoft Excel
- Discussion threads 2006-05-10
Additional Resources
- Find Specific Information Using AutoFilter
- Has one ever found himself scanning row after row in an Excel worksheet to pick out just the data he is interested in? Maybe one is looking for rows containing the name of a particular person, product, or company. Plowing through all of the irrelevant material takes time, especially if...
- Tags: Row, Microsoft Excel, Microsoft Office, Office Suites, Software
- Webcasts
- MS Excel
- Is there any possiblity to show the a number of rows in Excel spread sheet by writing code in formula barlike the one we use with autofilter and find what we want.
- Tags: Microsoft Office, pkb_pkb@..., Microsoft Excel, Microsoft Corp.
- Discussion threads 2007-05-28
- Filtering Out Blanks in a Table
- I keep an Excel table of students, their exam scores and when they took the exam. There is a row for each student, with the columns being the various exam grades and the dates they took the exam. I wish to create a list somewhere in the worksheet...
- Tags: cccgsmith, software, blank
- Q&A 2005-04-06
- 10 obscure Excel tricks that can expedite common chores
- The business world is full of users who have neither the opportunity nor the inclination to figure out Excel's timesaving shortcuts. They end up wasting a lot of time and adding to your support burden because they just don't know the smartest ways to work with spreadsheet data. IT...
- Tags: Business World, Microsoft Excel, Productivity, Microsoft Office, Office Suites, Software
- Download resources 2007-01-05
- Excel 2003 Personal Trainer: Working With Lists
- Another task Excel can perform is keeping track of information in lists or databases. Some examples of things one might track in a list include telephone numbers, clients, and employee rosters. Once a list is created in Excel, one can easily find, organize, and analyze its information with Excel's rich...
- Tags: Microsoft Excel 2003, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2004-11-08
- Duplicate Remover for Microsoft Excel (zip)
- With Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Excel worksheets or find unique entries. You can search for duplicates in one range or compare two lists with different number of columns, choose columns for comparison. Once duplicates are found you can perform any action to...
- Tags: Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2007-11-01
- Excel import yields double spacing
- I am importing pipe delimited .txt files into Excel on a regular basis. However, the records end up double spaced in Excel. Each .txt record is terminiated with . Is there a way to have the imported results be single spaced?There is. It may be a...
- Tags: Microsoft Excel
- Q&A 2006-03-28
- AlligatorSQL Business Intelligence (zip)
- AlligatorSQL is the first cross development and cross administration IDE for both DBAs and developers. We integrated not only twelve database management systems, but also combined development and administration features consequently into one tool. As a result AlligatorSQL is specialized for heterogeneous infrastructure and enables the user to develop, administer...
- Tags: Administration, Database Management System, Database Management, AlligatorSQL, Databases, Advertising & Promotion, Workforce Management, Enterprise Software, Software, Data Management, Marketing, Human Resources
- Software downloads 2006-12-18
- Teach Access to Excel users by comparing features
- When users call the help desk seeking Access training by phone, try to help them by comparing it to an application they know. Jeff Davis shares how he trained an Excel user to use Access by comparing similar features between the two applications.It’s unrealistic to expect to turn a first-time...
- Tags: Microsoft Office, Databases, Jeff Davis, Microsoft Access, Microsoft Excel
- Technical articles 2002-04-02
- 10 obscure Excel tricks that can expedite common chores
- Over the years, each new version of Excel has introduced some nifty features. However, buried within Excel are lots of cool features that too few users have discovered. If you or your users perform certain tasks every time you use Excel, you'll want to make sure you're taking advantage of...
- Tags: Data, Row, Column, Entry, Cell, Ctrl, Figure L, AutoCalculate, Microsoft Excel, Microsoft Office, Office Suites, Software, Jeff Davis
- Blog posts 2008-06-10
- Simplify your IT record keeping with our documentation download
- Documenting IT processes tends to be a pretty dreary chore. But neglect it, and you're bound to run into problems sooner or later. Our documentation download will make it easier to track those critical details and keep things running smoothly.So you’ve decided to forge ahead and start documenting your IT...
- Tags: Microsoft Excel, Strategy, Network technology, NETWORKING, Jim Wells MBA, information technology, IP
- Technical articles 2000-09-22
- Finding and flagging subsets of Excel records
- Finding subsets of records in an Excel spreadsheet can be tricky if the criterion is whether an entry contains a string. Use this formula to ferret out the records that contain the key word you are looking for.Recently, a consulting client called to ask the following Excel question: How can...
- Tags: Microsoft Office, Jeff Davis, Microsoft Excel
- Technical articles 2002-01-22
- Download Support Republic's ultimate Excel compilation
- Instead of waiting until your Excel users come to you for advice, be proactive—help them improve their Excel skills with Support Republic's ultimate Excel compilation. This download contains more than 100 pages of Excel tips, tricks, and examples taken from 20 TechRepublic and TechProGuild articles and five TechRepublic downloads.Include one...
- Tags: Microsoft Office, Bill Detwiler, Microsoft Excel
- Technical articles 2003-06-20
- Build interactive Web sites easily with Microsoft Office Web Components
- Microsoft Office Web Components are powerful tools for publishing interactive Web pages on your intranet. In this Daily Drill Down, Bruce Maples gives an overview of how to put these components to work for you.Did you build an intranet for your company that nobody cares about? Maybe it’s too static....
- Tags: Microsoft Excel, Microsoft Corp., Web site, Bruce Maples, Microsoft Office, Office Web Components, Office Web, Web
- Technical articles 2001-04-12
- << Previous
- page 1 of 1
- Next >>
