Learn Excel

Jun11

Tagged in:, , Comments: YourThoughts?

Freeze Panes - Make Top Row In Excel Stay On Top

windowlist

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

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

Apr04

Tagged in:, Comments: YourThoughts?

Getting Started With Excel Part 3

windows users

Continuing with the previous Excel beginner tutorials series, this video builds on your new knowledge. You will be introduced to mathematical calculations, and operators. Shortcuts and tips and tricks will be demonstrated too.

How to make calculations with mouse clicks, selections and using the Excel Autosum feature.

Demonstration of using Excel to: Total, Average, Max, Min and Count.

Easy to follow and helpful video tutorial for beginners. Or, seasoned pros who need a...

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