Excel in a Minute Lesson Summary: Calculating current ages from a list of birth dates can be performed in a number of ways — some are more accurate than others. This video describes using YEARFRAC with ROUNDDOWN or INT to accomplish this task.

CLICK HERE to download the completed spreadsheet for this lesson.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: Continuing the discussion of conditional testing in Excel with SUMIF, I introduce the use of an operator. When using operators such as “less than” or “greater than” with SUMIF, there is a modification to the syntax which must be made in order for the function to work properly. This lesson explains how.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: One type of conditional testing available in Excel is SUMIF. In this lesson, we use SUMIF to return totals associated with vendor names in our database.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: Conditional testing in Excel allows users to construct simple or complex scenarios to extract desired results from a database. IF Statements are the most frequently used type of conditional testing. This video demonstrates a simple solution to a common problem with source data by employing an IF Statement.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: All of the text functions that were introduced during this five-part video series are combined with a COUNT Function and an IF Statement to create a formula that is flexible enough to adapt to both two and three name instances. The text functions used are LEFT, RIGHT, MID, LEN, and FIND.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: The text functions that were introduced in the prior two videos are combined into a single formula to convert cells containing first and last names into the form “Last_Name, First_Name”. The text functions used are LEFT, RIGHT, MID, LEN, and FIND.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: The LEN and FIND functions are used in combination with LEFT, RIGHT, and MID to locate and extract characters from text strings.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: The text functions: LEFT, RIGHT, and MID are introduced in this video. These text functions are used to extract a specified number of characters from a text string within a cell.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: Text can be manipulated as easily as numbers in Excel. This is an introduction to a series of videos that will demonstrate uses for the following text functions: LEN, LEFT, MID, and RIGHT.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.

Excel in a Minute Lesson Summary: This final video of the Commission Spreadsheet Project series demonstrates the use of VLOOKUP with a tiered commission percentage table.

CLICK HERE to download the completed spreadsheet for this project.

[View the video in full screen for HD quality.]

The “Excel Basics” series of videos is intended for the new Excel user.

Click HERE to see the complete list of video tutorials.