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

0:02:27

Excel - How to show all Pivot Table options in new sheets

0:14:46

Excel - How to create automated dividend calendar

0:02:11

Excel - Case sensitive lookup

0:04:30

Excel - Lookup with multiple criteria

0:05:55

Excel - How to create hyperlink to specific cell based on multiple criteria

0:01:51

Excel - How to create all possible unique pairs from two lists

0:00:59

Excel Jokes

0:02:05

Excel - How to insert blank rows to your table

0:03:01

Excel - How to calculate streak (Years of dividend increases)

0:01:52

How to Import tables from PDF to Excel

0:02:45

Excel - How to add more links into one cell

0:04:30

Excel - How to check if stock is 100 bagger

0:01:40

Excel - How to SUM same cell from multiple sheets

0:01:51

Excel - How to find cell with value in table full of formulas

0:05:21

Excel - How to consolidate multiple tables

0:00:56

Excel - How to quickly copy thousands of rows

0:02:03

How to list all sheets. Hide, unhide or make sheet very hidden.

0:02:18

Excel - How to add picture into comment

0:02:08

Excel - How to use line breaks to split cell content

0:01:51

Excel - How to prepare for New Year (quick ways to update year)

0:02:09

Excel - How to reverse cells order

0:03:32

Excel - How to use absolute reference in Excel Tables

0:03:40

Excel - How to find & highlight TOP 5 & BOTTOM 5

0:04:33

Excel - How to use indent to transform hierarchy into table