In this video, we’ll cover the BEST new Excel features EVERYONE needs to know. These 5 tools take Excel to the next level.
First, we will cover Microsoft’s brandnew checkboxes and how to calculate values depending on whether they are checked or not. Next, we will go over the replacement for Pivot Tables: the GROUPBY and PIVOTBY Functions. Then, we’ll cover how to import data from a picture directly into our workbook with Excel’s new Data From Picture tool. Next, we’ll cover how to insert images directly into cells and the benefits of this. Lastly, we will cover how to quickly navigate our workbook using Excel’s new Navigation Pane.
FULL CHECKBOX TUTORIAL: • These New Checkboxes Will Blow Your Mind
FULL PIVOTBY TUTORIAL: • I stopped using Pivot Tables. Here's Why
RESOURCES
Download the workbook and follow along: https://exceldictionary.com/pages/yo...
SHOP EXCEL DICTIONARY
COURSES: https://exceldictionary.com/collecti...
GUIDES: https://exceldictionary.com/collecti...
MERCH: https://exceldictionary.com/collecti...
TEMPLATES: https://exceldictionary.com/collecti...
NEWSLETTER
Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.exceldictionary.com/subs...
SUBSCRIBE
Subscribe to never miss a video: / exceldictionary
TIMESTAMPS
‘0:00 Intro
‘0:17 1. New Checkboxes
‘2:19 2. GROUPBY & PIVOTBY Functions
‘4:28 3. Data From Picture
‘5:19 4. Insert Picture In A Cell
‘6:35 5. Navigation Pane
‘8:01 Wrap up
#excel #exceltips #tutorial