This special edition of the Help Desk Advisor has something for everyone who wants to know more about Excel, Microsoft’s popular spreadsheet program. I’ve selected six Excel articles based on their high number of responses from TechRepublic members. Click through the links below and see what you might be missing in Excel.
For subscribers only
Subscribe to Jeff Davis’ Help Desk TechMail and get a bonus of Jeff’s picks for the best resources on the Web.
The spreadsheet’s the thing
If you’re like me, you probably use Excel in your work almost as often as you use e-mail. I hope you can use at least one of these lessons to save time when you’re building or maintaining a spreadsheet solution.
- “The fastest way to parse text in Excel”
Find out why the Text to Columns feature can save you billions and billions of keystrokes.
- “Two tips for filling in holes in your Excel data”
This article explains why the Go To feature isn’t just for cell references and range names.
- “Two tips for translating codes into meaningful terms in Excel”
You figured out the Sum function, didn’t you? Knuckle down and figure out how to use Vlookup as well. This article will help.
- “A quick lesson in nested IF tests”
This is Spreadsheets 101-level material. If you’ve been putting off learning about functions, it’s time to belly up to the formula bar.
- “Designing a foolproof data entry form in Excel”
Here’s an eight-step lesson illustrating one way to create a foolproof (or nearly foolproof) data entry form.
- “Power-formatting Excel spreadsheets”
Display the Standard toolbar, find the icon that looks like a paintbrush, and learn how to use it. Any questions?
Marks of Excel-lence