03:14

Excel Vlookup visible (filtered) data

03:37

Excel avg excluding zeros on filtered (visible) data

02:21

Excel date converted into 3 letter month abbreviation

02:47

Excel fill non-repeated names and catch changes

04:02

Excel Conditional Formatting icon sets with a relative reference formula

03:52

Excel Finding duplicates across sheets

03:37

Excel Line Chart don't chart blanks

01:57

Excel Bar Chart Suppress Zeros

01:57

Excel not sorting correctly (off of a formula)

03:03

Excel info comments visible after scrolling with frozen panes

04:40

Excel Finding (Counting) Errors

01:32

Excel formatting calculated numbers joined onto text

03:40

Excel Numbers or Text; calculations not working

02:30

Excel conditional formatting based on a formula

03:51

Excel sum numbers in the same cell as text

03:08

Excel Ratio's

02:56

Excel adding a drop down / combo box

08:12

Excel Setting Sales Quota (Goal; Objective)

03:47

Excel Employee Performance Ranking

04:11

Excel Sumifs visible (filtered) data

03:46

Excel Countifs visible (filtered) data

03:20

Excel Countif visible (filtered) data

05:25

Excel rank visible (filtered) data

02:41

Excel sum based on multiple criteria using Sumifs

01:38

Excel sum based on one criteria using Sumif

02:47

Excel correct data entry via data validation

05:14

Excel hours worked

03:42

Excel conditional formatting on target value

06:43

Excel Working Days

04:53

Excel sum every nth value

03:14

Excel date conversion

05:20

Excel chart just the newest data

05:31

Excel 80 20 rule unaffected by sorting

04:34

Excel upper lower limit intersection using Vlookup / Match combo

08:01

Excel scrolling chart

02:53

Excel sum actuals versus forecast using Sum Offset combo

03:13

Excel moving average using Avg Offset combo

01:34

Excel multiple rows of autofilters

02:51

Excel Sort Switch

04:02

Excel small if based on a condition (s)

02:06

Excel sumif wildcard

05:34

Excel extract first middle and last name

06:03

Excel Top 50

03:04

Excel resizing the scroll bar handle

03:22

Excel create a unique identifier for a VLookup

03:31

Excel Vlookup not working

02:37

Excel making a product list consistent using substitute

04:54

Excel identify changes in lists using match

02:46

Excel making the same changes on multiple tabs

01:01

Excel delete shapes / objects

02:41

Excel change column data to row data (Transpose)

08:44

Excel consolidate comments onto one file

05:51

Excel dollars to percentage switch with alerts

05:17

Excel Date Stamp Conversion

04:38

Excel Indirect to update range

01:23

Excel count used cells

04:15

Excel Offset to update range dynamically

04:36

Excel Index to update range dynamically

04:19

Excel Vlookup Dynamic 3rd Argument (drag-able)

03:11

Pivot Table Grand Totals to the top