Live Lectures in Microsoft Excel
Date and TEXT
DATE and TEXT are what Excel does best. This lesson teaches options to find the Day, Month and Year from a Date. We use Dates to run a business. The TEXT functions can combine (CONCATENATE) cells together, say first name and last name. Other Text functions can trim (select) just a few characters.
The If Logical Formula
A Logical formula makes sense. There are only two answers: True/False, Yes/No. It begins with a Logical Test. This lesson uses the Logical IF Formula to get the data based on our criteria.
Intermediate Excel Objectives
Logical and Statistical Formulas, CONCATENATE (combine) data with a formula, Modify and format TEXT with formulas, Use DATE and TIME formulas, Use FINANCIAL formulas to calculate a car payment.