EXCEL data Untelligence
Excel Video Tutorials and Datasets
Learn the Filter Function in Excel. Including how to use the Filter Function with conditional requirements such as :
=Filter(And)
=Filter(Or)
=Filter(Contains)
=Filter(Does Not Contain)
=Filter(Columns)
=Filter(Across Multiple Sheets)
Learn how to create CHARTS and GRAPHS in EXCEL. Videos for beginners, Intermediate and Advanced :
Bar and Column Charts
Pie Charts
Advance Combination Charts
Dynamic and Auto-updating Charts
Learn some of the most popular excel functions, with some more advanced ones thrown in the mix… Including :
=IF
=IF(Contains)
=SUMIF, =SUMIFS
=SUMIF(Contains)
=COUNTIF
=VLOOKUP
=FIRSTWORD
=LASTWORD
=RANK
=RANK(UNIQUE)
=COUNTIF(S)
=ADD(Months)