30 Excel Tips to Save Time

30 Excel Tips to Save Time

Even if you use Excel every day, take a minute to review these 30 time-saving tips.

• Drag and Drop in Excel
  Move information around the worksheet without cutting and copying
  
• Save Versus Save As
  This head-scratcher explained
• Freezing Panes
  No more scrolling left and right and up and down to see the row and column headings
• Sorting Records
  The easy way
• Working in the Group Edit
  No more editing 12 sheets individually because there was a change
• Comparing Worksheets in an Excel Workbook
  Can't see two sheets in the same workbook at the same time...yes you can
• Scrolling wheel – scrolling left and right and then some!
  Put your scrolling wheel on steroids
• Wrapping Text
  Let Excel wrap text in the cells for you
• Indenting Text
  No more inserting spaces to get your categories and sub-categories indented
• Creating Charts
  The one keystroke method
• Navigating In a Document
  Home, End, and then some
• AutoFit Column Width and Height
  No more wondering if the column width is correct
• Excel Lists
  A feature that was added recently to help you create lists. It facilitates in sorting, filtering and sub-totaling
• Conditional Formatting
  Automatically format cells based on the contents
• Format Painter
  Makes formatting cells a breeze
• Accessing Templates
  Why start with a blank document when you can use a fully developed one!
• Data Validation
  Limit the type of entries that can be inserted in a cell
• Showing/Hiding Formulas
  Helps you troubleshoot your worksheets
• Formula Auditing – Tracing Dependents and Precedents
  A brilliant feature that helps you trace the flow of your formulas
• Defining Names
  Used with absolute references and to help simplify your worksheets
• Worksheets Printing Options
  Print headings on multiple pages and other helpful tips
• Scenario Manager
  This will allow you to have multiple scenarios built into the worksheet
• Filtering
  Show only the records that meet certain criteria, I use this one all the time
• Concatenating Cells
  Joining the entries in cells together. Useful for databases
• Finding Duplicate Records
  You've just combined records and need to find the duplicates
• Push Pinning Documents
  Helps you open frequently used files and network locations
• Pivot Tables - includes a video clip showing how it's done
  Spin that data around to analyze it quickly
• Customizing the Quick Access Toolbar
  Make that Quick Access Toolbar work for you, add frequently used options
• Easy Formatting Tips
  A little of this and a little of that to help make formatting easier
• Excel's Amazing Date Functions
  Parse a date into into more usable segments using functions 

Happy Computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via the email link on the right side of the screen so you get email alerts when Diane adds a new post.