Excel Busn Math 07: When ROUND function Is Required
by
ExcelIsFun
on
Youtube
Duration:
0.15 hours
See when to use the ROUND function for Math Calculations: 1)You are multiplying or Dividing Decimals 2)When you are required to ROUND (Money Requires ...
See how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles. Basic Statistics. Quartile divides a data set into 4 ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 251 Formula Unique List within Unique List
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to create a Unique List of Customers within a Unique List of Sales Reps using a series of standard Formulas and Array Formulas. See the functions ...
See how to create a Waterfall Profit Chart using a Stacked Column Chart, some formulas to create a second data set, and adding No Fill as a color to the second ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick # 252: Text Cell Range In A Function
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to use a cell range typed into a cell in a function. If I was counting the number of times the word "Rad" was in the range B13:B20, and B13:B20 was in ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 257 Convert Dates as Text to Dates As No.
by
ExcelIsFun
on
Youtube
Duration:
0.08 hours
Dates As text will cause problems in a Pivot Table (PivotTable). See how to convert Dates as Text to Dates As Numbers so that you can group dates by month ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 253: Data Table 1 Variable What If Analysis
by
ExcelIsFun
on
Youtube
Duration:
0.16 hours
See how to use a Data Table for 1 variable for what if analysis. See the PMT function. See the Formula equivalent to a Data Table. Other What If Analysis videos: ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
by
ExcelIsFun
on
Youtube
Duration:
0.13 hours
See how to create a 2 Two Variable Data Table in Excel (What If Analysis). See the PMT function. See the Formula equivalent to a Data Table. Other What If ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick # 258: Chart From Noncontiguous Data
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
When Making Charts, The data series do not have to be next to each other, and they sometimes can even be different sizes. The axis labels should be to the left ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Magic Trick # 254: Data Table Creates 100 Formulas
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to create a Contribution Margin Income Statement Analysis across various units using a 1 Variable Data Table (What if analysis). See how to create 5 ...
