How To Use Excel

The history of how the term "workbook" came to be used by Microsoft for the Excel program is interesting, even nostalgic for us old-timers, but what is a workbook and how to use an Excel workbook is what you're here to find out.

A workbook is the concept that Microsoft chose to illustrate the working theory when using Excel and is merely what Microsoft calls it's Excel files or documents. Excel files are computer files that end in the .xls (pre Excel 2007) and .xlsx (Excel 2007 and...

A Microsoft Excel workbook is the name given to, what was originally named, a spreadsheet. A workbook is the file you open in Excel. Back in the days of MS-DOS and before Excel you just opened a file (of whatever flavor spreadsheet program) and called it a "spreadsheet".

A workbook is essentially what had been traditionally termed a "spreadsheet" by programs like the ones run on IBM mainframe computers and, more recently (and, by "recently", I mean late 80's), VisiCalc on the Apple II...

Ever have a spreadsheet open in Excel that has a large number of rows and you scroll down to enter data in a cell, but lose track of which cell your information goes into?

There's a better way than scrolling to the top and memorizing the column heading and scrolling back to the cell at the bottom of your worksheet. That's a pain and a waste of your time.

You need to freeze panes. Make that top title row stay on top while you scroll down. If your title row (or header row) would...

Henry Gantt is responsible for the "gantt chart" so popular today. He created many different charts designed basically so anyone interested in project management could see where a project had been, where it should be when completed, and it's current status.

Gantt charts are very flexible and you can track tasks whether performed by machine or men or a combination of both.

This video explains the process of making a gantt chart in an Excel worksheet. A couple of helpful hints on...

Ever get in a situation where you need to add a sequential column or row in Excel? I know I have. I'm not the sharpest knife in the drawer at times and that leads me to not plan out my data the way I should.

Thank the engineers at Microsoft for the quick fix (and a little trick with Excel)!

Let me show you how to add a column and add the numbers in sequence.

First, let's add a column. Click on the column letter you want to insert your column before, then right click and...