Excel Training (Indirect, count & sum family)- Series 3

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

  • This series-3 you should watch if you are good with V-lookup ,Match and other basic formulas of excel.
  • This tutorial will take you to new level as we are discussing so many advance excel functions .As always, not just basic functions but their combinations as well - how it works in real excel life. You will then see some mini exercises as well that are sufficient to make you crazy about excel.
  • Introduction to Indirect Function, use of indirect in real life.
  • Introduction to Address function. What happens when indirect and address functions come together.
  • What is a name manager.How to create name managers. Their use with Indirect function
  • Learn how to make simple drop downs and dynamic powerful drop downs using indirect and name managers
  • Discussing about Count and sum family functions - Count,Counta,Count-blank,Count-if,Count-ifs ,Sum,Sum-if,Sum-ifs
  • Combination of these functions with each other by solving the real excel problems
  • Use of wild characters in Count Sum functions - use of * and ? . Unbelievable magic happens
  • Assignments are added to support you and help you in monitoring the progress. Write me back if you will have questions. I will love to help you.

Who this course is for:

  • Students who want to make career in analytics field. Require advance excel knowledge

Course content

1 section • 11 lectures • 7h 45m total length
  • Introduction to COUNT and SUM Family
    01:21:02
  • Introduction to Indirect Name Managers/Ranges and Data Validation
    01:24:09
  • Interesting Project on INDIRECT Function
    28:15
  • Surprise Test - - All complex and advance functions - All in one
    57:01
  • Surprise Test - - All complex and advance functions - All in one
    01:33:56
  • Surprise Test - Indirect and Address together
    11:59

Instructor

Instructor - Advance Excel, Excel Vba ,Access, Access Vba
  • 4.5 Instructor Rating
  • 533 Reviews
  • 2,289 Students
  • 45 Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Expected Outcomes

  1. Students will be able to learn dynamic functions like INDIRECT data validation Count Sum family functions with the live exposure of working on excel. Requirements Good Understanding of Excel functions like Vlookup Match Index Text functions is a must. Description This series-3 you should watch if you are good with V-lookup ,Match and other basic formulas of excel. This tutorial will take you to new level as we are discussing so many advance excel functions .As always, not just basic functions but their combinations as well - how it works in real excel life. You will then see some mini exercises as well that are sufficient to make you crazy about excel. Introduction to Indirect Function, use of indirect in real life. Introduction to Address function. What happens when indirect and address functions come together. What is a name manager.How to create name managers. Their use with Indirect function Learn how to make simple drop downs and dynamic powerful drop downs using indirect and name managers Discussing about Count and sum family functions - Count,Counta,Count-blank,Count-if,Count-ifs ,Sum,Sum-if,Sum-ifs Combination of these functions with each other by solving the real excel problems Use of wild characters in Count Sum functions - use of * and ? . Unbelievable magic happens Assignments are added to support you and help you in monitoring the progress. Write me back if you will have questions. I will love to help you. Who this course is for: Students who want to make career in analytics field. Require advance excel knowledge Show more Show less Course content 1 section • 11 lectures • 7h 45m total length Excel MIS Analytics Training - Series3 11 lectures • 7hr 46min Introduction to COUNT and SUM Family Preview 51:06 Introduction to COUNT and SUM Family 01:21:02 Introduction to Indirect Name Managers/Ranges and Data Validation 01:24:09 Indirect function - Project1 Preview 19:28 Interesting Project on INDIRECT Function 28:15 Indirect function - Project2 Preview 15:29 Surprise Test - - All complex and advance functions - All in one 57:01 Surprise Test - - All complex and advance functions - All in one 01:33:56 Surprise Test - Indirect and Address together 11:59 One more project - Indirect and Address Preview 22:25 My other Series/Tutorials with links and coupons Preview 00:55 Instructor ajay parmar Instructor - Advance Excel, Excel Vba ,Access, Access Vba 4.5 Instructor Rating 533 Reviews 2,289 Students 45 Courses I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781dfdfbd1dbbe2',m:'8169bb8bba4041769836cb1e31f4084d396fcdc8-1627850353-1800-AWgIm7K/IUxHYJ8epkwdstXvAXW5doe5h4TxH5VtKKtwYX9/1JpOAtKsMoiHX32Lmm/9XrUSYZvHnF+q1upXiX9rhjzoz7Tm4/7/pf17U0X23zYxV2SadlbJ7yx2/NOCDbo/svEYZVKNPbtzhiT/duOILkvfV8GjrnE618fiXqC+',s:[0x3987070f01,0x2d3c9dc500],}})();