skip to Main Content

Excel – Sorting Huge Lists of Data in a Spreadsheet in Excel

Sorting data in Excel is a common task you may perform all the time. It is possible to sort a list and find out the data didn’t sort exactly how you thought it would. There are three common reasons as to why your data won’t sort properly. One of the reasons could be that the list is just too large and you don’t have enough memory on your computer to perform the sort. The other two reasons are shown in detail in this tutorial.  This will work in Excel 2003, Excel 2007 and Excel 2010.
 

This post is only available to members.
Read More

How to Insert Hyperlink in e-mail Message or Document (Office 2007/2010)

You may want to forward a web address in an e-mail message or include a hyperlink in a document. This is a fairly easy process. This will work in most Office 2007 & 2010 programs (Outlook 2007, Outlook 2010, Word 2007, Word 2010, PowerPoint 2007 and PowerPoint 2010).  This example is shown using Outlook 2010.

 

This post is only available to members.
Read More

How to Save an Excel file as a .CSV File (Excel 2003)

You can convert an Excel file into a .CSV file (Comma Separated Value).  A .CSV file can be used to transfer data from one program to another.  For example, if you have a mailing list in Excel you can covert the file to a .CSV file and use it to upload the information into an e-mail program (Outlook, Gmail, etc.).  This video will show you how to covert an Excel file.

This post is only available to members.
Read More

Excel – Save an Excel File as a .CSV File (Excel 2010)

You can convert an Excel file into a .CSV file (Comma Separated Value).  A .CSV file can be used to transfer data from one program to another.  For example, if you have a mailing list in Excel you can covert the file to a .CSV file and use it to upload the information into an e-mail program (Outlook, Gmail, etc.).  This video will show you how to covert an Excel file.

This post is only available to members.
Read More
Back To Top