ArrayFormulas
ConditionalFormat
Data Filters
ExcelShortcuts
Easter Eggs
FormatCells
NamedRanges
PasteSpecial
Personal.xls
Page Breaks
Car Loans
IF Statement
Intro to IFs
IFs Pt. II
Subtotals
Vlookup

If you do not have Excel, the interactive spreadsheets will not work on your machine.  You can download Microsoft's FREE EXCEL VIEWER here.

How's your bandwidth?  Got a pretty quick Internet connection?  If so, you can go here and see and hear my free online video presentation on Excel formatting problems and more.

Click here to learn about array formulas in Excel

Using Data Filters in Excel

NEW ARTICLE I WROTE FOR TECHTRAX:  What's So Special about "Paste Special"?  Lots of Excel tips here!

Did you lose the password to your password protected spreadsheet?  Here's a handy little add-in that just might recover it for you!

Want to add the path, filename, and sheet name to any cell in a workbook?  Simply click in that cell and type  =cell("filename")  and there you go.  (Yes, type "filename" with the quotes....NOT the actual file name.)

We all know how to hide entire rows or columns, but if you want to hide the data in just one cell, there are two ways to do this.  One is to format the color of the font to be the same as the background color of the cell.  Or, another way is to select the cell, then go to the Format menu and choose Cells.  In this box, select the Number tab and select "Custom" as your format.  In the box at the right, type ;;;  .......this will hide the contents of the cell.  Unfortunately, both of these options will still show the contents in the Formula Bar at the top, but they won't show if you print the worksheet.

Want to learn how to set macros to work in all Workbooks instead of just the one you create them in?  Click here.

I'm not really into writing macros and VBA, but here's a simple one that you can try to get your feet wet.  If you like it, then hop on over to my ABC Newsletter  and search the archives for tutorials written by Chad Welch.  

Excel has limits on the number of arguments a function can handle. Although this limit is 30 and is usually adequate, there's an easy solution if you need more. Instead of listing all the arguments separately, group them if possible in parentheses. Excel will count each group as a single argument. For instance, a simple sum function

Sum(A1,B3,C5,D8,E12,F19...)

could quickly run up the count and reach 30 before you know it. When this is a possibility, try grouping the arguments as follows:

Sum((A1,B3,C5),(D8,E12,F19)...)

• Are your spreadsheets dull and boring?

• Would you like to be able to quickly see which data falls within specific parameters?

• Do you want your spreadsheet to warn you when certain dates, numbers or text are noted in your spreadsheet?

• Are you constantly sorting and re-sorting data to find items that are similar or meet certain criteria?

• Why not try Conditional Formatting?

A variety of great Excel add-ins are available at AbleBits.  Check 'em out, especially Pivot Table AutoFormat XL.

Excel 2000 keyboard shortcuts