Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

Saturday, May 10, 2008

Find, Replace and Sorting in Microsoft Excel 2007

Using the Find, Replace and Sorting functionality within Microsoft Excel 2007.

Monday, March 24, 2008

Using the REPT (Repeat) Function in Excel

This is a quick Microsoft Excel tutorial that demonstrates the ease-of-use of using the REPT function to display a bar-graph like column of data.

Sunday, January 13, 2008

Export Data From an Excel Sheet to a Word Document


Copying Excel cells into a Word document is just one way to transfer data between the two programs. Find out how to easily export data from Microsoft Excel to Word.

Wednesday, December 12, 2007

Working with Dates in Excel


We will go over formatting dates and using dates in formulas. We will calculate the number of days you've been alive, an employees seniority, etc. We'll learn the "today()" and "now()" functions.

Friday, October 26, 2007

Using IF in Formulas in Microsoft Excel


More advanced formula uses including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40." This is a very powerful tip.

Wednesday, October 17, 2007

Create a Seating Chart using Excel


Creating charts and diagrams may not be the first thing you think of when you use Excel, but I use it all the time. In this example, they use Excel to create a seating chart.

Tuesday, March 13, 2007

Using Excel to Calculate the Area of a Circle


Excel is quite a powerful application, and one of the things that can be easily done within the program is calculate the area of shapes, or perform mathematical equations in general. This short video tutorial shows you how to use Excel to Calculate the Area of a Circle.

Wednesday, February 07, 2007

Renaming Sheets in Excel


Learn how to rename sheets in Microsoft Excel.