Excel Tutorials | 804FD482A7C5A29BD0F850A9FFE22DA619A4C54E

Excel Tutorials

Name	Excel Tutorials	DOWNLOAD Copy Link
Total Size	15.4 GB
Total Files	1555
Last Seen	2024-10-10 23:24
Hash	804FD482A7C5A29BD0F850A9FFE22DA619A4C54E

/01_04/Calculated Columns/
Gross Profit FactOnLineSales Table.txt	0.0 KB
Income Bracket Customer Table.txt	0.1 KB
desktop.ini	0.1 KB
/01_04/Calculated Fields/
7 Year Over Year.txt	0.0 KB
1 Sum of Sales.txt	0.0 KB
5 Month over Month .txt	0.0 KB
8 YOY.txt	0.1 KB
9 MOM.txt	0.1 KB
2 Sales MTD.txt	0.1 KB
3 Sales YTD.txt	0.1 KB
4 Same Month Last Year.txt	0.1 KB
6 Previous Year.txt	0.1 KB
desktop.ini	0.1 KB
/02_01/
GoalsByCategory.txt	0.1 KB
desktop.ini	0.1 KB
02_01 Adding a Linked Table Start.xlsx	84.5 MB
02_01 Adding a Linked Table Complete.xlsx	84.5 MB
/Exercise Files/Chapter 05/
~$CorporateData.xlsx	0.2 KB
Olive-WesternConsolidation.xlsx	8.4 KB
CorpLink.xlsx	15.7 KB
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
Arizona.xlsx	28.9 KB
Oregon.xlsx	28.9 KB
Washington.xlsx	29.0 KB
California.xlsx	29.0 KB
CorporateData.xlsx	378.4 KB
/Exercise Files/
Get More PC and Internet Tips and Tricks.url	0.2 KB
Ch_09_PrintShare.xlsx	25.0 KB
Recent Sales Activity.pptx	47.5 KB
Ch_05_FormatTab.xlsx	49.9 KB
Ch_07_ChartSources.xlsx	55.6 KB
Ch_04_Chart Options.xlsx	69.6 KB
Ch_03_DesignTab.xlsx	258.9 KB
Ch_08_SpecializedExcelCharts.xlsx	785.9 KB
Ch_06_SpecificChartTypes.xlsx	866.9 KB
Ch_02_Chart_Building.xlsx	900.5 KB
Ch_01_Chart_Concepts.xlsx	1.0 MB
/0. Introduction/
Get More PC and Internet Tips and Tricks.url	0.2 KB
135358_00_02_3D15_exfiles.mp4	1.8 MB
135358_00_01_WX30_Intro.mp4	9.7 MB
/.../6. Adjusting Specific Chart Types/
Get More PC and Internet Tips and Tricks.url	0.2 KB
135358_06_02_3D15_Line.mp4	20.3 MB
135358_06_03_3D15_Pie.mp4	22.6 MB
135358_06_01_3D15_ColumnBar.mp4	31.7 MB
135358_06_05_3D15_DoughnutBubbleRadar.mp4	34.0 MB
135358_06_04_3D15_AreaStockXY.mp4	40.5 MB
/.../3. Fine-Tuning Charts with Design Tab Choices/
Get More PC and Internet Tips and Tricks.url	0.2 KB
135358_03_10_3D15_ChartLocation.mp4	6.8 MB
135358_03_04_3D15_ChartStyles.mp4	7.8 MB
135358_03_08_3D15_ChangeChartType.mp4	8.1 MB
135358_03_01_3D15_AddChartElement.mp4	8.6 MB
135358_03_06_3D15_SourceData.mp4	9.7 MB
135358_03_02_3D15_QuickLayout.mp4	10.1 MB
135358_03_05_3D15_SwitchRowColumn.mp4	10.8 MB
135358_03_03_3D15_ChartColors.mp4	10.8 MB
135358_03_11_3D15_ResizeChart.mp4	11.2 MB
135358_03_09_3D15_DefaultChartType.mp4	11.6 MB
135358_03_07_3D15_EmptyHiddenCells.mp4	19.4 MB
/Lynda - Excel 2013 - Advanced Formatting Techniques/
Get More PC and Internet Tips and Tricks.url	0.2 KB
Important ! Readme.txt	0.3 KB
42-Goodbye.mp4	795.7 KB
02-Using the exercise files.mp4	1.1 MB
40-Formatting column and row titles.mp4	4.8 MB
09-Indenting data and dollar signs.mp4	5.4 MB
08-Creating angled text variations for greater variety and readability.mp4	5.4 MB
41-Formatting a list for double-spaced printing.mp4	5.7 MB
29-Formatting text from Word or the web with the Justify feature.mp4	6.0 MB
35-Using WordArt for formatted titles and headings.mp4	6.4 MB
27-Applying different formatting styles within the same cell.mp4	6.4 MB
26-Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mp4	6.6 MB
38-Displaying large values without using formulas.mp4	7.8 MB
36-Hiding repeating titles in a column to clarify printed output.mp4	8.0 MB
17-Creating value-based formatting using logical operators.mp4	8.5 MB
32-Formatting picture styles.mp4	8.5 MB
07-Adjusting horizontal and vertical cell alignment.mp4	8.6 MB
10-Simplifying title adjustments with the Merge & Center button.mp4	8.8 MB
05-Applying border styles and adjusting gridlines.mp4	9.3 MB
01-Welcome.mp4	9.4 MB
06-Using fill color and patterns for cell backgrounds.mp4	9.6 MB
31-Using outlining symbols and levels.mp4	9.8 MB
04-Applying underline, strikethrough, subscript, and superscript formatting.mp4	9.9 MB
33-Adding borders and effects to pictures.mp4	10.4 MB
28-Copying formats quickly with dragging techniques and the Format Painter.mp4	10.5 MB
11-Controlling titles and headings with the Wrap Text and Shrink to Fit options.mp4	12.1 MB
34-Formatting sparklines for optimum impact.mp4	13.3 MB
03-Adjusting fonts, font sizes, and font colors.mp4	15.7 MB
22-Using styles and themes for consistent formatting.mp4	16.2 MB
14-Setting special formats for dates, times, phone numbers, ZIP codes, etc..mp4	16.3 MB
15-Building custom numeric formats.mp4	16.5 MB
16-Building custom date formats.mp4	17.4 MB
12-Working with numeric formatting options.mp4	17.9 MB
13-Essential numeric formatting keystroke shortcuts.mp4	18.4 MB
23-Adjusting single and multiple row heights and column widths without commands.mp4	18.5 MB
20-Conditional formatting in PivotTables.mp4	18.7 MB
37-Restoring missing title data in a column.mp4	20.7 MB
24-Working with rows, columns, and sheets.mp4	20.8 MB
19-Creating formats based on formulas.mp4	20.9 MB
25-Working with the Hide and Unhide options.mp4	23.3 MB
39-Creating linked worksheet images.mp4	25.5 MB
18-Creating value-based formatting using data bars, color scales, and icons.mp4	26.7 MB
30-Setting up data for outlining.mp4	34.8 MB
21-Working with tables.mp4	56.7 MB
/Lynda - Excel 2013_ Working with Charts and Graphs/
Please seed.txt	0.4 KB
004 Creating a chart.mp4	5.2 MB
019 Working with headers.mp4	7.1 MB
003 Exercise files.mp4	8.0 MB
018 Creating a table.mp4	9.3 MB
017 Using a radar chart.mp4	10.1 MB
025 Goodbye.mp4	10.4 MB
005 Editing data in a chart.mp4	10.7 MB
001 Welcome.mp4	10.9 MB
010 Using a line chart.mp4	11.3 MB
015 Using a stock chart.mp4	13.5 MB
022 Adding a SmartArt graphic.mp4	14.2 MB
014 Using a scatter or bubble chart.mp4	15.3 MB
013 Using an area chart.mp4	15.9 MB
012 Using a bar chart.mp4	16.4 MB
002 What you should know before watching the course.mp4	16.9 MB
020 Using table options to enhance clarity.mp4	16.9 MB
007 Using the Recommended Charts option.mp4	18.3 MB
011 Using a pie chart.mp4	18.4 MB
016 Using a doughnut chart.mp4	18.7 MB
023 Formatting a SmartArt graphic.mp4	21.6 MB
024 Converting a SmartArt graphic to shapes.mp4	23.4 MB
008 Viewing chart animations.mp4	23.6 MB
021 Applying styles to a table.mp4	24.9 MB
006 Modifying the appearance of a chart.mp4	27.1 MB
009 Using a column chart.mp4	27.3 MB
/.../03 Creating Formulas and Functions/
3.bsl	0.4 KB
03_02-copyFormulas.mp4	3.2 MB
03_03-YTD.mp4	4.0 MB
03_06-SUMAverage.mp4	6.7 MB
03_04-PctIncr.mp4	6.9 MB
03_05-absolute.mp4	7.6 MB
03_01-simpleFormulas.mp4	8.9 MB
03_07-otherFunctions.mp4	9.5 MB
/Exercise Files/Chapter12/
BaseData.csv	2.7 KB
Import.xlsx	7.6 KB
BaseData.xlsx	12.9 KB
Sales.xlsx	13.7 KB
CalculatedColumn.xlsx	13.7 KB
MultiSeries.xlsx	143.3 KB
Multiples.xlsx	143.8 KB
Map.xlsx	151.8 KB
Pie.xlsx	182.4 KB
ColumnAndBar.xlsx	182.6 KB
Line.xlsx	182.6 KB
/Exercise Files/Chapter11/
BaseData.csv	2.7 KB
Enable.xlsx	10.6 KB
BaseData.xlsx	12.8 KB
Table.xlsx	131.3 KB
Card.xlsx	180.4 KB
Tiles.xlsx	180.5 KB
Format.xlsx	182.7 KB
Filter.xlsx	182.9 KB
/Lynda - Data Analysis Fundamentals with Excel/
playlist.bsl	3.6 KB
003 Using the exercise files.mp4	1.7 MB
007 Introducing the central limit theorem.mp4	2.2 MB
002 What you should know.mp4	2.4 MB
017 Interpreting the results of your analysis.mp4	3.2 MB
035 Further resources.mp4	3.7 MB
009 Identifying and minimizing sources of error.mp4	3.8 MB
018 Considering the limits of hypothesis testing.mp4	4.1 MB
011 Identifying relationships using XY scatter charts.mp4	4.1 MB
030 Introducing Bayesian analysis.mp4	4.5 MB
028 Calculating correlation between two columns of data.mp4	4.7 MB
001 Welcome.mp4	5.3 MB
013 Adding trendlines to charts.mp4	6.2 MB
016 Formulating a hypothesis.mp4	6.7 MB
024 Visualizing what covariance means.mp4	6.8 MB
034 Updating your Bayesian analysis.mp4	7.6 MB
031 Analyzing a sample problem - Kahneman`s Cabs.mp4	7.8 MB
032 Creating a classification matrix.mp4	8.3 MB
026 Calculating covariance among multiple pairs of columns.mp4	8.4 MB
012 Visualizing data using logarithmic scales.mp4	8.5 MB
008 Analyzing a population using data samples.mp4	9.4 MB
029 Calculating correlation among multiple pairs of columns.mp4	9.6 MB
025 Calculating covariance between two columns of data.mp4	9.7 MB
010 Grouping data using histograms.mp4	9.7 MB
023 Using the Poisson distribution.mp4	9.7 MB
005 Measuring maximums, minimums, and other data characteristics.mp4	9.8 MB
015 Calculating running averages.mp4	10.5 MB
022 Using the binomial distribution.mp4	10.5 MB
027 Visualizing what correlation means.mp4	10.7 MB
014 Forecasting future results.mp4	11.3 MB
004 Calculating mean and median values.mp4	12.2 MB
021 Using a uniform distribution.mp4	12.4 MB
020 Using the exponential distribution.mp4	12.8 MB
019 Using the normal distribution.mp4	13.5 MB
033 Calculating Bayesian probabilities in Excel.mp4	13.7 MB
006 Analyzing data using variance and standard deviation.mp4	14.7 MB
/Exercise Files/Graphics/Icons/
incandescent bulb_icon.png	5.6 KB
cfc bulb_icon.png	5.6 KB
/.../PNG-transparent-300 dpi/
battery.png	6.1 KB
oil barrel.png	7.4 KB
house.png	8.4 KB
wind turbine.png	13.2 KB
CO2 cloud.png	14.1 KB
fire.png	14.5 KB
smoke stacks.png	14.7 KB
sun.png	15.4 KB
recycle truck.png	16.7 KB
electric car.png	18.9 KB
/Exercise Files/Graphics/
sun_icon.png	6.9 KB
kinetEco_logo.png	27.4 KB
/Exercise Files/Chapter09/
Import.xlsx	7.6 KB
Sales.xlsx	13.7 KB
AddToModel.xlsx	13.7 KB
CustomerInfo.xlsx	19.5 KB
ManageColumns.xlsx	162.0 KB
CreateRelationship.xlsx	208.3 KB
CreatePivot.xlsx	208.3 KB
Introducing.xlsx	211.8 KB
Timeline.xlsx	220.2 KB
DataSource.accdb	450.6 KB
/01_02/
01_02_ImportingData Start.xlsx	7.6 KB
01_02 Dashboard After Import downloaded Preloaded.xlsx	80.0 MB
/Exercise Files/Chapter01/
Connect.xlsx	7.6 KB
FormatData.xlsx	8.7 KB
Recommended.xlsx	9.6 KB
Create.xlsx	9.6 KB
Consolidating.xlsx	10.7 KB
Pivoting.xlsx	14.1 KB
Configuring.xlsx	14.5 KB
Managing.xlsx	14.6 KB
Clear.xlsx	14.7 KB
Introducing.xlsx	15.1 KB
ExternalData.xlsx	16.8 KB
/.../2 An Overview of Chart and Graph Types/
2-Pie.xslx.xlsx	8.2 KB
Doughnut.xlsx	8.2 KB
2-Area.xlsx	8.3 KB
Radar.xlsx	8.5 KB
2-Stocks.xlsx	36.9 KB
2-Axis Chart.xlsx	503.5 KB
2_Error Bars.xlsx	503.8 KB
2_1 Column.xlsx	503.8 KB
2-MargiunofError.xlsx	503.8 KB
2_Scatter.xlsx	506.5 KB
/Exercise Files/Chapter04/
Poisson.xlsx	8.3 KB
Uniform.xlsx	8.4 KB
Exponential.xlsx	13.9 KB
Binomial.xlsx	15.0 KB
Normal.xlsx	16.4 KB
/Exercise Files/Chapter04/
Poisson.xlsx	8.3 KB
Uniform.xlsx	8.4 KB
Exponential.xlsx	13.9 KB
Binomial.xlsx	15.0 KB
Normal.xlsx	16.4 KB
/Exercise Files/Chapter01/
MeansAndMedians.xlsx	8.3 KB
MinMax.xlsx	8.7 KB
Variance.xlsx	8.8 KB
/Exercise Files/Chapter01/
MeansAndMedians.xlsx	8.3 KB
MinMax.xlsx	8.7 KB
Variance.xlsx	8.8 KB
/Exercise Files/Chapter05/
SingleCorrelation.xlsx	8.4 KB
SingleCovariance.xlsx	8.4 KB
MultipleCovariance.xlsx	8.5 KB
MultipleCorrelations.xlsx	8.5 KB
VisualizeCovariance.xlsx	10.1 KB
VisualizeCorrelation.xlsx	10.1 KB
/Exercise Files/Chapter05/
SingleCorrelation.xlsx	8.4 KB
SingleCovariance.xlsx	8.4 KB
MultipleCovariance.xlsx	8.5 KB
MultipleCorrelations.xlsx	8.5 KB
VisualizeCovariance.xlsx	10.1 KB
VisualizeCorrelation.xlsx	10.1 KB
/Exercise Files/Other/
MapData`1.xlsx	8.5 KB
Sales_Data.xlsx	491.6 KB
Mixed Chart.xlsx	495.3 KB
2-Axis Chart.xlsx	496.2 KB
Error.xlsx	496.3 KB
/Exercise Files/Ch01/03/
scraping_data.xlsx	8.5 KB
scraping_data_finish.xlsx	8.8 KB
/Exercise Files/Chapter02/
XYScatter.xlsx	8.6 KB
Histogram.xlsx	8.7 KB
RunningAverage.xlsx	8.7 KB
Forecast.xlsx	9.9 KB
LogarithmicScale.xlsx	13.3 KB
Trendline.xlsx	13.8 KB
/Exercise Files/Chapter02/
XYScatter.xlsx	8.6 KB
Histogram.xlsx	8.7 KB
RunningAverage.xlsx	8.7 KB
Forecast.xlsx	9.9 KB
LogarithmicScale.xlsx	13.3 KB
Trendline.xlsx	13.8 KB
/Exercise Files/Chapter06/
Calculating.xlsx	9.0 KB
Updating.xlsx	9.5 KB
/Exercise Files/Chapter06/
Calculating.xlsx	9.0 KB
Updating.xlsx	9.5 KB
/Exercise Files/1 Chart Essentials/
DataSet1.xlsx	9.5 KB
DataSet2.xlsx	14.3 KB
DataSet3.xlsx	14.7 KB
/Exercise Files/Chapter06/
CreatePivot.xlsx	9.6 KB
Trendline.xlsx	19.0 KB
Filtering.xlsx	19.4 KB
Pivoting.xlsx	19.4 KB
Layout.xlsx	19.4 KB
Formatting.xlsx	19.4 KB
ChartType.xlsx	19.5 KB
/Exercise Files/Chapter03/
ModelSetUp.xlsx	9.9 KB
Sliders.xlsx	9.9 KB
CheckBoxes.xlsx	12.4 KB
Manipulate.xlsx	15.2 KB
/Exercise Files/Chapter04/
MonteCarloSetup.xlsx	10.1 KB
InputTable.xlsx	10.2 KB
Lookup.xlsx	12.7 KB
RunModel.xlsx	12.7 KB
/Exercise Files/Ch04/
Thumbs.db	10.2 KB
Bamboo_Slicker_with logo_YELLOW_101817957.jpg	50.3 KB
No_Obstacles_logo_transparent.jpg	52.9 KB
Twenty Second Sneakers_with logo_91548475.jpg	62.6 KB
04-Formatting.xlsx	202.8 KB
/Exercise Files/Ch01/04/
cost_categorization.xlsx	10.7 KB
cost_categorization_finish.xlsx	16.8 KB
/Exercise Files/Ch02/02/
expense_categorization.xlsx	10.9 KB
expense_categorization_finish.xlsx	11.0 KB
/Exercise Files/Chapter02/
SolverOptimization.xlsx	11.1 KB
SolverModel.xlsx	11.2 KB
IntegerSolutions.xlsx	11.2 KB
Goal Seek.xlsx	23.4 KB
/Exercise Files/Ch02/
02-Entering Data.xlsx	12.2 KB
/Exercise Files/
Ch_13.xlsx	12.9 KB
Ch_04A.xlsx	27.5 KB
Ch_02.xlsx	59.0 KB
Ch_08.xlsx	104.4 KB
Ch_09.xlsx	104.4 KB
Ch_07.xlsx	106.9 KB
Ch_06.xlsx	123.0 KB
Ch_12.xlsx	141.5 KB
Ch_05.xlsx	156.1 KB
Ch_03.xlsx	194.5 KB
Ch_10.xlsx	239.3 KB
Ch_11.xlsx	246.5 KB
Ch_01.xlsx	349.7 KB
Ch_04.xlsx	595.9 KB
/Exercise Files/
Ch05.xlsx	13.3 KB
Ch04.xlsx	14.1 KB
Ch02.xlsx	20.7 KB
Ch03.xlsx	20.9 KB
Ch01.xlsx	26.9 KB
Ch06.xlsx	37.1 KB
/Exercise Files/Chapter03/
ReportFilter.xlsx	14.2 KB
Rule.xlsx	14.5 KB
FormatSlicer.xlsx	14.5 KB
Slicer.xlsx	14.5 KB
SearchFilter.xlsx	14.8 KB
Clear.xlsx	14.9 KB
Selection.xlsx	15.1 KB
FilterSummary.xlsx	15.1 KB
Custom.xlsx	15.8 KB
Sorting.xlsx	16.0 KB
/Exercise Files/Chapter02/
Summary.xlsx	14.6 KB
Totals.xlsx	14.7 KB
DrillDown.xlsx	15.1 KB
MoreThanOne.xlsx	15.1 KB
Formula.xlsx	15.2 KB
Calculated.xlsx	15.4 KB
Grouping.xlsx	17.3 KB
/Exercise Files/Chapter04/
Layout.xlsx	14.6 KB
ApplyStyle.xlsx	15.0 KB
DefineStyle.xlsx	15.0 KB
NumberFormat.xlsx	16.4 KB
/Exercise Files/Chapter05/
IconSets.xlsx	16.2 KB
ColorScales.xlsx	16.4 KB
TopValues.xlsx	16.4 KB
FormatRule.xlsx	16.4 KB
DataBars.xlsx	16.4 KB
EditingRules.xlsx	16.5 KB
Multiple.xlsx	16.5 KB
Delete.xlsx	16.5 KB
/Exercise Files/Chapter08/
PresentationKit.xlsx	16.2 KB
RecordMacro.xlsx	16.5 KB
RunMacro.xlsm	20.8 KB
PresentationKit.xlsm	21.8 KB
/Exercise Files/Ch12/
12-Information.xlsx	16.3 KB
/Exercise Files/Chapter07/
PrintPivot.xlsx	16.5 KB
PrintChart.xlsx	19.5 KB
PrintHeaders.xlsx	20.7 KB
PrintEachItem.xlsx	20.8 KB
/.../PNG-transparent-72 dpi/
oil barrel.png	17.2 KB
battery.png	17.2 KB
fire.png	17.8 KB
house.png	18.0 KB
sun.png	18.4 KB
CO2 cloud.png	18.6 KB
electric car.png	18.7 KB
recycle truck.png	18.9 KB
wind turbine.png	19.0 KB
smoke stacks.png	19.7 KB
/Exercise Files/Ch01/07/
pivot_tables.xlsx	17.7 KB
pivot_tables_finish.xlsx	26.3 KB
/Exercise Files/Ch01/04/
db_format.xlsx	17.8 KB
/Exercise Files/Ch01/06/
sumif.xlsx	17.8 KB
sumif_finish.xlsx	19.0 KB
/.../4 Working with SmartArt/
Budget Cycle.xlsx	18.2 KB
Budget Cycle.2xlsx.xlsx	19.1 KB
OrgChart2.xlsx	23.6 KB
OrgChart.xlsx	40.0 KB
/.../JPGs-72 dpi/
CO2 cloud.jpg	18.2 KB
wind turbine.jpg	21.1 KB
battery.jpg	21.3 KB
smoke stacks.jpg	22.3 KB
electric car.jpg	23.0 KB
fire.jpg	23.6 KB
recycle truck.jpg	23.7 KB
sun.jpg	24.8 KB
oil barrel.jpg	26.3 KB
house.jpg	26.6 KB
/.../JPGs-300 dpi/
CO2 cloud.jpg	19.6 KB
battery.jpg	21.9 KB
wind turbine.jpg	22.5 KB
oil barrel.jpg	24.2 KB
fire.jpg	24.9 KB
smoke stacks.jpg	25.4 KB
house.jpg	25.8 KB
electric car.jpg	25.9 KB
sun.jpg	26.6 KB
recycle truck.jpg	26.9 KB
/Exercise Files/Ch04/02/
revenue_per_product.xlsx	20.3 KB
revenue_per_product_finish.xlsx	30.1 KB
/Exercise Files/Ch01/08-10/
revenue_database.xlsx	20.8 KB
standard_costs.xlsx	27.9 KB
standard_costs_finish.xlsx	28.0 KB
revenue_database_finish.xlsx	41.6 KB
/Exercise Files/Chapter 04/
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
StateSalesData.xlsx	51.3 KB
QuarterlyBudget.xlsx	75.5 KB
DivisionFiles.xlsx	376.5 KB
Chartdata2011.xlsx	961.0 KB
/Exercise Files/Chapter 03/
PivotTableSummary.xlsx	21.3 KB
Sample.xlsx	21.8 KB
LinkageFormulas.xlsx	22.2 KB
3D Formulas.xlsx	114.2 KB
/Exercise Files/Chapter 01/
RegionalFile2.xlsx	21.7 KB
SalesData.xlsx	21.8 KB
RegionalFile.xlsx	21.8 KB
Hyperlink State File.xlsx	121.6 KB
HiddenSheets.xlsx	378.2 KB
Sample.xlsx	379.7 KB
/Exercise Files/Chapter 02/
RegionalData.xlsx	21.8 KB
SalesData.xlsx	21.8 KB
Sample.xlsx	376.4 KB
DepartmentData.xlsx	376.5 KB
/Exercise Files/Ch11/
11-Text.xlsx	23.0 KB
/Exercise Files/Chapter01/
CreateScenario.xlsx	23.3 KB
EditAndDelete.xlsx	23.5 KB
ShowAndHide.xlsx	23.5 KB
Summarize.xlsx	23.5 KB
TaxRateIncrease.xlsx	34.0 KB
TaxAndIncome.xlsx	34.0 KB
/Exercise Files/Ch10/
10-Reference.xlsx	24.3 KB
/Exercise Files/Ch01/08/
consolidation.xlsx	26.3 KB
consolidation_finish.xlsx	30.5 KB
/Exercise Files/Ch01/06/
cost_allocation.xlsx	26.9 KB
cost_allocation_finish.xlsx	27.9 KB
/Exercise Files/
CH_04.xlsx	27.1 KB
CH_03.xlsx	59.9 KB
CH_01.xlsx	249.3 KB
CH_06.xlsx	370.8 KB
CH_05.xlsx	390.9 KB
CH_02.xlsx	409.1 KB
/.../3 Displaying Data with Tables/
3_Starter Budget.xls	27.1 KB
3_Starter Budget2.xls	28.2 KB
3_Starter Budget3.xls	30.2 KB
3_Starter Budget4.xls	30.2 KB
3_Sales_Data.xlsx	499.0 KB
/Exercise Files/Ch05/02/
exceptional_business.xlsx	29.1 KB
exceptional_business_finish.xlsx	30.4 KB
/Exercise Files/Ch04/03/
upsell_opportunities.xlsx	29.1 KB
upsell_opportunities_finish.xlsx	31.8 KB
/Exercise Files/Ch03/02/
customer_count.xlsx	29.6 KB
customer_count_finish.xlsx	30.3 KB
/Exercise Files/Ch02/02/
compare_to_past.xlsx	29.6 KB
compare_to_past_finish.xlsx	30.1 KB
/Exercise Files/Chapter 06/
06_06_Central_US_Installs_YTD.xlsx	29.7 KB
06_03 Sales Overview - Link.pptx	73.0 KB
06_05_Solar_Proposal.pptx	226.4 KB
06_02 Sales Overview 2013 Q1.pptx	506.6 KB
06_04 Sales Overview 2013 Q1.pptx	636.6 KB
/Exercise Files/Ch03/04/
new_vs_returning_customers_finish.xlsx	30.1 KB
new_vs_returning_customers.xlsx	31.0 KB
/Exercise Files/Ch03/03/
revenue_per_customer.xlsx	30.3 KB
revenue_per_customer_finish.xlsx	31.4 KB
/Exercise Files/Chapter10/
DAX Operators.pptx	35.4 KB
Filtered.xlsx	130.7 KB
Aggregate.xlsx	130.7 KB
CalculatedColumn.xlsx	161.9 KB
Survey.xlsx	162.0 KB
Operators.xlsx	162.0 KB
Introducing.xlsx	162.9 KB
CalculatedField.xlsx	175.8 KB
/Exercise Files/Ch03/
03-Creating Formulas and Functions.xlsx	35.9 KB
/Exercise Files/Chapter 01/
2013 YTD Report by Region.xlsx	37.0 KB
Slice Presentation.pptx	44.9 KB
/Exercise Files/Chapter 03/
03_04_Feb_2013_Wholesale.xlsx	38.0 KB
03_02_Feb_2013_Wholesale.xlsx	38.1 KB
03_01_Feb_2013_Wholesale.xlsx	38.7 KB
03_05_Feb_2013_Wholesale.xlsx	38.9 KB
03_03_Feb_2013_Wholesale.xlsx	44.9 KB
/Exercise Files/Chapter 05/
05_01_Jan_2013_MiniSolar_Wholesale_Orders.xlsx	39.2 KB
05_03_Jan_2013_MiniSolar_Wholesale_Orders.xlsx	48.0 KB
05_02_Jan_2013_MiniSolar_Wholesale_Orders.xlsx	48.1 KB
/Exercise Files/Chapter 04/
04_07_Jan_2013_Wholesale_Data.xlsx	39.5 KB
04_02_Jan_2013_Charts.xlsx	39.6 KB
04_03_Jan_2013_Charts.xlsx	48.7 KB
04_04_Jan_2013_Charts.xlsx	65.0 KB
04_05_Jan_2013_Charts.xlsx	85.8 KB
04_06_Jan_2013_Charts.xlsx	92.9 KB
/Exercise Files/Chapter 02/
02_04_Jan_2013_Wholesale.xlsx	39.5 KB
02_01_Jan_2013_Wholesale.xlsx	39.6 KB
02_03_Jan_2013_Wholesale.xlsx	41.0 KB
02_02_Jan_2013_Wholesale.xlsx	41.1 KB
/Exercise Files/Ch01/
01-RegionalSales.xlsx	40.1 KB
01-TipsShortcuts.xlsx	286.3 KB
/Exercise Files/Ch09/
09-03-RegionalSales.xlsx	40.7 KB
09-04-RegionalSales.xlsx	41.0 KB
09-RegionalSales.xlsx	42.4 KB
09-05-RegionalSales.xlsx	44.5 KB
09-02-RegionalSales.xlsx	57.3 KB
09-Home Product Line.xlsx	81.5 KB
09-05-EmployeeTable.xlsx	298.6 KB
09-EmployeeTable.xlsx	299.2 KB
09-04-EmployeeTable.xlsx	299.5 KB
/Exercise Files/
Ch_01_FontsBorders.xlsx	46.2 KB
Tree.tiff	54.0 KB
No Obstacles Logos.xlsx	55.1 KB
Ch_02_Alignment.xlsx	55.7 KB
Ch_07_OtherFormatting.xlsx	57.6 KB
Ch_03_Numeric.xlsx	67.6 KB
Ch_05_TablesStylesThemes.xlsx	81.4 KB
Ch_08_Outlines.xlsx	81.8 KB
Ch_06_RowColumnAdjustments.xlsx	87.9 KB
Ch_04_ConditionalFormatting.xlsx	153.6 KB
Ch_10_PowerTechniques.xlsx	154.1 KB
Ch_09_Pictures.xlsx	690.5 KB
IMG_0058.JPG	808.0 KB
/Exercise Files/Data/
KinetEco Solar System Cost and Payback Period.xlsx	52.8 KB
KinetEco Installation Planner.xlsx	57.1 KB
KinetEco Monthly Sales Report 2013_final.xlsx	80.2 KB
/Exercise Files/Chapter 07/
07_04_KinetEco Installation Tool (KIT).xlsx	57.0 KB
07_04_solar_proposal.pptx	226.3 KB
07_01_Sales_Overview_2013_Q1.pptx	658.2 KB
07_02_Sales_Overview_2013_Q1.pptx	667.5 KB
07_03_Sales_Overview_2013_Q1.pptx	675.2 KB
/Exercise Files/Ch08/
08-Date.xlsx	58.1 KB
/Exercise Files/Ch11/
11-Workbook before Sharing.xlsx	58.2 KB
TrackingChanges.xlsx	136.4 KB
11-Security&Sharing.xlsx	165.8 KB
/.../Final Charts and Tables/
Jan 2013 MiniSolar Tables and Charts Complete.xlsx	58.6 KB
Jan 2013 Sales Summary Charts Complete.xlsx	92.9 KB
/Exercise Files/Ch07/
07-Math.xlsx	65.9 KB
/Exercise Files/Ch07/
07-Charting.xlsx	71.5 KB
/Exercise Files/Ch06/
06-Stat.xlsx	124.7 KB
/Exercice Files/
Ex_Files_UaR_Excel_Cluster.zip	133.3 KB
/Exercise Files/Ch15/
15-Macros.xlsx	139.3 KB
/Exercise Files/Ch14/
14-DataAnalysis.xlsx	140.9 KB
/Exercise Files/Ch01/
01-Getting Started.xlsx	153.7 KB
01-Examples.xlsx	373.9 KB
/Exercise Files/Ch09/
09-Array.xlsx	160.4 KB
/Exercise Files/Ch13/
13-PivotTables.xlsx	160.5 KB
/Exercise Files/Ch05/
05-Layout.xlsx	187.6 KB
/Exercise Files/
Ch_03.xlsx	187.8 KB
Ch_01.xlsx	334.9 KB
Ch_02.xlsx	382.6 KB
/Exercise Files/Ch06/
06-Printing.xlsx	193.0 KB
/Exercise Files/Ch08/
08-Worksheet Views.xlsx	196.8 KB
/Exercise Files/Chapter 09/
09_01_Solar Proposal with KIT.pptx	198.8 KB
09_02_Solar Proposal with KIT.pptx	207.3 KB
/Exercise Files/Ch10/
10-IF VLOOKUP COUNTIF.xlsx	228.7 KB
/Exercise Files/Ch05/
05-COUNTIF-SUMIF.xlsx	275.3 KB
/Exercise Files/Ch12/
12-DatabaseFeatures.xlsx	294.4 KB
/Exercise Files/Ch04/
04-LookupFunctions.xlsx	340.8 KB
/Exercise Files/Graphics/4 by 6 graphics/
wind farm_86523769.jpg	411.3 KB
single sunflower and vertical solar panels_105556963.jpg	1.3 MB
wind farm_94401952.jpg	1.4 MB
red lilys & solar panels & wind turbine_95363316.jpg	1.7 MB
sunflowers & solar panels & wind turbine_95274899.jpg	1.8 MB
single sunflower & solar panels_104234506.jpg	1.9 MB
solar power farm_122633553.jpg	2.2 MB
solar panels & blue sky_108529227.jpg	2.4 MB
wind farm_medwt16013.jpg	3.7 MB
/Exercise Files/Ch02/
02-Tools.xlsx	456.9 KB
/Exercise Files/Media/
KinetEco CEO_ver3.mp3	517.6 KB
KinetEco_PSA_short cut.mp4	3.1 MB
KinetEco CEO_ver3.wav	6.1 MB
/Exercise Files/Ch03/
03-IF Function.xlsx	550.2 KB
/0 Introduction/
153775_00_02_XR15_whofor.mp4	719.8 KB
153775_00_03_XR15_whatknow.mp4	768.8 KB
153775_00_05_XR15_Challenges.mp4	807.5 KB
153775_00_04_XR15_Exercisefiles.mp4	939.9 KB
153775_00_01_WX30_welcome.mp4	2.1 MB
/01. Introduction/
01_03-Using the exercise files.mp4	825.0 KB
01_02-What you should know before watching this course.mp4	1.7 MB
01_01-Welcome.mp4	9.8 MB
/.../1 Visually Displaying Your Time-Series Data/
153775_01_08_CH30_XR30_challenge.mp4	862.2 KB
153775_01_01_XR15_timeseriesdata.mp4	2.0 MB
153775_01_06_XR15_noise.mp4	2.3 MB
153775_01_04_XR15_trend.mp4	2.6 MB
153775_01_02_XR15_plotting.mp4	2.7 MB
153775_01_03_XR151_level.mp4	3.8 MB
153775_01_05_XR15_seasonality.mp4	4.2 MB
153775_01_09_SO30_XR30_solution.mp4	4.3 MB
153775_01_07_XR15_movingaverage.mp4	4.7 MB
/Intro/
150165_00_03_XR15_exerfiles.mp4	863.6 KB
150165_00_02_XR15_know.mp4	914.8 KB
150165_00_01_WX30_intro.mp4	7.0 MB
/00 Introduction/
00_02-ExFiles.mp4	928.9 KB
00_01-Welcome.mp4	10.1 MB
/01. Introduction/
03 Using The Exercise Files.mp4	981.8 KB
02 What You Should Know.mp4	1.5 MB
01 Welcome.mp4	5.6 MB
/Exercise Files/Graphics/Employee Photos/
Ray Nguyen_Sales Representative_KinetEco_86526047.jpg	982.2 KB
Sally Kerner_CFO_KinetEco_153704542.jpg	4.7 MB
Jodean Langford_VP Sales&Marketing_KinetEco_89678676.jpg	4.8 MB
Lisa Marlee_Senior Sales Representative_KinetEco_80609062.jpg	5.5 MB
Evelyn Dott_Manager_Manufac&Distribution_KinetEco_165054775.jpg	7.6 MB
Jason Hemlock_Prin Design Engineer_KinetEco_128935745.jpg	8.0 MB
Robert Molina_Solar Installation Tech_KinetEco_89653785.jpg	9.6 MB
Simone Lodine_CEO_KinetEco_78528545.jpg	12.3 MB
Josephine Blickman_VP_Engineering&Manufacturing_KinetEco_145912962.jpg	17.7 MB
/.../5 Seasonality & the Ratio-to-Moving-Average Method/
153775_05_08_CH30_XR30_challenge.mp4	1.0 MB
153775_05_02_XR15_ratiotoMAintroduction.mp4	2.8 MB
153775_05_05_XR15_trend.mp4	3.8 MB
153775_05_07_XR15_trendchanging.mp4	4.8 MB
153775_05_09_SO30_XR30_solution.mp4	5.3 MB
153775_05_01_XR15_seasonalindex.mp4	5.9 MB
153775_05_03_XR15_CMA.mp4	6.7 MB
153775_05_04_XR15_indices.mp4	7.7 MB
153775_05_06_XR15_forecastingahead.mp4	9.0 MB
/.../3 Using a Trendline for Forecasting/
153775_03_06_CH30_XR30_challenge.mp4	1.1 MB
153775_03_02_XR15_intreprettrendline.mp4	2.6 MB
153775_03_01_XR15_trendline.mp4	4.2 MB
153775_03_03_XR15_Rsquare.mp4	6.8 MB
153775_03_04_XR15_standarderror.mp4	9.6 MB
153775_03_07_SO30_XR30_solution.mp4	10.0 MB
153775_03_05_XR15_autocorrelation.mp4	11.8 MB
/Exercise Files/
Ex_Files_ExcelDataAnalysis_Forecst.zip	1.1 MB
/.../2 How Good Are Your Forecasts - Errors, Accuracy & Bias/
153775_02_07_CH30_XR30_challenge.mp4	1.1 MB
153775_02_04_XR15_SSE.mp4	3.6 MB
153775_02_05_XR15_bias.mp4	4.4 MB
153775_02_02_XR15_MAD.mp4	5.2 MB
153775_02_06_XR15_advancedbias.mp4	5.7 MB
153775_02_01_XR15_accuracybias.mp4	6.4 MB
153775_02_03_XR15_MAPE.mp4	8.0 MB
153775_02_08_SO30_XR30_solution.mp4	8.6 MB
/0. Introduction/
Using the exercise files.mp4	1.1 MB
What you should know before watching this course.mp4	1.4 MB
Welcome.mp4	9.8 MB
/Exercise Files/Schematics/
3x9_windmill farm schematic.jpg	1.1 MB
/.../4 Modeling Exponential Growth & Compound Annual Growth Rate/
153775_04_04_CH30_XR30_challenge.mp4	1.2 MB
153775_04_03_XR15_CAGR.mp4	4.1 MB
153775_04_05_SO30_XR30_solution.mp4	4.9 MB
153775_04_01_XR15_lineartrendfails.mp4	7.6 MB
153775_04_02_XR15_exponential.mp4	8.2 MB
/13.Conclusion/
126129_13_01_SC11_goodbye.mp4.flv	1.2 MB
/05. Conclusion/
05_01-Next steps.mp4	1.3 MB
/Lynda - Excel 2013 Data Validation in Depth/
158659_00_02_XR15_exercise.mp4	1.3 MB
158659_07_01_XR15_next.mp4	1.7 MB
158659_01_02_XR15_inputmessage.mp4	3.4 MB
158659_01_03_XR15_erroralert.mp4	4.2 MB
158659_04_01_XR15_timecontrol.mp4	4.3 MB
158659_01_01_XR15_wholenumber.mp4	6.2 MB
158659_05_01_XR15_textcontrol.mp4	6.4 MB
158659_03_01_XR15_datecontrol.mp4	6.6 MB
158659_00_01_WX30_welcome.mp4	6.8 MB
158659_06_02_XR15_findvalidation.mp4	9.2 MB
158659_06_01_XR15_unique.mp4	9.5 MB
158659_06_03_XR15_violate.mp4	10.7 MB
158659_03_02_XR15_datefunctions.mp4	12.6 MB
158659_05_02_XR15_textfunctions.mp4	13.1 MB
158659_02_01_XR15_lists.mp4	13.2 MB
158659_04_02_XR15_timefunctions.mp4	13.3 MB
158659_02_02_XR15_listlocation.mp4	15.9 MB
158659_02_03_XR15_multitiered.mp4	16.3 MB
/3. Conclusion/
173210_03_01_XR15_next_steps.mp4	1.3 MB
/00. Introduction/
167361_00_02_XR15_exfiles.mp4	1.4 MB
167361_00_01_WX30_Intro.mp4	6.5 MB
/14. Conclusion/
167361_14_01_XR15_outro.mp4	1.4 MB
/.../05. Estimating Operating Expenses/
05_02-Excluding exceptional items.mp4	1.4 MB
05_05-Adding back exceptional elements.mp4	1.9 MB
05_01-Operating expenses (OPEX) projection basics.mp4	5.0 MB
05_04-Projecting variable OPEX.mp4	5.1 MB
05_03-Projecting fixed OPEX.mp4	5.2 MB
/.../1. Analyzing Gross Margin/
173210_01_05_XR15_allocating.mp4	1.4 MB
173210_01_07_XR15_using_standard_costs.mp4	7.2 MB
173210_01_01_XR15_basics.mp4	7.3 MB
173210_01_03_XR15_preparing.mp4	9.2 MB
173210_01_04_XR15_categorizing.mp4	9.7 MB
173210_01_10_XR15_adding_standard_costs3.mp4	10.8 MB
173210_01_12_XR15_levers.mp4	11.3 MB
173210_01_08_XR15_adding_standard_costs.mp4	13.0 MB
173210_01_02_XR15_data_points.mp4	15.7 MB
173210_01_11_XR15_analyzing.mp4	16.8 MB
173210_01_09_XR15_adding_standard_costs2.mp4	23.5 MB
173210_01_06_XR15_calculating.mp4	27.4 MB
/Conclusion/
150165_05_01_XR15_goodbye.mp4	1.4 MB
/00 Introduction/
0002 Using the exercise files.mov	1.4 MB
0001 Welcome.mov	12.9 MB
/Conclusion/
135358_10_01_3D15_Outro.mp4	1.5 MB
/08. Conclusion/
08_01-Next steps.mp4	1.5 MB
/01. Introduction/
01_02-Using the exercise files.mp4	1.5 MB
01_01-Welcome.mp4	9.0 MB
/Conclusion/
Next steps.mp4	1.5 MB
/01. Introduction/
01_02-Using the exercise files.mp4	1.6 MB
01_01-Welcome.mp4	8.8 MB
/.../02. Foundational Concepts of Data Analysis/
04 Introducing The Central Limit Theorem.mp4	1.6 MB
06 Identifying And Minimizing Sources Of Error.mp4	2.4 MB
05 Analyzing A Population Using Data Samples.mp4	6.1 MB
02 Measuring Maximums, Minimums, And Other Data Characteristics.mp4	6.6 MB
01 Calculating Mean And Median Values.mp4	8.1 MB
03 Analyzing Data Using Variance And Standard Deviation.mp4	9.8 MB
/08. Conclusion/
08_01-Next steps.mp4	1.6 MB
/16 Conclusion/
16_01-NextSteps.mp4	1.7 MB
/Lynda - Cleaning Up Your Excel 2013/
00_02-exfiles.mp4	1.8 MB
07_01-outro.mp4	1.9 MB
00_01-intro.mp4	8.1 MB
02_04-trailingminus.mp4	10.8 MB
03_02-texttocol.mp4	12.8 MB
01_01-moveinsert.mp4	13.6 MB
04_02-errorcheck.mp4	13.9 MB
03_03-datevalue.mp4	15.1 MB
05_01-misspell.mp4	15.2 MB
01_02-transpose.mp4	15.3 MB
04_01-texttovalue.mp4	16.4 MB
06_01-textfunctions.mp4	16.7 MB
02_01-substitute.mp4	21.5 MB
03_05-juliandate.mp4	25.2 MB
03_04-convertdate.mp4	26.6 MB
02_03-quotes.mp4	27.4 MB
05_02-autocorrect.mp4	27.6 MB
04_03-leadingzeroes.mp4	29.4 MB
01_03-sortempty.mp4	31.1 MB
02_02-replace.mp4	31.3 MB
06_05-flashfill.mp4	32.6 MB
03_01-unusual.mp4	34.7 MB
06_02-missingtitles.mp4	34.8 MB
06_04-texttocol.mp4	37.7 MB
06_03-combinecells.mp4	51.0 MB
/0.Introduction/
126129_00_02_SC11_exFiles.mp4.flv	2.0 MB
126129_00_01_SC13_intro.mp4.flv	8.1 MB
/0. Introduction/
173209_00_03_XR15_ex_files.mp4	2.0 MB
173209_00_02_XR15_need_to_know.mp4	3.2 MB
173209_00_01_WX30_welcome.mp4	7.1 MB
/.../04. Testing a Hypothesis/
02 Interpreting The Results Of Your Analysis.mp4	2.1 MB
03 Considering The Limits Of Hypothesis Testing.mp4	2.6 MB
01 Formulating A Hypothesis.mp4	4.3 MB
/0. Introduction/
173210_00_03_XR15_ex_files.mp4	2.1 MB
173210_00_02_XR15_need_to_know.mp4	3.1 MB
173210_00_01_WX30_welcome.mp4	5.9 MB
/0 Introduction/
186873_00_04_XR15_using_the_exercise_files.mp4	2.1 MB
186873_00_01_WX30_Welcome.mp4	2.8 MB
186873_00_03_XR15_Building_an_enviornment.mp4	3.7 MB
186873_00_02_XR15_Demonstration_of_the_dashboard_we_will_be_building.mp4	7.2 MB
/.../6 Forecasting with Multiple Regressions/
153775_06_09_CH30_XR30_challenge.mp4	2.2 MB
153775_06_03_XR15_running_regression.mp4	4.7 MB
153775_06_06_XR15_makingforecasts.mp4	7.7 MB
153775_06_08_XR15_coefficents.mp4	8.5 MB
153775_06_01_XR15_whatis.mp4	8.6 MB
153775_06_05_XR15_howgood.mp4	10.8 MB
153775_06_02_XR15_preparingdata.mp4	15.9 MB
153775_06_10_SO30_XR30_solution.mp4	16.2 MB
153775_06_04_XR15_findingEquation.mp4	17.7 MB
153775_06_07_XR15_validating.mp4	19.3 MB
/.../19. Summary And Credits/
19_02-About The Author.mp4	2.4 MB
19_01-What Have I Learned.mp4	6.7 MB
/.../01. Top Ten Shortcuts/
167361_01_08_XR15_datetime.mp4	2.4 MB
167361_01_06_XR15_createcharts.mp4	3.2 MB
167361_01_07_XR15_printpreview.mp4	4.6 MB
167361_01_03_XR151_copydowncol.mp4	4.9 MB
167361_01_01_XR15_nonadjacent.mp4	4.9 MB
167361_01_05_XR15_seeformulas.mp4	5.1 MB
167361_01_10_XR151_zoominout.mp4	7.0 MB
167361_01_04_XR151_columnwidth.mp4	8.5 MB
167361_01_02_XR15_convertform.mp4	8.9 MB
167361_01_09_XR151_undoredo.mp4	10.9 MB
/.../03. Creating Date and Time Entries/
03_02-Instant date and time entry.mp4	2.4 MB
03_03-Using TODAY and NOW functions for dynamic date and time entry.mp4	5.2 MB
03_01-Standard date- and time-entry options and acceptable alternatives.mp4	10.5 MB
03_04-Using AutoFill to enter a date or time series rapidly.mp4	18.9 MB
/.../3 Completing Your Dashboard/
186873_03_02_XR15_Formating_with_color.mp4	2.4 MB
186873_03_01_XR151_Adding_Power_View.mp4	6.9 MB
186873_03_03_XR15_Reviewing_the_completed_dashboard.mp4	8.5 MB
/4 Conclusion/
186873_04_01_XR15_Next_Steps.mp4	2.5 MB
/7. Conclusion/
173209_07_01_XR15_next_steps.mp4	2.5 MB
/08. Conclusion/
01 Further Resources.mp4	2.5 MB
/.../05. Date and Time Functions/
05_03-WEEKDAY Day-of-week determination.mp4	2.8 MB
05_07-DATEVALUE and TIMEVALUE Convert text entries into dates and times.mp4	4.8 MB
05_04-Calculating week numbers with WEEKNUM and ISOWEEKNUM.mp4	5.4 MB
05_05-NETWORKDAYS Calculate working days.mp4	5.5 MB
05_06-WORKDAY Calculate ending date.mp4	5.8 MB
05_01-EOMONTH and EDATE End of months and futurepast dates.mp4	9.5 MB
05_02-DATEDIF Date differences by year, month, day, and more.mp4	15.6 MB
/.../03. Visualizing Data/
02 Identifying Relationships Using XY Scatter Charts.mp4	2.8 MB
04 Adding Trendlines To Charts.mp4	4.1 MB
03 Visualizing Data Using Logarithmic Scales.mp4	5.6 MB
01 Grouping Data Using Histograms.mp4	6.6 MB
06 Calculating Running Averages.mp4	7.0 MB
05 Forecasting Future Results.mp4	7.8 MB
/06 Conclusion/
0601 Final thoughts.mov	2.8 MB
/.../1 Sourcing & Enhancing the Data Model/
186873_01_05_XR15_Creating_KPIs.mp4	2.9 MB
186873_01_01_XR15_Dashboard_Design_Guide_Lines.mp4	4.1 MB
186873_01_03_XR15_Relating_Data.mp4	4.2 MB
186873_01_02_XR15_Importing_Data.mp4	15.7 MB
186873_01_04_XR151_Creating_Calculated_Fields_and_Columns.mp4	17.8 MB
/7. Printing PivotTables/
Printing a PivotChart .mp4	3.0 MB
Printing a PivotTable.mp4	8.8 MB
Printing each item on its own pages..mp4	10.5 MB
Printing headers at the top of each printed page.mp4	11.3 MB
/.../07. Setting Up Targets/
07_01-Finding balance between the two approaches.mp4	3.0 MB
07_02-Moving from forecast to plan.mp4	6.6 MB
07_04-Developing worst-case scenarios.mp4	7.9 MB
07_03-Adapting projects for start-ups.mp4	18.7 MB
/08. Conclusion/
08_01-Next steps.mp4	3.0 MB
/.../07. Performing Bayesian Analysis/
01 Introducing Bayesian Analysis.mp4	3.0 MB
05 Updating Your Bayesian Analysis.mp4	5.0 MB
02 Analyzing A Sample Problem - Kahneman's Cabs.mp4	5.2 MB
03 Creating A Classification Matrix.mp4	5.5 MB
04 Calculating Bayesian Probabilities In Excel.mp4	9.1 MB
/7 Conclusion/
153775_07_01_XR15_nextsteps.mp4	3.0 MB
/10 Conclusion/
Next steps.mp4	3.1 MB
/.../08 Animating Charts and Data/
2 Removing animation.mp4	3.1 MB
4 Modifying animation orde.mp4	3.2 MB
3 Focusing your audience with emphasis effects and shapes.mp4	18.7 MB
1 Animating charts.mp4	21.8 MB
5 Animating SmartArt.mp4	21.9 MB
6 Animating large tables and objects.mp4	31.5 MB
/.../06. Measuring Covariance and Correlation/
05 Calculating Correlation Between Two Columns Of Data.mp4	3.2 MB
01 Visualizing What Covariance Means.mp4	4.5 MB
03 Calculating Covariance Among Multiple Pairs Of Columns.mp4	5.7 MB
06 Calculating Correlation Among Multiple Pairs Of Columns.mp4	6.4 MB
02 Calculating Covariance Between Two Columns Of Data.mp4	6.4 MB
04 Visualizing What Correlation Means.mp4	7.0 MB
/.../01 Getting Started with Excel 2013/
01_05-Formula.mp4	3.3 MB
01_06-status.mp4	3.7 MB
01_10-files.mp4	4.6 MB
01_09-help.mp4	5.5 MB
01_08-shortcutMenu.mp4	5.6 MB
01_01-ExcelUses.mp4	5.7 MB
01_04-Worksheet.mp4	6.2 MB
01_07-navigation.mp4	7.4 MB
01_02-menu.mp4	7.6 MB
01_03-QuickAccess.mp4	15.2 MB
/01. Introduction/
01_02-What you should know before watching this course.mp4	3.3 MB
01_01-Welcome.mp4	3.9 MB
/.../04. Estimating Cost of Production and Margin/
04_03-Combining product performance with product margins.mp4	3.3 MB
04_02-Determining which gross-margin profile to use.mp4	8.7 MB
04_01-Gross-margin projection basics.mp4	8.8 MB
/.../1. Preparing Your Revenue Information/
173209_01_05_XR15_pivot_sumif.mp4	3.4 MB
173209_01_01_XR15_basics.mp4	4.7 MB
173209_01_03_XR15_assembling.mp4	5.7 MB
173209_01_02_XR15_data_points.mp4	7.5 MB
173209_01_07_XR15_pivot.mp4	9.3 MB
173209_01_06_XR15_sumif.mp4	9.9 MB
173209_01_04_XR15_prep_data.mp4	17.3 MB
173209_01_08_XR15_consolidation.mp4	19.9 MB
/.../9. Starting with PowerPivot and the Data Model25m 44s/
Adding tables to the data model .mp4	3.4 MB
Enabling PowerPivot in Office 2013 Professional.mp4	4.3 MB
Importing PowerPivot data 3m .mp4	7.6 MB
Filtering data using a timeline.mp4	11.9 MB
Creating relationships between tables.mp4	11.9 MB
Managing table columns .mp4	12.0 MB
Creating a PowerPivot PivotTable.mp4	12.5 MB
Introducing PowerPivot.mp4	13.2 MB
/.../2. Creating Goal Seek and Solver Models/
150165_02_02_XR15_addsolver.mp4	3.6 MB
150165_02_03_XR15_setup.mp4	5.3 MB
150165_02_01_XR15_seek.mp4	5.4 MB
150165_02_05_XR15_integer.mp4	6.6 MB
150165_02_04_XR15_solve.mp4	10.1 MB
/00 Introduction/
2 What you should know before watching this course.mp4	3.6 MB
3 Using the exercise files.mp4	5.9 MB
1 Welcome.mp4	11.4 MB
/Lynda - Setting Up a Database in Excel 2013 + Exercise Files/
04_01-outro.mp4	3.8 MB
00_02-exfiles.mp4	5.3 MB
00_01-intro.mp4	9.1 MB
03_03-existingdata.mp4	15.4 MB
01_02-designproblem.mp4	18.6 MB
02_02-designtab.mp4	19.7 MB
02_04-tableformulas.mp4	25.5 MB
02_03-expandtables.mp4	29.1 MB
01_01-dbdesign.mp4	32.0 MB
02_05-slicers.mp4	32.0 MB
02_01-converttotable.mp4	36.7 MB
03_01-form.mp4	39.7 MB
03_02-datavalidation.mp4	48.2 MB
/.../2 Creating the Excel Power Pivot Dashboard/
186873_02_03_XR151_Create_The_Pivot_Charts.mp4	3.8 MB
186873_02_04_XR15_Create_The_Pivot_Tables_and_Charts_for_Customer_KPI_sheet.mp4	6.4 MB
186873_02_01_XR15_Linked_Table.mp4	8.4 MB
186873_02_02_XR15_Create_The_Pivot_Tables.mp4	11.1 MB
/.../06. Calculating with Dates and Times/
06_01-Calculating date differences with formulas and the DAYS function.mp4	4.0 MB
06_02-Calculating time differences within and between days.mp4	5.7 MB
06_07-Using times with currency calculations.mp4	5.7 MB
06_04-Calculating the first or last day of the last, current, or future month.mp4	7.4 MB
06_05-Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mp4	7.6 MB
06_03-Calculating fiscal years and quarters.mp4	9.3 MB
06_06-Rounding time calculations to convenient intervals.mp4	9.8 MB
/.../01. Getting Started/
01_02-Using The Included Files.mp4	4.0 MB
01_01-Will I Be Able To Keep Up.mp4	6.0 MB
01_03-New For 2013 Its All In The Cloud.mp4	10.3 MB
01_04-The Very Clever Flash Fill.mp4	12.2 MB
/.../02. Introducing Cluster Analysis/
02_02-How do you identify clusters.mp4	4.0 MB
02_01-What is clustering.mp4	4.1 MB
02_03-What does cluster analysis look like in Excel.mp4	6.0 MB
/.../02 Entering Data/
02_05-comments.mp4	4.1 MB
02_03-DatesTimes.mp4	4.3 MB
02_02-AutoFill.mp4	4.8 MB
02_01-dataEntry.mp4	5.1 MB
02_04-UndoRedo.mp4	5.1 MB
02_06-FileSave.mp4	6.4 MB
/.../4 Using the Data-Mining Add-ins in Excel/
186872_04_07_XR15_Excel_Data_Mining_Highlight_Exceptions.mp4	4.2 MB
186872_04_06_XR15_Excel_Data_Mining_Detect_Categories.mp4	4.7 MB
186872_04_08_XR15_Excel_Data_Mining_Scenario_Analysis.mp4	5.9 MB
186872_04_09_XR15_Excel_Data_Mining_Shopping_Basket_Analysis.mp4	6.5 MB
186872_04_05_XR15_Excel_Data_Mining_Analyize_Key_Influencers.mp4	6.6 MB
186872_04_10_XR15_Excel_Data_Mining_Prediction_Calculator.mp4	9.0 MB
186872_04_04_XR15_The_User_Interface_Data_Modeling_Group.mp4	16.9 MB
186872_04_03_XR15_The_User_Interface_Accuracy_and_Validation_Group.mp4	17.1 MB
186872_04_11_XR15_Excel_Data_Mining_Demonstration_of_prediction_with_a_model.mp4	19.7 MB
186872_04_01_XR15_The_User_Interface_Data_Preperation_Tab.mp4	29.4 MB
186872_04_02_XR15_The_User_Interface_Model_Usage_Group.mp4	37.1 MB
/.../02. Financial Projection Basics/
02_01-Financial projections.mp4	4.3 MB
02_02-The difference between forecasting and planning.mp4	6.7 MB
02_03-Treating start-ups and established businesses differently.mp4	7.4 MB
02_04-The top-down and bottom-up approaches.mp4	7.7 MB
02_05-Volatility and the treatment of exceptional elements.mp4	8.5 MB
/.../2. Analyzing Operating Expenses/
173210_02_07_XR15_analyzing_general.mp4	4.4 MB
173210_02_01_XR15_opex_analysis.mp4	4.7 MB
173210_02_04_XR15_analyzing_sales.mp4	6.6 MB
173210_02_05_XR15_analyzing_staff.mp4	8.7 MB
173210_02_02_XR15_finding.mp4	12.9 MB
173210_02_06_XR15_analyzing_productivity.mp4	12.9 MB
173210_02_03_XR15_analyzing_opex.mp4	13.2 MB
/.../3. Creating a Configurable Model/
150165_03_01_XR15_setup.mp4	4.4 MB
150165_03_04_XR15_manip.mp4	4.6 MB
150165_03_02_XR15_slider.mp4	8.9 MB
150165_03_03_XR15_check.mp4	15.8 MB
/.../12. Charting and Visual Object Tips/
167361_12_02_XR15_titlefromcell.mp4	4.4 MB
167361_12_01_XR15_chartplacement.mp4	8.4 MB
167361_12_03_XR15_shapes.mp4	11.4 MB
167361_12_04_XR151_linkpicture.mp4	27.8 MB
/.../03. Running a Macro/
03_03-Running a macro from a keystroke shortcut.mp4	4.4 MB
03_01-Running a macro from the Developer tab or the View tab.mp4	5.8 MB
03_04-Running a macro from an object or clip art.mp4	8.6 MB
03_02-Running a macro from the Quick Access Toolbar button.mp4	15.0 MB
/.../02. The Excel Date and Time Systems/
02_02-How Excel records and stores times.mp4	4.5 MB
02_01-How Excel records and stores dates.mp4	13.9 MB
/.../03. Estimating Volumes, Price, and Revenue/
03_01-Revenue projection basics.mp4	4.7 MB
03_06-Detailing your plan by month using seasonality.mp4	5.4 MB
03_04-Adjusting for changes in productivity.mp4	5.9 MB
03_07-Creating a product-level projection.mp4	6.4 MB
03_09-Market-driven forecasting.mp4	7.1 MB
03_08-Adding back exceptional elements using pipeline information.mp4	7.7 MB
03_05-Adjusting for changing resources.mp4	9.3 MB
03_02-Preparing past P&Ls.mp4	10.9 MB
03_03-Projecting revenue based on your resources.mp4	13.7 MB
/.../12. Visualizing Power View Data Using Charts and Maps/
Creating a pie chart.mp4	4.8 MB
Creating maps with multivalue series.mp4	6.2 MB
Creating chart multiples.mp4	6.4 MB
Creating a map.mp4	6.4 MB
Creating a line chart.mp4	6.5 MB
Creating a column or bar chart.mp4	9.2 MB
/04 Formatting/
04_03-alignment.mp4	4.9 MB
04_04-borders.mp4	6.6 MB
04_02-columnwidth.mp4	9.1 MB
04_06-datetime.mp4	10.8 MB
04_01-fonts.mp4	10.8 MB
04_09-insertVisuals.mp4	11.0 MB
04_07-conditional.mp4	12.3 MB
04_05-numeric.mp4	13.7 MB
04_08-tables.mp4	19.5 MB
/.../3 Introduction to Data Analysis Expressions (DAX)/
186871_03_05_XR15_other_dax_functions.mp4	4.9 MB
186871_03_04_XR15_calculate.mp4	15.0 MB
186871_03_03_XR15_evaluation_context.mp4	16.7 MB
186871_03_01_XR15_basic_dax_syntax.mp4	24.1 MB
186871_03_02_XR15_using_the_dax_coding_interface.mp4	36.3 MB
/.../09 Multiple Worksheets and Workbooks/
09_02-rename.mp4	4.9 MB
09_04-LinkingFormulas.mp4	8.7 MB
09_03-MoveCopy.mp4	8.9 MB
09_01-Displaying multiple worksheets and workbooks.mp4	10.6 MB
09_05-ManagingLinks.mp4	12.8 MB
/.../1. Defining Scenarios and Data Tables/
150165_01_05_XR15_one.mp4	5.1 MB
150165_01_03_XR15_summarize.mp4	5.1 MB
150165_01_04_XR15_edit.mp4	5.2 MB
150165_01_06_XR15_two.mp4	5.3 MB
150165_01_01_XR15_create.mp4	5.6 MB
150165_01_02_XR15_show.mp4	6.4 MB
/18. Macros/
18_01-What Is A Macro.mp4	5.2 MB
18_03-Saving Workbooks With Macros.mp4	5.6 MB
18_08-Trigger A Macro With A Keyboard Shortcut.mp4	6.3 MB
18_07-Use Of Relative Or Absolute Referencing.mp4	8.4 MB
18_05-The Personal Macro Workbook.mp4	8.6 MB
18_06-Deleting Macros.mp4	9.9 MB
18_04-Macro Security Settings For Workbooks With Macros.mp4	10.1 MB
18_14-Create Your Own Ribbon.mp4	11.3 MB
18_09-Formatting With A Macro.mp4	13.0 MB
18_02-Creating And Running Your First Macro.mp4	13.2 MB
18_13-Assigning Macros To Ribbon Icons.mp4	17.3 MB
18_12-Customizing Form Buttons And Other Shape Triggers.mp4	18.3 MB
18_10-Switch Scenarios And Views With Macros.mp4	18.4 MB
18_11-Use Of Worksheet Buttons To Trigger Macros.mp4	19.5 MB
18_15-View And Edit Macro Code.mp4	21.8 MB
18_16-Add An Are You Sure Box To Macros.mp4	24.4 MB
/.../17. Goal Seek And Solver/
17_02-Activating The Solver Add-In.mp4	5.2 MB
17_04-Adding Constraints To Solver.mp4	9.9 MB
17_01-What-If Analysis Using Goal Seek.mp4	10.1 MB
17_03-Using Solver To Complete A What-If.mp4	17.7 MB
/6. Other Considerations/
173209_06_02_XR15_KPIs.mp4	5.3 MB
173209_06_01_XR15_dependencies.mp4	6.3 MB
/.../04. Date and Time Formatting/
04_03-Keystroke shortcuts.mp4	5.4 MB
04_04-Time formatting for hours over 24.mp4	6.9 MB
04_02-Custom date formatting.mp4	7.0 MB
04_01-Standard date and time formats.mp4	7.6 MB
/.../2. Creating Basic Charts Quickly/
135358_02_04_3D15_StandardMenu.mp4	5.5 MB
135358_02_02_3D15_InstantCharts.mp4	8.2 MB
135358_02_03_3D15_RecommendedCharts.mp4	10.4 MB
135358_02_01_3D15_SelectData.mp4	14.0 MB
135358_02_05_3D15_Sparklines.mp4	21.6 MB
/.../11. Visualizing Power View Data Using Matrices, Cards, and Tiles/
Starting out with Power View.mp4	5.5 MB
Formatting Power View objects.mp4	6.6 MB
Installing Microsoft Silverlight .mp4	7.0 MB
Creating a tile .mp4	7.4 MB
Creating a card.mp4	7.7 MB
Filtering Power View objects.mp4	8.4 MB
Creating a table or matrix .mp4	10.3 MB
/Lynda - Financial Analysis Introduction to Business Performance Analysis/
02_01-next_steps.mp4	5.5 MB
00_02-need_to_know.mp4	6.5 MB
00_01-welcome.mp4	6.6 MB
01_04-controllable.mp4	9.1 MB
01_07-difference.mp4	9.8 MB
01_06-decision_making.mp4	10.3 MB
01_01-the_key.mp4	11.4 MB
01_02-analyzing.mp4	14.4 MB
01_05-exceptional.mp4	18.7 MB
01_03-when_to_stop.mp4	21.1 MB
/.../07. Using Dates and Times with Excel Commands/
07_03-Converting unusually formatted dates into usable data Text to columns.mp4	5.5 MB
07_02-Using date and time controls and functions in data validation rules.mp4	10.2 MB
07_01-Using special date filters with date data Advanced data filter applications.mp4	13.8 MB
/.../14 Data Analysis Tools/
14_04-DataTable.mp4	5.5 MB
14_02-Solver.mp4	9.6 MB
14_01-GoalSeek.mp4	11.1 MB
14_03-Scenario.mp4	14.8 MB
/.../2 The Microsoft Data-Mining Algoriithms/
186872_02_01_XR15_Types_of_data_mining_algorithims.mp4	5.5 MB
186872_02_02_XR15_The_Microsoft_algorithims.mp4	11.5 MB
/.../4. Performing Monte Carlo Simulation/
150165_04_03_XR15_lookup.mp4	5.5 MB
150165_04_01_XR15_setup.mp4	6.3 MB
150165_04_04_XR15_run.mp4	7.1 MB
150165_04_02_XR15_input.mp4	8.1 MB
/4 Conclusion/
186871_04_01_XR15_next_steps.mp4	5.6 MB
/.../05 Adjusting Worksheet Layout and Data/
05_04-findReplace.mp4	5.6 MB
05_02-hide.mp4	8.3 MB
05_01-insertDelete.mp4	14.9 MB
05_03-moveCopy.mp4	19.7 MB
/.../11. Database Techniques/
167361_11_05_XR15_joindata.mp4	5.6 MB
167361_11_06_XR15_uniqueentry.mp4	6.7 MB
167361_11_07_XR15_weekdays.mp4	7.6 MB
167361_11_08_XR15_uniquelists.mp4	10.4 MB
167361_11_01_XR15_sortbuttons.mp4	11.3 MB
167361_11_03_XR15_duplicates.mp4	11.8 MB
167361_11_04_XR15_splitdata.mp4	12.9 MB
167361_11_02_XR151_spaces.mp4	18.2 MB
/.../01 Mastering the Utility Tasks Associated with Multiple Worksheets/
0104 Changing tab colors and renaming sheets.mov	5.7 MB
0103 Copying and moving sheets within a workbook.mov	7.9 MB
0102 Inserting and deleting new sheets.mov	8.7 MB
0105 Using the Hide function on worksheet tabs.mov	11.6 MB
0101 Learning basic navigation tips.mov	19.2 MB
/.../06. Cash Flow Projection/
06_03-The exit methodology.mp4	5.7 MB
06_04-Projecting gross margin and OPEX.mp4	7.1 MB
06_01-Explaining the top-down approach.mp4	7.8 MB
06_02-The revenue trajectory method.mp4	10.1 MB
/.../02 Working with Multiple Worksheets/
0202 Copying, moving, and inserting data on different sheets.mov	5.9 MB
0203 Applying global changes to worksheets.mov	7.7 MB
0201 Displaying multiple worksheets from the same workbook.mov	18.4 MB
/.../11 Security and Sharing/
11_02-ProtectWorkbook.mp4	5.9 MB
11_04-SharingWorkbook.mp4	7.6 MB
11_03-WorkbookPassword.mp4	7.8 MB
11_05-TrackingChanges.mp4	9.2 MB
11_01-ProtectWorksheet.mp4	12.4 MB
/.../07. Drag-and-Drop Techniques/
167361_07_03_XR15_moveinsert.mp4	6.0 MB
167361_07_04_XR151_pastespec.mp4	11.4 MB
167361_07_01_XR151_copymove.mp4	11.5 MB
167361_07_02_XR151_copysheet.mp4	11.9 MB
167361_07_05_XR15_rightmouse.mp4	13.4 MB
/3. Customer Information/
173209_03_01_XR15_customer_info.mp4	6.0 MB
173209_03_02_XR15_current_cust.mp4	8.4 MB
173209_03_03_XR15_rev_per_cust.mp4	12.9 MB
173209_03_04_XR15_new_vs_return.mp4	20.3 MB
/.../06. Data Entry and Editing Shortcuts/
167361_06_03_XR15_times.mp4	6.1 MB
167361_06_05_XR151_editing.mp4	8.9 MB
167361_06_02_XR15_dates.mp4	16.7 MB
167361_06_01_XR151_dataentry.mp4	16.9 MB
167361_06_04_XR151_customlist.mp4	22.0 MB
/4. Product Information/
173209_04_03_XR15_upsell.mp4	6.2 MB
173209_04_01_XR15_prod_info.mp4	8.7 MB
173209_04_02_XR15_rev_per_prod.mp4	11.1 MB
/.../3. Sorting and Filtering PivotTable Data/
Clearing and reapplying PivotTable filters.mp4	6.2 MB
Filtering a PivotTable by rule.mp4	8.2 MB
Formatting slicers.mp4	8.6 MB
Filtering a PivotTable using slicers .mp4	10.2 MB
Sorting PivotTable data.mp4	10.8 MB
Filtering a PivotTable using a search filter.mp4	10.9 MB
Filtering a PivotTable field by selection.mp4	11.7 MB
Filtering with report filter fields.mp4	12.8 MB
Creating a custom sort order.mp4	14.6 MB
/13 PivotTables/
13_05-slicers.mp4	6.3 MB
13_06-PivotChart.mp4	7.8 MB
13_04-groupingOther.mp4	9.8 MB
13_02-manipulating.mp4	11.1 MB
13_03-grouping.mp4	12.0 MB
13_01-createPivotTable.mp4	23.9 MB
/05. Sparklines/
05_05-Removing Sparklines From A Worksheet.mp4	6.3 MB
05_03-Dealing With Empty Cells.mp4	6.9 MB
05_04-Comparing Sparklines Within A Sparkline Group.mp4	11.4 MB
05_02-Altering The Design Of Sparklines.mp4	11.7 MB
05_01-Creating A Sparkline.mp4	12.9 MB
/.../07 Using SmartArt in Data-Driven Presentations/
2 Repurposing lists as diagrams.mp4	6.5 MB
1 Creating a SmartArt diagram.mp4	10.0 MB
3 Creating an organization chart with photos.mp4	10.2 MB
4 Converting SmartArt to shapes.mp4	36.8 MB
/.../05. Utilizing Data Distributions/
05 Using The Poisson Distribution.mp4	6.5 MB
04 Using The Binomial Distribution.mp4	7.0 MB
03 Using A Uniform Distribution.mp4	8.3 MB
02 Using The Exponential Distribution.mp4	8.8 MB
01 Using The Normal Distribution.mp4	8.9 MB
/16. PivotCharts/
16_06-Hiding The PivotChart Buttons.mp4	6.5 MB
16_01-Creating A PivotChart.mp4	9.2 MB
16_05-Filtering A PivotChart.mp4	11.4 MB
16_07-Moving And Deleting PivotCharts.mp4	12.3 MB
16_02-Changing The Fields Used In A PivotChart.mp4	12.6 MB
16_04-Changing The PivotChart Type.mp4	13.5 MB
16_03-Formatting The PivotChart.mp4	14.1 MB
/.../5. Format Tab Options Inserting Pictures, Shapes, and Text Boxes/
135358_05_07_3D15_ChartText.mp4	6.6 MB
135358_05_05_3D15_ShapeEffects.mp4	7.0 MB
135358_05_06_3D15_WordArt.mp4	8.4 MB
135358_05_02_3D15_AddShapesArrows.mp4	9.0 MB
135358_05_08_3D15_RotateChartText.mp4	9.4 MB
135358_05_03_3D15_FloatingText.mp4	10.8 MB
135358_05_04_3D15_ShapeStyles.mp4	11.7 MB
135358_05_01_3D15_Picture.mp4	12.7 MB
/.../2. Summarizing PivotTable Data/
Summarizing more than one data field.mp4	6.6 MB
Drilling down to the underlying data.mp4	7.0 MB
Creating a calculated field .mp4	10.0 MB
Grouping PivotTable fields.mp4	11.6 MB
Using PivotTable data in a formula.mp4	12.3 MB
Managing subtotals and grand totals.mp4	12.9 MB
Changing the data field summary operation.mp4	18.4 MB
/15. PivotTables/
15_10-Drilling Down Behind The Pivot Numbers.mp4	6.7 MB
15_09-Refreshing A PivotTable.mp4	7.2 MB
15_20-Managing The External Connection To SQL Server.mp4	7.3 MB
15_16-Creating And Using Calculated Fields.mp4	9.8 MB
15_06-Moving And Deleting PivotTables.mp4	10.0 MB
15_01-What Is A PivotTable.mp4	10.1 MB
15_02-The New Recommended PivotTable Route.mp4	10.9 MB
15_17-Using The New Timeline Filter Option.mp4	11.4 MB
15_15-Creating Your Own PivotTable Styles.mp4	11.5 MB
15_04-Changing The Formatting And Formulas In PivotTable Summaries.mp4	11.9 MB
15_19-Using Data From An SQL Server In A PivotTable.mp4	12.1 MB
15_12-Controlling Grand Totals And Subtotals.mp4	12.8 MB
15_14-PivotTable Styles.mp4	13.1 MB
15_05-Creating Multiple PivotTables On The Same Dataset.mp4	13.1 MB
15_13-Dealing With Empty Cells And Other Additional Options.mp4	13.2 MB
15_08-Sorting The PivotTable Columns.mp4	13.4 MB
15_11-Multiple Fields In Row, Column, Or Data Sections.mp4	13.8 MB
15_18-Adding And Using The Data Slicer.mp4	14.2 MB
15_07-Making Use Of The Report Filter Options.mp4	14.3 MB
15_03-Creating Your Own PivotTables.mp4	16.8 MB
/.../6. Creating and Manipulating PivotCharts/
Pivoting a PivotChart .mp4	6.7 MB
Changing a PivotChart's chart type.mp4	6.9 MB
Filtering a PivotChart .mp4	7.6 MB
Adding a trendline to a PivotChart.mp4	8.3 MB
Creating a PivotChart .mp4	8.6 MB
Changing a PivotChart's layout.mp4	9.9 MB
Formatting a PivotChart.mp4	10.6 MB
/.../05 Summarizing with PivotTables and PivotCharts/
2 Filtering items in a PivotTable.mp4	6.8 MB
3 Creating a PivotChart.mp4	16.5 MB
1 Creating and formatting a PivotTable.mp4	23.4 MB
/.../03. Building a Cluster Analysis Worksheet/
03_01-Setting up your Excel table.mp4	6.8 MB
03_03-Calculating the distance to a centroid.mp4	7.5 MB
03_04-Identifying each row`s closest centroid.mp4	9.1 MB
03_07-Running macros using command buttons.mp4	9.7 MB
03_02-Creating a list of random centroids.mp4	11.2 MB
03_06-Automating updates using macros.mp4	11.6 MB
03_05-Updating centroids using averages.mp4	15.6 MB
/.../07 Introduction to Charting/
07_04-ChartElements.mp4	6.9 MB
07_01-CreatingCharts.mp4	8.6 MB
07_02-ChartTypes.mp4	9.2 MB
07_03-formatting.mp4	10.3 MB
07_05-Sparklines.mp4	13.3 MB
/.../1 Data-Mining Concepts/
186872_01_02_XR15_CRISP_DM.mp4	6.9 MB
186872_01_04_XR15_Models_induction_and_predictions.mp4	7.5 MB
186872_01_01_XR15_Concepts_and_results.mp4	11.3 MB
186872_01_03_XR15_Business_Problems_for_Data_Mining.mp4	13.3 MB
186872_01_05_XR15_Key_concepts.mp4	17.1 MB
/.../2 The Power Pivot Data Model/
186871_02_05_XR15_perspectives.mp4	6.9 MB
186871_02_06_XR15_kpis.mp4	8.7 MB
186871_02_04_XR15_hierarchies.mp4	12.4 MB
186871_02_02_XR15_relating_tables.mp4	24.1 MB
186871_02_01_XR15_datasources.mp4	31.0 MB
186871_02_03_XR151_date_tables.mp4	31.8 MB
/.../1. Creating and Pivoting PivotTables/
Connecting to an external data source.mp4	7.0 MB
Creating a Recommended PivotTable.mp4	8.2 MB
Creating a PivotTable .mp4	8.6 MB
Pivoting a PivotTable.mp4	8.9 MB
Formatting data for use in a PivotTable.mp4	9.2 MB
Configuring a PivotTable.mp4	10.8 MB
Introducing PivotTables .mp4	11.4 MB
Managing PivotTables.mp4	12.5 MB
Consolidating data from multiple sources.mp4	18.4 MB
/.../10. Introducing Data Analysis Expressions/
Adding calculated columns .mp4	7.0 MB
ntroducing the DAX language.mp4	7.8 MB
Creating filtered calculations .mp4	8.0 MB
Surveying DAX functions .mp4	8.6 MB
Adding calculated fields.mp4	9.1 MB
Using DAX operators.mp4	11.6 MB
Creating aggregate calculations .mp4	12.1 MB
/.../01 Data-Driven Presentations The Basics/
1 Creating a data-driven presentation.mp4	7.1 MB
2 Using Excel data in PowerPoint.mp4	19.3 MB
3 How themes impact presentation data.mp4	20.1 MB
/.../1. Understanding Excel Chart Concepts/
135358_01_03_3D15_ChartTerminology.mp4	7.1 MB
135358_01_04_3D15_ChartToolsRibbon.mp4	12.3 MB
135358_01_01_3D15_IdentifyChartElements.mp4	14.0 MB
135358_01_02_3D15_ChartTypes.mp4	16.8 MB
/.../03 Linking Worksheets with Formulas/
0301 Creating linkage formulas.mov	7.2 MB
0302 Creating 3D formulas for worksheets with identical layouts.mov	10.8 MB
0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov	20.5 MB
/.../04 Working with Multiple Workbooks/
0401 Navigating between open workbooks.mov	7.3 MB
0402 Displaying multiple worksheets from different workbooks.mov	10.5 MB
0403 Copying and moving data and entire worksheets across different workbooks.mov	12.6 MB
/.../4. Changing Chart Options/
135358_04_03_3D15_LinkingTitles.mp4	7.4 MB
135358_04_05_3D15_DataTable.mp4	7.8 MB
135358_04_06_3D15_ErrorBars.mp4	7.9 MB
135358_04_08_3D15_Legends.mp4	11.2 MB
135358_04_07_3D15_Gridlines.mp4	13.4 MB
135358_04_09_3D15_DropLines.mp4	14.6 MB
135358_04_10_3D15_Trendline.mp4	15.2 MB
135358_04_04_3D15_DataLabels.mp4	17.2 MB
135358_04_02_3D15_ChartTitles.mp4	19.3 MB
135358_04_01_3D15_ModifyingAxes.mp4	33.8 MB
/.../04 Using Charts to Illustrate Data/
6 Creating a combination chart.mp4	7.5 MB
2 Creating a pie chart.mp4	9.9 MB
1 Choosing the right chart.mp4	12.0 MB
5 Creating a 100% chart.mp4	13.1 MB
3 Creating a column chart.mp4	15.9 MB
4 Building an infographic using a picture fill.mp4	17.7 MB
7 Creating charts in PowerPoint.mp4	19.6 MB
/0 Introduction/
186871_00_02_XR15_ex_files.mp4	7.6 MB
186871_00_01_XR15_welcome.mp4	8.6 MB
/.../08. Formula Shortcuts/
167361_08_04_XR15_autosum.mp4	7.7 MB
167361_08_08_XR15_nonformula.mp4	9.3 MB
167361_08_05_XR151_rounding.mp4	10.8 MB
167361_08_02_XR15_dependents.mp4	11.0 MB
167361_08_06_XR151_random.mp4	12.2 MB
167361_08_03_XR15_precedents.mp4	13.0 MB
167361_08_01_XR151_fastformula.mp4	14.1 MB
167361_08_07_XR151_uniquecount.mp4	14.1 MB
/.../5. Applying Conditional Formats to PivotTables/
Deleting a conditional formatting rule.mp4	7.8 MB
Controlling how multiple rules are applied.mp4	10.5 MB
Formatting cells using color scales.mp4	11.2 MB
Formatting cells using data bars.mp4	11.9 MB
Formatting cells using icon sets.mp4	13.6 MB
Highlighting cells by applying a rule.mp4	14.5 MB
Editing a conditional formatting rule.mp4	16.1 MB
Highlighting the top or bottom values in a PivotTable .mp4	21.0 MB
/5 Conclusion/
186872_05_01_XR15_Next_steps.mp4	7.9 MB
/.../10. Formatting Shortcuts/
167361_10_04_XR15_condformat.mp4	8.0 MB
167361_10_05_XR15_colorformulas.mp4	8.3 MB
167361_10_07_XR15_hoursover24.mp4	9.5 MB
167361_10_02_XR151_alignment.mp4	12.8 MB
167361_10_08_XR15_borders.mp4	14.3 MB
167361_10_06_XR15_customformat.mp4	14.6 MB
167361_10_01_XR15_numformat.mp4	15.5 MB
167361_10_03_XR15_rowcoloring.mp4	20.7 MB
/.../05 Linking Formulas Across Multiple Workbooks/
0501 Creating formulas that link worksheets in different workbooks.mov	8.1 MB
0502 Locating and managing links between multiple workbooks.mov	11.6 MB
0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov	20.1 MB
/6.Statistical Functions/
126129_06_03_SC11_LARGESMALL.mp4.flv	8.1 MB
126129_06_05_SC11_COUNT.mp4.flv	13.0 MB
126129_06_01_SC11_MEDIAN.mp4.flv	13.0 MB
126129_06_02_SC11_RANK.mp4.flv	18.9 MB
126129_06_04_SC11_COUNTBLANK.mp4.flv	28.1 MB
/.../14. Auditing And Troubleshooting Formulas/
14_02-Adding And Removing Tracer Arrows.mp4	8.2 MB
14_04-Step-By-Step Formula Processing.mp4	10.3 MB
14_05-Using The Watch Window In Troubleshooting.mp4	11.3 MB
14_01-What Are Tracer Arrows.mp4	11.7 MB
14_03-Auditing Tools Error Checking And Tracing.mp4	16.0 MB
/.../09. Operational Shortcuts/
167361_09_05_XR15_2spaceprint.mp4	8.2 MB
167361_09_02_XR15_realigntext.mp4	9.2 MB
167361_09_03_XR151_blanks.mp4	14.6 MB
167361_09_04_XR151_outline.mp4	18.1 MB
167361_09_01_XR151_rowcolumn.mp4	20.9 MB
/5. Exceptional Revenue/
173209_05_01_XR15_identifying.mp4	8.2 MB
173209_05_03_XR15_analyzing.mp4	11.9 MB
173209_05_02_XR15_isolating.mp4	23.7 MB
/.../02. Ribbon and Quick Access Toolbar Tips/
167361_02_01_XR15_hideribbon.mp4	8.3 MB
167361_02_02_XR15_altkeycommand.mp4	9.3 MB
167361_02_03_XR15_quickaccess.mp4	9.7 MB
/.../10 IF, VLOOKUP, and Power Functions/
10_01-IFfunction.mp4	8.4 MB
10_04-countif.mp4	9.0 MB
10_02-vlookupApprox.mp4	10.7 MB
10_03-vlookupExact.mp4	15.8 MB
/.../8. Manipulating PivotTables Using Macros/
Creating a simple PivotTable presentation kit.mp4	8.4 MB
Recording and reviewing an Excel macro.mp4	9.8 MB
Running an Excel macro .mp4	10.7 MB
/2. Past Performance/
173209_02_02_XR15_combining.mp4	8.5 MB
173209_02_01_XR15_seasonality.mp4	16.7 MB
/0 Introduction/
186872_00_02_XR15_What_you_should_know_before_watching_this_course.mp4	8.5 MB
186872_00_01_WX30_Welcome.mp4	8.9 MB
186872_00_03_XR15_Demonstration_of_the_Excel_Data_Mining_Tools_we_will_be_building.mp4	11.6 MB
186872_00_04_XR15_Building_an_environment.mp4	23.4 MB
/.../09. Custom Views/
09_01-Custom Views Explained.mp4	8.6 MB
09_04-Add Quick Access To Custom Views.mp4	9.2 MB
09_02-Use Of Outlining To Help Setup Custom Views.mp4	9.9 MB
09_03-Editing And Deleting Custom Views.mp4	11.9 MB
/.../10. Functions For Manipulating Text/
10_09-Keeping The Values Created By String Manipulation.mp4	8.6 MB
10_05-Changing Case Functions.mp4	10.5 MB
10_01-LEFT And RIGHT Text Manipulation.mp4	12.1 MB
10_06-REPLACE And SUBSTITUTE Two More String Manipulation Functions.mp4	12.3 MB
10_08-Formatting Numeric And Date Values Using TEXT.mp4	13.1 MB
10_04-CONCATENATE Building Strings From Multiple Cells.mp4	13.9 MB
10_07-Use Of CHAR Function For More Obscure Characters.mp4	15.8 MB
10_02-LEN And TRIM String Extractions.mp4	16.3 MB
10_03-FIND And MID Text Functions Working Together.mp4	17.6 MB
/.../04. Navigation Shortcuts/
167361_04_01_XR15_betwnbooks.mp4	8.6 MB
167361_04_02_XR151_betwnsheets.mp4	12.4 MB
167361_04_03_XR151_withinsheet.mp4	21.7 MB
/4. Formatting PivotTables/
Changing the data field number format.mp4	8.6 MB
Applying a PivotTable style.mp4	9.7 MB
Creating a PivotTable style.mp4	15.4 MB
Changing the PivotTable layout.mp4	15.9 MB
/.../12. Useful Data Functions/
12_03-Handling Out Of Range Index Requests.mp4	8.7 MB
12_04-The CHOOSE Lookup Function.mp4	9.7 MB
12_02-How The INDEX Function Works.mp4	13.0 MB
12_05-MATCH And INDEX Functions Working Together.mp4	13.1 MB
12_01-Using The MATCH Function.mp4	17.0 MB
/07. Outlining/
07_02-Adding An Outline Manually.mp4	8.7 MB
07_01-Create An Outline Automatically.mp4	10.6 MB
07_03-Editing And Removing Outlining.mp4	17.3 MB
/.../03 Highlighting Data with Conditional Formatting/
1 Understanding conditional formatting.mp4	8.8 MB
3 Using data bars.mp4	16.3 MB
4 Using icon sets.mp4	16.7 MB
2 Formatting a cell based on its contents.mp4	24.8 MB
5 Editing a conditional format.mp4	26.8 MB
/.../02. Using Mathematical Functions/
02_04-COUNTIF For Selective Counting.mp4	8.8 MB
02_07-Area And Volume Calculations.mp4	9.3 MB
02_02-AVERAGE, MODE, MEAN, And MEDIAN.mp4	9.5 MB
02_05-AVERAGEIF For The Mean Of Selected Cells.mp4	10.0 MB
02_01-The Basic SUM, COUNT, MIN, And MAX.mp4	10.2 MB
02_03-SUMIF For Selective Adding Up.mp4	17.3 MB
02_06-Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF.mp4	23.0 MB
/.../12 The Database Features of Excel/
12_05-duplicates.mp4	8.8 MB
12_04-splitting.mp4	16.7 MB
12_01-sorting.mp4	18.1 MB
12_03-filter.mp4	21.6 MB
12_02-subtotal.mp4	52.8 MB
/.../12.Information Functions/
126129_12_04_SC11_ISFORMULA.mp4.flv	8.9 MB
126129_12_02_SC11_ISFunctions.mp4.flv	16.7 MB
126129_12_01_SC11_CELL-INFO.mp4.flv	17.9 MB
126129_12_03_SC11_errorChecking.mp4.flv	23.0 MB
/.../13. Some Other Useful Functions/
13_06-Dealing With INDIRECT Errors.mp4	9.2 MB
13_01-Introducing IS Functions.mp4	10.5 MB
13_03-OFFSET Function Syntax.mp4	11.0 MB
13_05-INDIRECT Function To Build Dynamic Formulas.mp4	11.5 MB
13_04-OFFSET Function Creating A Dynamic Named Range.mp4	13.1 MB
13_02-Error Checking Using ISERR, ISERROR, And IFERROR.mp4	16.2 MB
13_07-The CELL Function And Determining File Or Sheet Names.mp4	18.8 MB
/08. Scenarios/
08_02-Displaying And Editing The Different Scenarios.mp4	9.2 MB
08_05-Producing A Summary Of Scenarios.mp4	10.0 MB
08_03-How To Work Out Which Scenario You Are Displaying.mp4	10.6 MB
08_04-Merging And Deleting Scenarios.mp4	10.6 MB
08_01-Setting Up A Set Of Scenarios.mp4	18.1 MB
/.../03. Display Shortcuts/
167361_03_03_XR151_statusbar.mp4	9.6 MB
167361_03_02_XR151_restorelabel.mp4	21.5 MB
167361_03_01_XR151_splitfreeze.mp4	28.0 MB
/.../09 Finalizing Your Presentation/
2 Saving your presentation as a template.mp4	9.6 MB
1 Documenting your presentation.mp4	11.7 MB
/.../1.Formula and Function Tips and Shortcuts/
126129_01_06_SC11_updateValues.mp4.flv	9.7 MB
126129_01_09_SC11_3Dformulas.mp4.flv	15.9 MB
126129_01_07_SC11_debugFormulas.mp4.flv	16.1 MB
126129_01_04_SC11_copyColumnFormulas.mp4.flv	17.2 MB
126129_01_05_SC11_convertFormulas.mp4.flv	17.3 MB
126129_01_03_SC11_rowColumnRefs.mp4.flv	20.1 MB
126129_01_01_SC11_displayFormulas.mp4.flv	22.4 MB
126129_01_02_SC11_AuditingTools.mp4.flv	25.7 MB
126129_01_08_SC11_rangeNames.mp4.flv	27.2 MB
/.../2.Formula and Function Tools/
126129_02_01_SC11_hierarchy.mp4.flv	9.7 MB
126129_02_02_SC11_formulasTab.mp4.flv	11.3 MB
126129_02_05_SC11_absoluteRelative.mp4.flv	13.5 MB
126129_02_06_SC11_mixedReference.mp4.flv	13.6 MB
126129_02_03_SC11_insertFunction.mp4.flv	14.1 MB
126129_02_04_SC11_AutoSum.mp4.flv	20.9 MB
/.../3 Data Mining between Excel & SQL Server Analysis Services/
186872_03_02_XR15_Mining_models.mp4	9.7 MB
186872_03_01_XR15_Mining_structures.mp4	16.2 MB
/.../02 Formatting Excel Tables for Presentations/
3 Changing a table to a range.mp4	9.8 MB
4 Dividing large numbers.mp4	11.0 MB
2 Setting table options.mp4	13.2 MB
1 Formatting a range as a table.mp4	31.1 MB
/7.Math Functions/
126129_07_08_SC11_RomanArabic.mp4.flv	9.9 MB
126129_07_06_SC11_CONVERT.mp4.flv	11.9 MB
126129_07_03_SC11_TRUNC.mp4.flv	12.1 MB
126129_07_02_SC11_MROUND.mp4.flv	17.7 MB
126129_07_04_SC11_MOD.mp4.flv	18.7 MB
126129_07_01_SC11_ROUND.mp4.flv	20.7 MB
126129_07_07_SC11_AGGREGATE.mp4.flv	22.6 MB
126129_07_05_SC11_RAND.mp4.flv	26.2 MB
/.../1 Introduction to Power Pivot/
186871_01_01_XR15_concepts.mp4	10.0 MB
186871_01_02_XR15_interface.mp4	18.3 MB
/.../04. Analyzing and Visualizing Cluster Data/
04_02-Visualizing table data in a chart.mp4	10.5 MB
04_04-Troubleshooting a cluster analysis workbook.mp4	11.6 MB
04_01-Analyzing data in your Excel table.mp4	12.4 MB
04_03-Extending your analysis to more than two dimensions.mp4	18.3 MB
/.../7. Changing a Chart's Data Source/
135358_07_01_3D15_PasteNewData.mp4	10.5 MB
135358_07_02_3D15_MultipleDataSources.mp4	11.9 MB
135358_07_03_3D15_ChartBasedOnTable.mp4	15.1 MB
135358_07_04_3D15_LastNmonths.mp4	19.7 MB
/.../06. Further Mathematical Functions/
06_02-Calculations Using Time.mp4	10.6 MB
06_08-Loan Calculation Elements And Functions.mp4	12.0 MB
06_03-Useful Time And Date Functions.mp4	13.0 MB
06_05-MOD And INT Functions And Uses.mp4	14.1 MB
06_04-Rounding Decimal Places.mp4	14.1 MB
06_06-Generate And Use A Random Number.mp4	15.1 MB
06_07-Loan And Investment Calculations.mp4	16.2 MB
06_01-Working With Time In Excel.mp4	24.7 MB
/.../11.Text Functions/
126129_11_02_SC11_LEFTRIGHT.mp4.flv	10.7 MB
126129_11_05_SC11_PROPER.mp4.flv	13.2 MB
126129_11_03_SC11_TRIM.mp4.flv	16.9 MB
126129_11_04_SC11_Concatenate.mp4.flv	18.6 MB
126129_11_01_SC11_FINDMID.mp4.flv	19.1 MB
126129_11_06_SC11_REPLACE.mp4.flv	21.3 MB
126129_11_07_SC11_otherTextFunctions.mp4.flv	24.3 MB
/.../03. IF Functionality/
03_06-Display Cell Formulas In Another Cell.mp4	10.7 MB
03_04-Use Of The OR Operator Within An IF.mp4	12.4 MB
03_05-The NOT Operator Within AND And OR Statements.mp4	12.9 MB
03_03-Use Of The AND Operator Within An IF.mp4	16.7 MB
03_02-Nesting The IF Statement.mp4	19.0 MB
03_01-IF Syntax And Uses.mp4	19.8 MB
/.../4.Lookup and Reference Functions/
126129_04_06_SC11_CHOOSE.mp4.flv	10.8 MB
126129_04_08_SC11_INDEX.mp4.flv	11.1 MB
126129_04_07_SC11_MATCH.mp4.flv	15.0 MB
126129_04_05_SC11_largeVlookup.mp4.flv	16.6 MB
126129_04_04_SC11_nestedVlookup.mp4.flv	17.7 MB
126129_04_03_SC11_exactMatch.mp4.flv	17.7 MB
126129_04_01_SC11_VLOOKUPandHLOOKUP.mp4.flv	18.2 MB
126129_04_02_SC11_approxMatch.mp4.flv	29.2 MB
126129_04_09_SC11_MATCHINDEX.mp4.flv	30.4 MB
/.../8. Specialized Excel Charts/
135358_08_03_3D15_ParetoChart.mp4	10.9 MB
135358_08_01_3D15_ComboChart.mp4	11.0 MB
135358_08_04_3D15_FrequencyChart.mp4	12.2 MB
135358_08_05_3D15_FilterChart.mp4	15.1 MB
135358_08_02_3D15_GanttChart.mp4	21.4 MB
135358_08_05_3D15_DynamicChart.mp4	26.8 MB
/.../9. Printing and Sharing Charts/
135358_09_02_3D15_LinkCharts.mp4	11.0 MB
135358_09_01_3D15_PrintingCharts.mp4	18.4 MB
/.../04. Performing Data Lookups/
04_04-Using A Near Match In The Lookup.mp4	11.1 MB
04_03-HLOOKUP Variation On A Theme.mp4	12.0 MB
04_06-Managing The Lookup Table.mp4	12.5 MB
04_01-VLOOKUP Syntax And Usage.mp4	13.0 MB
04_05-Dealing With Missing Data In A Lookup.mp4	13.9 MB
04_07-Lookups Nested Within Lookups.mp4	16.7 MB
04_02-VLOOKUP In Live Action.mp4	20.3 MB
/.../15 Introduction to Macros/
15_02-CreateMacro.mp4	11.3 MB
15_01-MacroDefinition.mp4	15.9 MB
15_03-RunMacro.mp4	16.7 MB
/.../06. Creating Nonrecordable VBA Code/
06_04-Creating interactive macros.mp4	11.4 MB
06_03-Using Do While and Do Until statements.mp4	19.9 MB
06_01-Understanding when to use absolute or relative references.mp4	20.4 MB
06_02-Using For and For Next statements.mp4	30.4 MB
/.../04. Using Visual Basic for Applications (VBA)/
04_03-Closing and updating the Personal Macro Workbook.mp4	11.6 MB
04_02-Creating the Personal Macro Workbook.mp4	16.4 MB
04_01-The VBA environment and VBA components.mp4	18.6 MB
/Exercise Files/Chapter 08/
08_01_Sales_Overview.pptx	11.9 MB
08_03_Sales_Overview.pptx	11.9 MB
08_04_Sales_Overview.pptx	11.9 MB
08_02_Sales_Overview.pptx	11.9 MB
08_06_Sales_Overview.pptx	11.9 MB
08_05_Sales_Overview.pptx	11.9 MB
/.../8.Date and Time Functions/
126129_08_05_SC11_WORKDAY.mp4.flv	12.1 MB
126129_08_02_SC11_TODAYNOW.mp4.flv	12.1 MB
126129_08_04_SC11_NETWORKDAYS.mp4.flv	13.4 MB
126129_08_08_SC11_DATEVALUE.mp4.flv	15.1 MB
126129_08_03_SC11_WEEKDAY.mp4.flv	16.2 MB
126129_08_07_SC11_EDATEEOMONTH.mp4.flv	19.9 MB
126129_08_06_SC11_DATEDIF.mp4.flv	20.4 MB
126129_08_01_SC11_Dates.mp4.flv	31.0 MB
/.../3.IF and Related Functions/
126129_03_01_SC11_IFrelational.mp4.flv	12.9 MB
126129_03_02_SC11_IFnested.mp4.flv	14.8 MB
126129_03_03_SC11_IFcompound.mp4.flv	24.3 MB
/.../9.Array Formulas and Functions/
126129_09_04_SC11_TRANSPOSE.mp4.flv	13.0 MB
126129_09_05_SC11_TRENDGROWTH.mp4.flv	14.3 MB
126129_09_03_SC11_FREQUENCY.mp4.flv	14.9 MB
126129_09_06_SC11_ArrayMATCH.mp4.flv	17.6 MB
126129_09_02_SC11_Unique.mp4.flv	27.0 MB
126129_09_01_SC11_ARRAYS.mp4.flv	43.2 MB
/11. Arrays/
11_02-Array Formulas With IF Statements.mp4	13.1 MB
11_01-Arrays And Creating A New Array Formula.mp4	14.0 MB
11_04-The Array-Only TRANSPOSE Function.mp4	16.1 MB
11_03-Conditional Evaluation With No IFs.mp4	17.8 MB
/.../06 Taking Excel to PowerPoint/
6 Using sparklines in presentations.mp4	13.3 MB
2 Pasting charts and tables from the Office Clipboard.mp4	16.6 MB
1 Copying data and charts in Excel.mp4	19.7 MB
3 Linking data and objects.mp4	21.5 MB
5 Building a data-driven presentation directly in PowerPoint.mp4	23.9 MB
4 Copying tables and pasting pictures.mp4	25.9 MB
/.../05. Recording a Macro in Stages/
05_01-Recording a simple macro.mp4	13.6 MB
05_02-Expanding a macro with the if statement.mp4	18.6 MB
/.../10.Reference Functions/
126129_10_02_SC11_INDIRECT.mp4.flv	13.6 MB
126129_10_01_SC11_OFFSET.mp4.flv	20.8 MB
126129_10_03_SC11_PickList.mp4.flv	29.8 MB
/06 Printing/
06_03-PageSetup.mp4	14.5 MB
06_02-PageBreak.mp4	17.8 MB
06_01-PageLayout.mp4	20.9 MB
/.../08 Adjusting Worksheet Views/
08_03-Outlining.mp4	14.5 MB
08_02-Split.mp4	16.9 MB
08_01-Freezing.mp4	19.9 MB
/.../02. Getting Started with Macros/
02_05-Overview of other techniques.mp4	14.6 MB
02_02-Recognizing the need for single-action macros.mp4	15.9 MB
02_04-Short examples of the recording method.mp4	17.7 MB
02_01-Identifying applicable situations for using macros.mp4	19.0 MB
02_03-Understanding security.mp4	23.8 MB
/.../07. Macro Project Converting a Mailing List into a Database List/
07_03-Using loop structures in context.mp4	15.2 MB
07_06-Joining two macros.mp4	17.9 MB
07_04-Testing a macro in Step mode.mp4	19.9 MB
07_01-Planning a macro.mp4	22.3 MB
07_02-Recording partial code.mp4	23.4 MB
07_07-Streamlining macros.mp4	25.2 MB
07_05-Pulling the data together.mp4	36.9 MB
/.../13. Ten Tiny Tips/
167361_13_01_XR15_tinytips.mp4	18.8 MB
/.../05. Selection Shortcuts/
167361_05_01_XR15_selectrowcol.mp4	20.3 MB
167361_05_03_XR151_currentregion.mp4	23.4 MB
167361_05_02_XR151_visiblecells.mp4	25.8 MB
/5.Power Functions/
126129_05_02_SC11_MultipleCriteria.mp4.flv	21.2 MB
126129_05_01_SC11_SingleCriterion.mp4.flv	23.8 MB
/Exercise Files/
Ex_Files_Excel_Data_Mining.zip	52.1 MB
/01_03/
01_03 Dashboard Related Start.xlsx	80.0 MB
01_03 Dashboard Related Completed.xlsx	80.1 MB
/01_04/
01_04 Dashboard Calculated Fields Columns Start.xlsx	80.1 MB
01_04 Dashboard Calculated Fields Columns Complete.xlsx	84.5 MB
/01_05/
01_05 Dashboard Creating KPIs Complete.xlsx	84.5 MB
01_05 Dashboard Creating KPIs Start.xlsx	84.5 MB
/02_02/
02_02 Adding Pivot Tables to Sales Start.xlsx	84.5 MB
02_02 Adding Pivot Tables to Sales Complete.xlsx	84.6 MB
/02_03/
02_03 Create the Pivot Charts Start.xlsx	84.6 MB
02_03 Create the Pivot Charts Complete.xlsx	84.6 MB
/02_04/
02_04 Create The Pivot Tables and Charts for Customer KPI sheet Start.xlsx	84.6 MB
02_04 Create The Pivot Tables and Charts for Customer KPI sheet Complete.xlsx	84.6 MB
/03_01/
03_01 Adding Power View Start.xlsx	84.6 MB
03_01 Adding Power View Complete.xlsx	84.7 MB
/03_02/
03_02 Formating with color Start.xlsx	84.7 MB
03_02 Formating with color Complete.xlsx	84.7 MB
/Lynda - Create Excel Power Pivot and Power View_ Exercise Files/
Completed Dashboard.xlsx	84.7 MB
/Exercise Files/
Ex_Files_Data_Modeling.zip	223.7 MB
/Exercise Files/
Ex_Files_Power_Dash.zip	1.0 GB
Total files 1555