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

0:05:47

Assigning Unique ID to list of values which are either sorted or unsorted using 3 formulae

1:34:42

Excel Basics Training Session (20-Oct-2023) Unedited

0:46:19

Excel Setup for High productivity, QAT & Ribbon customization

0:01:57

Pasting multiple copied contents at once in Excel

0:06:36

Excel Power Tips to Work Smarter 1 to 4

0:03:15

Dynamic Numbering of List using Sequence function in Excel

0:06:35

Recording and Editing Macro to create 100's of Excel Sheet copies (Macro with VBA)

0:09:56

How to Identify Numbers that Add Up to a Specific Value using Solver Add-in of Excel

0:06:02

How to use Use Excel IFS Function (Alternate to nested IF ELSE)

0:08:03

3 Free Excel Add-Ins which helps in making better Dashboards and Reports (Video Player, QR Code etc)

0:14:00

Part 6 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:12:27

Part 5 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:10:31

Part 4 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:06:07

Part 3 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:08:43

Part 2 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:08:06

Part 1 of Top 30 Advanced Pivot Table hacks (Tips & Tricks) For Microsoft Excel

0:00:59

How to rotate chart using Camera tool in Excel - Useful while building dashboards

0:00:44

How to get Current Date & Time in Excel using Formula and Shortcuts (Both Dynamic & Constant)

0:00:59

How to create Sales Report & Chart Using Pivot Tables in less than a minute

0:00:59

How to create chart within a single cell to represent data from a range of cells - Spark line chart

0:01:00

How to keep the Top rows or left columns without scrolling - Use of Freeze Pane option

0:00:49

Transpose - Interchanging the Rows and Columns

0:00:58

How to Create Dual Axes Combo Charts in Excel (Display Sales & Profit % on 2 different scales)

0:00:51

How to create Hyperlinks in Excel to Navigate easily within and outside Excel