Complete Excel 2013 Class - Comprehensive Excel from Basics to Advanced

Complete Excel 2013 Class - Comprehensive Excel from Basics to Advanced

ExcelIsFun via YouTube Direct link

Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs

15 of 50
Previous
Next

15 of 50

Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Complete Excel 2013 Class - Comprehensive Excel from Basics to Advanced

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Highline Excel 2013 Class Video 01: Back To Basics: Number Format, Keyboards, PivotTables, Formulas
  2. 2 Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples
  3. 3 Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel
  4. 4 Highline Excel 2013 Class Video 04: Percentage Increase or Decrease Formula
  5. 5 Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)
  6. 6 Highline Excel 2013 Class Video 06: Scenarios To Save Sets Of Formula Inputs, Paste Special Trick
  7. 7 Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References
  8. 8 Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.
  9. 9 Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions
  10. 10 Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS
  11. 11 Highline Excel 2013 Class Video 11: Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM
  12. 12 Highline Excel 2013 Class Video 12: AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT
  13. 13 Highline Excel 2013 Class Video 13: AND & OR Criteria Calculations: Table Feature
  14. 14 Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
  15. 15 Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs
  16. 16 Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...
  17. 17 Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function
  18. 18 Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
  19. 19 Highline Excel 2013 Class Video 19: Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP
  20. 20 Highline Excel 2013 Class Video 20: VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples
  21. 21 Highline Excel 2013 Class Video 21: INDEX and MATCH Functions For Unusual Lookups 4 Examples
  22. 22 Highline Excel 2013 Class Video 22: CHOOSE function to lookup table for VLOOKUP With Multiple Tables
  23. 23 Highline Excel 2013 Class Video 23: VLOOKUP and IFNA for Commissions
  24. 24 Highline Excel 2013 Class Video 24: Getting Top 5 Values With LARGE And Bottom 5 With SMALL
  25. 25 Highline Excel 2013 Class Video 25: Goal Seek: Get Formula To Evaluate To Desired Result
  26. 26 Highline Excel 2013 Class Video 26: Excel Compare Two Lists Formula: Item In List? Item Not In List?
  27. 27 Highline Excel 2013 Class Video 27: How To Track Down Excel Formula Errors (16 Examples)
  28. 28 Highline Excel 2013 Class Video 28: Excel Data Validation: List, Date, Time, Custom (22 Examples)
  29. 29 Highline Excel 2013 Class Video 29: Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)
  30. 30 Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)
  31. 31 Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More
  32. 32 Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions
  33. 33 Highline Excel 2013 Class Video 33: Sorting In Excel. Excel Sort (13 Examples)
  34. 34 Highline Excel 2013 Class Video 34: Excel Subtotals, Add Subtotals based on One or Two Columns
  35. 35 Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
  36. 36 Highline Excel 2013 Class Video 36: Excel Filter For Extracting Records with AND or OR Criteria
  37. 37 Highline Excel 2013 Class Video 37: Excel Advanced Filter Extract Data 26 Examples Basic - Advanced
  38. 38 Highline Excel 2013 Class Video 38: Excel Text To Columns To Split or Convert Data 7 Examples
  39. 39 Highline Excel 2013 Class Video 39: Excel Import Data: Text File, CSV File, Access, Excel File
  40. 40 Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples
  41. 41 Highline Excel 2013 Class Video 41: Review Of Chart Basics For Excel 2013
  42. 42 Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013
  43. 43 Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Charts
  44. 44 Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013
  45. 45 Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013
  46. 46 Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas & Chart in Excel 2013
  47. 47 Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)
  48. 48 Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels
  49. 49 Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point
  50. 50 Highline Excel 2013 Class Video 51: Recorded Macro Basics, including Absolute & Relative References

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.