@exceldictionary profile picture
Excel Dictionary @exceldictionary

πŸ“² Excel | Sheets Tips πŸ‘‡πŸΌ Download my FREE Excel Shortcuts Guide

Joined October 2021
  • Tweets 2,456
  • Following 48
  • Followers 416,097
1,587 Photos and videos
Pinned Tweet
Excel Dictionary
@exceldictionary
1 Sep 2022
10 must-know Excel shortcuts:
953
19,153
88,285
How to add a scrollbar to any data table in Excel. 🀯 Download my FREE Excel Function Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #scrollabledatatable #excelformula #tutorial
0:28
19
133
9,341
10-second Excel tip that 99% of users don’t know 🀯 Download my FREE Excel Shortcut Guide πŸ‘‰πŸΌ shorturl.at/xGY8R #excel #exceltips #backgroundimage #exceltricks #tutorial
0:16
3
6
50
6,788
🚨 Replaced hours of manual checking with one formula! IF function: =IF(condition, value if true, value if false) Combine with AND for multiple conditions or OR for either condition. 500 rows checked in seconds ⚑ Tutorial: youtu.be/Ro8vAt1TCsA #Excel #IFFunction
9
59
5,776
How to create a deadline tracker in Excel. ⏰ Download my FREE Excel Function Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #deadlinetracker #excelformula #tutorial
0:24
30
200
13,800
How to automatically add and remove row borders when entering data in Excel 🀯 Download this free step-by-step guide I created πŸ‘‰πŸΌ scribehow.com/viewer/How_to_… #excel #exceltips #scribehow #rowborders #tutorial
0:39
11
82
8,758
How to automatically highlight your active row and column.🀯 Download my FREE Excel Shortcut Guide πŸ‘‰πŸΌ shorturl.at/xGY8R #excel #exceltips #focuscell #exceltricks #tutorial
0:20
10
93
9,517
Top 3 data hacks you should know in Excel. 🀯 Which is your favorite? Download my FREE Excel Dashboard 101 Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #datahacks #exceltricks #tutorial
0:18
1
8
56
6,836
🚨 Retire VLOOKUP for good! XLOOKUP advantages: β€’ Look any direction (not just right) β€’ Exact match default β€’ Built-in error handling β€’ Return multiple columns Learn it in 60 seconds ⚑ Tutorial: youtu.be/9-1SfQae0fA #Excel #XLOOKUP
10
79
7,018
How to remove gridlines in Excel using this faster shortcut. πŸ˜… Download my FREE Excel Shortcut Guide πŸ‘‰πŸΌ shorturl.at/xGY8R #excel #exceltips #gridlines #exceltricks #tutorial
0:16
16
79
8,202
How to reorganize data dynamically by category using this function. 🀯 Download this free step-by-step guide I created πŸ‘‰πŸΌ scribehow.com/viewer/How_to_… #excel #exceltips #scribehow #filterfunction #tutorial
0:34
10
77
9,154
How to translate text instantly using this function. 🀯 Download my FREE Excel Function Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #translatefunction #excelformula #tutorial
0:20
11
52
10,169
How to merge data without breaking your data. πŸ˜… Download my FREE Excel Shortcut Guide πŸ‘‰πŸΌ shorturl.at/xGY8R #excel #exceltips #mergecells #exceltricks #tutorial
0:20
13
58
6,709
LAST CALL = FREE Pivot Tables Class closes TOMORROW!🚨 Over 20,000 registered already!!! Learn to: βœ… Summarize data in seconds βœ… Analyze 1000s of rows instantly βœ… Save 5 hours/week Can't make it? Register & get the replay!!! πŸ‘‰ Link to register: start.miss-excel.com/pivot-e…
1
10
4,331
Top 3 Pivot Table hacks you don't know but should. 🀯 Who knew all three? Download my FREE Excel Pivot Table 101 Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #pivottable #excelhacks #tutorial
0:25
7
38
5,880
🚨 Stop creating invoices from scratch! Build invoice database β†’ dropdown selector β†’ FILTER function pulls line items β†’ auto-totals. 30 minutes becomes 30 seconds ⚑ Tutorial: youtu.be/6jwbcEJjDc0 #Excel #Automation
6
29
4,963
How to create an interactive Pivot Chart in Excel. πŸ“Š Download my FREE Excel Pivot Table 101 Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #pivotchart #pivottable #tutorial
0:31
1
42
151
9,219
How to use the clipboard panel to copy and paste multiple rows at once. 🀯 Download this free step-by-step guide I created πŸ‘‰πŸΌ scribehow.com/viewer/How_To_… #excel #exceltips #scribehow #clipboardpanel #tutorial
0:30
15
64
7,494
When someone asks the best way to summarize data... πŸ˜‚ PIVOT!!! 500 rows? Pivot Table. Sales by region? Pivot Table. Boss wants a report EOD? Pivot Table!!! Miss Excel and I are hosting a FREE 1-hour class on how to master them! πŸ‘‰ Link to register: start.miss-excel.com/pivot-e…
4
25
7,459
How to turn your Excel data into an interactive calendar πŸ—“οΈ Try @emergentlabs for FREEπŸ‘‰πŸΌ app.emergent.sh/?via=excel #excel #exceltips #emergentai #webcalendar #tutorial
0:43
1
15
74
9,692
10-second Excel tip that'll save you hours. 🀯 Download my FREE Excel Pivot Table 101 Guide πŸ‘‰πŸΌ excel-dictionary.com/pages/f… #excel #exceltips #pivottable #datasummary #tutorial
0:19
15
63
8,742
Load more