Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Excel Analytics: Creating Tables for Your data

February 3, 2016 by Tyrone Pernsley

There are a variety of ways to sort and organize your data in Excel. These features allow you to quickly process data to get essential analytics, statistics, trends and other information to inform decision-making. One feature is using Excel tables. Excel Tables are great way to quickly and easily organize and display your data. The following quick guide will provide you with tips, so you can start creating Tables for your data.

Creating a Table

To create a table, first highlight the data that you want included, then go to the “Insert” tab on the top toolbar and select “Table.”

Creating Tables Image 2

Your table will be created, and you will automatically be in the “Design” tab.

Creating Tables Image 3

Now, you can choose how you want your table to look by choosing from the different table styles. You can choose from a variety of different colors and then you can choose color density from light to dark. There is also a quick shortcut that you can use to insert a table. To use this, highlight your data, and then click “Ctrl” + “L.” Your table will be created automatically and then you can design it.

Filtering and Sorting the Data in Your Table

Creating tables image 4Once you have created your table, each column heading will have a drop-down box that automatically appears in the column heading in the top row. The down arrow key allows you to open the drop-down menu.

You have different options to sort the data in the drop-down box. From there, you can sort the data alphabetically, by highest or lowest value or by color.

Excel Analysis Creating Tables for Your Data Filter

To filter your data, you can customize number or text filters by specifying the values that you want hidden or shown. You can also exclude values that you don’t want show by unchecking the check box next to the value(s) that you want hidden.

Excel Analytics- Simple Tables image 5.jpg

Making Calculations in Your Table

You can use calculations to find the totals, averages, and various other calculations for columns or rows. To do this, you have two options. First option: you can click on the cell at end of the column or row and click on the “AutoSum” button.

Creating Tables for you data gif 2

The other option is to select the cell at the end of the column or row, then go to the “Formulas” tab and select the formula that you want to use. When the formula is added to the table, a drop-down arrow is automatically inserted to the right of the value. From the drop-down options, you can choose different formulas to perform other calculations on that row or column.

Creating Tables for you data gif 3

We here at Learn Excel Now hope you now feel confident in creating tables for your data in Excel. 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. Subscribe to our blog to receive weekly Excel tips. If you’re looking for more in-depth training check out our upcoming instructor-led, live online training.

Liked this Excel Tables quick guide? 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