Using Microsoft Excel

Jul10

Tagged in:, Comments:2 comments

How To Use An Excel Workbook Basics

txt

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...

Share

Apr12

Tagged in:, , Comments: YourThoughts?

Use The Dollar Sign To Assign Absolute Reference

dollar-in-lightbulb

Don't want Excel to adjust references when you copy a formula to a different cell? Use an absolute reference. Absolute reference in Excel is handy when you want to re-use a formula across a spreadsheet and need it's calculation to stay fixed in a constant fashion.

Perhaps you need to build a multiplication table that will multiply row 1 times it's counterpart in column A. If you copy your formula to the other cells in your table, the formula will move "relative" to the cell. We get...

Share

« Back To Tags Index

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.

About