5 Awesome Excel Tricks No One Taught You (But You’ll Use Every Day)

The A-Z of Excel Formatting - https://goodly.co.in/custom-formattin...
   • The KING of All Excel Functions – Explaine...  
Learn the Basics of Power BI in a structured way, in just 1 Week - https://products.goodly.co.in/power-b...


In this video, I'll show you 5 simple but powerful Excel tricks that can save you time every day. Learn how to make negative numbers appear in red automatically, create lists that grow by themselves when you add new data, and pull information from other files without copying and pasting. I'll also show you how to fix dates that show up wrong and teach you a special formula trick that can solve many problems. These easy-to-learn tips will help you work faster and make your spreadsheets look more professional.


===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...


===== LINKS 🔗 =====
Blog 📰 - https://www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/
Need my help on a Project 💻- https://www.goodly.co.in/consulting/
Download the File ⬇️- https://subscribepage.io/74ZwUp


=====CHAPTERS =====
00:00 - Intro
00:16 - Custom Formatting
05:10 - Named Range
09:05 - Filter from Different Excel File
13:27 - Creating a Pivot Table by connection
15:56 - Convert MM-DD to DD-MM
19:31 - LAMBDA Function



===== CONTACT 🌐 =====
Twitter -   / chandeep2786  
LinkedIn -   / chandeepchhabra  
Email - [email protected]


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!