Excel4Business Tutorials
Loading...
141
subscribers
36,225
video views
Uploaded videos
1-10 of 43-
Excel Basics -029- Calculating Current Age - YEARFRAC and ROUNDDOWN or INT
Excel4Business
1,295 views
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 RO...
-
Excel Basics -028- Conditional Tests - SUMIF with Operators
Excel4Business
216 views
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 "great...
-
Excel Basics -027- Conditional Tests - SUMIF
Excel4Business
104 views
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.
...
-
Excel Basics -026- Conditional Tests - IF Statements
Excel4Business
189 views
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 f...
-
Excel Basics -025- Text Functions - Three Names
Excel4Business
178 views
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...
-
Excel Basics -024- Text Functions - Two Names
Excel4Business
130 views
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...
-
Excel Basics -023- Text Functions - LEN and FIND
Excel4Business
197 views
Lesson Summary: The LEN and FIND functions are used in combination with LEFT, RIGHT, and MID to locate and extract characters from text strings.
Visit http://www.excel4b...
-
Excel Basics -022- Text Functions - LEFT RIGHT and MID
Excel4Business
127 views
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 tex...
-
Excel Basics -021- Text Functions - Introduction
Excel4Business
128 views
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 func...
-
Excel Macros -014- Multiple Files
Excel4Business
1,841 views
Lesson Summary: Multiple Files. This video shows you how to open, save and close files using macros. It uses the file dialog command and shows you how to change other open ...
Advertisement
Play all(43)