|
|||||
Excel 2010 Expert 2 & 3 Finished By Richard Rost 13 years ago I just finished Excel Expert 2 and 3. They're online and available for immediate consumption. Level 2 covers working with dates & times. Level 3 covers logic functions. Excel 2010 Expert Level 2 Running Time: 1 Hour, 33 Minutes 00. Intro (7:49) 01. Excel Dates & Times (9:12) Valid Date Formats Valid Time Formats Valid Date/Time Formats Understanding Internal Dates Date Arithmetic Adding Days Adding Hours 02. Custom Date/Time Codes (6:33) Customizing Date Formats Custom Date & Time Codes 03. Date/Time Functions 1 (11:11) Current System Date/Time Current Time NOW() F9 to Recalculate Current Date TODAY() Calculating the Time Only Components of a Date YEAR, MONTH, DAY HOUR, MINUTE, SECOND WEEKDAY Changing WEEKDAY Start Day Building a Date from Components DATE Buildnig a Time from Components TIME Adding Dates with DATE Function Adding Times with TIME Function 04. Date/Time Functions 2 (14:13) Calculate Difference in Dates Calculate Age in Years Using Math INT function Difference in Whole Years YEARFRAC DATEDIF Difference in Months Between Dates 05. Date/Time Functions 3 (13:49) Converting Bad Imported Dates Convert 20110801 to 8/1/2011 Review of LEFT, RIGHT, MID Convert Text Date to Actual Date DATEVALUE, TIMEVALUE EDATE Determine Last Day of the Month EOMONTH Work Days Between Two Dates NETWORKDAYS Custom List of Excluded Holidays Count Number of Workdays Forward WORKDAY NETWORKDAYS.INTL WORKDAY.INTL Custom Work Days String "0000011" Week Number of the Year WEEKNUM 06. Date/Time Functions 4 (12:04) AutoFill with Days of the Week AutoFill Date Options Fill Days, Months, Years, Weekdays Subtract Two Times Format as a Number Convert Days to Hours Display Hours and Fractions Display Hours and Minutes Adding up hours with [h]:mm 07. Date/Time Tips & Tricks (13:57) Creating a series of dates with AutoFill Calculating specific dates First day of a month Last day of a month Number of days in a month What quarter is a date in First day of the year Last day of the year Day number (of the year) Days remaining in the year Inserting the current date and time Adding up hours, minutes, seconds [h]:mm [mm]:ss Displaying fractions of a second h:mm:ss.00 08. Review (4:28) Excel 2010 Expert Level 3 Running Time: 1 Hour, 11 Minutes 00. Intro (6:29) 01. Logic Functions (19:05) TRUE, FALSE Values 0 = FALSE AND, OR, NOT Is an invoice late? Is an invoice paid? Collection Letter Example Shipping an Order Example Credit Card Batching Example TRUE, FALSE Functions 02. IF Function 1 (14:18) IF THEN Statement IF THEN ELSE Statement Charge Sales Tax Example Set Tax Rate if in NY Calculate Sales Tax Calculate Credit Card Batch Total Give Students PASS or FAIL Grade 03. IF Function 2 (14:05) Nested IF Functions Assign a Letter Grade with IF Fixing Our Time Sheet Example Shifts That Cross Over Midnight Calculating Overtime Pay 04. IS Functions (14:05) ISBLANK, ISERROR ISEVEN, ISODD ISLOGICAL, ISNUMBER ISTEXT, ISNONTEXT Extra Space Between Names FN, MI, LN "Mr.", "Mrs.", or "Mr. & Mrs." Divide by Zero errors ISERROR to fix #DIV/0! IFERROR to fix #DIV/0! 05. Review (3:20)
|
||
| |||