Gentle Introduction To Advanced Excel Techniques | 7051849327D43909B53A674412F82A4654FB99B0

Gentle Introduction To Advanced Excel Techniques

Name	A Gentle Introduction To Advanced Excel Techniques	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	4.1 GB
Total Files	220
Hash	7051849327D43909B53A674412F82A4654FB99B0

/.../04 Conditional Calculations and Table Lookups/
017 Table Lookups Part 2 ... VLOOKUP a deeper look.mp4	206.0 MB
014 Lecture14.pdf	496.3 KB
014 Lecture14demos.rar	49.4 KB
014 Lecture14exercisesnotes.rar	506.5 KB
014 Using Conditional Statements Part 1 ... IF and CHOOSE.en.srt	21.9 KB
014 Using Conditional Statements Part 1 ... IF and CHOOSE.mp4	129.1 MB
015 Lecture15.pdf	398.6 KB
015 Lecture15ChallengeProblems.pdf	573.2 KB
015 party.xlsx	11.9 KB
015 river.xlsx	10.4 KB
015 Using Conditional Statements Part 2 ... Practical Applications.en.srt	20.5 KB
015 Using Conditional Statements Part 2 ... Practical Applications.mp4	131.4 MB
016 Lecture16.pdf	568.2 KB
016 Lecture16demos.rar	36.8 KB
016 Lecture16exercisesnotes.rar	536.8 KB
016 Table Lookups Part 1 ... VLOOKUP a first look.en.srt	18.2 KB
016 Table Lookups Part 1 ... VLOOKUP a first look.mp4	104.9 MB
017 BicycleShop.xlsx	15.3 KB
017 BicycleShopSolution.xlsx	15.8 KB
017 ChiarelliPharmacy.xlsx	22.2 KB
017 ChiarelliPharmacySolution.xlsx	34.6 KB
017 Lecture17.pdf	352.4 KB
017 Table Lookups Part 2 ... VLOOKUP a deeper look.en.srt	32.6 KB
017 VLOOKUPDeeperLookExercises.pdf	749.0 KB
018 BicycleShop.xlsx	15.3 KB
018 BicycleShopIndexSolution.xlsx	15.6 KB
018 index1.xlsx	12.7 KB
018 index2.xlsx	13.0 KB
018 indexmatch.xlsx	13.4 KB
018 Lecture18.pdf	484.7 KB
018 Table Lookups Part 3 ... INDEX.en.srt	21.2 KB
018 Table Lookups Part 3 ... INDEX.mp4	143.5 MB
019 blinds.xlsx	14.1 KB
019 Lecture19.pdf	402.2 KB
019 Table Lookups Part 4 ... Practical Application.en.srt	16.9 KB
019 Table Lookups Part 4 ... Practical Application.mp4	97.2 MB
019 VerticalBlindsApplication.pdf	12.3 KB
/
Visit Coursedrive.org.url	0.1 KB
ReadMe.txt	0.2 KB
/A Gentle Introduction To Advanced Excel Techniques/
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
/.../01 Course Information/
001 Lecture1.pdf	423.4 KB
001 Welcome.en.srt	4.1 KB
001 Welcome.mp4	39.4 MB
002 Lecture2.pdf	418.6 KB
002 Lecture11demos.rar	104.7 KB
002 What You Need.en.srt	8.1 KB
002 What You Need.mp4	51.3 MB
003 ExcelCourseOverview.pdf	467.7 KB
003 Lecture3.pdf	357.0 KB
003 What You are Going to Learn.en.srt	26.1 KB
003 What You are Going to Learn.mp4	163.3 MB
003 WhatYouAreGoingToLearnDemos.rar	634.3 KB
external-assets-links.txt	0.0 KB
/.../02 Excel Basics Review and Extension/
004 ChrisKentBudgetFinal.xlsx	12.5 KB
004 ChrisKentBudgetSkeleton.xls	27.1 KB
004 ChrisKentBudgetSkeleton.xlsx	11.1 KB
004 ExcelReviewExercises.pdf	718.5 KB
004 Lecture4.pdf	404.0 KB
004 The Basics Part 1 ... The Personal Budget Spreadsheet.en.srt	23.3 KB
004 The Basics Part 1 ... The Personal Budget Spreadsheet.mp4	155.2 MB
005 int2Final.xlsx	14.7 KB
005 Lecture5.pdf	419.1 KB
005 Lecture5exercisesnotes.rar	871.7 KB
005 The Basics Part 2 ... The Compound Interest Problem.en.srt	17.3 KB
005 The Basics Part 2 ... The Compound Interest Problem.mp4	101.3 MB
006 int2Enhanced.xlsx	12.4 KB
006 int2Plain.xlsx	10.2 KB
006 Lecture6.pdf	487.5 KB
006 Spreadsheet Design Principles ... Enhancing the Appearance.en.srt	14.4 KB
006 Spreadsheet Design Principles ... Enhancing the Appearance.mp4	86.1 MB
007 Lecture7.pdf	483.3 KB
007 Lecture7exercisesnotes.rar	465.9 KB
007 multiplesheetsFinal.xlsx	14.9 KB
007 multiplesheetsSkeleton.xlsx	12.5 KB
007 Working with Multiple Sheets.en.srt	11.9 KB
007 Working with Multiple Sheets.mp4	69.2 MB
008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.en.srt	13.3 KB
008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.mp4	73.6 MB
008 ChartingExercise.pdf	383.9 KB
008 fastfood.xlsx	10.0 KB
008 fastfoodChart.xlsx	17.4 KB
008 Lecture8.pdf	482.0 KB
008 supplies.xlsx	9.9 KB
008 suppliesPieChart.xlsx	16.3 KB
009 babytracker.xlsx	12.0 KB
009 babytrackerChart.xlsx	19.0 KB
009 Chart Basics Part 2 ... Combo Charts and more.en.srt	13.3 KB
009 Chart Basics Part 2 ... Combo Charts and more.mp4	76.0 MB
009 havana.xlsx	16.6 KB
009 HavanaClimographExercise.pdf	741.5 KB
009 Lecture9.pdf	485.6 KB
009 timely.xlsx	9.7 KB
009 timelyComboChart.xlsx	16.0 KB
010 File Integration with Object Linking and Embedding.en.srt	14.2 KB
010 File Integration with Object Linking and Embedding.mp4	78.4 MB
010 Lecture10.pdf	543.7 KB
010 Lecture10exercisesnotes.rar	574.3 KB
010 OLEDemo.xlsx	9.9 KB
010 TestWordFile.docx	12.7 KB
/.../03 Data Analysis Basics/
011 ExerciseSolution.xlsx	29.5 KB
011 Lecture11.pdf	500.1 KB
011 Lecture11demos.rar	104.7 KB
011 SolverExercise.pdf	470.0 KB
011 What-If Analysis Using Goal Seek and Solver.en.srt	24.3 KB
011 What-If Analysis Using Goal Seek and Solver.mp4	132.2 MB
012 Lecture12.pdf	484.7 KB
012 Lecture12demos.rar	44.0 KB
012 Lecture12exercisesnotes.rar	640.9 KB
012 Pivot Tables Part 1.en.srt	18.0 KB
012 Pivot Tables Part 1.mp4	115.7 MB
013 Lecture13.pdf	480.2 KB
013 Lecture13exercisesnotes.rar	763.4 KB
013 Pivot Tables Part 2.en.srt	12.8 KB
013 Pivot Tables Part 2.mp4	100.2 MB
013 pivotdata.xlsx	9.9 KB
013 pivotdataChart.xlsx	19.6 KB
/.../05 Introduction to Excel Macros and VBA Programming/
020 Lecture20.pdf	625.5 KB
020 Macros vs VBA.en.srt	9.1 KB
020 Macros vs VBA.mp4	53.5 MB
020 RecordedMacroDemo.rar	15.1 KB
020 VBAdemo.rar	33.0 KB
021 ExcelMacroTips.pdf	546.8 KB
021 Lecture21.pdf	540.8 KB
021 macrorecordintro.xlsm	18.5 KB
021 Using the EXCEL Macro Recorder.en.srt	13.3 KB
021 Using the EXCEL Macro Recorder.mp4	79.1 MB
022 Creating User Defined Functions Part 1.en.srt	10.5 KB
022 Creating User Defined Functions Part 1.mp4	47.8 MB
022 Lecture22.pdf	632.1 KB
022 tempconversion.xlsm	14.2 KB
023 Commission.xlsm	13.9 KB
023 Creating User Defined Functions Part 2.en.srt	15.2 KB
023 Creating User Defined Functions Part 2.mp4	72.1 MB
023 interestvba.xlsm	19.1 KB
023 Lecture23.pdf	472.0 KB
023 Lecture23exercisesnotes.rar	500.5 KB
024 Budget.xlsx	13.8 KB
024 ExcelObjectModelExercise.pdf	465.4 KB
024 Lecture24.pdf	545.1 KB
024 QtrSales.xlsx	11.4 KB
024 Sales.xlsx	11.4 KB
024 The EXCEL Object Model.en.srt	16.2 KB
024 The EXCEL Object Model.mp4	109.2 MB
025 Lecture25.pdf	461.1 KB
025 Lecture25exercisesnotes.rar	637.4 KB
025 sales.xlsx	11.6 KB
025 salesvba.xlsm	21.1 KB
025 Using Variables ... The Object Variable.en.srt	31.3 KB
025 Using Variables ... The Object Variable.mp4	157.5 MB
026 commission.xlsx	10.3 KB
026 commissionvba.xlsm	16.1 KB
026 indexget1.xlsm	19.0 KB
026 Lecture26.pdf	557.9 KB
026 Using Variables ... String Variables Part 1.en.srt	20.6 KB
026 Using Variables ... String Variables Part 1.mp4	114.7 MB
027 commissionvba.xlsm	16.1 KB
027 commissionvbaCall.xlsm	17.3 KB
027 Lecture27.pdf	487.7 KB
027 Lecture27exercisesnotes.rar	570.7 KB
027 Using Variables ... String Variables Part 2.en.srt	26.9 KB
027 Using Variables ... String Variables Part 2.mp4	163.5 MB
028 Lecture28.pdf	464.1 KB
028 party.xlsx	11.9 KB
028 partymac.xlsm	18.3 KB
028 partymacCall.xlsm	22.4 KB
028 Using Variables ... The Party Planner Practical Application.en.srt	8.2 KB
028 Using Variables ... The Party Planner Practical Application.mp4	54.4 MB
029 Lecture29.pdf	490.8 KB
029 Lecture29exercisesnotes.rar	521.7 KB
029 pricelist.xlsx	10.3 KB
029 pricelistvba.xlsm	22.5 KB
029 Worksheet Controls ... Creating and using a Combo Box and List Box.en.srt	29.6 KB
029 Worksheet Controls ... Creating and using a Combo Box and List Box.mp4	147.4 MB
030 index2.xlsx	13.0 KB
030 indexget2.xlsm	28.8 KB
030 indexget2AllVBA.xlsm	33.0 KB
030 Lecture30.pdf	490.4 KB
030 Practical Application Parts Ordering App Part 1.en.srt	30.5 KB
030 Practical Application Parts Ordering App Part 1.mp4	202.5 MB
031 indexbr.xlsm	30.2 KB
031 Lecture31.pdf	552.0 KB
031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.en.srt	18.9 KB
031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.mp4	103.4 MB
031 SelectionRepetitionPrimer.xlsm	27.3 KB
032 Lecture32.pdf	416.2 KB
032 partycheck.xlsm	26.5 KB
032 partymac.xlsm	18.3 KB
032 Practical Application ... Party Planner.en.srt	9.9 KB
032 Practical Application ... Party Planner.mp4	59.9 MB
033 blinds.xlsx	14.1 KB
033 blindsmac.xlsm	35.2 KB
033 blindsmacupdate.xlsm	44.4 KB
033 Lecture33.pdf	552.1 KB
033 Practical Application ... The Blinds Store Application.en.srt	31.6 KB
033 Practical Application ... The Blinds Store Application.mp4	183.9 MB
033 VerticalBlindsApplicationRevisited.pdf	12.3 KB
034 Creating Menu Driven Workbooks.en.srt	23.7 KB
034 Creating Menu Driven Workbooks.mp4	136.3 MB
034 foodcosts.xlsx	12.2 KB
034 foodcostsMenuUpdate.xlsm	134.8 KB
034 Lecture34.pdf	645.9 KB
034 Lecture34exercisesnotes.rar	509.6 KB
034 partybtn.xlsm	123.4 KB
035 Creating Custom User Forms.en.srt	31.7 KB
035 Creating Custom User Forms.mp4	166.9 MB
035 Lecture35.pdf	495.6 KB
035 Lecture35demos.rar	27.2 KB
036 Creating Custom User Forms Review and Extension.en.srt	11.9 KB
036 Creating Custom User Forms Review and Extension.mp4	60.0 MB
036 Lecture36.pdf	472.6 KB
036 Lecture36demos.rar	33.0 KB
037 Lecture37.pdf	424.4 KB
037 Lecture37demos.rar	68.4 KB
037 Practical Application ... Parts Ordering App Final Version.en.srt	18.1 KB
037 Practical Application ... Parts Ordering App Final Version.mp4	101.8 MB
038 BudgetTracker.rar	203.3 KB
038 Lecture38.pdf	349.6 KB
038 Practical Application ... The Budget Tracking Application.en.srt	6.6 KB
038 Practical Application ... The Budget Tracking Application.mp4	41.7 MB
Total files 220