import excel list to outlook contacts

How to Import Excel List Into Outlook Contacts

With so many different programs available for managing your email and your email messages, you will probably switch from one program to another at some point in your life. However, the process for exporting your contacts from the old email account into the new one might not be immediately obvious. Most email programs are capable … Read more

Excel print options

Fit a Spreadsheet on One Page

Working with a large spreadsheet in Microsoft Excel 2010 can be a bit of a challenge when you are not able to view the entire spreadsheet on your monitor at one time. However, trying to fit a spreadsheet on one page in Microsoft Excel 2010 when you are printing can be even more frustrating. If … Read more

pivot table menu

Pivot Table

Microsoft Excel 2010 users are always looking for the best way to organize and sort the data in their spreadsheets. This can be accomplished in a number of different ways, and your situation will likely be the dictating scenario in determining which method is right for you. However, a pivot table in Microsoft Excel 2010 … Read more

Microsoft Office Starter 2010

Microsoft Office Starter 2010

Once you have unpacked and set up your new Dell computer, you will notice that there are already a number of different programs and shortcut icons installed on the computer, including Microsoft Office Starter 2010. This is commonly referred to as “bloatware” and is typically comprised of programs that developers have paid to have included … Read more

Excel compare columns with VLOOKUP

Excel Compare Columns

There are plenty of “Excel compare columns” methods that you could employ within Microsoft Excel, and the option that you choose is ultimately going to depend upon what you are attempting to accomplish. If your “Excel compare columns” search is being triggered in an effort to check one column for instances of a value in … Read more

Change XML default program

Open XML Files with Excel in Windows 7

Last updated: January 17, 2017 XML files can provide a variety of information to multiple programs, but a common use for them is storing data in a tabular format, similar to that of Microsoft Excel. In fact, if you have recently converted a PDF to Excel with Acrobat, then you may have an XML file … Read more

Save PDF as "Tables for Excel"

Convert PDF to Excel with Acrobat

PDF files are a popular form for sending data because the formatting will remain intact, regardless of which PDF-compatible program is used to open the file. However, the popularity of PDF forms has forced many people into the habit of sending files that would be better transmitted as a different file type, such as an … Read more

Clear conditional formatting from your selected cells

Remove Cell Fill Color That Will Not Go Away

Microsoft Excel is popular for handling data because it lets you do things like write formulas and use macros that can simply the process of sorting, evaluating, and creating data. But if also has a number of formatting options that can help make your data look good and be easier to read. Typically you can … Read more

Select pivot table from the Insert menu

How to Make a Pivot Table in Excel 2010

I was recently downloading a lot of CSV orders from a customer, which I then combined into one file using the CSV file combination process in this article. However, all of the data from those orders was itemized, and our production team needed each item combined into one line so that they knew how much … Read more