New Courses Posted: Access 2010

To go along with the rest of the new Microsoft Suite, we are pleased to announce that our new set of courses on Access 2010 is posted. In step-by-step demonstrations, Instructor Irasema Perrot guides beginning to advanced users through the features of Access 2010. Access is such a useful program: it allows you to organize your data into neat, easy-to-use databases. You can find specific information in your database by creating and running searches called queries. If you've already started using the program and want more information, here are some of the most frequently asked questions regarding Access 2010. Also, make sure to take advantage of our free previews on how to get started using Access.

Tip: If you're using Access to store people's information, such as addresses, running a query can be a great way to pull up information for people you want to send holiday cards to. It's easy to make labels from your query results—say goodbye to hours of sorting through your client/contacts/family info and handwriting or typing up labels. With Access, you've already got the information set up and ready to use whenever you may need it.

Read More

Ways to Use Excel

1. Create a budget to track your personal finance. This is a great way to see where your money is going in order to cut back on unnecessary spending. The benefit of a spreadsheet includes the ability to make formulas and work out complex sums easily, making financial planning that much easier. 

Medieval palace in Segovia, Spain
Start preparing your trip to Spain by
learning the basics of the Spanish language.

2. If you are planning on travelling, you can create a spreadsheet outlining your vacation, including where you will stay, how you will get to each place, and how many days you will be at each location (this will greatly reduce stress if you are travelling to multiple places during one vacation, especially if it's your first visit).

3. Create a spreadsheet to track household chores, where you can include categories like daily, weekly, bi-monthly, and monthly chores. Be sure to leave a checkbox next to each entry!

4. Use spreadsheets for To Do lists—these can cover the week and be broken down into days. Include both weekly and daily tasks. Checkboxes on each task are helpful here too, and can give you a sense of accomplishment when you get to check off a completed task.

5. Create a spreadsheet to evaluate items you are considering purchasing, such as a new car.

6. Create a spreadsheet to track inventory if you have a business, or even if you just want to keep track of all your personal possessions.

These are just a few examples of how you could use Excel—the possibilities are endless. So now we're curious, what do you use Excel for?

Remember to check out the first 3 FREE tutorials for some great insight on how to use Excel 2010, the newest version of Excel. We also have both introductory and advanced courses available in earlier versions of Excel.

Read More