saurabhjain70

[saurabhjain70]

Learn in 2 minutes - How to merge multiple worksheets into one worksheet in Excel.

[saurabhjain70]

Mail Merge Personalized email

https://youtu.be/YVfTCK31yVk

Learn in 5 minutes - How to send personalized email to multiple users

[saurabhjain70]

How to skip Conditional Formatting for blank Cells

[saurabhjain70]

This video will help you to understand AutoFilter function step by step. After watching video, you can automate filter functionality and copying filtered data to another sheet using VBA. So, watch the video till end!

[saurabhjain70]

In this video, I'm going to show you how to lookup with multiple conditions in Excel using the Index and match function. This is a great way to find specific information quickly and easily in your data sheets.

[saurabhjain70]

How to use double lookup values in VLOOKUP function

[saurabhjain70]

How to count Distinct Values in a list in Excel

[saurabhjain70]

VLOOKUP with INDIRECT function

[saurabhjain70]

How to extract date or time from Date Time in Excel

[saurabhjain70]

Type DATEDIF in Excel

AND

You will not get any information.

But you can use this function to calculate age or date difference.

How??

Watch this video and Learn in 5 minutes.

https://youtu.be/hSxXHjyfPCo

[saurabhjain70]

Learn all options of

Go To Special box in Excel

1. How to delete all objects used in sheet.

2. How to delete all blank rows.

3. How to identify cells with formula or constant value.

4. How to copy paste only visible cells/rows.

https://youtu.be/n7MFKyvgOZY

[saurabhjain70]

Fully automated Break sheet Tracker in Excel

# Login and Logout time

# Break durations

# Lunch break

# Log file to track all breaks

# Dashboard

# Save file for each week

https://youtu.be/X_n0LcmPv8A

[saurabhjain70]

We change parameters of VLookup if

1. Value from a different column is required. Or

2. A new row or column is added.

In this video, you learn how to make VLookup function dynamic so that VLookup function returns the data from a different column or a new row or column automatically.

https://youtu.be/2Jxll7wTlEk

[saurabhjain70]

Watch complete video if you are getting any of these issue

1. Are you getting #NA error when using VLOOKUP, even if data is available?

2. When VLOOKUP throws #REF error?

3. How to use VLOOKUP when data is in different sheet or different workbook?

4. How to handle #NA error when data is NOT Available?

https://youtu.be/lICuMYo45CU

[saurabhjain70]

Learn in 5 minutes

---------------------------------

How to convert text into Symbol in Excel cell

https://youtu.be/m5DEwu6sZs4

[saurabhjain70]

Learn Excel in 5 minutes

How to search data and highlight cells in Excel using Conditional formatting

https://youtu.be/iun9UxIP__4

[saurabhjain70]

Learn in 5 minutes

How to highlight missing values in a list using Conditional formatting

https://youtu.be/-kXWnIPCVGA