|
|
001 Lecture1.pdf
|
PDF
|
413.5 KB
|
|
|
001 Welcome.en.srt
|
SRT
|
4 KB
|
|
|
001 Welcome.mp4
|
MP4
|
37.6 MB
|
|
|
002 Lecture11demos.rar
|
RAR
|
102.3 KB
|
|
|
002 Lecture2.pdf
|
PDF
|
408.8 KB
|
|
|
002 What You Need.en.srt
|
SRT
|
7.9 KB
|
|
|
002 What You Need.mp4
|
MP4
|
48.9 MB
|
|
|
003 ExcelCourseOverview.pdf
|
PDF
|
456.8 KB
|
|
|
003 Lecture3.pdf
|
PDF
|
348.7 KB
|
|
|
003 What You are Going to Learn.en.srt
|
SRT
|
25.5 KB
|
|
|
003 What You are Going to Learn.mp4
|
MP4
|
155.8 MB
|
|
|
003 WhatYouAreGoingToLearnDemos.rar
|
RAR
|
619.4 KB
|
|
|
004 ChrisKentBudgetFinal.xlsx
|
XLSX
|
12.2 KB
|
|
|
004 ChrisKentBudgetSkeleton.xls
|
XLS
|
26.5 KB
|
|
|
004 ChrisKentBudgetSkeleton.xlsx
|
XLSX
|
10.9 KB
|
|
|
004 ExcelReviewExercises.pdf
|
PDF
|
701.7 KB
|
|
|
004 Lecture4.pdf
|
PDF
|
394.5 KB
|
|
|
004 The Basics Part 1 ... The Personal Budget Spreadsheet.en.srt
|
SRT
|
22.7 KB
|
|
|
004 The Basics Part 1 ... The Personal Budget Spreadsheet.mp4
|
MP4
|
148 MB
|
|
|
005 Lecture5.pdf
|
PDF
|
409.3 KB
|
|
|
005 Lecture5exercisesnotes.rar
|
RAR
|
851.3 KB
|
|
|
005 The Basics Part 2 ... The Compound Interest Problem.en.srt
|
SRT
|
16.9 KB
|
|
|
005 The Basics Part 2 ... The Compound Interest Problem.mp4
|
MP4
|
96.6 MB
|
|
|
005 int2Final.xlsx
|
XLSX
|
14.3 KB
|
|
|
006 Lecture6.pdf
|
PDF
|
476.1 KB
|
|
|
006 Spreadsheet Design Principles ... Enhancing the Appearance.en.srt
|
SRT
|
14.1 KB
|
|
|
006 Spreadsheet Design Principles ... Enhancing the Appearance.mp4
|
MP4
|
82.1 MB
|
|
|
006 int2Enhanced.xlsx
|
XLSX
|
12.1 KB
|
|
|
006 int2Plain.xlsx
|
XLSX
|
9.9 KB
|
|
|
007 Lecture7.pdf
|
PDF
|
472 KB
|
|
|
007 Lecture7exercisesnotes.rar
|
RAR
|
455 KB
|
|
|
007 Working with Multiple Sheets.en.srt
|
SRT
|
11.7 KB
|
|
|
007 Working with Multiple Sheets.mp4
|
MP4
|
65.9 MB
|
|
|
007 multiplesheetsFinal.xlsx
|
XLSX
|
14.6 KB
|
|
|
007 multiplesheetsSkeleton.xlsx
|
XLSX
|
12.2 KB
|
|
|
008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.en.srt
|
SRT
|
13 KB
|
|
|
008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.mp4
|
MP4
|
70.2 MB
|
|
|
008 ChartingExercise.pdf
|
PDF
|
374.9 KB
|
|
|
008 Lecture8.pdf
|
PDF
|
470.7 KB
|
|
|
008 fastfood.xlsx
|
XLSX
|
9.8 KB
|
|
|
008 fastfoodChart.xlsx
|
XLSX
|
17 KB
|
|
|
008 supplies.xlsx
|
XLSX
|
9.7 KB
|
|
|
008 suppliesPieChart.xlsx
|
XLSX
|
16 KB
|
|
|
009 Chart Basics Part 2 ... Combo Charts and more.en.srt
|
SRT
|
13 KB
|
|
|
009 Chart Basics Part 2 ... Combo Charts and more.mp4
|
MP4
|
72.5 MB
|
|
|
009 HavanaClimographExercise.pdf
|
PDF
|
724.1 KB
|
|
|
009 Lecture9.pdf
|
PDF
|
474.2 KB
|
|
|
009 babytracker.xlsx
|
XLSX
|
11.8 KB
|
|
|
009 babytrackerChart.xlsx
|
XLSX
|
18.6 KB
|
|
|
009 havana.xlsx
|
XLSX
|
16.2 KB
|
|
|
009 timely.xlsx
|
XLSX
|
9.5 KB
|
|
|
009 timelyComboChart.xlsx
|
XLSX
|
15.6 KB
|
|
|
010 File Integration with Object Linking and Embedding.en.srt
|
SRT
|
13.9 KB
|
|
|
010 File Integration with Object Linking and Embedding.mp4
|
MP4
|
74.8 MB
|
|
|
010 Lecture10.pdf
|
PDF
|
531 KB
|
|
|
010 Lecture10exercisesnotes.rar
|
RAR
|
560.9 KB
|
|
|
010 OLEDemo.xlsx
|
XLSX
|
9.7 KB
|
|
|
010 TestWordFile.docx
|
DOCX
|
12.4 KB
|
|
|
011 ExerciseSolution.xlsx
|
XLSX
|
28.9 KB
|
|
|
011 Lecture11.pdf
|
PDF
|
488.4 KB
|
|
|
011 Lecture11demos.rar
|
RAR
|
102.3 KB
|
|
|
011 SolverExercise.pdf
|
PDF
|
459 KB
|
|
|
011 What-If Analysis Using Goal Seek and Solver.en.srt
|
SRT
|
23.7 KB
|
|
|
011 What-If Analysis Using Goal Seek and Solver.mp4
|
MP4
|
126.1 MB
|
|
|
012 Lecture12.pdf
|
PDF
|
473.3 KB
|
|
|
012 Lecture12demos.rar
|
RAR
|
42.9 KB
|
|
|
012 Lecture12exercisesnotes.rar
|
RAR
|
625.8 KB
|
|
|
012 Pivot Tables Part 1.en.srt
|
SRT
|
17.6 KB
|
|
|
012 Pivot Tables Part 1.mp4
|
MP4
|
110.3 MB
|
|
|
013 Lecture13.pdf
|
PDF
|
468.9 KB
|
|
|
013 Lecture13exercisesnotes.rar
|
RAR
|
745.5 KB
|
|
|
013 Pivot Tables Part 2.en.srt
|
SRT
|
12.5 KB
|
|
|
013 Pivot Tables Part 2.mp4
|
MP4
|
95.6 MB
|
|
|
013 pivotdata.xlsx
|
XLSX
|
9.7 KB
|
|
|
013 pivotdataChart.xlsx
|
XLSX
|
19.1 KB
|
|
|
014 Lecture14.pdf
|
PDF
|
484.6 KB
|
|
|
014 Lecture14demos.rar
|
RAR
|
48.3 KB
|
|
|
014 Lecture14exercisesnotes.rar
|
RAR
|
494.6 KB
|
|
|
014 Using Conditional Statements Part 1 ... IF and CHOOSE.en.srt
|
SRT
|
21.4 KB
|
|
|
014 Using Conditional Statements Part 1 ... IF and CHOOSE.mp4
|
MP4
|
123.1 MB
|
|
|
015 Lecture15.pdf
|
PDF
|
389.3 KB
|
|
|
015 Lecture15ChallengeProblems.pdf
|
PDF
|
559.7 KB
|
|
|
015 Using Conditional Statements Part 2 ... Practical Applications.en.srt
|
SRT
|
20 KB
|
|
|
015 Using Conditional Statements Part 2 ... Practical Applications.mp4
|
MP4
|
125.4 MB
|
|
|
015 party.xlsx
|
XLSX
|
11.6 KB
|
|
|
015 river.xlsx
|
XLSX
|
10.1 KB
|
|
|
016 Lecture16.pdf
|
PDF
|
554.9 KB
|
|
|
016 Lecture16demos.rar
|
RAR
|
35.9 KB
|
|
|
016 Lecture16exercisesnotes.rar
|
RAR
|
524.2 KB
|
|
|
016 Table Lookups Part 1 ... VLOOKUP a first look.en.srt
|
SRT
|
17.7 KB
|
|
|
016 Table Lookups Part 1 ... VLOOKUP a first look.mp4
|
MP4
|
100 MB
|
|
|
017 BicycleShop.xlsx
|
XLSX
|
14.9 KB
|
|
|
017 BicycleShopSolution.xlsx
|
XLSX
|
15.4 KB
|
|
|
017 ChiarelliPharmacy.xlsx
|
XLSX
|
21.7 KB
|
|
|
017 ChiarelliPharmacySolution.xlsx
|
XLSX
|
33.8 KB
|
|
|
017 Lecture17.pdf
|
PDF
|
344.1 KB
|
|
|
017 Table Lookups Part 2 ... VLOOKUP a deeper look.en.srt
|
SRT
|
31.8 KB
|
|
|
017 Table Lookups Part 2 ... VLOOKUP a deeper look.mp4
|
MP4
|
196.4 MB
|
|
|
017 VLOOKUPDeeperLookExercises.pdf
|
PDF
|
731.5 KB
|
|
|
018 BicycleShop.xlsx
|
XLSX
|
14.9 KB
|
|
|
018 BicycleShopIndexSolution.xlsx
|
XLSX
|
15.2 KB
|
|
|
018 Lecture18.pdf
|
PDF
|
473.4 KB
|
|
|
018 Table Lookups Part 3 ... INDEX.en.srt
|
SRT
|
20.7 KB
|
|
|
018 Table Lookups Part 3 ... INDEX.mp4
|
MP4
|
136.9 MB
|
|
|
018 index1.xlsx
|
XLSX
|
12.4 KB
|
|
|
018 index2.xlsx
|
XLSX
|
12.7 KB
|
|
|
018 indexmatch.xlsx
|
XLSX
|
13.1 KB
|
|
|
019 Lecture19.pdf
|
PDF
|
392.8 KB
|
|
|
019 Table Lookups Part 4 ... Practical Application.en.srt
|
SRT
|
16.5 KB
|
|
|
019 Table Lookups Part 4 ... Practical Application.mp4
|
MP4
|
92.7 MB
|
|
|
019 VerticalBlindsApplication.pdf
|
PDF
|
12.1 KB
|
|
|
019 blinds.xlsx
|
XLSX
|
13.8 KB
|
|
|
020 Lecture20.pdf
|
PDF
|
610.8 KB
|
|
|
020 Macros vs VBA.en.srt
|
SRT
|
8.9 KB
|
|
|
020 Macros vs VBA.mp4
|
MP4
|
51 MB
|
|
|
020 RecordedMacroDemo.rar
|
RAR
|
14.7 KB
|
|
|
020 VBAdemo.rar
|
RAR
|
32.3 KB
|
|
|
021 ExcelMacroTips.pdf
|
PDF
|
534 KB
|
|
|
021 Lecture21.pdf
|
PDF
|
528.1 KB
|
|
|
021 Using the EXCEL Macro Recorder.en.srt
|
SRT
|
13 KB
|
|
|
021 Using the EXCEL Macro Recorder.mp4
|
MP4
|
75.4 MB
|
|
|
021 macrorecordintro.xlsm
|
XLSM
|
18.1 KB
|
|
|
022 Creating User Defined Functions Part 1.en.srt
|
SRT
|
10.3 KB
|
|
|
022 Creating User Defined Functions Part 1.mp4
|
MP4
|
45.6 MB
|
|
|
022 Lecture22.pdf
|
PDF
|
617.3 KB
|
|
|
022 tempconversion.xlsm
|
XLSM
|
13.9 KB
|
|
|
023 Commission.xlsm
|
XLSM
|
13.5 KB
|
|
|
023 Creating User Defined Functions Part 2.en.srt
|
SRT
|
14.8 KB
|
|
|
023 Creating User Defined Functions Part 2.mp4
|
MP4
|
68.8 MB
|
|
|
023 Lecture23.pdf
|
PDF
|
461 KB
|
|
|
023 Lecture23exercisesnotes.rar
|
RAR
|
488.8 KB
|
|
|
023 interestvba.xlsm
|
XLSM
|
18.6 KB
|
|
|
024 Budget.xlsx
|
XLSX
|
13.5 KB
|
|
|
024 ExcelObjectModelExercise.pdf
|
PDF
|
454.5 KB
|
|
|
024 Lecture24.pdf
|
PDF
|
532.4 KB
|
|
|
024 QtrSales.xlsx
|
XLSX
|
11.1 KB
|
|
|
024 Sales.xlsx
|
XLSX
|
11.1 KB
|
|
|
024 The EXCEL Object Model.en.srt
|
SRT
|
15.8 KB
|
|
|
024 The EXCEL Object Model.mp4
|
MP4
|
104.2 MB
|
|
|
025 Lecture25.pdf
|
PDF
|
450.3 KB
|
|
|
025 Lecture25exercisesnotes.rar
|
RAR
|
622.5 KB
|
|
|
025 Using Variables ... The Object Variable.en.srt
|
SRT
|
30.5 KB
|
|
|
025 Using Variables ... The Object Variable.mp4
|
MP4
|
150.2 MB
|
|
|
025 sales.xlsx
|
XLSX
|
11.4 KB
|
|
|
025 salesvba.xlsm
|
XLSM
|
20.6 KB
|
|
|
026 Lecture26.pdf
|
PDF
|
544.8 KB
|
|
|
026 Using Variables ... String Variables Part 1.en.srt
|
SRT
|
20.1 KB
|
|
|
026 Using Variables ... String Variables Part 1.mp4
|
MP4
|
109.4 MB
|
|
|
026 commission.xlsx
|
XLSX
|
10.1 KB
|
|
|
026 commissionvba.xlsm
|
XLSM
|
15.7 KB
|
|
|
026 indexget1.xlsm
|
XLSM
|
18.6 KB
|
|
|
027 Lecture27.pdf
|
PDF
|
476.2 KB
|
|
|
027 Lecture27exercisesnotes.rar
|
RAR
|
557.3 KB
|
|
|
027 Using Variables ... String Variables Part 2.en.srt
|
SRT
|
26.3 KB
|
|
|
027 Using Variables ... String Variables Part 2.mp4
|
MP4
|
155.9 MB
|
|
|
027 commissionvba.xlsm
|
XLSM
|
15.7 KB
|
|
|
027 commissionvbaCall.xlsm
|
XLSM
|
16.9 KB
|
|
|
028 Lecture28.pdf
|
PDF
|
453.2 KB
|
|
|
028 Using Variables ... The Party Planner Practical Application.en.srt
|
SRT
|
8.1 KB
|
|
|
028 Using Variables ... The Party Planner Practical Application.mp4
|
MP4
|
51.9 MB
|
|
|
028 party.xlsx
|
XLSX
|
11.6 KB
|
|
|
028 partymac.xlsm
|
XLSM
|
17.9 KB
|
|
|
028 partymacCall.xlsm
|
XLSM
|
21.9 KB
|
|
|
029 Lecture29.pdf
|
PDF
|
479.3 KB
|
|
|
029 Lecture29exercisesnotes.rar
|
RAR
|
509.4 KB
|
|
|
029 Worksheet Controls ... Creating and using a Combo Box and List Box.en.srt
|
SRT
|
28.9 KB
|
|
|
029 Worksheet Controls ... Creating and using a Combo Box and List Box.mp4
|
MP4
|
140.6 MB
|
|
|
029 pricelist.xlsx
|
XLSX
|
10.1 KB
|
|
|
029 pricelistvba.xlsm
|
XLSM
|
22 KB
|
|
|
030 Lecture30.pdf
|
PDF
|
478.9 KB
|
|
|
030 Practical Application Parts Ordering App Part 1.en.srt
|
SRT
|
29.8 KB
|
|
|
030 Practical Application Parts Ordering App Part 1.mp4
|
MP4
|
193.1 MB
|
|
|
030 index2.xlsx
|
XLSX
|
12.7 KB
|
|
|
030 indexget2.xlsm
|
XLSM
|
28.2 KB
|
|
|
030 indexget2AllVBA.xlsm
|
XLSM
|
32.2 KB
|
|
|
031 Lecture31.pdf
|
PDF
|
539 KB
|
|
|
031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.en.srt
|
SRT
|
18.5 KB
|
|
|
031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.mp4
|
MP4
|
98.6 MB
|
|
|
031 SelectionRepetitionPrimer.xlsm
|
XLSM
|
26.7 KB
|
|
|
031 indexbr.xlsm
|
XLSM
|
29.5 KB
|
|
|
032 Lecture32.pdf
|
PDF
|
406.4 KB
|
|
|
032 Practical Application ... Party Planner.en.srt
|
SRT
|
9.7 KB
|
|
|
032 Practical Application ... Party Planner.mp4
|
MP4
|
57.1 MB
|
|
|
032 partycheck.xlsm
|
XLSM
|
25.9 KB
|
|
|
032 partymac.xlsm
|
XLSM
|
17.9 KB
|
|
|
033 Lecture33.pdf
|
PDF
|
539.2 KB
|
|
|
033 Practical Application ... The Blinds Store Application.en.srt
|
SRT
|
30.8 KB
|
|
|
033 Practical Application ... The Blinds Store Application.mp4
|
MP4
|
175.4 MB
|
|
|
033 VerticalBlindsApplicationRevisited.pdf
|
PDF
|
12.1 KB
|
|
|
033 blinds.xlsx
|
XLSX
|
13.8 KB
|
|
|
033 blindsmac.xlsm
|
XLSM
|
34.4 KB
|
|
|
033 blindsmacupdate.xlsm
|
XLSM
|
43.4 KB
|
|
|
034 Creating Menu Driven Workbooks.en.srt
|
SRT
|
23.1 KB
|
|
|
034 Creating Menu Driven Workbooks.mp4
|
MP4
|
130 MB
|
|
|
034 Lecture34.pdf
|
PDF
|
630.7 KB
|
|
|
034 Lecture34exercisesnotes.rar
|
RAR
|
497.7 KB
|
|
|
034 foodcosts.xlsx
|
XLSX
|
11.9 KB
|
|
|
034 foodcostsMenuUpdate.xlsm
|
XLSM
|
131.6 KB
|
|
|
034 partybtn.xlsm
|
XLSM
|
120.5 KB
|
|
|
035 Creating Custom User Forms.en.srt
|
SRT
|
30.9 KB
|
|
|
035 Creating Custom User Forms.mp4
|
MP4
|
159.2 MB
|
|
|
035 Lecture35.pdf
|
PDF
|
484 KB
|
|
|
035 Lecture35demos.rar
|
RAR
|
26.6 KB
|
|
|
036 Creating Custom User Forms Review and Extension.en.srt
|
SRT
|
11.6 KB
|
|
|
036 Creating Custom User Forms Review and Extension.mp4
|
MP4
|
57.2 MB
|
|
|
036 Lecture36.pdf
|
PDF
|
461.5 KB
|
|
|
036 Lecture36demos.rar
|
RAR
|
32.3 KB
|
|
|
037 Lecture37.pdf
|
PDF
|
414.4 KB
|
|
|
037 Lecture37demos.rar
|
RAR
|
66.8 KB
|
|
|
037 Practical Application ... Parts Ordering App Final Version.en.srt
|
SRT
|
17.6 KB
|
|
|
037 Practical Application ... Parts Ordering App Final Version.mp4
|
MP4
|
97.1 MB
|
|
|
038 BudgetTracker.rar
|
RAR
|
198.6 KB
|
|
|
038 Lecture38.pdf
|
PDF
|
341.5 KB
|
|
|
038 Practical Application ... The Budget Tracking Application.en.srt
|
SRT
|
6.4 KB
|
|
|
038 Practical Application ... The Budget Tracking Application.mp4
|
MP4
|
39.8 MB
|
|
|
ReadMe.txt
|
TXT
|
204.8 B
|
|
|
Visit Coursedrive.org.url
|
URL
|
102.4 B
|
|
|
external-assets-links.txt
|
TXT
|
0 B
|
![Udemy - A Gentle Introduction To Advanced Excel Techniques [Course Drive]](/static/img/no-torrent-image.png "Udemy - A Gentle Introduction To Advanced Excel Techniques [Course Drive]")
