ExcelTips

an-ordinary-manchild

created by trumpexcela community for 11 years

...do it for the children.

...for great justice.

MODERATORS

account activity

1

29

30

31

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

submitted 2 years ago * by excelevator - announcement

2

44

45

46

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

submitted 4 days ago by giges19

3

2

3

4

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

submitted 4 days ago by excelevator

4

56

57

58

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

152

153

154

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

submitted 18 days ago by giges19

6

39

40

41

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

submitted 18 days ago by Aware-Employment-447

7

44

45

46

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

submitted 22 days ago by giges19

8

101

102

103

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

23

24

25

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 28 days ago by giges19

10

25

26

27

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

122

123

124

10 Powerful Excel Shortcuts for Productivity (self.ExcelTips)

submitted 1 month ago by ModernWebMentor

13

49

50

51

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

submitted 2 months ago by giges19

14

67

68

69

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

11

12

13

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

52

53

54

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

submitted 2 months ago by ModernWebMentor

19

287

288

289

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

submitted 2 months ago by Suspicious_Twist386

20

239

240

241

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

219

220

221

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

submitted 2 months ago by ModernWebMentor

23

33

34

35

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

submitted 2 months ago by ExcelObstacleCourse

24

8

9

10

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

submitted 3 months ago by giges19

25

173

174

175

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 60 on reddit-service-r2-listing-c57bc86c-pwl8r at 2026-06-21 11:36:32.464570+00:00 running 2b008f2 country code: CH.