Znajdź zawartość

Udemy - Excel for Analysts: Mastering Advanced Formulas & Functions English | MP4 | 1280x720 | 58 kbps | 44 KHz | 6 hours | 1.10 Gb Genre: eLearning Learn how to write powerful Excel functions with hands-on, interactive exercises designed by an award-winning instructor It's time to show Excel who wears the pants in this relationship. Whether you're starting from square one or aspiring to become an absolute Excel badass, you've come to the right place. It's time to stop digging through help forums and shelling out absurd fees for tutors and textbooks -- you deserve better. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a nuMber of ways. I will not train you to regurgitate formula syntax; I will teach you how to THINK like Excel. readmore By the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to: Easily build dynamic tools & dashboards to filter, display and analyze your data Go rogue and design your own formula-based formatting rules Join datasets from multiple sources in seconds Tap into API data sources like live weather, stock quotes, GPS data, etc. Manipulate dates, times, text, and arrays Automate tedious and time-consuming tasks (no VBA required!) And much, much more... What gives you the right to teach this class? Can't I just Google this stuff? Fantastic question. First and foremost, I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and/or significant others. The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven I've been lucky enough to teach thousands of people just like you over the past 7+ years. My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend. As a full-time analytics consultant and Excel instructor, I cut my teeth using Excel to solve real-world business problems and develop award-winning analytics & data visualization tools for Fortune 500 companies. If you care about creds, I'm a card-carrying MOS Certified Excel Expert and my work has been featured by Microsoft and the New York Times. Ok so I don't actually carry the card, but you get the idea. What are the requirements? Microsoft Excel (2007+) installed and ready to roll Some experience with basic formulas is recommended, but not required (we'll spend some time laying the groundwork for the more advanced stuff) What am I going to get from this course? Over 76 lectures and 5.5 hours of content! 60+ downloadable PDF slides and 9 Excel practice files Hands-on practice writing powerful, complex Excel functions from scratch A step-by-step, 100% comprehensive guide to the most versatile, powerful functions in Excel What is the target audience? Excel users who have basic skills but want to get really, REALLY good Anyone hoping to expand their analytical skill set, work more efficiently with data, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to training DOWNLOAD http://rapidgator.net/file/79a5f26f5dad4291a9647d593659ce4c/7Excel.part1.rar.html http://rapidgator.net/file/5db1c48fa378762f75047227c5fef0c4/7Excel.part2.rar.html http://rapidgator.net/file/a4695eca59c3bc21bb063eba0bce3af8/7Excel.part3.rar.html http://rapidgator.net/file/1f484a7de96b88b6a0fc7b96d16286c7/7Excel.part4.rar.html http://rapidgator.net/file/644869d34c631512d4ddeebe1c26bc86/7Excel.part5.rar.html http://uploaded.net/file/t7rcldo3/7Excel.part1.rar http://uploaded.net/file/v161876l/7Excel.part2.rar http://uploaded.net/file/azyo15ne/7Excel.part3.rar http://uploaded.net/file/bu2dhfso/7Excel.part4.rar http://uploaded.net/file/5r1fzmqv/7Excel.part5.rar http://www.hitfile.net/Xbx/7Excel.part1.rar.html http://www.hitfile.net/Y1z/7Excel.part2.rar.html http://www.hitfile.net/Xjf/7Excel.part3.rar.html http://www.hitfile.net/XrT/7Excel.part4.rar.html http://www.hitfile.net/XCJ/7Excel.part5.rar.html http://www.uploadable.ch/file/dHH72vRBe85B/7Excel.part1.rar http://www.uploadable.ch/file/2TmdVF9sKu4h/7Excel.part2.rar http://www.uploadable.ch/file/fM3F8MbNFxcy/7Excel.part3.rar http://www.uploadable.ch/file/fEcsb2An8SsH/7Excel.part4.rar http://www.uploadable.ch/file/wVzyv4fNNpTB/7Excel.part5.rar

Udemy - Bug Hunting: Problem Determination for Analysts English | 3h | AVC (.MP4) 1280x720 30fps | AAC 44.1KHz 2ch | 415 Mb Genre: eLearning Gain a reputation for solving tricky IT problems efficiently. Learn to manage problem determination effectively. What are the requirements? Ideally, before starting this course, you should have some experience of dealing with problems in IT systems. What am I going to get from this course? Over 21 lectures and 2.5 hours of content! Describe "Problem Determination" and apply it to problems with IT systems. Explain why "Problem Determination" matters and justify using a structured approach. Use an 8-step framework to manage Problem Determination Apply proven techniques to isolate problem causes Recognise situations where these techniques might not be appropriate and understand what to do at these times. What is the target audience? This course is intended for analysts who need to deal with problems in complex IT systems. It is probably not for you if you are looking for detailed technical diagnosis techniques. Help-desk professionals who want to advance from simply following a script will learn how to identify the causes of new problems. Managers who take this course will learn a framework which can be used to prioritise problems and techniques which make the process more efficient and predictable. DOWNLOAD http://rapidgator.net/file/a4c6675d54a2fea930985cd1e6768a0f/cBug.part1.rar.html http://rapidgator.net/file/8663630e326cd4d7316b17564c72e059/cBug.part2.rar.html http://rapidgator.net/file/e24c521205ed0d9f78915e0766695416/cBug.part3.rar.html http://rapidgator.net/file/172d284cf3052059de4ae339ddda16fe/cBug.part4.rar.html http://rapidgator.net/file/f12dea19304f84b821a78b1bacb023a4/cBug.part5.rar.html http://uploaded.net/file/774x4epp/cBug.part1.rar http://uploaded.net/file/hhsdtxzs/cBug.part2.rar http://uploaded.net/file/afq6yo9d/cBug.part3.rar http://uploaded.net/file/ty0nkm28/cBug.part4.rar http://uploaded.net/file/9w63lerk/cBug.part5.rar http://www.uploadable.ch/file/teATCk4QQuNa/cBug.part1.rar http://www.uploadable.ch/file/CuAYgqTc9fkX/cBug.part2.rar http://www.uploadable.ch/file/5y5E9XeC4hwQ/cBug.part3.rar http://www.uploadable.ch/file/GSqFzaEfcugg/cBug.part4.rar http://www.uploadable.ch/file/E7VaUEzWWnVa/cBug.part5.rar http://www.hitfile.net/4h5w/dSakimi.part1.rar.html http://www.hitfile.net/4hcW/dSakimi.part2.rar.html http://www.hitfile.net/4hem/dSakimi.part3.rar.html http://www.hitfile.net/4hQ9/dSakimi.part4.rar.html http://www.hitfile.net/4h8v/dSakimi.part5.rar.html