| 001 Lecture1.pdf | 413.5 KB | ||
| 001 Welcome.en.srt | 4 KB | ||
| 001 Welcome.mp4 | 37.6 MB | ||
| 002 Lecture11demos.rar | 102.3 KB | ||
| 002 Lecture2.pdf | 408.8 KB | ||
| 002 What You Need.en.srt | 7.9 KB | ||
| 002 What You Need.mp4 | 48.9 MB | ||
| 003 ExcelCourseOverview.pdf | 456.8 KB | ||
| 003 Lecture3.pdf | 348.7 KB | ||
| 003 What You are Going to Learn.en.srt | 25.5 KB | ||
| 003 What You are Going to Learn.mp4 | 155.8 MB | ||
| 003 WhatYouAreGoingToLearnDemos.rar | 619.4 KB | ||
| 004 ChrisKentBudgetFinal.xlsx | 12.2 KB | ||
| 004 ChrisKentBudgetSkeleton.xls | 26.5 KB | ||
| 004 ChrisKentBudgetSkeleton.xlsx | 10.9 KB | ||
| 004 ExcelReviewExercises.pdf | 701.7 KB | ||
| 004 Lecture4.pdf | 394.5 KB | ||
| 004 The Basics Part 1 ... The Personal Budget Spreadsheet.en.srt | 22.7 KB | ||
| 004 The Basics Part 1 ... The Personal Budget Spreadsheet.mp4 | 148 MB | ||
| 005 Lecture5.pdf | 409.3 KB | ||
| 005 Lecture5exercisesnotes.rar | 851.3 KB | ||
| 005 The Basics Part 2 ... The Compound Interest Problem.en.srt | 16.9 KB | ||
| 005 The Basics Part 2 ... The Compound Interest Problem.mp4 | 96.6 MB | ||
| 005 int2Final.xlsx | 14.3 KB | ||
| 006 Lecture6.pdf | 476.1 KB | ||
| 006 Spreadsheet Design Principles ... Enhancing the Appearance.en.srt | 14.1 KB | ||
| 006 Spreadsheet Design Principles ... Enhancing the Appearance.mp4 | 82.1 MB | ||
| 006 int2Enhanced.xlsx | 12.1 KB | ||
| 006 int2Plain.xlsx | 9.9 KB | ||
| 007 Lecture7.pdf | 472 KB | ||
| 007 Lecture7exercisesnotes.rar | 455 KB | ||
| 007 Working with Multiple Sheets.en.srt | 11.7 KB | ||
| 007 Working with Multiple Sheets.mp4 | 65.9 MB | ||
| 007 multiplesheetsFinal.xlsx | 14.6 KB | ||
| 007 multiplesheetsSkeleton.xlsx | 12.2 KB | ||
| 008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.en.srt | 13 KB | ||
| 008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.mp4 | 70.2 MB | ||
| 008 ChartingExercise.pdf | 374.9 KB | ||
| 008 Lecture8.pdf | 470.7 KB | ||
| 008 fastfood.xlsx | 9.8 KB | ||
| 008 fastfoodChart.xlsx | 17 KB | ||
| 008 supplies.xlsx | 9.7 KB | ||
| 008 suppliesPieChart.xlsx | 16 KB | ||
| 009 Chart Basics Part 2 ... Combo Charts and more.en.srt | 13 KB | ||
| 009 Chart Basics Part 2 ... Combo Charts and more.mp4 | 72.5 MB | ||
| 009 HavanaClimographExercise.pdf | 724.1 KB | ||
| 009 Lecture9.pdf | 474.2 KB | ||
| 009 babytracker.xlsx | 11.8 KB | ||
| 009 babytrackerChart.xlsx | 18.6 KB | ||
| 009 havana.xlsx | 16.2 KB | ||
| 009 timely.xlsx | 9.5 KB | ||
| 009 timelyComboChart.xlsx | 15.6 KB | ||
| 010 File Integration with Object Linking and Embedding.en.srt | 13.9 KB | ||
| 010 File Integration with Object Linking and Embedding.mp4 | 74.8 MB | ||
| 010 Lecture10.pdf | 531 KB | ||
| 010 Lecture10exercisesnotes.rar | 560.9 KB | ||
| 010 OLEDemo.xlsx | 9.7 KB | ||
| 010 TestWordFile.docx | 12.4 KB | ||
| 011 ExerciseSolution.xlsx | 28.9 KB | ||
| 011 Lecture11.pdf | 488.4 KB | ||
| 011 Lecture11demos.rar | 102.3 KB | ||
| 011 SolverExercise.pdf | 459 KB | ||
| 011 What-If Analysis Using Goal Seek and Solver.en.srt | 23.7 KB | ||
| 011 What-If Analysis Using Goal Seek and Solver.mp4 | 126.1 MB | ||
| 012 Lecture12.pdf | 473.3 KB | ||
| 012 Lecture12demos.rar | 42.9 KB | ||
| 012 Lecture12exercisesnotes.rar | 625.8 KB | ||
| 012 Pivot Tables Part 1.en.srt | 17.6 KB | ||
| 012 Pivot Tables Part 1.mp4 | 110.3 MB | ||
| 013 Lecture13.pdf | 468.9 KB | ||
| 013 Lecture13exercisesnotes.rar | 745.5 KB | ||
| 013 Pivot Tables Part 2.en.srt | 12.5 KB | ||
| 013 Pivot Tables Part 2.mp4 | 95.6 MB | ||
| 013 pivotdata.xlsx | 9.7 KB | ||
| 013 pivotdataChart.xlsx | 19.1 KB | ||
| 014 Lecture14.pdf | 484.6 KB | ||
| 014 Lecture14demos.rar | 48.3 KB | ||
| 014 Lecture14exercisesnotes.rar | 494.6 KB | ||
| 014 Using Conditional Statements Part 1 ... IF and CHOOSE.en.srt | 21.4 KB | ||
| 014 Using Conditional Statements Part 1 ... IF and CHOOSE.mp4 | 123.1 MB | ||
| 015 Lecture15.pdf | 389.3 KB | ||
| 015 Lecture15ChallengeProblems.pdf | 559.7 KB | ||
| 015 Using Conditional Statements Part 2 ... Practical Applications.en.srt | 20 KB | ||
| 015 Using Conditional Statements Part 2 ... Practical Applications.mp4 | 125.4 MB | ||
| 015 party.xlsx | 11.6 KB | ||
| 015 river.xlsx | 10.1 KB | ||
| 016 Lecture16.pdf | 554.9 KB | ||
| 016 Lecture16demos.rar | 35.9 KB | ||
| 016 Lecture16exercisesnotes.rar | 524.2 KB | ||
| 016 Table Lookups Part 1 ... VLOOKUP a first look.en.srt | 17.7 KB | ||
| 016 Table Lookups Part 1 ... VLOOKUP a first look.mp4 | 100 MB | ||
| 017 BicycleShop.xlsx | 14.9 KB | ||
| 017 BicycleShopSolution.xlsx | 15.4 KB | ||
| 017 ChiarelliPharmacy.xlsx | 21.7 KB | ||
| 017 ChiarelliPharmacySolution.xlsx | 33.8 KB | ||
| 017 Lecture17.pdf | 344.1 KB | ||
| 017 Table Lookups Part 2 ... VLOOKUP a deeper look.en.srt | 31.8 KB | ||
| 017 Table Lookups Part 2 ... VLOOKUP a deeper look.mp4 | 196.4 MB | ||
| 017 VLOOKUPDeeperLookExercises.pdf | 731.5 KB | ||
| 018 BicycleShop.xlsx | 14.9 KB | ||
| 018 BicycleShopIndexSolution.xlsx | 15.2 KB | ||
| 018 Lecture18.pdf | 473.4 KB | ||
| 018 Table Lookups Part 3 ... INDEX.en.srt | 20.7 KB | ||
| 018 Table Lookups Part 3 ... INDEX.mp4 | 136.9 MB | ||
| 018 index1.xlsx | 12.4 KB | ||
| 018 index2.xlsx | 12.7 KB | ||
| 018 indexmatch.xlsx | 13.1 KB | ||
| 019 Lecture19.pdf | 392.8 KB | ||
| 019 Table Lookups Part 4 ... Practical Application.en.srt | 16.5 KB | ||
| 019 Table Lookups Part 4 ... Practical Application.mp4 | 92.7 MB | ||
| 019 VerticalBlindsApplication.pdf | 12.1 KB | ||
| 019 blinds.xlsx | 13.8 KB | ||
| 020 Lecture20.pdf | 610.8 KB | ||
| 020 Macros vs VBA.en.srt | 8.9 KB | ||
| 020 Macros vs VBA.mp4 | 51 MB | ||
| 020 RecordedMacroDemo.rar | 14.7 KB | ||
| 020 VBAdemo.rar | 32.3 KB | ||
| 021 ExcelMacroTips.pdf | 534 KB | ||
| 021 Lecture21.pdf | 528.1 KB | ||
| 021 Using the EXCEL Macro Recorder.en.srt | 13 KB | ||
| 021 Using the EXCEL Macro Recorder.mp4 | 75.4 MB | ||
| 021 macrorecordintro.xlsm | 18.1 KB | ||
| 022 Creating User Defined Functions Part 1.en.srt | 10.3 KB | ||
| 022 Creating User Defined Functions Part 1.mp4 | 45.6 MB | ||
| 022 Lecture22.pdf | 617.3 KB | ||
| 022 tempconversion.xlsm | 13.9 KB | ||
| 023 Commission.xlsm | 13.5 KB | ||
| 023 Creating User Defined Functions Part 2.en.srt | 14.8 KB | ||
| 023 Creating User Defined Functions Part 2.mp4 | 68.8 MB | ||
| 023 Lecture23.pdf | 461 KB | ||
| 023 Lecture23exercisesnotes.rar | 488.8 KB | ||
| 023 interestvba.xlsm | 18.6 KB | ||
| 024 Budget.xlsx | 13.5 KB | ||
| 024 ExcelObjectModelExercise.pdf | 454.5 KB | ||
| 024 Lecture24.pdf | 532.4 KB | ||
| 024 QtrSales.xlsx | 11.1 KB | ||
| 024 Sales.xlsx | 11.1 KB | ||
| 024 The EXCEL Object Model.en.srt | 15.8 KB | ||
| 024 The EXCEL Object Model.mp4 | 104.2 MB | ||
| 025 Lecture25.pdf | 450.3 KB | ||
| 025 Lecture25exercisesnotes.rar | 622.5 KB | ||
| 025 Using Variables ... The Object Variable.en.srt | 30.5 KB | ||
| 025 Using Variables ... The Object Variable.mp4 | 150.2 MB | ||
| 025 sales.xlsx | 11.4 KB | ||
| 025 salesvba.xlsm | 20.6 KB | ||
| 026 Lecture26.pdf | 544.8 KB | ||
| 026 Using Variables ... String Variables Part 1.en.srt | 20.1 KB | ||
| 026 Using Variables ... String Variables Part 1.mp4 | 109.4 MB | ||
| 026 commission.xlsx | 10.1 KB | ||
| 026 commissionvba.xlsm | 15.7 KB | ||
| 026 indexget1.xlsm | 18.6 KB | ||
| 027 Lecture27.pdf | 476.2 KB | ||
| 027 Lecture27exercisesnotes.rar | 557.3 KB | ||
| 027 Using Variables ... String Variables Part 2.en.srt | 26.3 KB | ||
| 027 Using Variables ... String Variables Part 2.mp4 | 155.9 MB | ||
| 027 commissionvba.xlsm | 15.7 KB | ||
| 027 commissionvbaCall.xlsm | 16.9 KB | ||
| 028 Lecture28.pdf | 453.2 KB | ||
| 028 Using Variables ... The Party Planner Practical Application.en.srt | 8.1 KB | ||
| 028 Using Variables ... The Party Planner Practical Application.mp4 | 51.9 MB | ||
| 028 party.xlsx | 11.6 KB | ||
| 028 partymac.xlsm | 17.9 KB | ||
| 028 partymacCall.xlsm | 21.9 KB | ||
| 029 Lecture29.pdf | 479.3 KB | ||
| 029 Lecture29exercisesnotes.rar | 509.4 KB | ||
| 029 Worksheet Controls ... Creating and using a Combo Box and List Box.en.srt | 28.9 KB | ||
| 029 Worksheet Controls ... Creating and using a Combo Box and List Box.mp4 | 140.6 MB | ||
| 029 pricelist.xlsx | 10.1 KB | ||
| 029 pricelistvba.xlsm | 22 KB | ||
| 030 Lecture30.pdf | 478.9 KB | ||
| 030 Practical Application Parts Ordering App Part 1.en.srt | 29.8 KB | ||
| 030 Practical Application Parts Ordering App Part 1.mp4 | 193.1 MB | ||
| 030 index2.xlsx | 12.7 KB | ||
| 030 indexget2.xlsm | 28.2 KB | ||
| 030 indexget2AllVBA.xlsm | 32.2 KB | ||
| 031 Lecture31.pdf | 539 KB | ||
| 031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.en.srt | 18.5 KB | ||
| 031 Practical Application Parts Ordering App Part 2 ... Selection and Repetition.mp4 | 98.6 MB | ||
| 031 SelectionRepetitionPrimer.xlsm | 26.7 KB | ||
| 031 indexbr.xlsm | 29.5 KB | ||
| 032 Lecture32.pdf | 406.4 KB | ||
| 032 Practical Application ... Party Planner.en.srt | 9.7 KB | ||
| 032 Practical Application ... Party Planner.mp4 | 57.1 MB | ||
| 032 partycheck.xlsm | 25.9 KB | ||
| 032 partymac.xlsm | 17.9 KB | ||
| 033 Lecture33.pdf | 539.2 KB | ||
| 033 Practical Application ... The Blinds Store Application.en.srt | 30.8 KB | ||
| 033 Practical Application ... The Blinds Store Application.mp4 | 175.4 MB | ||
| 033 VerticalBlindsApplicationRevisited.pdf | 12.1 KB | ||
| 033 blinds.xlsx | 13.8 KB | ||
| 033 blindsmac.xlsm | 34.4 KB | ||
| 033 blindsmacupdate.xlsm | 43.4 KB | ||
| 034 Creating Menu Driven Workbooks.en.srt | 23.1 KB | ||
| 034 Creating Menu Driven Workbooks.mp4 | 130 MB | ||
| 034 Lecture34.pdf | 630.7 KB | ||
| 034 Lecture34exercisesnotes.rar | 497.7 KB | ||
| 034 foodcosts.xlsx | 11.9 KB | ||
| 034 foodcostsMenuUpdate.xlsm | 131.6 KB | ||
| 034 partybtn.xlsm | 120.5 KB | ||
| 035 Creating Custom User Forms.en.srt | 30.9 KB | ||
| 035 Creating Custom User Forms.mp4 | 159.2 MB | ||
| 035 Lecture35.pdf | 484 KB | ||
| 035 Lecture35demos.rar | 26.6 KB | ||
| 036 Creating Custom User Forms Review and Extension.en.srt | 11.6 KB | ||
| 036 Creating Custom User Forms Review and Extension.mp4 | 57.2 MB | ||
| 036 Lecture36.pdf | 461.5 KB | ||
| 036 Lecture36demos.rar | 32.3 KB | ||
| 037 Lecture37.pdf | 414.4 KB | ||
| 037 Lecture37demos.rar | 66.8 KB | ||
| 037 Practical Application ... Parts Ordering App Final Version.en.srt | 17.6 KB | ||
| 037 Practical Application ... Parts Ordering App Final Version.mp4 | 97.1 MB | ||
| 038 BudgetTracker.rar | 198.6 KB | ||
| 038 Lecture38.pdf | 341.5 KB | ||
| 038 Practical Application ... The Budget Tracking Application.en.srt | 6.4 KB | ||
| 038 Practical Application ... The Budget Tracking Application.mp4 | 39.8 MB | ||
| ReadMe.txt | 204.8 B | ||
| Visit Coursedrive.org.url | 102.4 B | ||
| external-assets-links.txt | 0 B | ||
| ▲ 220 total files | |||
⚡️⚡️For More Udemy Courses Visit ???????? Course Drive
A Gentle Introduction To Advanced Excel Techniques
Take your EXCEL skills to the next level . Learn basic data analysis , lookup techniques, macros and programming in VBA
What you'll learn
• Review some Excel basics to get you up to speed
• Analyze spreadsheet data using goal seek and solver
• Implement pivot tables to analyze complex data in a variety of ways
• Use advanced Excel commands which incorporate conditional statements
• Implement look up tables using the vlookup and index commands
• Create simple macros to automate specific procedures
• Create user defined functions
• Create simple VBA (Visual Basic Applications) incorporating string and numeric variables
• Create simple applications which incorporate combo boxes, dialog boxes and other UI interface controls
• Create simple applications which check user input using the concepts of Selection (IF) and Repetition(DO...LOOP)
• Create Menu driven workbooks
• Implement user friendly input techniques by creating custom user forms
• Create a fully functioning Budget Application to track household or business expenses
Requirements
• A recent version of Excel (most techniques taught will work with Office Version 97 or later ...the actual course was created using Excel 2016)
• Should have a beginners knowledge of how to use Excel
Description
You may or may not know of the importance of Excel and the dependency businesses have on its use every single day. There is a HUGE need for advanced Excel users in the marketplace. I hope to transform you from being an ordinary user into your company's leading Excel expert and eventually master the ability to automate tasks with macros and the use of VBA programming . My hope is to provide you with a very straightforward course which will allow you to use some of the most advanced Excel techniques.
VBA is a very useful skill to have and is used in almost all organizations. Knowing VBA can help you work considerably faster. Think of VBA as an extension of Excel skills. If improving your Excel abilities would be beneficial, then you should absolutely consider learning VBA.
Here's how I will help you to succeed:
o Each lecture starts with a list of objectives/speaking notes
o Every example covered in the lecture is available for download in the resources section … including the objectives/speaking notes
o Almost every lecture has a set of Practice problems with full solutions provided
o My style of writing and teaching follows the KISS principle : Keep It Super Simple. I try to stay away from fancy computer terminology and try to teach like am speaking to a brand new user with little to no previous knowledge on the subject matter.... and I am always available for help … replying most times within a day.
Who this course is for:
• Individuals looking to enhance their Excel skills to perform advanced data analysis and automation (macros, programming in VBA)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.3 GB | freecoursewb | 2 days | 14 | 22 | |
| 1.2 GB | freecoursewb | 2 days | 7 | 11 | |
| 1.2 GB | freecoursewb | 2 weeks | 22 | 4 | |
| 2.4 GB | freecoursewb | 3 weeks | 0 | 0 | |
|
Udemy - Demo like a Pro - Beginners Guide to Software Demos in Sales Posted by
freecoursewb in Other
|
844.6 MB | freecoursewb | 3 weeks | 18 | 4 |
All Comments