UDEMY_EXCEL_FOR_ANALYSTS_MASTERING_ADVANCED_FORMULAS_AND_FUNCTIONS_TUTORIAL-kEISO

Section

Appz

Group

kEISO

Size

1,11 GB

Files

26

Date

2015-08-23

NFO

                                                   █▀▀▀▀
                                                   ▓ ████████ ░
                                                   ░ ████████ ▓
                                           █▀▀▀      ████████ ▀▀▀▀  ▀▀▓
                                           ▓ ███████████▓████████████ ▒
            ████████ ▄                     ░ ██████████▓▒▓███████████ ░
            ████████ █▓▄              ▄▓█▄▄  ████████▓▀ ░ ▀▀▀▓███████
 ████████▌▄ ████████ ▀▀▀▀           ▄▓███████ ░ ▄▄▄▄ ▄█▄ ▄██▄ ▓▄▄ ▄   ████████
 ▀▀▀█████▌█ ██████████████▄       ▄▓███████▀▄▄     ▓▐████████ ░       ████████
  ███████▌█ █████████████▌█▓▄   ▄▓█████████████▓▄▄ ░ ▀█████▀ ▐▄▄█████▌████████
  ███████▌ ▄████████▓████▌█▀▀▀    ▀▀████████████████▄█▄▀█▀ ▄▌░███████▌████████
███████▓▀▄████████▓▀▄████ █ ████████▄▄█▀████████████████ ▄██▌▓████████████████
▓█████▄█████████▀ ▓██████ ▀ █████▄ ▐██████▌▀▓████████▓██████▌▀██████████▀▀▀▀▀▀
  ▀▀▓████████▓▀   ████████▄ ███████▐██████▌   ▀██████▀███████ ▄▀██▓████▄ ▀██▀
  ▐▄▄ ▀▀▓███████▄▄█▀▀▓██████▄▄▐▀▓██▐███████  ▄████▓▀  ███████ ▓  ▀░██████▄▀
  ▐███░▄▄ ▐████████ ░░ ▀▀▓█████████ ███████▄██▓██▀    ▀▀█████ ░    ▀▀▓████░▄
▄▄▄▄▄█▓██ ▐████████▄▄▄▄▄▄▄ ▀▀██████ ▀▀█▀███▀▀███▄  ▄▐████████▌▄▄▄░████████▓██
▐████████ ▓███████▓██████▓  ██▄▓███████████▌██████▄▀ ████████▌███▒████▀▀▀
 ████████ ▓█████▄▄ ▄▄████▌  █████▐█████████▌████████▄████████▓███▓████  ███████
 ███▀▀▀▀▀▐███  ███ ██████████████ █████████▌ ▀██▓█████▀▀▀    ▐███████▌  ███████
  ▄▄████ ▐█      █▄▄▄▄▄▄ ▀▀▀▀▀▓██ ███▌▀▀▀ ▄▄█▄ ▀░███████▄ ▄██████████▓███████▀▀
   ▀▓▀▀▀ ▐███░ ███████▌▐▀█████▄▄▄▄▀▄▄▄██▀ ▀▓███▄ ▀███████████▌▐█▄▄▀▀▀▀▀▀▀█████
         ▓███  ███████▌██▄▀▀▀▀▓████▄▀▓██ ▓  ▀▓███▄ ▀▀████████▌▓█████████▄▄▄▄▄
         ▀▀▀▀▀▀▀▀▀▐ ██ ███          ▀▀  ▓█▓   ▀▀▀  ▄██████████     ▀▀▀▀▓███▀
          ▀▓█▀▀▀▀▀▀▀▀▀▀███       ░░ ▀▀█▓█████▀▀▄▄▓▄▄ ▀▀███████ ▓▄▄
            ▀ ████████ ▀▀▀    ▄▄▄▓▓▌  ▄██▀██▄    ▀▀▓██▄  ▀▀███ ████▓▄
           ▄▄▄████████▄▄▄▄▓▓█████▀▀  ▐▓▀ █▄▀▓█       ▀ ▄██▄▄ ▀ ▀█▀███▌
  ░▄▄▄▄██████▀██████▓██████████████  ▀ ▄████▄██▄▄▄▓██ ██████▀   ▄█████ ███▄▄▄▄▄
██▓█████▓███████████░▓█████████████ ▐████████████████░█████▌  ▄▓██▀███▌████████
▓███████░██████████████████  █▓▓▀▀▀ ▐██████▓███▌█████▓█████ ▄███▀▐████▌███████▌
░▓█████▀ ███▀▀▀█████▌▀▓█████▄   ▄▓█ ▐██████▒███████▀▀▀▐██████▓▀  ▐████▌█████▄
 ▀██████▄   ▄▓▐██████▄ ▀▓██████ █▀▀ ███████░▀███████▄ ░█████▀▄  ▄████▓███████▌
   ▀▓██████ ▀▀▐█████▓▓ ▄▄██████   ▄ ███████▄▐▄▀██████▓▓▄███▄█████████░███████▌
   ▄▄██████   ▄█████████████▌   ███▄▄███████    ▀▓███ ▄▄▄▄▄▄▄▄ ▀▀██▓▀ ███████
░███████▌   █████▐███████████  ▐████████████████   ▐█ █████████▓▄▄   ▐███████
 ▌▄▄█████  ▐█████▐█████▐██████▄█████▄███████▀███▌  ██ ▀▀░▓█████████▓▄▐███████
  ▐███████▄█████▌▐█████ ▀█████████ █▀███████▓████▄██████▓████████████████████
   ▀▓█████████▓▀▄██████ █▄▄▀▀██▓▀▀  ▓▄▀█████▀▓████████▐███████▀▓█████▀▀▀████▌
      ▀▀▓░░▀▀▄▄███████  ▀ ▄▄▄▄█████ ▄▀█▄▀███▐▄ ▀▀░░▓▀▀▐███████ ▄▄▀▀   ░▄  ▀█▌
     ▄▀ ▄ ▀▄   ████████████████▓███ ██ ▓█▄▄█ ▀██▄▄▄██▀▄▄▄▄▄▄▄▄ ██▀ ▄▀ ▄ ▀▄  ▌
    ▐▌ ■░■ ▐▌  ████████████████████ ███ ▀▓██   ▀▀▓▀▀▄██████▓▀   ▀ ▐▌ ■░■ ▐▌
     ▀▄ ■ ▄▀   ███████▓▓▀▀▀▀▀▓▓▄▄▄▄       ▀▓       ▀▀▀▀▀▀▀▀        ▀▄ ■ ▄▀
  ▄ ▀ ▐ ▓ ▌ ▀ ▄  ▄▄▄▄▄███████████▀ ▄■▀▀▀▀▀■▄                    ▄ ▀ ▐ ▓ ▌ ▀ ▄
 ■    ▐ ▒ ▌    ■  ▀████▓▓▓░░░▀▀▀ ▄▀  KYRIE  ▀▄                 ■ ▄  ▐ ▒ ▌    ■
▌   ▄▀▐ ░ ▌▀▄   ▐   ▀▀    ▄▄▄▄▄▄▄▌  ELEISON  ▐▄▄▄▄▄▄▄░        ▌  ▀▄▀▐ ░ ▌▀▄   ▐
▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄ ▄▄▓▀▀▀ ▄ ▄ ▄▀▄ ▄▄▀▀▀▄▄ ▄▀▄ ▄ ▄ ▀▀▀▓▄▄ ▄▀▀▀▄ ▀▄▓▐ ░ ▌▓▄▄ ▄▀
  ▐▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌  ▄  ▀  ▄▄▄▄▄▄█▀░   ░▀█▄▄▄▄▄▄  ▀  ▄  ▐▌ ▀▓ ▌ ▀▀▀▄▀▄▀▀▀▀▌
▄  ▀▀▀▓ ▀  ▀▀▀ ▀▄▄▄▀  ▓██ █▓▀▀     ▀▌▄   ▄▐▀     ▀▀▓█ ██▓  ▀▄▄▄▀ ▐▀▀  ▀ ▓▀▀▀  ▄
█▄   ▀▐  ▄██▄   ▄  ▄▄█▀              ▀▀▀▀▀              ▀█▄▄  ▄  ▄▄██▄  ▌▀   ▄█
▓█▓▄    █▄▀▀█▌ ▄ ▄█▓▀                                     ▀▓█▄ ▄ ▀█▀▀▄█    ▄▓█▓
 ▀▓█▓▄▄▓████▄▄▄██▀▀           RELEASE INFORMATION           ▀▀██▄ ▄████▓▄▄▓█▓▀
  ▀▓████▀▓█▀ ▀▓▀                                               ▀▓  ▀█▓▀████▓▀
 █ ▀█▓▓██▄▄██    TITLE: Excel for Analysts: Mastering Advanced    ██▄▄██▓▓█▀ █
 █▀ ▐█▒▓██░██            Formulas and Functions                   ██░██▓▒█▌ ▀█
 █▀  █▓███▒█▌                                                     ▐█▒███▓█  ▀█
 █▀ ▐█▓███▓█░                                                     ░█▓███▓█▌ ▀█
 █▀ ▐██████▌     PUBLISHER..........: UDEMY                        ▐██████▌ ▀█
 █▀ ▀▀████▓      LINK...............: http://is.gd/TlrJzI           ▓████▀▀ ▀█
 ▌ ▓██▌▄ ▀▀      AUTHOR.............: Chris Dutton                  ▀▀ ▄▐██▓ ▐
 ▌▐███░▒███▌     LEVEL..............: all level                    ▐███▒░███▌▐
 ▌ ████▓████     RUNTIME............: 5.5 hours                    ████▓████ ▐
 █ ▐▓█▀█████░    LANGUAGE...........: ENGLISH                     ░█████▀█▓▌ █
 █▀ ▀▄█▄▄▀▀█▓    RELEASE TYPE.......: RETAIL                      ▓█▀▀▄▄█▄▀ ▀█
 █▀▄ ▄▀███▓▄     RELEASE FORMAT.....: ISO                          ▄▓███▀▄ ▄▀█
 █▀█ ▐▓▄▀████    STORE DATE:........: 2015.08.21                  ████▀▄▓▌ █▀█
 █▀█ ▐█▌▓██▓     RELEASE DATE.......: 2015.08.22                   ▓██▓▐█▌ █▀█
 ▓▀█ ▓▌░██▓      ISO SIZE...........: 1,190,998,016                 ▓██░▐▓ █▀▓
 ▒▀█ █ ▓█▓       ISO CHECKSUM.......: FFE71C61                       ▓█▓ █ █▀▒
 ░ █ ▌░██        DISKCOUNT..........: 24 * 50MB                       ██░▐ █ ░
   ▓█▌▓█▌        SAVED MONEY........: YOU DID!                          ▐█▓▐█▓
 ░ ▒█▐██         DISKNAME...........: keiso_ueamaff                    ██▌█▒ ░
   ░▀ ▀                                                                   ▀ ▀░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██  ▄▄▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀         TUTORIAL          ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓  ▄ █▀▀                                                   ▀▀█ ▄  ▓▄ █▀█
 █▀█ ▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄ █▀█
 █▀█ █▓ ▄▓▄▀ *** THIS IS A BRAND NEW COURSE FOR 2015-2016***       ▀▄▓▄ ▓█ █▀█
 █▀█ ▓▒  ▒                                                           ▒  ▒▓ █▀█
 █▀█ ▒░  ░ 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.                                              ░
   ░                                                                    ░
   ░ 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.                                                             ░
   ░                                                                    ░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██  ▄▄▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀       NOTES / NEWS        ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓  ▄ █▀▀                                                   ▀▀█ ▄  ▓▄ █▀█
 █▀█ ▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄ █▀█
 █▀█ █▓ ▄▓▄▀                                                       ▀▄▓▄ ▓█ █▀█
 █▀█ ▓▒  ▒               Huh? No news are good news!                 ▒  ▒▓ █▀█
 █▀█ ▒░  ░                                                           ░  ░▒ █▀█
 ▓▀█ ▒░                                                                 ░▒ █▀▓
 ▒▀█ ░▓                                                                 ▓░ █▀▒
 ░ █  ▒                                                                 ▒  █ ░
   ▓  ░                                                                 ░  ▓
 ░ ▒  ░                                                                 ░  ▒ ░
   ░                                                                    ░
 ░                                                                           ░
 ░▄░ ░       ██           ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄           ██       ░ ░▄░
 ▒▄▒ ▓░   ████████  ▄▄▓█▌▀▀█▄▄▀▀               ▀▀▄▄█▀▀▐█▓▄▄  ████████   ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄    ██    ▐██▀ ▄██▀                       ▀██▄ ▀██▌▄▄  ██    ▄▀▀ ▀▓▄▓▐
█▀  ▓░  ▄ █▄▌██ ▄░  ▀█▌▐▓▀          RESPECTS         ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄  ░▓  ▀█
 ▄▀ ▄ ▀▄   ▀▌▓█   ▀▄▄ ▀ ▀▄                           ▄▀ ▀ ▄▄▀   █▓▐▀   ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌  ▄▌░▓   ▄██   ▀  ▓                       ▓  ▀   ██▄   ▓░▐▄  ▐▌ ■░■ ▐▌
 ▀▄ ■ ▄▀ ▀▀▀▀ ▄▄▓▀▀▀           ▀      ▀ ▀      ▀           ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
 █▀█ ▄▓▄ ▄▄█▀▀▀                                                  ▀▀█ ▄ ▄▓▄ █▀█
 ▌ ▐▄▄▓  ▄ ▐▌                                                     ▐▌ ▄  ▓▄▄▌ ▐
 ▌  ▀█▓ ▄▓▄▀       BBL - DDU - EEn - iNTENSiTY - JGT - RBS         ▀▄▓▄ ▓█▀  ▐
 ▌░   ▓  █                                                           █  ▓   ░▐
 ▌▒   ▒▄█▀                                                           ▀█▄▒   ▒▐
 ▌▓▌  ░                                                                 ░  ▐▓▐
 ▌██  ░                            SHOUTOUTS                            ░  ██▐
 ▌▐▓█                                                                     █▓▌▐
 ▌ ░▓█                                                                   █▓░ ▐
 █  ░██                                                                 ██░  █
 █▀▄ ▓██▄         DVT - FONT - iRONiSO - LAXiTY - PARADOX - SO        ▄██▓ ▄▀█
 █▀ ▄ ▓███▄                                                         ▄███▓ ▄ ▀█
 █▀  █▄▀▓█▀██▄                         ▓                         ▄██▀█▓▀▄█  ▀█
 █▀ ▀ ▀█▄▀▓█▄▀▀▓▄▄                  ▄▀ ▄ ▀▄                  ▄▄▓▀▀▄█▓▀▄█▀ ▀ ▀█
 █▀▄ ▀▄▀██▄▀▀█▄  ▀▀▓▄▄        ░  ▄▌▐▌ ■░■ ▐▌▐▄  ░        ▄▄▓▀▀  ▄█▀▀▄██▀▄▀ ▄▀█
 █▀█ ▄ ▀▄▀███▄▀▀█▄▄  ▀▀▓▄  ▄▄▄▓▓█▀  ▀▄ ■ ▄▀  ▀█▓▓▄▄▄  ▄▓▀▀  ▄▄█▀▀▄███▀▄▀ ▄ █▀█
 █▀█ █  ▀█▄▀█▄▀█▄▀▀█▄   █▓  ▀█ ▄ ▄ ▀ ▐ ▓ ▌ ▀ ▄ ▄ █▀  ▓█   ▄█▀▀▄█▀▄█▀▄█▀  █ █▀█
 █▀█ █ █  ▀█▄▀█ ▀██▄▀█▄ ▐█▓░  ▀ ■    ▐ ▒ ▌    ■ ▀  ░▓█▌ ▄█▀▄██▀ █▀▄█▀  █ █ █▀█
 █▀█ █ █ ▐▌▐██▐█▄ ▓██▐█▌██░   ░▌   ▄▀▐ ░ ▌▀▄   ▐░   ░██▐█▌██▓ ▄█▌██▌▐▌ █ █ █▀█
  ▀█ ▀████ ██▀████▐████▓▀   ▄▀▀▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄   ▀▓████▌████▀██ ████▀ █▀
   ▀█▄  ▀▀▀████▓▀▄█▓▀▀     ▐▌ ▀▓ ▌▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌     ▀▀▓█▄▀▓████▀▀▀  ▄█▀
      ▀ ▄▄    ▀▀▀▀▀▀▀   ▄▌  ▀▄▄▄▀ ▀▀▀▄ ▀ ▄▀▀▀ ▀▄▄▄▀  ▐▄   ▀████▀▀ ▄▄ ▄▄ ▀
          ▀▀█▄▄▄▄▄▄▄▄▄████▄    ▄  ██▌▐ █ ▌▐██  ▄    ▄████▄▀        ▀▄▄
                ▀▀▀▀▀▀▀▀██▓▓░░  ▄  ▀ ▐ ▓ ▌ ▀  ▄  ░░▓▓██▀▀▄ H7/BREAK ▄▀
                         ▄▀ ▄ ▀▄  ▓ ▄▐ ▒ ▌▄ ▓  ▄▀ ▄ ▀▄    ▀▐▄    ▄▌▀
                        ▐▌ ▌ ▐ ▐▌ ░  ▐ ░ ▌  ░ ▐▌ ▌ ▐ ▐▌
                         ▀▄ ▀ ▄▀▄▄   █ ░ █   ▄▄▀▄ ▀ ▄▀
                           ▀▀▀ █  █  █ ░ █  █  █ ▀▀▀
                                ▀▀  ▐▐ ░ ▌▌  ▀▀
                                    █▐ ░ ▌█
                                   ▀▄▐ ░ ▌▄▀
                                     ▐ ▒ ▌
                                     ▐ ▓ ▌
                                    ▄▀ ■ ▀▄
                                   ▐▌ ■░■ ▐▌
                                    ▀▄ ▀ ▄▀
                                      ▀░▀

Files