1 / 11

Excel’s Top 10 Tips

Excel’s Top 10 Tips . Stormy Stark. #1 Linking. Starts with an equals sign (a link is a formula!) Dynamically joins data Automatically updates Much safer then copying and pasting. #2 Text To Columns. Lots of text in one cell Highlight the column Use the Text to Column button

donny
Télécharger la présentation

Excel’s Top 10 Tips

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel’s Top 10 Tips Stormy Stark

  2. #1 Linking • Starts with an equals sign (a link is a formula!) • Dynamically joins data • Automatically updates • Much safer then copying and pasting

  3. #2 Text To Columns • Lots of text in one cell • Highlight the column • Use the Text to Column button • Data Ribbon • Select the proper delimiter

  4. # 3 The Fill Handle • Little Black Box • Left click and drag down • Establish the pattern! • Double clicking can save lots of time

  5. # 4 Deleting Duplicates • Highlight your list • Select delete duplicates • Data Ribbon • Select the correct column • Excel leaves the 1st instance and deletes the rest

  6. #5 Hiding & Unhiding Cells • Select the rows or columns • Right click • Choose Hide Cells • Remember what is hidden can be unhidden!!!

  7. #6 Filtering • Fast way to visualize data • Data Ribbon • Drop down arrows appear (but do NOT print) • Can filter on multiple criteria

  8. #7 Subtotals • Fastest way to get counts and sums • Data Tab • ALWAYS sort your list first! • Pay careful attention to column selection • Choose function • Summary Below Data

  9. #8 Visible Cells Only • Add to Quick Access Bar • Used with subtotals and filtering • Copies ONLY the visible cells • NOT those hidden depending on group level

  10. #9 Conditional Formatting • Apply specific formatting to certain cells • Determine your criteria • Determine your formatting • Can sort based on formatting

  11. #10 Moving Windows • View Ribbon • Open new windows • Arrange as desired • REMEMBER to SAVE EACH WINDOW!!!!

More Related