Videos from “ExcelIsFun” (25 video results)
See Mr Excel and excelisfun take math formulas stored as text and evaluate then using three methods: VBA, Excel 4 Macro Function or the MoreFunc add-in. See how to create ...
Learn about Pivot Tables, SUMIF function, COUNTIF function and SUMPRODUCT function. Learn about:
1.How SUMIF and COUNTIF cannot handle arrays and so the solution means that ...
We will try to answer the questions:
1.What is the Difference Between Array and Range?
2.What is an Array Formula?
3.When Do I Have To Use Ctrl + Shift + Enter?
Advanced ...
Abbreviated notes about Excel Data Analysis Raw Data, Sort, Filter, Subtotals, and Pivot Tables PivotTables. This is a video with hints for the Excel test in Business 216 ...
Abbreviated notes about Number Formatting. See how Number Formatting is like House Paint or a Halloween Mask. Learn about General, Number, Currency, ACCOUNTING, DATE and ...
See how to count the number of times in a list of times that begin with 7. Example 1:30, 7:00, 7:34, 6:00 would be a count of 2. See the functions HOUR, TEXT and SUMPRODUCT....
See how to construct a monthly cumulative sales total with a SUMIF function formula and a Pivot Table PivotTable.
See how to Multiply a Column Times a Row With TRANSPOSE Function.
Advanced Array Formula. See how to calculate the MODE and use the MODE to lookup a value using the functions LOOKUP, CHOOSE, MODE, MIN and IF.
See how to create a formula for calculating time worked when the time in and time out are entered into the same cell. This complicated formula comes from the fact that the ...
See how to use the AND and OR functions to test to see which records should be extracted in a Advanced Filter Data Dump on a new sheet.
See how to use the OFFSET function to avoid the #REF! error when rows are deleted. Learn about the default settings for the OFFSET function.
Learn about some common confusion between lookup and data extraction. See the LEFT and TRIM functions and adding zero to convert text to a number create the criteria for ...
See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his lookup with the MIN, IF, MATCH ...
This 50 minute video shows 15 examples of how to use Cell References:
1)Relative Cell References
2)Absolute Cell References
3)Mixed Cell References With Column Locked
4)Mixed ...
See Mr Excel and excelisfun do a three way lookup. Compare a method that uses INDEX, MATCH and OFFSET function to a second method that uses INDEX and MATCH but instead of ...
See how to use the new Excel 2010 NETWORKDAYS.INTL function that can deal counting workdays given a set of holidays and the fact that the weekend could be on any set of days....
See how to Count Workdays given a stat and end date, a number of holidays and the fact that the weekend could be any two days (weekends are not Saturday and Sunday).
See how to use the NETWORKDAYS Function for Counting Workdays when Saturday and Sunday are the weekend using a start date and end date. This function will take Holidays into ...
See how to use VLOOKUP when the first four columns of the lookup table must be used for the lookup value. The data is badly setup up because it is an import into Excel from ...
See how to take duplicate records listed vertically and list them horizontally using an array formula. See the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL, ROW functions....
See how to create an array formula to extract transaction records that have been completed using an arry formula. See the functions: COUNTIF, IF, ROWS, INDEX, SMALL, ROW ...
See how to use Custom Number Format to show values as rounded to thousands position and show the chacter k.
See how to use the COUNTIF function, Sort, Advanced Filter Extract Unique Records to find and extract duplicate records from a data set.
See how to count cells with a custom number format using the Excel 4 GET.CELL Macro Function.
Popular Keywords
Also Try: