Business Management Daily

Driven to help organizations and individuals succeed.

Have you discovered all the shortcuts buried within Excel?

Try zipping around Excel spreadsheets using these keyboard techniques:

• “Home” changes the “active cell” to the cell in column A of the current row.
• “Ctrl”+“Home” makes cell A1 the active cell.

Register now for the Microsoft Excel Training Series

• “Ctrl”+“End” changes the active cell to the cell farthest down and to the right of all the cells.
• The right, left, up and down arrow keys advance your work sheet and your active cell one cell at a time.
• “Page Up” and “Page Down” advance the work sheet and the active cell up and down, respectively, one screen at a time.
• “Alt”+“Page Up” and “Alt”+ “Page Down” advance the work sheet and the active cell left and right, respectively, one screen at a time.

During this two-part webinar on Microsoft Excel training you'll be able to field questions directly to our Excel training expert. Register now to have all your Microsoft Excel questions answered and receive a complimentary registration bonus — 59 Technology Tips for the Administrative Professional

• “Ctrl”+“Page Up” and “Ctrl”+ “Page Down” change the view to the next sheet and previous sheet, respectively.
• “Ctrl”+arrow key (or “End” key followed by an arrow key) moves the cellpointer in the direction of the arrow pressed. The cellpointer goes to the first occupied cell if you start from a blank cell, or it goes to the last occupied cell if you start in an area where the cells are occupied.

During this two-part webinar training event, you'll learn the tricks the pros use to optimize their time and their workbooks:

Webinar #1: How to Excel at Excel
Tuesday, Oct. 13, 1 to 2:15 p.m. ET

• Keyboard Shortcuts: Getting Fast and Accurate with Excel
• Wrangling Worksheets Without Frustration
• Type Less and Get More Done with AutoFill, AutoCorrect and Custom Lists
• Repeat Success Using Templates Solving Problems with Formulas

Webinar #2: Excel Master Class
Friday, Oct. 16, 1 to 2:15 p.m. ET

Become a Microsoft Excel pro! Learn the four power tools you can put to work the minute the webinar is over.

Make your data nightmares and keystroke intensive tasks just a memory:

1. Drill down to the data you need using filter & form
2. Importing data into Excel: garbage in … gold out
3. Macros: Do the hard work one time
4. LookUp: The secret of the Excel guru
5. PLUS other Excel “power tools"

Register now for this interactive event!

—Adapted from "Excel Tip: Moving Around the Worksheet," www.accountingweb.com.