A Gentle Introduction To Advanced Excel Techniques Torrent Download Locations

A Gentle Introduction To Advanced Excel Techniques
    04 Conditional Calculations and Table Lookups
          017 Table Lookups Part 2 ... VLOOKUP a deeper look.mp4 -

     Visit Coursedrive.org.url -

     ReadMe.txt -

     Visit Coursedrive.org.url -

    01 Course Information
          001 Lecture1.pdf -

          001 Welcome.en.srt -

          001 Welcome.mp4 -

          002 Lecture2.pdf -

          002 Lecture11demos.rar -

          002 What You Need.en.srt -

          002 What You Need.mp4 -

          003 ExcelCourseOverview.pdf -

          003 Lecture3.pdf -

          003 What You are Going to Learn.en.srt -

          003 What You are Going to Learn.mp4 -

          003 WhatYouAreGoingToLearnDemos.rar -

          external-assets-links.txt -

    02 Excel Basics Review and Extension
          004 ChrisKentBudgetFinal.xlsx -

          004 ChrisKentBudgetSkeleton.xls -

          004 ChrisKentBudgetSkeleton.xlsx -

          004 ExcelReviewExercises.pdf -

          004 Lecture4.pdf -

          004 The Basics Part 1 ... The Personal Budget Spreadsheet.en.srt -

          004 The Basics Part 1 ... The Personal Budget Spreadsheet.mp4 -

          005 int2Final.xlsx -

          005 Lecture5.pdf -

          005 Lecture5exercisesnotes.rar -

          005 The Basics Part 2 ... The Compound Interest Problem.en.srt -

          005 The Basics Part 2 ... The Compound Interest Problem.mp4 -

          006 int2Enhanced.xlsx -

          006 int2Plain.xlsx -

          006 Lecture6.pdf -

          006 Spreadsheet Design Principles ... Enhancing the Appearance.en.srt -

          006 Spreadsheet Design Principles ... Enhancing the Appearance.mp4 -

          007 Lecture7.pdf -

          007 Lecture7exercisesnotes.rar -

          007 multiplesheetsFinal.xlsx -

          007 multiplesheetsSkeleton.xlsx -

          007 Working with Multiple Sheets.en.srt -

          007 Working with Multiple Sheets.mp4 -

          008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.en.srt -

          008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.mp4 -

          008 ChartingExercise.pdf -

          008 fastfood.xlsx -

          008 fastfoodChart.xlsx -

          008 Lecture8.pdf -

          008 supplies.xlsx -

          008 suppliesPieChart.xlsx -

          009 babytracker.xlsx -

          009 babytrackerChart.xlsx -

          009 Chart Basics Part 2 ... Combo Charts and more.en.srt -

          009 Chart Basics Part 2 ... Combo Charts and more.mp4 -

          009 havana.xlsx -

          009 HavanaClimographExercise.pdf -

          009 Lecture9.pdf -

          009 timely.xlsx -

          009 timelyComboChart.xlsx -

          010 File Integration with Object Linking and Embedding.en.srt -

          010 File Integration with Object Linking and Embedding.mp4 -

          010 Lecture10.pdf -

          010 Lecture10exercisesnotes.rar -

          010 OLEDemo.xlsx -

          010 TestWordFile.docx -

    03 Data Analysis Basics
          011 ExerciseSolution.xlsx -

          011 Lecture11.pdf -

          011 Lecture11demos.rar -

          011 SolverExercise.pdf -

          011 What-If Analysis Using Goal Seek and Solver.en.srt -

          011 What-If Analysis Using Goal Seek and Solver.mp4 -

          012 Lecture12.pdf -

          012 Lecture12demos.rar -

          012 Lecture12exercisesnotes.rar -

          012 Pivot Tables Part 1.en.srt -

          012 Pivot Tables Part 1.mp4 -

          013 Lecture13.pdf -

          013 Lecture13exercisesnotes.rar -

          013 Pivot Tables Part 2.en.srt -

          013 Pivot Tables Part 2.mp4 -

          013 pivotdata.xlsx -

          013 pivotdataChart.xlsx -

    04 Conditional Calculations and Table Lookups
          014 Lecture14.pdf -

          014 Lecture14demos.rar -

          014 Lecture14exercisesnotes.rar -

          014 Using Conditional Statements Part 1 ... IF and CHOOSE.en.srt -

          014 Using Conditional Statements Part 1 ... IF and CHOOSE.mp4 -

          015 Lecture15.pdf -

          015 Lecture15ChallengeProblems.pdf -

          015 party.xlsx -

          015 river.xlsx -

          015 Using Conditional Statements Part 2 ... Practical Applications.en.srt -

          015 Using Conditional Statements Part 2 ... Practical Applications.mp4 -

          016 Lecture16.pdf -

          016 Lecture16demos.rar -

          016 Lecture16exercisesnotes.rar -

          016 Table Lookups Part 1 ... VLOOKUP a first look.en.srt -

          016 Table Lookups Part 1 ... VLOOKUP a first look.mp4 -

          017 BicycleShop.xlsx -

          017 BicycleShopSolution.xlsx -

          017 ChiarelliPharmacy.xlsx -

          017 ChiarelliPharmacySolution.xlsx -

          017 Lecture17.pdf -

          017 Table Lookups Part 2 ... VLOOKUP a deeper look.en.srt -

     ReadMe.txt -

          017 VLOOKUPDeeperLookExercises.pdf -

          018 BicycleShop.xlsx -

          018 BicycleShopIndexSolution.xlsx -

          018 index1.xlsx -

          018 index2.xlsx -

          018 indexmatch.xlsx -

          018 Lecture18.pdf -

          018 Table Lookups Part 3 ... INDEX.en.srt -

          018 Table Lookups Part 3 ... INDEX.mp4 -

          019 blinds.xlsx -

          019 Lecture19.pdf -

          019 Table Lookups Part 4 ... Practical Application.en.srt -

          019 Table Lookups Part 4 ... Practical Application.mp4 -

          019 VerticalBlindsApplication.pdf -

    05 Introduction to Excel Macros and VBA Programming
          020 Lecture20.pdf -

          020 Macros vs VBA.en.srt -

          020 Macros vs VBA.mp4 -

          020 RecordedMacroDemo.rar -

          020 VBAdemo.rar -

          021 ExcelMacroTips.pdf -

          021 Lecture21.pdf -

          021 macrorecordintro.xlsm -

          021 Using the EXCEL Macro Recorder.en.srt -

          021 Using the EXCEL Macro Recorder.mp4 -

          022 Creating User Defined Functions Part 1.en.srt -

          022 Creating User Defined Functions Part 1.mp4 -

          022 Lecture22.pdf -

          022 tempconversion.xlsm -

          023 Commission.xlsm -

          023 Creating User Defined Functions Part 2.en.srt -

          023 Creating User Defined Functions Part 2.mp4 -

          023 interestvba.xlsm -

          023 Lecture23.pdf -

          023 Lecture23exercisesnotes.rar -

          024 Budget.xlsx -

          024 ExcelObjectModelExercise.pdf -

          024 Lecture24.pdf -

          024 QtrSales.xlsx -

          024 Sales.xlsx -

          024 The EXCEL Object Model.en.srt -

          024 The EXCEL Object Model.mp4 -

          025 Lecture25.pdf -

          025 Lecture25exercisesnotes.rar -

          025 sales.xlsx -

          025 salesvba.xlsm -

          025 Using Variables ... The Object Variable.en.srt -

          025 Using Variables ... The Object Variable.mp4 -