Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Let Excel e-mail your weekly reports
- What about Lotus Notes?This looks great but seems to reply on Outlook or Outlook Express (that's what pops up on my screen even though my default mail is Lotus Notes). I don't want to start a debate on Notes vs Outlook here, but given I can't change my email program,...
- Discussion threads 2007-11-14
Additional Resources
- Let Excel's Indirect function keep data at your fingertips
- typos?Are those cell addresses in the text correct?Great toolThanks for this tip. I think some of the cell refernces may be incorrect. In the sample, E9 should be E19, E8 should read E18 and E10 should read E20.cell reference errors?In Fig A it is saying to type E9, E10 etc....
- Discussion threads 2008-12-03
- Let Excel enter decimal points for you
- You may be able to get away with entering numbers without decimal places, but what about whole numbers or uneven places? Mary Ann Richardson shows you how you can make Excel enter decimal points for you. If you need to enter columns of numbers with a fixed number ...
- Technical articles 2006-08-15
- Let Excel enter decimal points for you
- Great toolTakes a few sessions to get used to, but then it saves a lot of time.Should be used with caution if others have access to your PC and worksheets.May add more key strokesIf, in your worksheet, you enter a large number of integers, then this tip would cause you...
- Discussion threads 2006-08-16
- Conversion in Excel file from numbers to english Words
- Pls. let me know how to convert the number to English words in MS.Excel.e.g. 10,000 as Ten Thousands.How to convert a numeric value into English words in Excelhttp://support.microsoft.com/kb/213360
- Discussion threads 2007-07-16
- Anatomy of an Excel formula: Using functions to perform calculations
- If you'refairly new to Microsoft Excel, you've probably learned to enter data intocells to provide consistent formatting, and give yourself an easy way to updateinformation, such as your office budget. However, many people brand new toExcel don't realize how much easier the power of Excel's formulas can make your job...
- Technical articles 2005-08-22
- Getting over your fear of Excel's database functions
- Kick your spreadsheet skills up a notch by taking this crash course in how to use Excel's database functions.By Chris DunnDo you support Excel users who are afraid to try anything but what they know? Let’s face it, we all like to stay in our comfort zone—I’ve worked with people...
- Technical articles 2000-05-17
- 10 key enhancements in Excel 2007
- This information is also available as a PDF download.Given the learning hurdle that comes with an entirely revamped albeit improved user interface, Excel 2007 must offer significant enhancements to encourage you to upgrade. Herewith, my top 10.#1: Make the Ribbon work for youThe Office 2007 redesign includes some radical...
- Blog posts 2007-06-07
- Teach two-variable Excel data tables with real-life examples
- Looking for a great way to teach end users two-variable Excel data tables? A real-life example might just do the trick. Find out how this method works for one training pro.When teaching Excel classes, I’ve found that it pays to use real-life examples to keep users interested. In my recent...
- Technical articles 2001-03-02
- Teach users to manipulate data with Excel pivot tables
- If your users are looking for a great way to manipulate data in Excel, pivot tables may be the answer. Here's the information you need to teach your users how to start using this valuable Excel feature.I recently read an article that ranked Excel pivot tables among a list of...
- Technical articles 2000-12-18
- Download our sample Excel ledger to learn about absolute cell references
- Don't go nuts trying to figure out Excel absolute cell references. Instead, read this article to find out how to create and use this handy Excel feature. We even provide a sample ledger for you to download as an example.My previous article, "See how our sample spreadsheet uses absolute cell...
- Technical articles 2001-04-25
- How do you parse huge multicolumn excel sheet into VB & refer to each cell?
- I am trying to parse a huge excel spread sheet into my VB code for a GUI and refer to its elements cells for carrying out the computations. Can anybody suggets an easy and fast way to do it?Below is what I have developed till now:Public Class Form1 ...
- Discussion threads 2008-06-05
- Pull data into Microsoft Excel with Web queries
- An Excel Web query allows you to bring data from a Web siteinto an Excel worksheet. It will find any tables on the Web page and let youselect the ones containing data you want to put into your worksheet, allowingfor dynamic updates from the Web page. Web queries are not...
- Technical articles 2006-09-14
- Ensure accurate data entry in Excel by using Data Validation to create drop-down lists
- You don't have to know how to program in Visual Basic to create drop-down lists and validate entries in an Excel spreadsheet. The Data Validation feature makes it easy to eliminate data entry errors.You could write a book about all the ways you can use Excel’s Data Validation feature. Like...
- Technical articles 2000-04-27
- Teach users to liven up Microsoft Word documents with Excel
- Are your users looking for a quick and easy way to breathe life into their boring Word documents? If so, check out these tips and teach your users how to liven up their Word documents with Excel.Most of us are always looking for new ways to improve our ordinary Word...
- Technical articles 2000-11-29
- Choose the right spreadsheet: Excel XP, Quattro Pro 9, or Calc 6
- Behind word processors, spreadsheet programs are probably the most used office suite component. This article compares Excel XP, Quattro Pro 9, and StarOffice Calc 6. Find out which is right for your organization.In my previous article, "Choose the right word processor: WordPerfect, StarOffice Writer, or Word XP", I compared the...
- Technical articles 2002-03-06
- Poewr Point to Excel for Chart
- Dear Sir, I make my graph i.e, pie, on excel. After finishing this graph, I take it to Powerpoint format. Now take suppose it that due to some error, I want to transfer this power point chart to exel, so that I can edit it as original on excel or...
- Q&A 2005-02-20
- 10 obscure Excel tricks that can expedite common chores
- This article is also available as a PDF download.Over the years, each new version of Excel has introducedsome nifty features. However, buried within Excel are lots of cool featuresthat too few users have discovered. If you or your users perform certaintasks every time you use Excel, you'll want to make...
- Technical articles 2007-01-05
- How do I... Calculate a conditional running total in Excel?
- Adding a column vs More complicated formulaWithout adding the extra column with the concatenation, the more complex formula =if(and(month(A3)=month(A2),year(A3)=year(A2)),D2+C3,C3) will do the trick.This however underlines the constant balancing between comlexity and readability on the one hand vs extra columnsDeonAnother way to do itwould be to hide the extra columns or...
- Discussion threads 2008-01-10
- Create a summary report in Excel with data consolidation
- Creating report of changes with Consolidate commandCreating report of changes Recently, a sole proprietor of a small drugstore called to ask the following Excel question: How can I create report of monthly changes between two Excel inventory tables taken at the end dates of two succeeding months. The problem was...
- Discussion threads 2005-05-19
- << Previous
- page 1 of 1
- Next >>


