Posts Tagged ‘Top Excel Power Shortcut’

Top Excel Power Shortcut #5: Instant display of all worksheet formulas

Published by | Monday, August 16th, 2010

Excel 2010 Power Shortcuts with Dennis Taylor is now live in the Online Training Library®, so be sure to check it out. Here’s shortcut number five, Instant display of all worksheet formulas:

Did you miss the first four top shortcuts?

Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells
Top Excel Power Shortcut #2: Converting formulas to values
Top Excel Power Shortcut #3: Copying formulas or data in a column
Top Excel Power Shortcut #4: Adjust column widths or row heights

and see all of the Power Shortcuts in the course.

Top Excel Power Shortcut #4: Adjust column widths or row heights

Published by | Thursday, August 12th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s shortcut number four:

Have an Excel spreadsheet that has columns or rows that are sized incorrectly, making the data difficult or impossible to read? This time-saving shortcut shows how you can adjust column widths or row heights in a flash.

Did you miss the first three top shortcuts?

Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells
Top Excel Power Shortcut #2: Converting formulas to values
Top Excel Power Shortcut #3: Copying formulas or data in a column

Top Excel Power Shortcut #3: Copying formulas or data in a column

Published by | Wednesday, August 11th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the third shortcut:


In Excel, if you want to copy a formula or data down a column, you don’t need to copy and paste or even drag—a difficult task if you have thousands of rows of data. This time-saving shortcut shows how you can copy text or a formula down a column in an instant. If you’re already familiar with this shortcut, this video shows how it is improved in Excel 2010.

Did you miss the first two top shortcuts? Watch Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells and Top Excel Power Shortcut #2: Converting formulas to values.

Top Excel Power Shortcut #2: Converting formulas to values

Published by | Monday, August 9th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the second:


If you want to convert formulas to values in Excel, you don’t need to use a multi-step copy and paste process. This time-saving shortcut shows how you can convert formulas with a simple drag.

Did you miss the first top shortcut? Watch Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells.

Top Excel Power Shortcut #1: Entering the same data into nonadjacent cells

Published by | Thursday, August 5th, 2010

We’re very excited about our upcoming course, Excel 2010 Power Shortcuts with Dennis Taylor, that’s due to be released soon—so excited that we’ve decided to give you a sneak peek at some of his top power shortcuts. Here’s the first:

In Excel, if you have to enter the same data into multiple cells, you don’t need to retype it or even copy and paste. This time-saving shortcut shows how you can enter text or formulas into multiple, nonadjacent cells simultaneously.