04:20

Excel - How to do Data validation with formula - checking the budget | Excel Tips 128

04:49

Excel - How to do Partial Lookup so lookup a part of longer phrase | Excel Tips 127

05:04

Excel - How to Find Last Value (not empty cell) | Excel Tips 126

05:39

Excel - How to insert icons with Conditional Formatting | Excel Tips 125

02:33

Excel - How to create step chart | Excel Tips 124

03:37

Excel - How to Group text in Pivot Table | Excel Tips 123

02:27

Excel - How to Group Dates by weeks in Pivot Table | Excel Tips 122

04:19

Excel - How to Group Dates in Pivot Table | Excel Tips 121

03:29

Excel - How to add Total Row to tables at the bottom and on the top of data | Excel Tips 120

10:38

Excel - How to Sort data based on values from drop down list and checkboxes | Excel Tips 119

03:16

Excel - How to add colors and shapes to number formatting | Excel Tips 118

02:17

Excel - How to show nanometers and other small and large units of measurements | Excel Tips 117

03:56

Excel - How to get partial match with FILTER function | Excel Tips 116

03:09

Excel - How to Choose function/summary based on value on a drop down list | Excel Tips 115

06:25

Excel - How to Nested IF | Excel Tips 114

04:37

Excel - How to Split text based on its length | Excel Tips 113

03:36

Excel - How to use text to columns command | Excel Tips 112

03:54

Excel - How to format number as thousands or millions | Excel Tips 111

05:05

Excel - How to create a chart based on drop down list | Excel Tips 110

02:46

Excel - How to Connect shape with value from a cell | Excel Tips 109

06:16

Excel - How to Count Unique Values with condition | Excel Tips 108

02:34

Excel - How to Count Unique Values | Excel Tips 107

08:55

Excel - Last number or text | Excel Tips 106

03:01

Excel - Conditional Formatting - Color scales | Excel Tips 105

02:58

Excel - Conditional Formatting - Data bars | Excel Tips 104

03:31

Excel - How to Sort by and add custom list | Excel Tips 103

04:59

Excel - Box and whisker chart | Excel Tips 102

03:39

Excel - The most frequent text - MODE.MULT function | Excel Tips 101

03:29

Excel - The most frequent number - MODE function | Excel Tips 100

01:16

Excel - lower, UPPER and Proper letters in words | Excel Tips 99

01:43

Excel - How to insert todays date and time - TODAY and NOW functions and shortcuts | Excel Tips 98

01:39

Excel - How to create DATE from Year, Month and Day | Excel Tips 97

07:05

Excel - How to Wrap rows and columns with a function | Excel Tips 96

02:45

Excel - How to create links in Excel | Excel Tips 95

02:17

Excel - How to Remove duplicates | Excel Tips 94

03:36

Excel - How to remove empty rows | Excel Tips 93

03:35

Excel - How to extract Quarter, Year, Month and Day from the date | Excel Tips 92

01:33

Excel - How to Freeze Panes to always see first row and column | Excel Tips 91

02:04

Excel - How to SUMIF with OR condition | Excel Tips 90

02:51

Excel - How to Merge cells without losing data | Excel Tips 89

03:56

Excel - How to protect cells with formulas | Excel Tips 88

03:34

Excel - How to find merged cells | Excel Tips 87

13:29

Excel - Find discount based on selected product and quantity | Challenge 03

05:33

Excel - How to customize Header and Footer while printing | Excel Tips 86

02:55

Excel - How to Fill Down values to empty cells | Excel Tips 85

12:52

Excel - How to split text to column - TEXTSPLIT Function | Excel Tips 84

08:45

Excel - TEXTAFTER and TEXTBEFORE Functions | Excel Tips 83

03:42

Excel - First and last Friday of the month WORKDAY.INTL | Excel Tips 82

02:07

Excel - How to Open New Excel Instance | Power Query 10

04:27

Excel - Sum values based on Year, SUMIF or SUMPRODUCT functions | Excel Tips 81

14:05

Excel Lookup based on 2 conditions, first and n-th occurrence | Challenge 02

02:57

Excel - Running total in tables | Excel Tips 80

02:46

Excel - Sum only visible cells | Excel Tips 79

09:20

Excel - How to Combine values from many sheets | Power Query 09

07:40

Excel - 3D Sum with INDIRECT function | Excel Tips 78

04:29

Excel - How to summarize by weekday | Power Query 08

04:17

Excel - How to summarize by weekday | Excel Tips 77

09:50

Excel - How Sum filtered data with condition | Excel Tips 76

03:21

Excel - Selection Pane/Selection Window | Excel Tips 75

01:27

Excel - Ribbon color/Office theme | Excel Tips 74