Excel Quick Tips

Vair Training Presents: 5 Excel Steps for Easier Modeling - A Free Webinar

Webinar Course Objectives:

• No drop in curser after pressing the Enter key

• Using the Accounting format for financial models

• Hiding Columns for quick modeling and reducing size

• Splitting the Screen for simpler coding with larger models

• Freezing the Panes for better presentation

1.No Dropping the Curser after pressing Enter

Financial modeling ≠ data entry
More key strokes = more coding mistakes:
2003 Excel Alt + Tools Options

2007 Excel Alt + File- Options Advanced

2010 Excel Alt + File-Options Advanced

2. Using the Accounting format for financial models

Accounting format help identify Material numbers when using units

Rounding errors

3. Hiding Columns for quick modeling & reducing size

2003 Excel had 256 columns

2010 Excel has 16,384 columns

This is a great advantage for large models, but causes unwieldy model sizes if not managed properly.

Ctrl + Space Bar Tab Highlights Columns (Shift + SBT: Rows)

Shift + Ctrl + Right Curser Highlights All Columns to Page’s End

Ctrl + 0 (Zero)

To Unhide Columns

–  Ctrl + A

–  Alt + Home

–  Format

–  Hide & Unhide

–  Unhide Columns

Hides Columns (Ctrl + 9: Hides Rows) Highlights Entire Worksheet

4. Splitting the Screen with large worksheets

Big Worksheets can be hard to manage

Where you place the curser, the split occurs on the Northwest Corner of the cell

If you want to spilt the sheet horizontally, make sure to place curser in Column A

If you want to spilt the sheet vertically, make sure to place curser in Row 1

Place curser in desired cell
Alt + View
Split
F6 allows for navigation between the two splits

5. Freezing the Panes for better presentation • Big worksheets can be difficult to view

– Allows viewing of either columns or rows or both as desired

Extra step from Excel 2003 to Excel 2007/10 (but welcomed)

Place curser in desired cell

Alt + View

Freeze (2003 stops here)

Freeze Panes (allows for additional functionality a la Split issues)

*Make sure you can see Cell A1

Additional Excel Hint: Highlight a desired section(s) and F11 will give you a quick bar graph.