Excel Sessions @saurabhjain70 - Tumblr Blog

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

Mail Merge Personalized email

https://youtu.be/YVfTCK31yVk

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

How to skip Conditional Formatting for blank Cells

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!

#youtube

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.

#youtube

How to use double lookup values in VLOOKUP function

#youtube

How to count Distinct Values in a list in Excel

#youtube #excel #excelfunctions #microsoft excel #excel formulas #excel tricks #excel tutorial #excel tips #ms excel

VLOOKUP with INDIRECT function

#youtube #excel #excel training #microsoft excel #ms excel #exceltricks #exceltraining #learn excel #vlookup #indirect

How to extract date or time from Date Time in Excel

#youtube #excel #excel training #microsoft excel #ms excel

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

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

#excel #excel training #microsoft excel #excel tutorial #ms excel #excel formulas #learn excel #excel tips #excel spreadsheet

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

#excel #excel training #microsoft excel #ms excel #excel tutorial #excel tips #learn excel #excel spreadsheet #excel formulas

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