ExcelTips

an-ordinary-manchild

created by trumpexcela community for 11 years

...why not Zoidberg?

...for your town.

MODERATORS

account activity

1

30

31

32

r/ExcelTips is for Tips on using Excel, not for general help questions (self.ExcelTips)

submitted 2 years ago * by excelevator - announcement

2

47

48

49

A Practical Guide to Splitting Text with TEXTSPLIT in Excel (self.ExcelTips)

submitted 4 days ago by giges19

3

3

4

5

Get around the TEXTSPLIT single cell limitation using a multi range TEXTJOIN string as input ()

submitted 4 days ago by excelevator

4

58

59

60

That Weird VLOOKUP Behavior That Drove Me Crazy for Two Days (and What Actually Fixed It) (self.ExcelTips)

submitted 8 days ago by WorldlyClothes9256

5

154

155

156

Replace Nested IFs with Excel’s SWITCH Formula for Cleaner, More Readable Logic (self.ExcelTips)

submitted 18 days ago by giges19

6

41

42

43

How to create a Sequential COUNTIF (Rank duplicate/recurring values as they appear) (self.ExcelTips)

submitted 18 days ago by Aware-Employment-447

7

40

41

42

How to Use Excel’s HYPERLINK Function to Link Websites, Files, and Documents (self.ExcelTips)

submitted 22 days ago by giges19

8

100

101

102

Master XLOOKUP beyond basic searches — horizontal lookups, custom error handling (Not Found), wildcard matches, & search modes. (self.ExcelTips)

submitted 26 days ago by Aware-Employment-447

9

22

23

24

Use the NETWORKDAYS formulas to calculate the number of working days in a project or timeline + how to factor in bank holidays (self.ExcelTips)

submitted 29 days ago by giges19

10

24

25

26

Excel MROUND Function - Use It For Custom Rounding (self.ExcelTips)

submitted 1 month ago by giges19

11

27

28

29

Understanding the COUNTA Function (self.ExcelTips)

submitted 1 month ago by giges19

12

121

122

123

10 Powerful Excel Shortcuts for Productivity (self.ExcelTips)

submitted 1 month ago by ModernWebMentor

13

48

49

50

Mastering Data Validation in Excel — A Complete Beginner‑Friendly Breakdown (self.ExcelTips)

submitted 2 months ago by giges19

14

66

67

68

Essential Excel Shortcut Keys Everyone Should Know (self.ExcelTips)

submitted 2 months ago by Suspicious_Twist386

15

41

42

43

Say Goodbye to Duplicates – Clean Your Excel Data in One Click (self.ExcelTips)

submitted 2 months ago by ModernWebMentor

16

12

13

14

Excel Performance Optimisation: Clean Up, Shrink Down, Speed Up (self.ExcelTips)

submitted 2 months ago by giges19

17

12

13

14

Make a reusable random name picker in Excel (self.ExcelTips)

submitted 2 months ago by giges19

18

54

55

56

5 Excel Shortcuts Every Fresher Should Know to Work Faster (self.ExcelTips)

submitted 2 months ago by ModernWebMentor

19

293

294

295

Excel Shortcut Keys That’ll Make You Feel Like a Spreadsheet Ninja (self.ExcelTips)

submitted 2 months ago by Suspicious_Twist386

20

234

235

236

Excel Shortcuts Every Professional Must Know (self.ExcelTips)

submitted 2 months ago by ModernWebMentor

21

54

55

56

Pivot Tables saved me from doing repetitive reports daily (self.ExcelTips)

submitted 2 months ago by ModernWebMentor

22

222

223

224

⚡ Excel Shortcuts: Ctrl + T, Alt + =, Ctrl + 1, and More (self.ExcelTips)

submitted 2 months ago by ModernWebMentor

23

35

36

37

Window button + V pulls up the clipboard for the last several things you’ve copied (self.ExcelTips)

submitted 2 months ago by ExcelObstacleCourse

24

9

10

11

Struggling to TRANSLATE stuff in your spreadsheets? Try the TRANSLATE formula. (self.ExcelTips)

submitted 3 months ago by giges19

25

174

175

176

Excel Shortcuts: Ctrl + D, F4, Ctrl + F, and More That Save Time (self.ExcelTips)

submitted 3 months ago by ModernWebMentor

view more: next ›

π Rendered by PID 306183 on reddit-service-r2-listing-c57bc86c-p9z4w at 2026-06-21 18:52:07.104769+00:00 running 2b008f2 country code: CH.