Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Excel Tricks: Easy Data Fill

December 23, 2015 by Tyrone Pernsley

Excel is great for summarizing your data. You can create tables, charts, PivotTables, and more. The following tips are provided to give you the power to do easy data summary in Excel.

Special Paste

The Special Paste feature can be used to copy and paste both static and linked data. To use it, first copy the data that you want to paste by highlighting it and either right clicking and selecting copy or pressing “Ctrl” + “C.” Click on the first cell where you want your data to be pasted, right-click, and select “Paste Special.” From there, a dialog box will appear and you can choose how you want the data to be pasted. You can choose to paste everything, only the formulas, only the values, only formats and more. If you want to apply a mathematical operation to your data, you can select which operation you want to apply. You can also choose to not copy blank cells by checking the “Skip blanks” box. To have your columns be pasted as rows or to have your rows pasted as columns, check the “Transpose” box.

Easy Data Summary image 1.jpg

Auto Fill

Instead of entering in all of your data manually, you can use the Auto Fill feature to automatically fill the cells with the data that you want based on a pattern or based on the data that you’ve already entered. To copy a repeated value, click on the cell that you want to copy and in the bottom right corner, your cursor will turn into a little black plus sign, and then you can drag your value down or across. You can also copy a pattern like numbering 1-20, months, or number patterns (like even or odd numbers). To number your row or column from 1 to another value, type 1 and 2 into the first two cells, then highlight the two cells and when the black plus sign appears, drag the numbers to the value that you want. To copy a series of months, type two consecutive months in the first two cells, and then drag the column or row to show the values that you want. To create a pattern, type the first two or three numbers in that pattern’s series, highlight the cells, and when the black plus sign appears drag until you have your desired values.

Easy Data Summary image 2.jpg

Case Change

If you have a messy or inconsistent data table, you can clean it up by making the text more uniform by using the case change feature. Enter the formula that you want to use (Upper, Lower, or Proper) and select which cell you want to change.

Upper, Lower, & Proper Formulas:

Easy Data Summary image 3

We here at Learn Excel Now hope you now feel confident in your ability to do easy data summary in Excel Dashboards. It is our desire to bring you the best advice possible to effectively and efficiently use your desktop features so you can focus on your work. Liked these Excel Database tips? Have questions? Leave your comments below; we’d love to hear from you.

Getting Social with Excel: Spread the word and share the knowledge!

Kevin – Learn Excel Now

 

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In