InfiniteSkills Advanced Microsoft Excel 2013 | FA2CFEC56C5DE21D85BAEED53D18002C44088357

InfiniteSkills Advanced Microsoft Excel 2013

Name	InfiniteSkills.Advanced.Microsoft.Excel.2013	DOWNLOAD Copy Link
Total Size	1.7 GB
Total Files	306
Hash	FA2CFEC56C5DE21D85BAEED53D18002C44088357

/
1501.What Is A PivotTable.mp4	25.9 MB
1103.Conditional Evaluation With No IFs.mp4	25.4 MB
0601.Working With Time In Excel.mp4	24.6 MB
1003.FIND And MID Text Functions Working Together.mp4	24.5 MB
1004.CONCATENATE Building Strings From Multiple Cells.mp4	24.1 MB
1002.LEN And TRIM String Extractions.mp4	23.5 MB
1514.PivotTable Styles.mp4	23.0 MB
1816.Add An Are You Sure Box To Macros.mp4	22.5 MB
1201.Using The MATCH Function.mp4	21.8 MB
0801.Setting Up A Set Of Scenarios.mp4	21.6 MB
1515.Creating Your Own PivotTable Styles.mp4	21.5 MB
1007.Use Of CHAR Function For More Obscure Characters.mp4	21.2 MB
1518.Adding And Using The Data Slicer.mp4	20.6 MB
0402.VLOOKUP In Live Action.mp4	20.5 MB
0703.Editing And Removing Outlining.mp4	19.9 MB
0407.Lookups Nested Within Lookups.mp4	19.8 MB
1503.Creating Your Own PivotTables.mp4	19.1 MB
0406.Managing The Lookup Table.mp4	19.1 MB
1307.The CELL Function And Determining File Or Sheet Names.mp4	19.0 MB
1502.The New Recommended PivotTable Route.mp4	18.7 MB
1508.Sorting The PivotTable Columns.mp4	18.4 MB
0302.Nesting The IF Statement.mp4	18.2 MB
1403.Auditing Tools Error Checking And Tracing.mp4	18.2 MB
1513.Dealing With Empty Cells And Other Additional Options.mp4	17.9 MB
0301.IF Syntax And Uses.mp4	17.9 MB
1511.Multiple Fields In Row, Column, Or Data Sections.mp4	17.8 MB
1505.Creating Multiple PivotTables On The Same Dataset.mp4	17.8 MB
1006.REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4	17.7 MB
1815.View And Edit Macro Code.mp4	17.6 MB
1008.Formatting Numeric And Date Values Using TEXT.mp4	17.4 MB
1304.OFFSET Function Creating A Dynamic Named Range.mp4	17.4 MB
0206.Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4	17.3 MB
1302.Error Checking Using ISERR, ISERROR, And IFERROR.mp4	17.1 MB
1603.Formatting The PivotChart.mp4	16.9 MB
1104.The Array-Only TRANSPOSE Function.mp4	16.8 MB
1810.Switch Scenarios And Views With Macros.mp4	16.3 MB
0303.Use Of The AND Operator Within An IF.mp4	16.1 MB
1102.Array Formulas With IF Statements.mp4	16.1 MB
1517.Using The New Timeline Filter Option.mp4	16.0 MB
1512.Controlling Grand Totals And Subtotals.mp4	16.0 MB
1205.MATCH And INDEX Functions Working Together.mp4	15.8 MB
1202.How The INDEX Function Works.mp4	15.7 MB
1507.Making Use Of The Report Filter Options.mp4	15.6 MB
0805.Producing A Summary Of Scenarios.mp4	15.4 MB
1519.Using Data From An SQL Server In A PivotTable.mp4	15.3 MB
1504.Changing The Formatting And Formulas In PivotTable Summaries.mp4	15.3 MB
1001.LEFT And RIGHT Text Manipulation.mp4	15.3 MB
0403.HLOOKUP Variation On A Theme.mp4	14.9 MB
1811.Use Of Worksheet Buttons To Trigger Macros.mp4	14.8 MB
1813.Assigning Macros To Ribbon Icons.mp4	14.7 MB
0501.Creating A Sparkline.mp4	14.4 MB
1101.Arrays And Creating A New Array Formula.mp4	14.4 MB
0606.Generate And Use A Random Number.mp4	14.3 MB
1005.Changing Case Functions.mp4	14.1 MB
1703.Using Solver To Complete A What-If.mp4	14.0 MB
1510.Drilling Down Behind The Pivot Numbers.mp4	14.0 MB
1607.Moving And Deleting PivotCharts.mp4	13.9 MB
1812.Customizing Form Buttons And Other Shape Triggers.mp4	13.8 MB
0203.SUMIF For Selective Adding Up.mp4	13.8 MB
0803.How To Work Out Which Scenario You Are Displaying.mp4	13.7 MB
0405.Dealing With Missing Data In A Lookup.mp4	13.7 MB
1405.Using The Watch Window In Troubleshooting.mp4	13.7 MB
0607.Loan And Investment Calculations.mp4	13.5 MB
1604.Changing The PivotChart Type.mp4	13.3 MB
0306.Display Cell Formulas In Another Cell.mp4	13.2 MB
0104.The Very Clever Flash Fill.mp4	13.1 MB
1516.Creating And Using Calculated Fields.mp4	13.0 MB
0903.Editing And Deleting Custom Views.mp4	12.8 MB
1401.What Are Tracer Arrows.mp4	12.7 MB
0502.Altering The Design Of Sparklines.mp4	12.7 MB
1802.Creating And Running Your First Macro.mp4	12.7 MB
0401.VLOOKUP Syntax And Usage.mp4	12.6 MB
0902.Use Of Outlining To Help Setup Custom Views.mp4	12.4 MB
1009.Keeping The Values Created By String Manipulation.mp4	12.4 MB
1305.INDIRECT Function To Build Dynamic Formulas.mp4	12.4 MB
1602.Changing The Fields Used In A PivotChart.mp4	12.2 MB
1506.Moving And Deleting PivotTables.mp4	12.2 MB
0603.Useful Time And Date Functions.mp4	12.1 MB
1601.Creating A PivotChart.mp4	12.1 MB
1704.Adding Constraints To Solver.mp4	11.9 MB
0504.Comparing Sparklines Within A Sparkline Group.mp4	11.7 MB
0605.MOD And INT Functions And Uses.mp4	11.5 MB
0602.Calculations Using Time.mp4	11.4 MB
0804.Merging And Deleting Scenarios.mp4	11.4 MB
0904.Add Quick Access To Custom Views.mp4	11.3 MB
0305.The NOT Operator Within AND And OR Statements.mp4	11.2 MB
1404.Step-By-Step Formula Processing.mp4	11.2 MB
1804.Macro Security Settings For Workbooks With Macros.mp4	11.0 MB
1303.OFFSET Function Syntax.mp4	10.9 MB
0604.Rounding Decimal Places.mp4	10.9 MB
0702.Adding An Outline Manually.mp4	10.9 MB
1509.Refreshing A PivotTable.mp4	10.7 MB
1605.Filtering A PivotChart.mp4	10.7 MB
0701.Create An Outline Automatically.mp4	10.5 MB
1204.The CHOOSE Lookup Function.mp4	10.4 MB
0608.Loan Calculation Elements And Functions.mp4	10.0 MB
1306.Dealing With INDIRECT Errors.mp4	10.0 MB
0304.Use Of The OR Operator Within An IF.mp4	10.0 MB
1203.Handling Out Of Range Index Requests.mp4	9.8 MB
0802.Displaying And Editing The Different Scenarios.mp4	9.7 MB
1814.Create Your Own Ribbon.mp4	9.7 MB
1809.Formatting With A Macro.mp4	9.6 MB
0404.Using A Near Match In The Lookup.mp4	9.4 MB
0201.The Basic SUM, COUNT, MIN, And MAX.mp4	9.4 MB
1520.Managing The External Connection To SQL Server.mp4	8.9 MB
1402.Adding And Removing Tracer Arrows.mp4	8.8 MB
1301.Introducing IS Functions.mp4	8.5 MB
0103.New For 2013 Its All In The Cloud.mp4	7.8 MB
0205.AVERAGEIF For The Mean Of Selected Cells.mp4	7.8 MB
1701.What-If Analysis Using Goal Seek.mp4	7.7 MB
0202.AVERAGE, MODE, MEAN, And MEDIAN.mp4	7.5 MB
1806.Deleting Macros.mp4	7.4 MB
0503.Dealing With Empty Cells.mp4	7.2 MB
0207.Area And Volume Calculations.mp4	7.1 MB
0204.COUNTIF For Selective Counting.mp4	7.0 MB
0901.Custom Views Explained.mp4	6.9 MB
1805.The Personal Macro Workbook.mp4	6.9 MB
1807.Use Of Relative Or Absolute Referencing.mp4	6.4 MB
0505.Removing Sparklines From A Worksheet.mp4	6.1 MB
1606.Hiding The PivotChart Buttons.mp4	5.9 MB
1803.Saving Workbooks With Macros.mp4	5.8 MB
1702.Activating The Solver Add-In.mp4	5.7 MB
1901.What Have I Learned.mp4	5.3 MB
0101.Will I Be Able To Keep Up.mp4	5.1 MB
1808.Trigger A Macro With A Keyboard Shortcut.mp4	5.0 MB
1801.What Is A Macro.mp4	4.2 MB
0102.Using The Included Files.mp4	3.0 MB
1902.About The Author.mp4	1.9 MB
/Working Files/Chapter 15/
sqlDataPivot.xlsx	236.4 KB
sqlDataPivotTable.xlsx	236.4 KB
sqlDataPivotTable_Result.xlsx	236.4 KB
pivotTables.xlsx	73.4 KB
SalesInc2013_Pivot_TimeLine_result.xlsx	57.9 KB
SalesInc2013_Pivot.xlsx	57.5 KB
SalesInc2013_MorePivots.xlsx	56.7 KB
stockdata_CalculatedField_result.xlsx	54.8 KB
SalesInc2013_FormattedSummary-Result.xlsx	54.4 KB
SalesInc2013_withPivotResult.xlsx	53.9 KB
employees_PivotReportFilter_Result.xlsx	42.6 KB
SalesInc2013.xlsx	39.1 KB
employees_MultiplePivot_CustomStyle_Result.xlsx	37.4 KB
employees_MultiplePivot_sorted_Result.xlsx	37.4 KB
employees_MultiplePivot.xlsx	37.1 KB
employees_SinglePivot_result.xlsx	37.1 KB
employeesLargePivot_DataSlicer_Result.xlsx	36.3 KB
employees_MultipleRows_Result.xlsx	34.2 KB
employeesLargePivot_CustomStyle_Result.xlsx	34.1 KB
employeesLargePivot.xlsx	33.7 KB
employees_MultipleRows.xlsx	33.2 KB
stockdata.xlsx	33.2 KB
employees_withPivotResult.xlsx	32.8 KB
employees_MultiplePivot_MovedDeleted_result.xlsx	32.7 KB
employees_SinglePivot.xlsx	32.4 KB
employees.xlsx	21.8 KB
sqlConnection.txt	0.1 KB
/Working Files/Chapter 16/
SalesInc2013_PivotChart_Result.xlsx	61.2 KB
SalesInc2013.xlsx	61.1 KB
employeesPivotChart_Formatted_Result.xlsx	48.1 KB
employeesPivotChart_result.xlsx	47.8 KB
employeesPivotChart_ChartTypes_Result.xlsx	47.5 KB
employeesPivotChart_Filtered_Result.xlsx	47.4 KB
employeesPivotChart.xlsx	46.6 KB
employees.xlsx	21.8 KB
/Working Files/Chapter 4/
stockDataInternational_Result.xlsx	50.4 KB
stockDataInternational.xlsx	50.1 KB
missingData.xlsx	36.2 KB
TableManage_Result.xlsx	34.7 KB
TableManage.xlsx	34.3 KB
missingData_Result.xlsx	34.3 KB
stockdata_Vlookup_Result.xlsx	33.9 KB
stockdata.xlsx	33.1 KB
hlookup_result.xlsx	11.1 KB
hlookup.xlsx	10.6 KB
vlookup.xlsx	10.5 KB
vlookup_Result.xlsx	10.3 KB
dancers_Result.xlsx	10.0 KB
dancers.xlsx	9.4 KB
/Working Files/Chapter 13/
stockDataInternational_OFFSET_Result.xlsx	50.2 KB
stockDataInternational.xlsx	50.0 KB
errors_result.xlsx	10.9 KB
errors.xlsx	10.4 KB
sales2013_Indirect_Error_Result.xlsx	10.3 KB
sales2013_Indirect_Error.xlsx	10.3 KB
sales2013_Indirect_Result.xlsx	10.3 KB
sales2013_OFFSET_Result.xlsx	10.1 KB
sales2013.xlsx	10.0 KB
ExcelFilename_Result.xlsx	9.3 KB
is.xlsx	8.7 KB
ExcelFilename.xlsx	8.6 KB
/Working Files/Chapter 14/
stockDataInternational.xlsx	50.1 KB
sales2013_noArrows.xlsx	15.0 KB
sales2013.xlsx	15.0 KB
sales2013_Errors.xlsx	10.7 KB
sales2013_Errors_Result.xlsx	10.7 KB
/Working Files/Chapter 10/
stockdata_LenTrim_Result.xlsx	42.9 KB
stockdata_MID_FIND_Result.xlsx	36.7 KB
stockdata.xlsx	31.5 KB
employees_Concatentated.xlsx	28.7 KB
employees_concatenate_result.xlsx	28.4 KB
employees_CaseChange_Result.xlsx	27.8 KB
employees_Concatentated_Result.xlsx	27.8 KB
employees_TEXT_Result.xlsx	26.3 KB
employees_LeftRight_Result.xlsx	25.7 KB
employees_REPLACE_Result.xlsx	25.5 KB
employees_MID_FIND_Result.xlsx	24.2 KB
employees_LineFeed_Result.xlsx	22.9 KB
employees.xlsx	21.8 KB
Char_Function.xlsx	13.9 KB
/Working Files/Chapter 2/
SalesData2013_ResultsSUM.xlsx	36.9 KB
SalesData2013.xlsx	33.8 KB
FruitData_Results_AverageIF.xlsx	32.6 KB
FruitData_Result_SUMIF.xlsx	32.5 KB
FruitData_MultipleCriteria_Result.xlsx	32.5 KB
FruitData_Result_COUNTIF.xlsx	32.4 KB
FruitData_Results_Average.xlsx	32.2 KB
FruitData.xlsx	31.9 KB
FruitData_MultipleCriteria.xlsx	30.6 KB
shapes_Result.xlsx	10.3 KB
shapes.xlsx	9.8 KB
/Working Files/Chapter 18/
Scenarios_withButtons._Resultxlsm.xlsm	34.3 KB
Scenarios_withButtons.xlsm	24.0 KB
employees.xlsx	21.8 KB
CustomViews_withButtons_Result.xlsm	20.3 KB
CustomViews_withButtons.xlsm	20.1 KB
Scenarios.xlsm	18.5 KB
typemyname_EditedMacroResult.xlsm	17.7 KB
CustomViews.xlsm	16.6 KB
typemyname.xlsm	14.0 KB
sampleMacro.xlsm	13.2 KB
sampleMacro2013.xlsm	13.2 KB
CustomViews.xlsx	12.3 KB
Scenarios.xlsx	11.6 KB
sales_MacroFormatted_Result.xlsx	9.3 KB
sales.xlsx	9.1 KB
What Is A Macro.xlsx	8.4 KB
/Working Files/Chapter 11/
stockdata_ArraySummary_Result.xlsx	32.9 KB
stockdata_Array_Result.xlsx	32.7 KB
stockdata_ArraySummary.xlsx	32.2 KB
stockdata.xlsx	32.2 KB
employees_ARRAY_IF_Result.xlsx	22.3 KB
employees.xlsx	21.8 KB
staff_Result.xlsx	11.0 KB
staff.xlsx	9.6 KB
array_Result.xlsx	9.0 KB
array.xlsx	8.8 KB
/Working Files/Chapter 1/
sampledata_FlashFilled.xlsx	25.3 KB
sampledata.xlsx	21.8 KB
/Working Files/Chapter 8/
salesScenarioSummaries_Result.xlsx	19.8 KB
sales_withMultipleScenarios.xlsx	13.5 KB
sales_withMultipleScenarios_result.xlsx	13.5 KB
salesScenarioSummaries.xlsx	11.7 KB
sales_withScenarios.xlsx	11.6 KB
scenarioSales_Result.xlsx	11.4 KB
scenarioSales.xlsx	10.9 KB
/Working Files/Chapter 17/
FruitandSalesData2013_Solver1_Result.xlsx	16.4 KB
FruitandSalesData2013_Solver1.xlsx	14.0 KB
FruitandSalesData2013_Solver_Result.xlsx	14.0 KB
FruitandSalesData2013_GoalSeek_Result.xlsx	11.4 KB
FruitandSalesData2013.xlsx	11.4 KB
/Working Files/Chapter 9/
sales2013_CustomViewsResult.xlsx	12.5 KB
CustomViews_Result.xlsx	12.4 KB
CustomViews.xlsx	12.3 KB
sales2013_CustomViews.xlsx	12.3 KB
sales2013.xlsx	10.8 KB
/Working Files/Chapter 12/
salesStaff_Match_Result.xlsx	11.5 KB
salesStaff.xlsx	11.1 KB
sales2013_MATCH_INDEX_Result.xlsx	10.3 KB
sales2013_OutOfRange_Result.xlsx	10.2 KB
sales2013_CHOOSE_Result.xlsx	10.1 KB
sales2013_INDEX_Result.xlsx	10.1 KB
sales2013.xlsx	10.0 KB
fruitSales.xlsx	7.6 KB
/Working Files/Chapter 3/
nestedIfs.xlsx	11.3 KB
IF_Result.xlsx	11.3 KB
IF.xlsx	11.0 KB
AND-OR_ResultOR.xlsx	11.0 KB
AND-OR_ResultAnd.xlsx	10.9 KB
AND-OR.xlsx	10.7 KB
formulaDisplay_Result.xlsx	10.5 KB
NOT_Result.xlsx	10.4 KB
NOT.xlsx	10.2 KB
formulaDisplay.xlsx	10.0 KB
nestedIfs_Result.xlsx	10.0 KB
/Working Files/Chapter 6/
timeCalculations_Results.xlsx	10.9 KB
timeCalculations.xlsx	10.7 KB
timeData_Results.xlsx	10.6 KB
timeDateFunctions_Result.xlsx	10.1 KB
random_Result.xlsx	9.8 KB
random.xlsx	9.7 KB
mod_Result.xlsx	9.6 KB
loansAndSavings_Result.xlsx	9.4 KB
mod.xlsx	9.3 KB
timeData.xlsx	9.1 KB
loansPortions_Result.xlsx	9.0 KB
timeDateFunctions.xlsx	9.0 KB
loansPortions.xlsx	8.9 KB
rounding_result.xlsx	8.9 KB
loansAndSavings.xlsx	8.8 KB
rounding.xlsx	8.3 KB
/Working Files/Chapter 5/
sparklines.xlsx	10.9 KB
FruitandSalesData_Sparklines_Result.xlsx	10.9 KB
FruitandSalesData_Sparklines.xlsx	10.6 KB
FruitandSalesData.xlsx	9.8 KB
/Working Files/Chapter 7/
sales2013_withOutlining.xlsx	10.3 KB
sales2013.xlsx	10.1 KB
/Working Files/
Working Files - README.txt	0.3 KB
Total files 306