Excel 2013 Tips and Tricks - Flash Fill, New Functions, Data Model, and PowerPivot Features

Excel 2013 Tips and Tricks - Flash Fill, New Functions, Data Model, and PowerPivot Features

ExcelIsFun via YouTube Direct link

Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more

18 of 33

18 of 33

Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2013 Tips and Tricks - Flash Fill, New Functions, Data Model, and PowerPivot Features

Automatically move to the next video in the Classroom when playback concludes

  1. 1 What's New In Excel 2013: Flash Fill, Functions, Data Model, PowerPivot, New Charts, Table Slicers..
  2. 2 Highline Excel 2013 Class Video 29: Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)
  3. 3 Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function
  4. 4 Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts & PivotTables
  5. 5 Excel Magic Trick 1050: Excel 2013 Sheet Navigation Arrows For Go To Last Or First Sheet Where?
  6. 6 Excel 2013 Preview #1: Smooth and Improved Excel 2013, Office 15 (Excel Magic Trick 949)
  7. 7 Excel 2013 Preview #2: Flash Fill To Extract First & Last Names From Column (Excel Magic Trick 950)
  8. 8 Excel 2013 Preview #3: FLOOR.MATH & CEILING.MATH: Round To Significance Excel Magic Trick 951
  9. 9 Excel 2013 Preview #4: FORMULATEXT Function: Show Formula From A Cell (Excel Magic Trick 952)
  10. 10 Excel 2013 Preview 5 IFNA & VLOOKUP Functions: Show Message When #N/A (Excel Magic Trick 953)
  11. 11 Excel 2013 Preview #6: ISFORMULA Function (Excel Magic Trick 954)
  12. 12 Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955)
  13. 13 Excel 2013 Preview #8: SHEET Function (Excel Magic Trick 956)
  14. 14 Word & Excel 2013 Preview #9: Spell Check Is Amazing (In Word)! (Excel Magic Trick 957)
  15. 15 Excel Magic Trick 1039: Turn Off Animation In Excel 2013
  16. 16 Excel Magic Trick 960: Add Noncontiguous ranges that have #N/A Errors
  17. 17 Excel Magic Trick 961: Calculate Total Savings: Old Price, New Price & Quantity IFNA 2013 Function
  18. 18 Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more
  19. 19 Highline Excel 2013 Class Video 49: Break Even Analysis Formulas & Chart, Plotting Break Even Point
  20. 20 Highline Excel 2013 Class Video 48: Conditional Formatting: Bar Chart with Data Labels
  21. 21 Highline Excel 2013 Class Video 47: Statistics: Dot Plot (Cell Chart)
  22. 22 Highline Excel 2013 Class Video 46: Statistics: Histogram Formulas & Chart in Excel 2013
  23. 23 Highline Excel 2013 Class Video 45: Combining Chart Types and Secondary Axis in Excel 2013
  24. 24 Highline Excel 2013 Class Video 44: Pie within Pie Chart in Excel 2013
  25. 25 Highline Excel 2013 Class Video 43: Set Default Chart in Excel 2013, Keyboard Shortcuts Charts
  26. 26 Highline Excel 2013 Class Video 42: Save Chart As Template in Excel 2013
  27. 27 Highline Excel 2013 Class Video 41: Review Of Chart Basics For Excel 2013
  28. 28 Excel Magic Trick 1056: Excel 2013 Slicer Formulas
  29. 29 Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)
  30. 30 Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013
  31. 31 Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula
  32. 32 Excel 2013 Accounting Tricks for Excel CPE Credit at Poodle Dog Restaurant (50 Examples)
  33. 33 Excel Magic Trick 1463: Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.