Канал: Deepak Aaryan

Aggregate function (Calculate even in errors)

Aggregate function (Calculate even in errors)

Calculate Age, Month and Day

Calculate Age, Month and Day

Formatting with multiple Color into single cell

Formatting with multiple Color into single cell

Star Rating in excel

Star Rating in excel

INSERT BLANK ROW AFTER EVERY ROW

INSERT BLANK ROW AFTER EVERY ROW

Split last name

Split last name

Split first Name

Split first Name

2. Advance Filter & Slicer Dashboard

2. Advance Filter & Slicer Dashboard

1. MIS & Analytics Reporting || EXCEL

1. MIS & Analytics Reporting || EXCEL

Pick Top 5 Values

Pick Top 5 Values

Sum every Nth Column

Sum every Nth Column

EXCEL VBA #16: Insert Alternate Rows

EXCEL VBA #16: Insert Alternate Rows

EXCEL VBA #15: Send bulk emails using VBA and Outlook

EXCEL VBA #15: Send bulk emails using VBA and Outlook

EXCEL VBA #14: Delete All Comments at Once

EXCEL VBA #14: Delete All Comments at Once

EXCEL VBA #13: DATA SORTING

EXCEL VBA #13: DATA SORTING

Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

EXCEL VBA #12: UpperCase, ProperCase and LowerCase

EXCEL VBA #12: UpperCase, ProperCase and LowerCase

EXCEL VBA #11: POSITIONING(OFFSET Example)

EXCEL VBA #11: POSITIONING(OFFSET Example)

EXCEL VBA #10: Hide / Unhide multiple sheets at once

EXCEL VBA #10: Hide / Unhide multiple sheets at once

EXCEL VBA #9: For Loop Tutorial

EXCEL VBA #9: For Loop Tutorial

EXCEL VBA #8: Highlighting Cells Based On Value/Text

EXCEL VBA #8: Highlighting Cells Based On Value/Text

Excel VBA #7: CASE STATEMENTS

Excel VBA #7: CASE STATEMENTS

Excel VBA #6: IF THEN Statement (with ELSEIF & Looping in cells)

Excel VBA #6: IF THEN Statement (with ELSEIF & Looping in cells)

Variables in VBA #5 | Excel VBA Tutorial

Variables in VBA #5 | Excel VBA Tutorial

Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

Excel VBA Beginner - 4 (Functions)

Excel VBA Beginner - 4 (Functions)

Excel VBA Beginner - 3 (Msgbox Tutorial)

Excel VBA Beginner - 3 (Msgbox Tutorial)

Excel VBA Beginner - 2

Excel VBA Beginner - 2

Excel VBA Part 1 - Writing your First VBA Code

Excel VBA Part 1 - Writing your First VBA Code

How to Reverse or flip data range in Excel

How to Reverse or flip data range in Excel

How to sort Data through Functions || MS EXCEL

How to sort Data through Functions || MS EXCEL

How to Find Quarter of a Month || MS EXCEL

How to Find Quarter of a Month || MS EXCEL

How to Find Group Wise Rank

How to Find Group Wise Rank

#2 Count Functions in EXCEL

#2 Count Functions in EXCEL

#1 How to Calculate percentage, SUM, MIN And MAX

#1 How to Calculate percentage, SUM, MIN And MAX

Data Validation || MS - EXCEL

Data Validation || MS - EXCEL

What IF Analysis || Goal SEEK || Scenario Manager || Data Table

What IF Analysis || Goal SEEK || Scenario Manager || Data Table

How to Create a Dynamic Range || OFFSET || COUNTA

How to Create a Dynamic Range || OFFSET || COUNTA

How to Define a Name in Excel || Use of Define Name || Ranged Names

How to Define a Name in Excel || Use of Define Name || Ranged Names

Calculate Call Logs of SUNDAY

Calculate Call Logs of SUNDAY

How to find Top & Bottom 5 Value in Excel

How to find Top & Bottom 5 Value in Excel

How to Calculate Hours Worked in Excel

How to Calculate Hours Worked in Excel

Picture LOOKUP (Image Lookup) in Excel using Formulas

Picture LOOKUP (Image Lookup) in Excel using Formulas

How to Generate QR Code in EXCEL

How to Generate QR Code in EXCEL

AND & OR FUNCTION IN EXCEL

AND & OR FUNCTION IN EXCEL

How to Use ROW() & COLUMN() Functions In Excel

How to Use ROW() & COLUMN() Functions In Excel

How to Count a Specific Text within a Text

How to Count a Specific Text within a Text

Conditional Formatting with Formula

Conditional Formatting with Formula

HOW TO CALCULATE TAX ON OUR INCOME

HOW TO CALCULATE TAX ON OUR INCOME

How to Show Numbers in Thousands or Millions in Excel (really easy way)

How to Show Numbers in Thousands or Millions in Excel (really easy way)

TAX CALCULATE Using IF Function || MS EXCEL

TAX CALCULATE Using IF Function || MS EXCEL

Reverse Lookup WITH Vlookup + Choose Function in Excel

Reverse Lookup WITH Vlookup + Choose Function in Excel

Lookup Value with Two Column in EXCEL

Lookup Value with Two Column in EXCEL

ROUND, ROUNDDOWN, ROUNDUP, MROUND IN EXCEL

ROUND, ROUNDDOWN, ROUNDUP, MROUND IN EXCEL

HOW TO SUM EVERY NTH COLUMN IN EXCEL

HOW TO SUM EVERY NTH COLUMN IN EXCEL

How to Calculate Rank Excluding Blank Data

How to Calculate Rank Excluding Blank Data

Concatenate text based on criteria in EXCEL

Concatenate text based on criteria in EXCEL

How to Split Names in Excel || Data Learning HUB

How to Split Names in Excel || Data Learning HUB

How to Apply Conditional Formatting in Excel

How to Apply Conditional Formatting in Excel

How to Split Names in Excel || Data Learning HUB

How to Split Names in Excel || Data Learning HUB

How to Create a Container Chart in Excel || Data Learning HUB

How to Create a Container Chart in Excel || Data Learning HUB

How to Create a Effective COLUMN CHART

How to Create a Effective COLUMN CHART

how to Create a Drag Down list in Excel || Data Leaning HUB

how to Create a Drag Down list in Excel || Data Leaning HUB

SUMIF & SUMIFS || Data Learning HUB

SUMIF & SUMIFS || Data Learning HUB

DOUBLE VLOOKUP IN EXCEL || DATA LEARNING HUB

DOUBLE VLOOKUP IN EXCEL || DATA LEARNING HUB

WILDCARD CHARACTERS IN EXCEL || Data Learning HUB

WILDCARD CHARACTERS IN EXCEL || Data Learning HUB

TIPS & TRICKS || EASY TRANSPOSE & CALCULATION

TIPS & TRICKS || EASY TRANSPOSE & CALCULATION

How to Use Date Function || Data Learning HUB

How to Use Date Function || Data Learning HUB

Everything You Need To Know About Excel Tables || Data Learning HUB

Everything You Need To Know About Excel Tables || Data Learning HUB

Male & Female Infographics in Excel || Data Learning HUB

Male & Female Infographics in Excel || Data Learning HUB

SUM PRODUCT || ALTERNATE OF SUMPRODUCT || DATA LEARNING HUB

SUM PRODUCT || ALTERNATE OF SUMPRODUCT || DATA LEARNING HUB

PMT FUNCTION || LOAN EMI || DATA LEARNING HUB

PMT FUNCTION || LOAN EMI || DATA LEARNING HUB

TIPS & TRICKS || REPT FUNCTION || Data Learning HUB

TIPS & TRICKS || REPT FUNCTION || Data Learning HUB

How to create a Login Form in Excel || Data Learning HUB

How to create a Login Form in Excel || Data Learning HUB

Transfer Data from One Sheet to Another || Data Learning HUB

Transfer Data from One Sheet to Another || Data Learning HUB

Split Data into Multiple Sheets | Data Learning Hub

Split Data into Multiple Sheets | Data Learning Hub

Data Entry Form - NO Macro/VBA || Data Learning HUB

Data Entry Form - NO Macro/VBA || Data Learning HUB

MS EXCEL - HLOOKUP (PART - 2) || Data Learning Hub

MS EXCEL - HLOOKUP (PART - 2) || Data Learning Hub

Dependent Drop Down LIST || Data Learning Hub

Dependent Drop Down LIST || Data Learning Hub

MS EXCEL - HLOOKUP || Data Learning Hub

MS EXCEL - HLOOKUP || Data Learning Hub

MS EXCEL - SHORTCUT KEYS || Data Learning Hub

MS EXCEL - SHORTCUT KEYS || Data Learning Hub

MS Excel - Pivot Table || Data Learning Hub

MS Excel - Pivot Table || Data Learning Hub

Mail Merge in Excel || Data Learning Hub

Mail Merge in Excel || Data Learning Hub

How to use Index Match In Excel || Data Learning Hub

How to use Index Match In Excel || Data Learning Hub

MS EXCEL - NUMBER FORMATTING || Data Learning Hub

MS EXCEL - NUMBER FORMATTING || Data Learning Hub

VLOOKUP WITH IF & Match FUNCTIONS || Data Learning Hub

VLOOKUP WITH IF & Match FUNCTIONS || Data Learning Hub

VLOOKUP WITH EXACT MATCH || Data Learning Hub

VLOOKUP WITH EXACT MATCH || Data Learning Hub

MS EXCEL - IF FUNCTION || Data Learning Hub

MS EXCEL - IF FUNCTION || Data Learning Hub

Operations Like sum, average and etc in Excel excluding errors || Data Learning Hub

Operations Like sum, average and etc in Excel excluding errors || Data Learning Hub