Excel Dictionary
@exceldictionary
Followers
419K
Following
145
Media
1K
Statuses
2K
📲 Excel | Sheets Tips 📚 @pptdictionary 👇🏼 Shop courses, guides, and merch
Pittsburgh
Joined October 2021
369
10K
37K
5 Excel shortcuts to improve daily productivity:.
123
4K
13K
Save hours of your life with these 10 Excel productivity tips:.
120
3K
9K
7 Excel Quick Analysis (QA) that analyze your data, so you don't have to:.
104
2K
7K
How to create a project tracker in Google Sheets. 🤓
18
2K
7K
1. CTRL E. CTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.
50
667
7K
5 Excel shortcuts you should learn (even on a Friday):.
75
2K
7K
How to create hundreds of employee folders in seconds. 🤯
31
1K
6K
3 Excel tricks that will blow your mind. Which is your fav?! 🤯
18
888
4K
3 data visualization tricks you need to know (part two). Which is your favorite? . #Excel #Microsoft #tutorial
35
636
4K
If your VLOOKUP function isn’t working, don’t panic; here’s why and how to fix it.
40
944
4K
Never waste time cleaning up messy names in Excel again. Instead, let the PROPER and TRIM functions do the cleaning. PROPER capitalizes the first letter of each word in a text string and converts all other letters to lowercase, while TRIM removes all extra spaces. 🤯. #Excel
31
878
4K
3. ALT H O I. If you are unable to see your data, ALT H O I is here to help! Press ALT H O I to automatically adjust the column widths to fit the size of your data.
11
276
4K
Save hours and your sanity using these 10 Excel shortcuts:.
51
1K
4K
2. ALT =. Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
18
269
3K
How to insert Timelines to filter data in Excel. 🤯
28
809
3K
5 Excel shortcuts you need to know. 🤓 Who knew all 5?!
10
735
3K
1. AutoFit. Automatically fit all column widths to the size of the data by hitting ALT H O I.
31
420
3K
28
560
3K
5 ways Excel's Flash Fill tool can save you hours:.
60
721
3K
3 ways to split text in Excel. Who knew all three?! ✋🏼
16
620
3K
I’m so excited to announce that I have received the Microsoft MVP award to recognize my technical community leadership in Excel! What a great way to start off 2023. I couldn’t have done it without this amazing community. Thank you all for being here and supporting me. 🤍
126
127
3K
How to create spin buttons in Excel. Would you use these? 👀
11
603
3K
Over 80 Excel Shortcuts right at your fingertips. 🤭. Shop:
19
641
3K
How to automatically sum data in Excel using two keys. 🤯
13
607
3K
How to transform a list into a data table with this Excel function. 🤯
18
616
3K
Conversions can be tricky, but not with this Excel function! The CONVERT function converts a number from one measurement unit (from_unit) to another measurement unit (to_unit). #Excel #Skills #Microsoft
18
676
3K
7
623
3K
BREAKING: I will no longer be using Pivot Tables. Yup, you read that correctly. Excel just released the PIVOTBY function that allows you to pivot data quickly by writing a formula. 🤯 Watch my latest YT for everything you need to know about this function.
11
435
2K
Share with a friend who loves Excel functions. 🤓
12
597
2K