• What We Do
    • Services Overview
    • Application Development
      • Development Services Overview
      • Enterprise Custom Software
      • Mobile Application Development
      • Websites and Apps
      • System Software Integration
    • Digital Marketing
    • Cloud Infrastructure
      • Cloud Services Overview
      • Infrastructure Optimization
    • Managed IT Services
      • Managed IT Services Overview
      • Office 365 Migration
  • Success Stories
    • Project Successes
    • Case Studies
  • Thought Leadership
    • Our Content
    • Blog
      • Blog Feed
      • Authors
    • Videos
      • Video Feed
    • Radio
    • News
    • Events
  • Company
    • Company Overview
    • About Us
      • History and Culture
      • Awards & Accolades
      • Wizard Mission & Values
    • Our Partners
    • Meet The Team
    • Become a Wizard
      • Work Here
      • Career Opportunities
  • Get In Touch
    • Contact Us
    • Our Locations
      • Offices
      • Fort Walton Beach, Florida
      • Atlanta, Georgia
      • Memphis, Tennessee
      • Austin, Texas
      • Jacksonville, Florida
    • Subscribe
Search Bit-Wizards
Blog / Five Microsoft Excel Tips that Will Change Your Life
 

Five Microsoft Excel Tips that Will Change Your Life

I have five tips to share, and I use them almost every day to make processing data a little bit easier.
Samuel O. Blowes 4/11/2018 Jump to Comments
There is so much data to process these days, and one of the best productivity tools for that is Microsoft Excel. So in this month's installment of MITS Tips, I am sharing five Excel tips that will change your life, and I use them almost every day to make processing data a little bit easier. If you want to follow along using Excel, download my demo Excel Spreadsheet and follow the steps as I do them in the video!
 

Tip 1 – Quickly Format Data Into a Table

The first trick that I want to show you is how to turn your bulk data into a nice-looking (and useful) table. This tip will make it much easier to work with your data and to drill down into it to see specific kinds of information.

First click anywhere inside your data, and then find the icon labeled Format as Table.
format data as a table
Next, choose the color scheme you want to use for your table. I'm going to use a light blue color scheme. Then you will need to determine whether you have headers on your table. Choose Yes if you do, so that your table will format correctly.
 
Then, click OK, and then your data has a nice color scheme. Luckily, there's more to it than just the color scheme!
format data as a table step 2
 

Tip 2 - Quickly Size Columns

To begin, click in the top left corner to select all the cells in the worksheet, and then double-click between any two columns to expand all of the data so that it fits a bit better.
auto size columns
 

Tip 3 - Quickly Filter Data

The advantage of putting your data in a table is that you can drill down into the data to see specific information that you need. For example, you can click on the drop-down filter arrows in the header row Payment Type and select a type of payment to display (I chose Visa), and you will then only see that payment type in your column.
filtering your data
You can do that same for the Country Column, and now you will see just the Australia Visa payment information.
 
You can quickly clear any of these filters as well by clicking Clear, in the filter drop down in the header row, and all your data is visible again.
 

Tip 4 - Quickly Move Columns and Rows

I always see people using the cut/paste feature to move columns or rows of data around—and you don't have to do it that way! It's quite simple to move columns and move rows of data around without having to use cut/paste.
 
First, select the Price Column and hover your mouse over the edge of the column while also holding down Shift on the keyboard then click and drag the row to the new location.
 
And as you can see, I move the price column over to the end of the address section.
moving columns quickly
You can do this with rows as well using the same method.
moving rows quickly
 

Tip 5 - Quickly Split Data into Two Columns

I use this last tip quite often. Sometimes you will have a column with multiple types of data inside such as a first name and a last name, or maybe it has the state and the zip code, and you need to split that data into two separate columns.
 
First, take the last column, which for our example is Longitude. We want to split this because this is set to a whole number and a decimal place after. So, we are going to split it at the decimal point into two own columns.
 
Click at the top of your screen in the ribbon on Data and then choose Text to Data.
separating data into two columns
Under delimiters, select the Other option, and since we are using the decimal point (or period) as our delimiter type a "." into the associated box.
separating data into two columns step 2
Then choose Next, and you will see how the data will break before confirming you want to do it. If it all looks good, as ours does, then click Finish. For our example, we now have the longitudinal minutes, and the fractional part of it as well in its own column.
separating data into two columns step 3
Almost everyone uses Excel to manipulate different types of data, and some people are great at it, but I think we can all get a little bit better by using some simple tricks like these. Also, if you use Microsoft Outlook, these three tips will save you a ton of time!

If you need more help using Excel or other Microsoft Office products, get in touch with us!
Share This!
Previous Post
Three Outlook Tips to Make Your Life Better
Next Post
SharePoint Tips You Never Knew You Would Need

Comments

 
comments powered by Disqus

Author

Samuel O. Blowes, Director of IT
Samuel O. Blowes

Director of IT

Read more by Sam

Related Blogs

  • Three Outlook Tips to Make Your Life Better

    In this blog, we will show you three Outlook tips that will make your entire life better!

    Read More
  • sharepoint sync client
    The New (Long-Awaited) SharePoint Sync Client

    Microsoft has added SharePoint Online synchronization to the OneDrive sync tool.

    Read More
  • 10 Security Questions from Small Business Owners

    We have created a quick list of some of the most frequently asked IT security questions from small and medium size business owners.

    Read More

Twitter

  • Sending birthday wishes to our chicken wing-loving OG wizard, JJ! 🍺 #wizardlife https://t.co/0aM6yQPwKY

  • No self-help books needed if you help us give the @ArcEmeraldCoast clients a magical Christmas! Visit our Go Fund M… https://t.co/ZdCXQ7PDn1

Follow Us

Contact Us
Our Locations

About us

Founded in 2000 by Vince Mayfield and Louis Erickson, Bit-Wizards is the result of a vision to create a company where innovation and creativity flourish. We adhere to proven engineering methods, which has helped us become a leading software development, digital marketing, and cloud information technology agency in the Southeastern United States. Visit our main office in sunny, Fort Walton Beach, Florida!
Copyright by Bit-Wizards
  • Privacy Policy
  • What We Do
    • Services Overview
    • Application Development
      • Development Services Overview
      • Enterprise Custom Software
      • Mobile Application Development
      • Websites and Apps
      • System Software Integration
    • Digital Marketing
    • Cloud Infrastructure
      • Cloud Services Overview
      • Infrastructure Optimization
    • Managed IT Services
      • Managed IT Services Overview
      • Office 365 Migration
  • Success Stories
    • Project Successes
    • Case Studies
    • Thought Leadership
      • Our Content
      • Blog
        • Blog Feed
        • Authors
      • Videos
        • Video Feed
      • Radio
      • News
      • Events
    • Company
      • Company Overview
      • About Us
        • History and Culture
        • Awards & Accolades
        • Wizard Mission & Values
      • Our Partners
      • Meet The Team
      • Become a Wizard
        • Work Here
        • Career Opportunities
    • Get In Touch
      • Contact Us
      • Our Locations
        • Offices
      • Subscribe