Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn essential tips and techniques for maximizing productivity in Excel 2013 through this comprehensive video tutorial series. Master the revolutionary Flash Fill feature for extracting, combining, inserting, and reversing data with 25 practical examples, and explore new functions including SHEET, SHEETS, FLOOR.MATH, CEILING.MATH, IFNA, ISFORMULA, and FORMULATEXT. Discover Excel 2013's enhanced charting capabilities with recommended charts, PivotTables with distinct count functions, and advanced chart types including pie-within-pie charts, combined chart types with secondary axes, and custom chart templates. Develop proficiency in data analysis tools such as break-even analysis formulas and charts, statistical visualizations including histograms and dot plots, and conditional formatting techniques for creating bar charts with data labels. Explore the improved Data Model and PowerPivot features for handling millions of rows of data, learn to use table slicers and slicer formulas, and master navigation improvements including sheet navigation arrows and spell check enhancements. Practice real-world applications through accounting examples, formula troubleshooting with FORMULATEXT and ISFORMULA functions, and data manipulation techniques using Text to Columns and Flash Fill for cleaning and organizing information efficiently.

Syllabus

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

Taught by

ExcelIsFun

Reviews

Start your review of Excel 2013 Tips and Tricks - Flash Fill, New Functions, Data Model, and PowerPivot Features

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.