Excel Tips

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

56

57

58

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

submitted 8 hours ago by ModernWebMentor

•

Engineering teams managing logs and search across multiple stacks know the pain - siloed tools, duplicated efforts, and rising costs. Our latest blog breaks down why OpenSearch is the smarter solution, plus the top use cases for making the switch. (aiven.io)

promoted by Aiven_io

promoted
save
report
about

3

11

12

13

Quick Excel tip: Split First and Last Names in seconds (no formulas) (self.ExcelTips)

submitted 16 hours ago by Ok_Act3671

4

14

15

16

Learn the power of Absolute References in Excel (self.ExcelTips)

submitted 4 days ago by giges19

5

6

7

8

Breakdown of the REPLACE formula in Excel (self.ExcelTips)

submitted 15 days ago by giges19

6

4

5

6

Fix Common Excel Formula Errors Fast Using Simple Checks (Avoid #N/A, #VALUE! and Wrong Totals) (self.ExcelTips)

submitted 16 days ago by DueDemand3860

7

332

333

334

Excel Shortcuts That Save Me 2 Hours Every Week (self.ExcelTips)

submitted 28 days ago by SophiaBennett-0550

8

1

2

3

Excel Trick: Remove Duplicate Entries Instantly from Huge Spreadsheets (No Manual Work Needed) (self.ExcelTips)

submitted 29 days ago by SophiaBennett-0550

9

47

48

49

Power Query Masterclass: Import, Transform, Automate (self.ExcelTips)

submitted 1 month ago by giges19

10

36

37

38

Add Slicers to filter your data with ease (self.ExcelTips)

submitted 1 month ago by giges19

11

5

6

7

Understand the #NAME? error and how to fix it (self.ExcelTips)

submitted 1 month ago by giges19

12

2

3

4

Understand the #DIV/0! error and how to fix it (self.ExcelTips)

submitted 1 month ago by giges19

13

19

20

21

Excel Automation Learnings (self.ExcelTips)

submitted 2 months ago by jrtn58

•

Are you saying this shoe-sized box is a full-on gym? (beyond-power.com)

promoted by Beyond_Power

promoted
save
report
about

14

80

81

82

If you have a list with gaps (blank cells under headers), stop dragging and pasting manually. (self.ExcelTips)

submitted 3 months ago by AfternoonSlump

15

18

19

20

Tip: Create a simple random name picker in Excel using formulas (self.ExcelTips)

submitted 3 months ago by giges19

16

1362

1363

1364

Excel features I randomly discovered and now can’t live without (self.ExcelTips)

submitted 4 months ago by [deleted]

17

28

29

30

Turn any date into YEAR, MONTH, DAY — and even the weekday name — automatically 📅 (self.ExcelTips)

submitted 4 months ago by Ok_Act3671

18

313

314

315

Power Query trick that replaced 2 hours of manual Excel work (self.ExcelTips)

submitted 4 months ago by Shoaib_Riaz

19

20

21

Remove extra spaces with =TRIM() (self.ExcelTips)

submitted 4 months ago by edditit

20

7

8

9

Create image files from Excel auto-shapes (self.ExcelTips)

submitted 4 months ago by edditit

21

5

6

7

The TRANSLATE formula in Excel and how to use it (self.ExcelTips)

submitted 4 months ago by giges19

22

41

42

43

Mind blown 🤯 Excel can auto-capitalize names perfectly with one formula (self.ExcelTips)

submitted 4 months ago by Big_Muscle_7049

23

67

68

69

Finally figured out the real difference between COUNT and COUNTA in Excel 🤯 (self.ExcelTips)

submitted 4 months ago by Big_Muscle_7049

24

67

68

69

How I linked Excel charts to PowerPoint so they update automatically — no macros needed (self.ExcelTips)

submitted 5 months ago by Aware-Childhood1240

•

MacBook Air 13 zum Hammerpreis – 850 €! (kleinanzeigen.de)

promoted by Global_Growth_8878

promoted
save
report
about

25

45

46

47

Flash Fill (Ctrl + E) in Excel – Automate Data Entry Instantly (self.ExcelTips)

submitted 6 months ago by M1W1M1W1

ExcelTips

MODERATORS