A person is using a laptop and editing something to a excel file and beside the laptop is a cup of coffee and a sunglasses

How to Print Labels from Excel: Ultimate Guide

There are times where you will want to print from any number of applications on your computer. This includes Microsoft Excel. The software allows you to not only create spreadsheets but also labels. If you have several labels you need to produce, whether for mailing or for personal identification, you will want to generate the …

Read more

How to Delete Duplicates in Excel

How to Delete Duplicates in Excel: An Easy Guide

A Microsoft Excel spreadsheet’s primary function is organizing any data set into manageable rows and columns that can be easily viewed, searched, and arranged. Here, we will show you how to delete duplicates in Excel easily. Because of the way Excel organizes this data, it should be easy to manipulate, whether this means changing your …

Read more

Excel SUM Formula: What Is It And When Do I Use It?

If you have a large database of information, it can be difficult to make sense of all those names numbers. The Excel SUM formula lets you focus on specific categories within an Excel worksheet and come up with subtotals that can help you to spot trends and patterns in your data. Read on to find …

Read more

Photo of spreadsheet on laptop with column selected for "how to move columns in Excel" article.

How to Move Columns in Excel While Keeping Your Data Intact

Ready to hone your skills in working with Excel spreadsheets for a more organized workflow? Start with learning how to move columns in Excel. This especially helps with columns containing large swaths of data. Columns, rows, and cells are perhaps the three most recognizable features of Excel. They provide the window in which to view, …

Read more

Excel 2010 icon

An Excel Crossroads – Mac and Windows

I bought a MacBook Pro and installed Windows 7 with Boot Camp Assistant so I could access the “normal” Excel. This was important to me at the time because I was doing Excel development work in versions 2003, 2007 and 2010 on a Windows PC. I love my MacBook Pro, which I consider my computer …

Read more

Microsoft Office on the iPad

Over the past two days there has been talk of Microsoft coming out with a version of Office for the iPad in 2012. I for one would happily purchase the Excel part of this package, assuming the price point is similar to that of Apple’s Numbers app at $9.99 USD. If, like me, you started …

Read more

Putting Windows 7 on a Mac to Run Excel for Windows

I bought my first Mac almost 11 months ago and now comes the moment of truth. I need to go on the road and take my MacBook Pro with me, but also need to take several versions of Excel for Windows (2010, 2007, 2003) to validate and tweak an Excel reporting package. Note: Cross posted …

Read more

Top 10 Articles for 2010

The year started for Excel Semi-Pro with my first article on 15 June, 2010. Thanks to you all for visiting my site to see what’s cooking with Excel. According to my Site Stats, here are the top 10 articles this year. Happy Holidays to everyone.