10 Amazing (Less Known) Excel Tricks You Should Know

Share
TrumpExcel
Published at : 07 Dec 2021
377020 views
9896
169

In this video, I covered 10 less known but amazing Excel tricks it can save you a lot of time.

These are simple Excel tricks that you can use in your day-to-day work and be more efficient

00:00 Intro
00:12 Repeat Headers in Printed Pages (Name Box Trick)
01:10 Convert Number of Percentage (Paste Special Trick)
01:54 Filter Data based on Cell Value (two-click method)
02:35 Automatically Insert Decimal Point when Typing
03:55 Quickly Add Line Breaks (Find and Replace trick)
05:34 Quick Access Toolbar Shortcuts Trick
07:55 Split Screen to Compare Data
10:23 Move Rows and Column in Excel (Drag and Drop trick)
12:51 Group Sheets and Make Changes in One Go
15:04 Compare Sheets in the Same workbook (Side by Side)

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial
excel tricksexcel tricks and tips 2020excel tricks and tips

First Light

First Light

LOADS of suggestions for this years ALIEXPRESS SALE.

LOADS of suggestions for this years ALIEXPRESS SALE.

Kellogg’s Froot Loops

Kellogg’s Froot Loops

Support Bike Shops: Ranch Camp

Support Bike Shops: Ranch Camp

The Next Generation of Homeowners

The Next Generation of Homeowners

Open Air

Open Air

Brit Awards to SCRAP male and female awards in favour of gender-neutral awards

Brit Awards to SCRAP male and female awards in favour of gender-neutral awards

Where are we in terms of Religious Freedom in the UK?

Where are we in terms of Religious Freedom in the UK?

Survive

Survive

Amazing Tools and Repair Tips Level 100!

Amazing Tools and Repair Tips Level 100!

Noy Vanneth Old Song Collections Non Stop   Noy Vanneth Best Song HD

Noy Vanneth Old Song Collections Non Stop Noy Vanneth Best Song HD

It Should Be Physically IMPOSSIBLE To Do What This Man DID!

It Should Be Physically IMPOSSIBLE To Do What This Man DID!

Definitely, Certainly - Adverbs of Certainty || Short lesson #shorts

Definitely, Certainly - Adverbs of Certainty || Short lesson #shorts

Geared up for the Kolkata Derby! | SC East Bengal vs ATK Mohun Bagan Preview | ISL 2021-22

Geared up for the Kolkata Derby! | SC East Bengal vs ATK Mohun Bagan Preview | ISL 2021-22

NO MORE BAD MAKEUP DAYS! Here is how to apply eyeshadow flawlessly

NO MORE BAD MAKEUP DAYS! Here is how to apply eyeshadow flawlessly

Colin Hay - A Thousand Million Reasons - 2/2/2017 - Paste Studios, New York, NY

Colin Hay - A Thousand Million Reasons - 2/2/2017 - Paste Studios, New York, NY

Sunday Choice twakiriye Clarisse Karasira ,Mutoni Assia na Lavane  Phil Peter,M Irene na Moses

Sunday Choice twakiriye Clarisse Karasira ,Mutoni Assia na Lavane Phil Peter,M Irene na Moses

How to Continually Find New Keyword Opportunities (That You'll Be Able to Rank For)

How to Continually Find New Keyword Opportunities (That You'll Be Able to Rank For)

Dub Techno || Selection 077 || Stability

Dub Techno || Selection 077 || Stability

How To Get Your Man To Buy You What You Want

How To Get Your Man To Buy You What You Want

Great Moments in Unintended Consequences (Vol. 1)

Great Moments in Unintended Consequences (Vol. 1)

George and Amal Clooney on the Red Carpet at 'The Tender Bar' Premiere

George and Amal Clooney on the Red Carpet at 'The Tender Bar' Premiere

There are various types of conflicts: military conflicts, economic

There are various types of conflicts: military conflicts, economic

MAE's VLOGMAS: Personalized Gift Ideas ft. @silviax jewelry ✨🎄🎁

MAE's VLOGMAS: Personalized Gift Ideas ft. @silviax jewelry ✨🎄🎁

Throne - ISAIAH (LYRICS)

Throne - ISAIAH (LYRICS)

PRODUCE FRUIT IN KEEPING WITH REPENTANCE | Matthew 3:1-12 | Shine Thomas | City Harvest AG Church

PRODUCE FRUIT IN KEEPING WITH REPENTANCE | Matthew 3:1-12 | Shine Thomas | City Harvest AG Church

100% Cashback | Free COD | Up to 70% Discount on MRP | 100% Buyer | Shorts | Speakme | Diwali Diya

100% Cashback | Free COD | Up to 70% Discount on MRP | 100% Buyer | Shorts | Speakme | Diwali Diya

Detest - Hyper Schranz

Detest - Hyper Schranz

Illenium - Fortress (feat. Joni Fatora)

Illenium - Fortress (feat. Joni Fatora)

How to SET UP standalone forums vs connecting forums to the groups, and more?

How to SET UP standalone forums vs connecting forums to the groups, and more?

3 REASONS HARMONY ONE HITS $1 - ALTCOIN UPDATE

3 REASONS HARMONY ONE HITS $1 - ALTCOIN UPDATE

Supergirl, Elder Scrolls, Sword Art Online

Supergirl, Elder Scrolls, Sword Art Online

ΕΤΟΙΜΑΣΤΕ ΤΑ VBUCKS ΣΑΣ... 🐱‍👤 NARUTO *EVENT* ΜΕ 4 ΣΚΙΝΣ (ΕΠΙΣΗΜΟ ΑΠΟ ΤΗΝ EPIC)

ΕΤΟΙΜΑΣΤΕ ΤΑ VBUCKS ΣΑΣ... 🐱‍👤 NARUTO *EVENT* ΜΕ 4 ΣΚΙΝΣ (ΕΠΙΣΗΜΟ ΑΠΟ ΤΗΝ EPIC)

5 Reasons You Keep Procrastinating

5 Reasons You Keep Procrastinating

Alcaraz vs Berrettini; Sinner, Tiafoe, Zverev, Ruud All Play | Vienna 2021 Quarter-Final Highlights

Alcaraz vs Berrettini; Sinner, Tiafoe, Zverev, Ruud All Play | Vienna 2021 Quarter-Final Highlights

Selecting the right database (3:36 min)

Selecting the right database (3:36 min)

Pop smoke teaches you how to dance

Pop smoke teaches you how to dance

백예린 - 산책 / 가사

백예린 - 산책 / 가사

The Top Tiny Homes Of 2021

The Top Tiny Homes Of 2021

OLDER MEN, YOUNGER WOMEN

OLDER MEN, YOUNGER WOMEN

Most Bizarre PARANORMAL, SUPERNATURAL, and UFO INVESTIGATION Cases... 6-Hour Special

Most Bizarre PARANORMAL, SUPERNATURAL, and UFO INVESTIGATION Cases... 6-Hour Special

It’s soon going to be all over for Xi Jinping.

It’s soon going to be all over for Xi Jinping.

Adelina - Bye Bye (Robert Cristian Remix)

Adelina - Bye Bye (Robert Cristian Remix)

I Bought Myself a Birthday Present

I Bought Myself a Birthday Present

final

final

Can purchase orders be automated? | How to Automate purchase orders

Can purchase orders be automated? | How to Automate purchase orders

Why it’s important to specialize in cybersecurity | Cyber Work Podcast

Why it’s important to specialize in cybersecurity | Cyber Work Podcast

LIVE: Governor Asa Hutchinson Holds News Conference on OSHA and CMS Rules for Vaccine Requirements

LIVE: Governor Asa Hutchinson Holds News Conference on OSHA and CMS Rules for Vaccine Requirements

Sourdough Bread History | Proof Bread

Sourdough Bread History | Proof Bread