What Is VoIP Anyway?

If you have been in business for very long at all, you've probably heard rumblings from people about a new phone technology that uses the internet instead of a traditional phone line. This blog post should help you to understand some basics about VoIP. 

Back to posts

5 Ways to Best Utilize Microsoft Excel

5-ways-to-best-utilize-excel

 As you most likely know, Microsoft Excel can be a very useful program for businesses when it comes to organizing data. Odds are, you have a basic grasp of the software's basic functions. However, the following are 5 Ways to Best Utilize Microsoft Excel:

 

1. Adding Rows and Columns

As you're adding data to your spreadsheet, there's a good chance that you'll need to add new rows and columns. While it's not difficult to figure out how to add one row or column at a time, going about it this way can get tedious, especially if you need to add dozens or even hundreds of additional rows.

Fortunately, there's an easier way to add multiple rows and columns. Simply highlight the corresponding number of rows and columns that you want to add from the existing rows and columns on your spreadsheet. Then right-click and choose Insert. That number of rows and columns will then be added to your spreadsheet.

 

Related Post: Tips and Tricks - Microsoft Word

 

2. Using Filters

If you have a large data set in front of you, trying to look at a specific piece of data can be a bit challenging since you're confronted with all of the data in your spreadsheet. The use of filters allows you to only look at specific rows of data at a single time, making it easier to inspect the data you need to look at. To do this, you'll need to add filters to each column in your data.

Begin by clicking on the Data tab and choosing Filter. Then click the arrow next to the column headers. By doing this, you'll not only be able to decide whether you want your data to be sorted in descending or ascending order, but you'll be able to select what specific rows you want to show.

 

3. Removing Duplicates

Larger data sets often contain duplicate content. Finding and deleting duplicate content on your own is way too challenging and time-consuming if you're faced with a large data set. Instead, simply highlight the row or column from which you want duplicate data to be deleted. Go to the Data tab and choose Remove Duplicates under the Tools menu. A pop-up will show up to confirm the data you've chosen. Then simply select Remove Duplicates.

 

4. Turning Columns into Rows

If you decide to reformat your spreadsheet by turning columns into rows or vice versa, you can use the Transpose feature to make quick work of it. Highlight the column that you want to turn into rows and right-click it. Choose Copy and then select the cells where you want your first row to begin. Right-click and choose Paste Special. A module will appear from which you can select the Transpose feature. Your column will then be turned into a row.

 

5. Splitting One Cell Into Two

If you have information in one cell that you want to divide into two cells (such as, for example, splitting someone's name into a first name cell and a last name cell), you can do so by highlighting the column you want to split and choosing Text to Columns under the Data tab. Choose either the Delimited (breaking up text based on commas, tabs or spaces) or Fixed Width (breaking up text based on the exact location you choose) options, view the preview and then hit Next to execute the split.

 

New Call-to-action

 

These are five ways that you can get better use out of Microsoft Excel. For more tips and tricks on how to use your business software, be sure to visit us at EnvisionIT Solutions today.

- Ads by Google -


Kevin Gray
ABOUT THE AUTHOR | Kevin Gray
Hello! I am the Vice President @ EnvisionIT Solutions. | Technology Expert | Author | Speaker | Small & Medium Business IT Support - We founded EnvisionIT Solutions in 2007 to provide IT services and support for business owners/CEOs who value the necessity of technology to drive their success and growth.

Find me on:


21-questions

21 Questions To Ask Before Hiring An Honest, Competent, Responsive, Fairly-Priced Computer Consultant

Don’t trust your company’s critical data and operations to just anyone! This business advisory guide will arm you with 21 Revealing Questions you should ask any computer consultant before giving them access to your network.

21 Questions

Recent Posts

What Is VoIP Anyway?

If you have been in business for very long at all, you've probably heard rumblings from people about a new phone technology that uses the internet ins...

Read more

What is VOIP and Why Should I Switch?

Long gone are the days where business owners are required to pay by the minute for long distance phone calls. Today, Voice over Internet Protocol (VoI...

Read more

5 Mobile App Development Tips For Small Businesses

Mobile apps have become one of the most utilized technologies on the planet with the rise of smartphones. 89% of mobile phone users are using mobile a...

Read more

Traditional Marketing vs Content Marketing

 Businesses that have been using mostly traditional marketing methods may not quite see the difference between traditional marketing and content marke...

Read more