Excel 2013 Turorial | 89E39CF5B28B06FA4D664ED47C16CC1513B03FA5

Excel 2013 Turorial

Name	Excel 2013 Turorial	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.6 GB
Total Files	129
Hash	89E39CF5B28B06FA4D664ED47C16CC1513B03FA5

/06. Further Mathematical Functions/
06_01-Working With Time In Excel.mp4	24.7 MB
06_07-Loan And Investment Calculations.mp4	16.2 MB
06_06-Generate And Use A Random Number.mp4	15.1 MB
06_04-Rounding Decimal Places.mp4	14.1 MB
06_05-MOD And INT Functions And Uses.mp4	14.1 MB
06_03-Useful Time And Date Functions.mp4	13.0 MB
06_08-Loan Calculation Elements And Functions.mp4	12.0 MB
06_02-Calculations Using Time.mp4	10.6 MB
/18. Macros/
18_16-Add An Are You Sure Box To Macros.mp4	24.4 MB
18_15-View And Edit Macro Code.mp4	21.8 MB
18_11-Use Of Worksheet Buttons To Trigger Macros.mp4	19.5 MB
18_10-Switch Scenarios And Views With Macros.mp4	18.4 MB
18_12-Customizing Form Buttons And Other Shape Triggers.mp4	18.3 MB
18_13-Assigning Macros To Ribbon Icons.mp4	17.3 MB
18_02-Creating And Running Your First Macro.mp4	13.2 MB
18_09-Formatting With A Macro.mp4	13.0 MB
18_14-Create Your Own Ribbon.mp4	11.3 MB
18_04-Macro Security Settings For Workbooks With Macros.mp4	10.1 MB
18_06-Deleting Macros.mp4	9.9 MB
18_05-The Personal Macro Workbook.mp4	8.6 MB
18_07-Use Of Relative Or Absolute Referencing.mp4	8.4 MB
18_08-Trigger A Macro With A Keyboard Shortcut.mp4	6.3 MB
18_03-Saving Workbooks With Macros.mp4	5.6 MB
18_01-What Is A Macro.mp4	5.2 MB
/02. Using Mathematical Functions/
02_06-Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4	23.0 MB
02_03-SUMIF For Selective Adding Up.mp4	17.3 MB
02_01-The Basic SUM, COUNT, MIN, And MAX.mp4	10.2 MB
02_05-AVERAGEIF For The Mean Of Selected Cells.mp4	10.0 MB
02_02-AVERAGE, MODE, MEAN, And MEDIAN.mp4	9.5 MB
02_07-Area And Volume Calculations.mp4	9.3 MB
02_04-COUNTIF For Selective Counting.mp4	8.8 MB
/04. Performing Data Lookups/
04_02-VLOOKUP In Live Action.mp4	20.3 MB
04_07-Lookups Nested Within Lookups.mp4	16.7 MB
04_05-Dealing With Missing Data In A Lookup.mp4	13.9 MB
04_01-VLOOKUP Syntax And Usage.mp4	13.0 MB
04_06-Managing The Lookup Table.mp4	12.5 MB
04_03-HLOOKUP Variation On A Theme.mp4	12.0 MB
04_04-Using A Near Match In The Lookup.mp4	11.1 MB
/03. IF Functionality/
03_01-IF Syntax And Uses.mp4	19.8 MB
03_02-Nesting The IF Statement.mp4	19.0 MB
03_03-Use Of The AND Operator Within An IF.mp4	16.7 MB
03_05-The NOT Operator Within AND And OR Statements.mp4	12.9 MB
03_04-Use Of The OR Operator Within An IF.mp4	12.4 MB
03_06-Display Cell Formulas In Another Cell.mp4	10.7 MB
/13. Some Other Useful Functions/
13_07-The CELL Function And Determining File Or Sheet Names.mp4	18.8 MB
13_02-Error Checking Using ISERR, ISERROR, And IFERROR.mp4	16.2 MB
13_04-OFFSET Function Creating A Dynamic Named Range.mp4	13.1 MB
13_05-INDIRECT Function To Build Dynamic Formulas.mp4	11.5 MB
13_03-OFFSET Function Syntax.mp4	11.0 MB
13_01-Introducing IS Functions.mp4	10.5 MB
13_06-Dealing With INDIRECT Errors.mp4	9.2 MB
/08. Scenarios/
08_01-Setting Up A Set Of Scenarios.mp4	18.1 MB
08_04-Merging And Deleting Scenarios.mp4	10.6 MB
08_03-How To Work Out Which Scenario You Are Displaying.mp4	10.6 MB
08_05-Producing A Summary Of Scenarios.mp4	10.0 MB
08_02-Displaying And Editing The Different Scenarios.mp4	9.2 MB
/11. Arrays/
11_03-Conditional Evaluation With No IFs.mp4	17.8 MB
11_04-The Array-Only TRANSPOSE Function.mp4	16.1 MB
11_01-Arrays And Creating A New Array Formula.mp4	14.0 MB
11_02-Array Formulas With IF Statements.mp4	13.1 MB
/17. Goal Seek And Solver/
17_03-Using Solver To Complete A What-If.mp4	17.7 MB
17_01-What-If Analysis Using Goal Seek.mp4	10.1 MB
17_04-Adding Constraints To Solver.mp4	9.9 MB
17_02-Activating The Solver Add-In.mp4	5.2 MB
/10. Functions For Manipulating Text/
10_03-FIND And MID Text Functions Working Together.mp4	17.6 MB
10_02-LEN And TRIM String Extractions.mp4	16.3 MB
10_07-Use Of CHAR Function For More Obscure Characters.mp4	15.8 MB
10_04-CONCATENATE Building Strings From Multiple Cells.mp4	13.9 MB
10_08-Formatting Numeric And Date Values Using TEXT.mp4	13.1 MB
10_06-REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4	12.3 MB
10_01-LEFT And RIGHT Text Manipulation.mp4	12.1 MB
10_05-Changing Case Functions.mp4	10.5 MB
10_09-Keeping The Values Created By String Manipulation.mp4	8.6 MB
/07. Outlining/
07_03-Editing And Removing Outlining.mp4	17.3 MB
07_01-Create An Outline Automatically.mp4	10.6 MB
07_02-Adding An Outline Manually.mp4	8.7 MB
/12. Useful Data Functions/
12_01-Using The MATCH Function.mp4	17.0 MB
12_05-MATCH And INDEX Functions Working Together.mp4	13.1 MB
12_02-How The INDEX Function Works.mp4	13.0 MB
12_04-The CHOOSE Lookup Function.mp4	9.7 MB
12_03-Handling Out Of Range Index Requests.mp4	8.7 MB
/15. PivotTables/
15_03-Creating Your Own PivotTables.mp4	16.8 MB
15_07-Making Use Of The Report Filter Options.mp4	14.3 MB
15_18-Adding And Using The Data Slicer.mp4	14.2 MB
15_11-Multiple Fields In Row, Column, Or Data Sections.mp4	13.8 MB
15_08-Sorting The PivotTable Columns.mp4	13.4 MB
15_13-Dealing With Empty Cells And Other Additional Options.mp4	13.2 MB
15_05-Creating Multiple PivotTables On The Same Dataset.mp4	13.1 MB
15_14-PivotTable Styles.mp4	13.1 MB
15_12-Controlling Grand Totals And Subtotals.mp4	12.8 MB
15_19-Using Data From An SQL Server In A PivotTable.mp4	12.1 MB
15_04-Changing The Formatting And Formulas In PivotTable Summaries.mp4	11.9 MB
15_15-Creating Your Own PivotTable Styles.mp4	11.5 MB
15_17-Using The New Timeline Filter Option.mp4	11.4 MB
15_02-The New Recommended PivotTable Route.mp4	10.9 MB
15_01-What Is A PivotTable.mp4	10.1 MB
15_06-Moving And Deleting PivotTables.mp4	10.0 MB
15_16-Creating And Using Calculated Fields.mp4	9.8 MB
15_20-Managing The External Connection To SQL Server.mp4	7.3 MB
15_09-Refreshing A PivotTable.mp4	7.2 MB
15_10-Drilling Down Behind The Pivot Numbers.mp4	6.7 MB
/14. Auditing And Troubleshooting Formulas/
14_03-Auditing Tools Error Checking And Tracing.mp4	16.0 MB
14_01-What Are Tracer Arrows.mp4	11.7 MB
14_05-Using The Watch Window In Troubleshooting.mp4	11.3 MB
14_04-Step-By-Step Formula Processing.mp4	10.3 MB
14_02-Adding And Removing Tracer Arrows.mp4	8.2 MB
/16. PivotCharts/
16_03-Formatting The PivotChart.mp4	14.1 MB
16_04-Changing The PivotChart Type.mp4	13.5 MB
16_02-Changing The Fields Used In A PivotChart.mp4	12.6 MB
16_07-Moving And Deleting PivotCharts.mp4	12.3 MB
16_05-Filtering A PivotChart.mp4	11.4 MB
16_01-Creating A PivotChart.mp4	9.2 MB
16_06-Hiding The PivotChart Buttons.mp4	6.5 MB
/05. Sparklines/
05_01-Creating A Sparkline.mp4	12.9 MB
05_02-Altering The Design Of Sparklines.mp4	11.7 MB
05_04-Comparing Sparklines Within A Sparkline Group.mp4	11.4 MB
05_03-Dealing With Empty Cells.mp4	6.9 MB
05_05-Removing Sparklines From A Worksheet.mp4	6.3 MB
/01. Getting Started/
01_04-The Very Clever Flash Fill.mp4	12.2 MB
01_03-New For 2013 Its All In The Cloud.mp4	10.3 MB
01_01-Will I Be Able To Keep Up.mp4	6.0 MB
01_02-Using The Included Files.mp4	4.0 MB
/09. Custom Views/
09_03-Editing And Deleting Custom Views.mp4	11.9 MB
09_02-Use Of Outlining To Help Setup Custom Views.mp4	9.9 MB
09_04-Add Quick Access To Custom Views.mp4	9.2 MB
09_01-Custom Views Explained.mp4	8.6 MB
/19. Summary And Credits/
19_01-What Have I Learned.mp4	6.7 MB
19_02-About The Author.mp4	2.4 MB
/
Snap1.png	181.1 KB
Total files 129