• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Be honest with yourself: Do you have a love/hate relationship with Excel?

Excel can make your job easier – if you know how to use it right. If you don't, you could be wasting more time than you're saving.

Here are three time-savers to help you navigate Excel and maximize your spreadsheets:

1. Create a quick-and-dirty Excel chart in one keystroke

First, select any cells within the data table you want to chart. Then press the F11 key. Excel creates a Column chart in a new work sheet. You can take the chart as is, or alter it as you would any other chart.

2. Improve your Excel printouts

Separate groups of data with page breaks, so they print on separate pages.

Here’s how: Open your workbook. Choose “View > Page Break Preview” from the menu bar. Then, select a cell (or an entire row or column) below the line where you wish to insert a horizontal break, or to the right of a line where you wish to insert a vertical break. Right-click on the selection and choose “Insert Page Break” from the shortcut menu.

3. Use Google Spreadsheets to share existing Excel files

Google Spreadsheets is Web-based software that allows you to create new spreadsheets online, or to import and share existing Microsoft Excel files. Using the Google software, you can create multiple sheets in a workbook, sort, format and create formulas.

But the real plus is being able to share data with multiple users online, so they can edit simultaneously or have an on-screen chat about what they’re viewing. And that means a lot fewer e-mails flying back and forth.

{ 1 comment… read it below or add one }

john1martin August 29, 2012 at 5:02 pm

Learn vlookup, excel hlookup, sumif , vba etc.We are excel consultant and access programmer with expertise in advanced Excel formulas, modeling, macros, and VBA.


Leave a Comment