30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Microsoft Excel and Big Data Tutorial

A professionally created, self-study video training course
Includes 7 hours of easy to follow Microsoft Excel and Big Data video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Excel and Big Data tutorial videos by clicking a blue link below:
  • Tutor: Lauri Sowa
  • Duration: 7 hours
  • Video lessons: 92
  • Product code: 34852
  • In stock: YES
Learn exactly how to unearth the potential of MS Excel to make informed and accurate decisions based on your own data with the help of these beginners Microsoft Excel and Big Data tutorial videos.

Commencing with the basics, expert trainer Lauri Sowa uses step by step training videos to help explain and demonstrate how you can use Microsoft Excel to analyze, extract and clean the large amounts of data you have collected.

Throughout the course, the exact same Excel files that the trainer demonstrates on are also included in the course allowing you to work in parallel with his on-screen instruction and accelerate the learning process.

The complete course comprises of almost 7 hours of high quality training videos and starts with a description of what Big Data is and reviewing the basics such as tables, subtotal tricks and filters and sort.
Once the basics have been covered, Lauri moves onto using Pivot tables in Excel including data extraction and creation, formulas and pivot charts.
You will also learn about automation and coding, speed and file size limitations, and learning how to clean your data and data manipulation.
Towards the conclusion, Lauri covers Macros in depth and VBA and custom functions.

The complete training course contents are listed below and you can start your Excel and Big Data education right away. Click any blue linked lesson to sample FREE Excel and Big Data video tutorials and discover how effective this visual teaching method is...
What Our Customers Are Saying

"I received my Civil 3d training cd today and I wanted to send a thank you email. I am very pleased with your service. I also have the Revit Architecture training cd. I first ordered this as a download, and upon having difficulty I was very pleased with your prompt fix to the problem by sending the cd instead of using the download program. Again I thank you and look forward to future business with you."Brett Carmer, Indiana
COMPLETE COURSE CONTENTS
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via Download.
Paid Content
Section

Get all lessons with purchase
Pivot Tables
Data Extraction and Creation
Calculations and Summarization
Formulas
Slicers and Filters
Pivot Charts and Menu Formats

PowerPivot
Introduction to PowerPivot
Relationships
Adding Data
PowerPivot KPI
Installing PowerPivot
Option Add Ins

Working with PowerPivot DAX
DAX Overview
Basic Syntax
Dax in the Pivot Table

Dynamic Charting
Review of Charting Features
Dialog Boxes
Intro to Dynamic Charts
Using the Offset Command
Dynamic Chart Continued

Interpreting and Summarizing Data
Conditional Formatting and IF
Use IF and Formulas
The AND operator and IF
Using a List with a VLOOKUP
VLOOKUP
VLOOKUP with Approximate
VLOOKUP with IF

Matching Functions
Create a Table of Contents
Finding Duplicates
MATCH
INDEX
MATCH and INDEX together

Functions for Manipulating Text
String Extractions
Case Functions and CONCATENATE
REPLACE and SUBSTITUTE

Data Cleaning
Cleaning Empty Cells
Cleaning continued
Text to Column
ISERROR Function

Arrays
About Arrays
Creating
Including IF Statements
Array Exercises from the Help Menu

Macros
Getting Started with Macros
Enhancing Usage and Automation
Absolute vs Relative
Viewing the Macro in VBA
Invoking macros with Form controls
Forms continued
Option Buttons
Security
R1C1 Reference

VBA
The VBA Window
Simple Code and WorkFiles
Creating a Form
Creating a Form Continued
Adding Code
Fine tuning the Spreadsheet Form

Custom Functions
Understanding Custom Functions
Creating a Function
Properties
Adding Descriptions

Auditing and Other Features
Tools for Formulas
Tracing calculations
Tracing calculations continued
Watches and Formula Bar

Analysis Tools
Toolpak
Goal seek
Solver
Add Ons
Remembering the User

Scenarios
The Power of Scenarios
Using Named Ranges
Creating a Scenario
Scenario Summary

Dashboards
Power of the Dashboard
Templates
Creating Dashboards
Business Intelligence

About the Tutor
Wrap Up
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
PRICE
CURRENCY
   
Item(s):
Once purchased, you will receive 92 Microsoft Excel and Big Data training videos (listed left), lasting a total of 7 hours and the working files.

Worldwide
Shipping
Delivery Details
Download Course downloadable when payment processed (within one hour average)
WE AIM TO PLEASE
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
|
Need to Train Multiple Users?
This Microsoft Excel and Big Data course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system


USING THE SAME EXCELLENT CONTENT AS SINGLE USER COURSES
For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Excel and Big Data course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

EASILY VIEWED OVER A NETWORK
The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

ADDITIONAL USERS AND TITLES CAN BE ADDED
More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
See our complete range of Microsoft Excel Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Excel and Big Data. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"It was nice speaking with you last week. I received the training software and have already used it for a few hours. I'm very happy with it, very good instructor, superior quality product. Regards."Mike Evans, California