Udemy - A Gentle Introduction To Advanced Excel Techniques [Course Drive]

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size3.9 GB
  • Uploaded Bycoursedrive
  • Downloads398
  • Last checkedMay. 08th '20
  • Date uploadedMay. 06th '20
  • Seeders 9
  • Leechers10
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 7051849327D43909B53A674412F82A4654FB99B0

⚡️⚡️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)

Files:

A Gentle Introduction To Advanced Excel Techniques A Gentle Introduction To Advanced Excel Techniques 04 Conditional Calculations and Table Lookups
  • 017 Table Lookups Part 2 ... VLOOKUP a deeper look.mp4 (196.4 MB)
  • 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 party.xlsx (11.6 KB)
  • 015 river.xlsx (10.1 KB)
  • 015 Using Conditional Statements Part 2 ... Practical Applications.en.srt (20.0 KB)
  • 015 Using Conditional Statements Part 2 ... Practical Applications.mp4 (125.4 MB)
  • 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.0 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 VLOOKUPDeeperLookExercises.pdf (731.5 KB)
  • 018 BicycleShop.xlsx (14.9 KB)
  • 018 BicycleShopIndexSolution.xlsx (15.2 KB)
  • 018 index1.xlsx (12.4 KB)
  • 018 index2.xlsx (12.7 KB)
  • 018 indexmatch.xlsx (13.1 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)
  • 019 blinds.xlsx (13.8 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)
  • ReadMe.txt (0.2 KB)
  • Visit Coursedrive.org.url (0.1 KB)
    • 01 Course Information
    • 001 Lecture1.pdf (413.5 KB)
    • 001 Welcome.en.srt (4.0 KB)
    • 001 Welcome.mp4 (37.6 MB)
    • 002 Lecture2.pdf (408.8 KB)
    • 002 Lecture11demos.rar (102.3 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)
    • external-assets-links.txt (0.0 KB)
    02 Excel Basics Review and Extension
    • 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.0 MB)
    • 005 int2Final.xlsx (14.3 KB)
    • 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)
    • 006 int2Enhanced.xlsx (12.1 KB)
    • 006 int2Plain.xlsx (9.9 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)
    • 007 Lecture7.pdf (472.0 KB)
    • 007 Lecture7exercisesnotes.rar (455.0 KB)
    • 007 multiplesheetsFinal.xlsx (14.6 KB)
    • 007 multiplesheetsSkeleton.xlsx (12.2 KB)
    • 007 Working with Multiple Sheets.en.srt (11.7 KB)
    • 007 Working with Multiple Sheets.mp4 (65.9 MB)
    • 008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.en.srt (13.0 KB)
    • 008 Chart Basics Part 1 ... Bar Charts and Pie Graphs.mp4 (70.2 MB)
    • 008 ChartingExercise.pdf (374.9 KB)
    • 008 fastfood.xlsx (9.8 KB)
    • 008 fastfoodChart.xlsx (17.0 KB)
    • 008 Lecture8.pdf (470.7 KB)
    • 008 supplies.xlsx (9.7 KB)
    • 008 suppliesPieChart.xlsx (16.0 KB)
    • 009 babytracker.xlsx (11.8 KB)
    • 009 babytrackerChart.xlsx (18.6 KB)
    • 009 Chart Basics Part 2 ... Combo Charts and more.en.srt (13.0 KB)
    • 009 Chart Basics Part 2 ... Combo Charts and more.mp4 (72.5 MB)
    • 009 havana.xlsx (16.2 KB)
    • 009 HavanaClimographExercise.pdf (724.1 KB)
    • 009 Lecture9.pdf (474.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.0 KB)
    • 010 Lecture10exercisesnotes.rar (560.9 KB)
    • 010 OLEDemo.xlsx (9.7 KB)
    • 010 TestWordFile.docx (12.4 KB)
    03 Data Analysis Basics
    • 011 ExerciseSolution.xlsx (28.9 KB)
    • 011 Lecture11.pdf (488.4 KB)
    • 011 Lecture11demos.rar (102.3 KB)
    • 011 SolverExercise.pdf (459.0 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 pivotdataCh

Code:

  • udp://tracker.opentrackr.org:1337/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • http://p4p.arenabg.com:1337/announce
  • udp://9.rarbg.to:2710/announce
  • udp://9.rarbg.me:2710/announce
  • udp://exodus.desync.com:6969/announce
  • udp://open.stealth.si:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://tracker.sbsub.com:2710/announce
  • udp://retracker.lanta-net.ru:2710/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.moeking.me:6969/announce
  • http://tracker3.itzmx.com:6961/announce
  • http://tracker1.itzmx.com:8080/announce