Big Data Analytics with Excel Training Video

Courses For Success

AU$ 189 - (Rs 9,221)

Important information

  • Course
  • Online
  • When:

Big Data Analytics with Excel Training Video A Practical Training Course That Teaches Real World Skills In this project-based Big Data Analytics with Excel video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course to get: Concise, informative and broadcast-quality Big Data Analytics with Excel training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Big Data Analytics with Excel subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Big Data Analytics with Excel tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 8.5 hours to complete this course 89 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description 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...

Important information

Requirements: System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...


Where and when

Starts Location

What you'll learn on the course

Basic IT training
Basic IT
3d training
MS Excel
Skills and Training

Course programme

  • 01. Introduction
    • Introducing Excel Big Data
    • About The Author
    • Using The Working Files
    • 0104 How To Access Your Working Files
  • 02. Basic Data Manipulation
    • Fixing Headers For Screen And Print
    • Sorting Data
    • Filtering Data
    • Add A Chart In A Second
  • 03. Data Cleansing
    • Starting Out The Cleaning Process
    • Removing Duplicate Records
    • Changing The Case
    • Replacing Text Method Part - 1
    • Replacing Text Method Part - 2
    • Removal Of Non Printing Characters And Spaces
    • Numbers Standardized On Import And Export
    • Dealing With Date And Time Issues
    • Merging And Splitting Data Columns
    • Rearranging Columns And Rows
    • Comparing Multiple Datasets
  • 04. Excel Tables
    • 0401 Creating A Table
    • 0402 Formatting Made Easy
    • 0403 Managing Rows And Columns
    • 0404 Sorting And Filtering Table Data
    • 0405 Using The Totals Row
    • 0406 Adding A Calculated Column
    • 0407 Adding Charts And Pivot Tables Using Table Data
    • 0408 Data Entry And Editing Through A Form
    • 0409 Filtering Using The Slicer
    • 0410 Advanced Filtering
    • 0411 External Data As A Table Source
  • 05. Pivot Tables
    • 0501 Introducing Pivot Tables
    • 0502 Recommended Pivot Tables
    • 0503 Use Named Ranges And Rename Column Headings
    • 0504 Change The Data Function And Format The Numbers
    • 0505 Moving And Or Removing A Pivot Table
    • 0506 The Report Filter Option
    • 0507 Sorting And Filtering By Pivot Table Columns
    • 0508 Refreshing A Pivot Table
    • 0509 Drilldown Behind Pivot Table Numbers
    • 0510 Using Pivot Table Styles
    • 0511 Use Of Multiple Fields In Rows And Columns
    • 0512 Grand And Sub Totals
    • 0513 Filtering Columns And Rows Within A Pivot Table
    • 0514 Exploring Additional Options
    • 0515 Using The Data Slicer
    • 0516 Connecting To A SQL Server Database
    • 0517 Using External Connection Files
  • 06. Charts
    • 0601 Creating And Using Charts
    • 0602 Using Trendlines
    • 0603 Dynamic Named Ranges
    • 0604 Creating A Forecast Sheet
    • 0605 Plotting On Two Axis
  • 07. Pivot Charts
    • 0701 Creating A Pivot Chart
    • 0702 Altering Chart Design And Location
    • 0703 Filtering And Hiding Elements
  • 08. Power Query
    • 0801 Introducing Get And Transform The New Power Query
    • 0802 Making The Most Of The Query Editor
    • 0803 Using The Query Editor To Group Or Combine
    • 0804 Using An Odata Feed And Merging Data
    • 0805 Using Google Sheets As Your Source Data
    • 0806 Connecting To Using And Combining Webpage Data
    • 0807 Connecting To And Using Data From Facebook
    • 0808 SQL Server Data Connections
    • 0809 Get And Transform Data From Multiple Files In A Folder
  • 09. Power Map
    • 0901 Activating And Creating Your First 3D Power Map
    • 0902 A Simple Map Alternative To 3D Power Map
    • 0903 Tours Scenes And Layers
    • 0904 Create A Tour And Customize A Layer
    • 0905 Displaying Additional Data With Additional Layers
    • 0906 Adding And Animating Scenes
    • 0907 Filtering Data Within A Layer And Scene
    • 0908 Customization Options
    • 0909 Exporting Images And Videos Of Your 3D Map Tour
  • 10. Power Pivot
    • 1001 Introducing Power Pivots
    • 1002 Importing Data And Adding Additional Data To The Data Model
    • 1003 Adding Tables To The Data Model And Creating Relationships
    • 1004 Powerpivot Pivotstables And Pivotcharts
    • 1005 Adding Calculated Fields To Your Data Model
    • 1006 Measures And KPIs In Your Powerpivot
  • 11. Goal Seek And Solver
    • 1101 Use Goal Seek To Carry Out What If Analysis
    • 1102 Installing And Uninstalling Solver
    • 1103 Use Solver To Carry Out What If Analysis
    • 1104 Using Scenarios
    • 1105 Adding Constraints To Solver
  • 12. Data Analysis Tools
    • 1201 Introducing The Analysis Toolpack
    • 1202 Calculating And Graphing The Moving Average
    • 1203 Creating A Histogram With A Bell Curve
  • 13. The End
    • 1301 Sharing Your Big Data
    • 1302 Resume

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...