InfiniteSkills Advanced Microsoft Excel 2013

seeders: 23
leechers: 6
Added on August 4, 2013 by EliteBeastin Other > Tutorials
Torrent verified.



InfiniteSkills Advanced Microsoft Excel 2013 (Size: 1.62 GB)
 sqlDataPivot.xlsx230.83 KB
 sqlDataPivotTable.xlsx230.83 KB
 sqlDataPivotTable_Result.xlsx230.82 KB
 pivotTables.xlsx71.65 KB
 SalesInc2013_Pivot_TimeLine_result.xlsx56.55 KB
 SalesInc2013_Pivot.xlsx56.11 KB
 SalesInc2013_MorePivots.xlsx55.36 KB
 stockdata_CalculatedField_result.xlsx53.48 KB
 SalesInc2013_FormattedSummary-Result.xlsx53.12 KB
 SalesInc2013_withPivotResult.xlsx52.67 KB
 SalesInc2013_PivotChart_Result.xlsx59.76 KB
 SalesInc2013.xlsx59.7 KB
 employeesPivotChart_Formatted_Result.xlsx46.95 KB
 employeesPivotChart_result.xlsx46.67 KB
 employeesPivotChart_ChartTypes_Result.xlsx46.37 KB
 employeesPivotChart_Filtered_Result.xlsx46.33 KB
 employeesPivotChart.xlsx45.46 KB
 employees.xlsx21.33 KB
 stockDataInternational_Result.xlsx49.21 KB
 stockDataInternational.xlsx48.93 KB
 missingData.xlsx35.4 KB
 TableManage_Result.xlsx33.91 KB
 TableManage.xlsx33.49 KB
 missingData_Result.xlsx33.46 KB
 stockdata_Vlookup_Result.xlsx33.08 KB
 stockdata.xlsx32.37 KB
 hlookup_result.xlsx10.85 KB
 hlookup.xlsx10.38 KB
 stockDataInternational_OFFSET_Result.xlsx49.05 KB
 stockDataInternational.xlsx48.84 KB
 errors_result.xlsx10.66 KB
 Errors.xlsx10.13 KB
 sales2013_Indirect_Error_Result.xlsx10.09 KB
 sales2013_Indirect_Error.xlsx10.05 KB
 sales2013_Indirect_Result.xlsx10.05 KB
 sales2013_OFFSET_Result.xlsx9.88 KB
 sales2013.xlsx9.81 KB
 ExcelFilename_Result.xlsx9.04 KB
 stockDataInternational.xlsx48.91 KB
 sales2013_noArrows.xlsx14.63 KB
 sales2013.xlsx14.62 KB
 sales2013_Errors.xlsx10.44 KB
 sales2013_Errors_Result.xlsx10.43 KB
 stockdata_LenTrim_Result.xlsx41.91 KB
 stockdata_MID_FIND_Result.xlsx35.86 KB
 stockdata.xlsx30.75 KB
 employees_Concatentated.xlsx28.05 KB
 employees_concatenate_result.xlsx27.71 KB
 employees_CaseChange_Result.xlsx27.11 KB
 employees_Concatentated_Result.xlsx27.1 KB
 employees_TEXT_Result.xlsx25.64 KB
 employees_LeftRight_Result.xlsx25.1 KB
 employees_REPLACE_Result.xlsx24.91 KB
 SalesData2013_ResultsSUM.xlsx36.03 KB
 SalesData2013.xlsx33 KB
 FruitData_Results_AverageIF.xlsx31.86 KB
 FruitData_Result_SUMIF.xlsx31.72 KB
 FruitData_MultipleCriteria_Result.xlsx31.72 KB
 FruitData_Result_COUNTIF.xlsx31.67 KB
 FruitData_Results_Average.xlsx31.41 KB
 FruitData.xlsx31.14 KB
 FruitData_MultipleCriteria.xlsx29.92 KB
 shapes_Result.xlsx10.04 KB
 shapes.xlsx9.61 KB
 Scenarios_withButtons._Resultxlsm.xlsm33.5 KB
 Scenarios_withButtons.xlsm23.43 KB
 employees.xlsx21.33 KB
 CustomViews_withButtons_Result.xlsm19.8 KB
 CustomViews_withButtons.xlsm19.62 KB
 Scenarios.xlsm18.07 KB
 typemyname_EditedMacroResult.xlsm17.31 KB
 CustomViews.xlsm16.2 KB
 typemyname.xlsm13.66 KB
 sampleMacro.xlsm12.93 KB
 stockdata_ArraySummary_Result.xlsx32.15 KB
 stockdata_Array_Result.xlsx31.96 KB
 stockdata_ArraySummary.xlsx31.46 KB
 stockdata.xlsx31.46 KB
 employees_ARRAY_IF_Result.xlsx21.74 KB
 employees.xlsx21.33 KB
 staff_Result.xlsx10.72 KB
 staff.xlsx9.39 KB
 array_Result.xlsx8.74 KB
 Array.xlsx8.63 KB
 sampledata_FlashFilled.xlsx24.67 KB
 SampleData.xlsx21.33 KB
 salesScenarioSummaries_Result.xlsx19.36 KB
 sales_withMultipleScenarios.xlsx13.17 KB
 sales_withMultipleScenarios_result.xlsx13.14 KB
 salesScenarioSummaries.xlsx11.41 KB
 sales_withScenarios.xlsx11.36 KB
 scenarioSales_Result.xlsx11.17 KB
 scenarioSales.xlsx10.6 KB
 FruitandSalesData2013_Solver1_Result.xlsx15.99 KB
 FruitandSalesData2013_Solver1.xlsx13.69 KB
 FruitandSalesData2013_Solver_Result.xlsx13.69 KB
 FruitandSalesData2013_GoalSeek_Result.xlsx11.14 KB
 FruitandSalesData2013.xlsx11.14 KB
 sales2013_CustomViewsResult.xlsx12.16 KB
 CustomViews_Result.xlsx12.07 KB
 CustomViews.xlsx12.03 KB
 sales2013_CustomViews.xlsx12.02 KB
 sales2013.xlsx10.58 KB
 salesStaff_Match_Result.xlsx11.27 KB
 salesStaff.xlsx10.86 KB
 sales2013_MATCH_INDEX_Result.xlsx10.07 KB
 sales2013_OutOfRange_Result.xlsx9.93 KB
 sales2013_CHOOSE_Result.xlsx9.91 KB
 sales2013_INDEX_Result.xlsx9.9 KB
 sales2013.xlsx9.81 KB
 fruitSales.xlsx7.42 KB
 nestedIfs.xlsx11.02 KB
 IF_Result.xlsx11.01 KB
 if.xlsx10.76 KB
 AND-OR_ResultOR.xlsx10.7 KB
 AND-OR_ResultAnd.xlsx10.67 KB
 AND-OR.xlsx10.44 KB
 formulaDisplay_Result.xlsx10.3 KB
 NOT_Result.xlsx10.15 KB
 not.xlsx9.93 KB
 formulaDisplay.xlsx9.78 KB
 nestedIfs_Result.xlsx9.73 KB
 timeCalculations_Results.xlsx10.67 KB
 timeCalculations.xlsx10.42 KB
 timeData_Results.xlsx10.32 KB
 timeDateFunctions_Result.xlsx9.89 KB
 random_Result.xlsx9.53 KB
 random.xlsx9.48 KB
 mod_Result.xlsx9.42 KB
 loansAndSavings_Result.xlsx9.21 KB
 Mod.xlsx9.04 KB
 TIMEDATA.xlsx8.91 KB
 sparklines.xlsx10.66 KB
 FruitandSalesData_Sparklines_Result.xlsx10.65 KB
 FruitandSalesData_Sparklines.xlsx10.36 KB
 FruitandSalesData.xlsx9.61 KB
 sales2013_withOutlining.xlsx10.04 KB
 sales2013.xlsx9.86 KB
 Working Files - README.txt256 bytes
 1501.What Is A PivotTable.mp424.68 MB
 1103.Conditional Evaluation With No IFs.mp424.21 MB
 0601.Working With Time In Excel.mp423.42 MB
 1003.FIND And MID Text Functions Working Together.mp423.34 MB
 1004.CONCATENATE Building Strings From Multiple Cells.mp422.95 MB
 1002.LEN And TRIM String Extractions.mp422.45 MB
 1514.PivotTable Styles.mp421.91 MB
 1816.Add An Are You Sure Box To Macros.mp421.46 MB
 1201.Using The MATCH Function.mp420.75 MB
 0801.Setting Up A Set Of Scenarios.mp420.59 MB
 1515.Creating Your Own PivotTable Styles.mp420.5 MB
 1007.Use Of CHAR Function For More Obscure Characters.mp420.25 MB
 1518.Adding And Using The Data Slicer.mp419.68 MB
 0402.VLOOKUP In Live Action.mp419.59 MB
 0703.Editing And Removing Outlining.mp418.96 MB
 0407.Lookups Nested Within Lookups.mp418.88 MB
 1503.Creating Your Own PivotTables.mp418.26 MB
 0406.Managing The Lookup Table.mp418.17 MB
 1307.The CELL Function And Determining File Or Sheet Names.mp418.14 MB
 1502.The New Recommended PivotTable Route.mp417.88 MB
 1508.Sorting The PivotTable Columns.mp417.53 MB
 0302.Nesting The IF Statement.mp417.37 MB
 1403.Auditing Tools Error Checking And Tracing.mp417.36 MB
 1513.Dealing With Empty Cells And Other Additional Options.mp417.06 MB
 0301.IF Syntax And Uses.mp417.06 MB
 1511.Multiple Fields In Row, Column, Or Data Sections.mp416.98 MB
 1505.Creating Multiple PivotTables On The Same Dataset.mp416.93 MB
 1006.REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp416.91 MB
 1815.View And Edit Macro Code.mp416.8 MB
 1008.Formatting Numeric And Date Values Using TEXT.mp416.63 MB


Description

Duration 10 hours

In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.

You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.

By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
1.62 GB
seeders:23
leechers:6
InfiniteSkills Advanced Microsoft Excel 2013

All Comments

Thank You
Thanks.
DOWNLOADED.THANK YOU UPLOADER