Все публикации

FLASH FILL |0:14:25

FLASH FILL | AI Based Auto-Fill Tool in Excel

Calculate difference between0:07:55

Calculate difference between Dates | DATEDIF

Conditional SUMPRODUCT |0:16:45

Conditional SUMPRODUCT | Multiple Criteria based SUMPRODUCT | Use SUMPRODUCT to SUM and COUNT

Extract Only Text0:06:52

Extract Only Text from any String | Data cleaning Techniques

Extract Numbers from0:07:12

Extract Numbers from any String | Data Cleaning Techniques

SOLVER in Excel0:05:13

SOLVER in Excel | Real Life Example | 5 Minute Tutorial | Multiple Criteria Goal Seek

Excel Keyboard Shortcuts0:03:17

Excel Keyboard Shortcuts - CTRL + Alphabet Keys (A-Z)

Unstack Column with0:07:43

Unstack Column with Formulas | 2 Ways - Dynamic Array & Non Dynamic Array Formulas

Excel Printing Tips0:10:20

Excel Printing Tips | 10 Tips to Solve Printing Problems in Excel | Don't Miss Last One!

Unstack Column through0:07:17

Unstack Column through Power Query | Convert Stacked Column back to Table or Matrix Format

Unpivot Data |0:08:45

Unpivot Data | Part-2 | Convert Matrix Format Report having Multiple Header Rows back to Table Form

Unpivot Data |0:09:03

Unpivot Data | Part-1 | Convert Matrix Format Report back to Tabular Form

Highlight Active Row,0:11:35

Highlight Active Row, Column and Cell with Active CTRL+Z | Solution without Clearing Clipboard

Merge Data from0:13:39

Merge Data from Multiple Sources in Single Excel File | Combine Data Using Power Query

Searchable Dropdown List0:14:28

Searchable Dropdown List in Excel | 2 Methods | Without Dynamic Arrays & With Dynamic Arrays

Combine Multiple Excel0:08:53

Combine Multiple Excel Files to One | Power Query | No Copy Paste | Append directly to Pivot Table

SOLVER in Excel0:08:34

SOLVER in Excel | Multiple Criteria Goal Seek | Step by Step Explanation | Real Life Examples

EXCEL Shortcuts Part-110:00:59

EXCEL Shortcuts Part-11 | CTRL + Alphabet Keys N-Z

New Year Calendar0:12:01

New Year Calendar | 8100 Year Calendar in Excel | 2021 Calendar | Just 1 Formula to Make Calendar

EXCEL Shortcuts Part-100:00:59

EXCEL Shortcuts Part-10 | Ctrl + Alphabet Keys (A-M)

11 Text Formatting0:12:35

11 Text Formatting Tips in Excel | Time Saving Expert Level Tips & Tricks to Format Text

EXCEL Shortcuts Part-90:00:54

EXCEL Shortcuts Part-9 | Ctrl + Shift + Numeric Keys

LET Function |0:21:14

LET Function | New Function in EXCEL 365 | Define Variables for Calculations inside Formula

EXCEL Shortcuts Part-80:00:59

EXCEL Shortcuts Part-8 | Ctrl + Numeric Keys