Big Data Analytics with Excel
Import, Link, Clean, Manipulate, and Analyze Large Sets of Data
By Guy Vaccaro
Publisher: O'Reilly Media
Final Release Date: March 2016
Run time: 8 hours 36 minutes

In this Big Data Analytics with Excel training course, expert author Guy Vaccaro teaches you how to manage large quantities of data with Excel. This course is designed for users that are already familiar with Excel and how to navigate a workbook and manage worksheets.

You will start by learning basic data manipulation, then jump into learning about data cleansing, including removing duplicate records, replacing text, and merging and splitting data columns. From there, Guy will teach you about Excel tables, pivot tables, charts, and pivot charts. This video tutorial also covers Power Query, Power Map, and Power Pivot. Finally, you will learn how to use Goal Seek and Solver, as well as learn about data analysis tools.

Once you have completed this computer based training course, you will have learned everything you need to know to effectively manage large quantities of data with Excel. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents
Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyBig Data Analytics with Excel
 
5.0

(based on 2 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 2 customers

Displaying reviews 1-2

Back to top

 
5.0

Again excellent work from Guy - Master of Excel

By Ruben

from China

About Me Developer, Sys Admin

Verified Buyer

Pros

  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Intermediate
    • Novice
    • Student

    Comments about oreilly Big Data Analytics with Excel:

    Hi

    This is the fourth video training I enjoyed from this author. I saw another two about Excel and one about Project.

    He explains in an ideal speed with realistic examples.
    No lessons in which I felt too difficult or not understandable. - I am a German nerd and English is just my second language. The words he used are in daily vocabulary.

    His video courses are ideal as lessons are small 4 to 8 minutes and easy to digest. After lunch, in the bus or wherever or you have a little time slot you can see and learn.

    By this trainings you learn the basics and a bit beyond. In short time you can built a strong fundamental to continue yourself.

    He uses the latest Excel version, but wit Excel 2010 and free plugin you can do exactly the same as far I can judge after seeing half of this course.

    I only can recommend this to you!

    Kind regards

    Ruben

    (1 of 1 customers found this review helpful)

     
    5.0

    Good Video

    By Jeweler

    from Denver, Colorado

    About Me Developer

    Verified Buyer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples

    Cons

      Best Uses

      • Intermediate

      Comments about oreilly Big Data Analytics with Excel:

      Good Video course

      Displaying reviews 1-2

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Video:  $119.99
      (Streaming, Downloadable)