Gyan On Tube

Gyan On Tube Excel Trainer | MIS | Power BI
Daily Excel Tips in Hindi
Learn Excel for Job & Growth

03/03/2026

Stop Typing Month Names

Extract day, month & year instantly

=DAY(A2)
=MONTH(A2)
=YEAR(A2)

Build smarter reports

Save this reel
Follow for daily Excel hacks





BeforeTotal changes with Region selectionAfter Grand Total stays constantPower BI DAX TrickCALCULATE( SUM(Sales[Amoun...
03/03/2026

Before
Total changes with Region selection

After
Grand Total stays constant

Power BI DAX Trick

CALCULATE( SUM(Sales[Amount]), ALL(Sales[Region]))

Ignore slicer
Show real total
Build smarter dashboards

Save this
Share with BI learners

Hashtags (20–25):

Sohan Dey GyanOnTube:Before Basic filters only After Smart dynamic filtering Power BI Advanced DAXCALCULATE( SUM(Sale...
01/03/2026

Sohan Dey GyanOnTube:
Before
Basic filters only

After
Smart dynamic filtering

Power BI Advanced DAX

CALCULATE(
SUM(Sales[Amount]),
FILTER(
Sales,
Sales[Revenue] > 0
)
)

Custom row logic
Advanced analytics
Next-level BI skill

Save this
Share with Power BI learners

Hashtags (20–25):

01/03/2026

Sohan Dey GyanOnTube:
Excel Interview Question

Create connected dropdowns in Excel

Name your ranges
Create first dropdown
Use =INDIRECT(A2)

Boom 💥 Dynamic validation.

Save this reel
Follow for daily Excel hacks





26/02/2026

Excel Trick You’re Not Using 😳

Make Excel formulas look PRO

Use Name Manager in Excel.

✔ Name your ranges
✔ Create dynamic formulas
✔ Build smart dashboards

Save this reel
Follow for daily Excel hacks





Before No proper total calculation After Dynamic Total Sales Power BI SUMX MagicSUMX( Sales, Sales[Quantity] * Sal...
26/02/2026

Before
No proper total calculation

After
Dynamic Total Sales

Power BI SUMX Magic

SUMX(
Sales,
Sales[Quantity] * Sales[Price])

Row by row calculation
Cleaner dashboards
Advanced BI skill

Save this for later
Share with Power BI learners

24/02/2026

Dependent List in 1 Formula 🔥

Excel can auto-generate city list 😎

Use:

=UNIQUE(FILTER(Table1[City],Table1[State]=O1))

Select state
Filter cities
Remove duplicates
Fully dynamic

Save this reel
Follow for daily Excel hacks



Before All years mixed together 😵After Only 2024 Sales 😍Power BI DAX TrickCALCULATE( SUM(Sales[Amount]), Sales[Yea...
24/02/2026

Before
All years mixed together 😵

After
Only 2024 Sales 😍

Power BI DAX Trick

CALCULATE(
SUM(Sales[Amount]),
Sales[Year] = 2024
)

Change filter context
Get precise insights
Pro BI skill

Save this
Share with BI learners

20/02/2026

Check 2 Conditions in 1 Formula 🔥

Excel can check TWO things at once 😎

Use this:

=IF(AND(D2>=E2,C2="Sales"),"Bonus","")

Target achieved
Department = Sales
Both TRUE → Bonus

That’s IF + AND 🔥

Save this reel
Follow for daily Excel hacks 💚



18/02/2026

Need to calculate employee bonus automatically in Excel? 💰

Use this Nested IF formula:

=IF(D2>=E2*1.2,5000,IF(D2>=E2,2000,"Not Eligible"))

Excel checks:
First condition
Second condition
Otherwise result

Perfect for:
Incentives
Commission
Performance grading

Smart logic. Powerful reporting



17/02/2026

Sohan Dey GyanOnTube:
Nested IF Made Simple

Excel can calculate bonus automatically

=IF(D2>=E2*1.2,5000,IF(D2>=E2,2000,"Not Eligible"))

Above 120% → 5000
Above 100% → 2000
Below Target → Not Eligible

That’s Nested IF

Save this reel
Follow for daily Excel tricks



Before Counting days manually After Instant working days calculation =NETWORKDAYS(A2,B2)No manual countingAccurate resul...
17/02/2026

Before
Counting days manually

After
Instant working days calculation

=NETWORKDAYS(A2,B2)

No manual counting
Accurate results
Perfect for HR & projects

Save this
Share with Excel learners

Address

Dwarka
Delhi
110059

Website

Alerts

Be the first to know and let us send you an email when Gyan On Tube posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Gyan On Tube:

Shortcuts

Share