Data analytics involves inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, drawing conclusions, and supporting decision-making.
Curriculum
ADVANCED EXCEL
Module 1: Getting to Know Excel
The Ribbon
The Work Surface
Navigation
Formatting
Module 2: – Essential Formula Knowledge - I
Formula Anatomy
Cell Referencing
Function Anatomy
Module 3: Essentials Formula Knowledge - II
Logic Functions
Conditional Math
Temporal Function(EOMONTH)
Function Anatomy
Module 4: Functions
Math Functions
Text Functions
Understanding Dates
Understanding Time
Module 5: - Search Functions
VLOOKUP
Other Lookup Method (Index & Match )
HLOOKUP
Module 6: Optimizing Data
Sorting
Filtering
Naming Ranges
Module 7: Data Analysis
Creating PivotTables
Formatting PivotTables
Calculated Fields in PivotTables
Module 8: Getting and Transforming Data
Importing Data from a Text File
Contiguous Data
Module 9: Presenting and Reporting with Formats
Conditional Formats with Built-In Rules
Cell Formatting
Conditional Formats with Custom Rules
Module 10: – Presenting and Reporting with Charts
Building Column Charts
Building Bar Chart
Building Pie Charts
Building Line Charts
Module 11: Validating and Updating
Data Validation
Comments & Notes
Apply built-in number styles
VBA
Module 1: Introduction To VBA
Introduction to Excel
Introduction to Programming
VBA Syntax And Grammar
Introduction to Cloud Compu
Quick Review of Macros
Working with Macros
How to use Visual Basic Editor
Module 2: Understanding VBA Editor
The Visual Basic Editor
Parts of the VBA Editor
About VBA Forms, Sub Procedures & Modules
Creating Forms
Using Controls and their Properties
Running VBA Forms in Excel
Module 3: VBA Syntax And Grammar
Objects – The Grammar
Using Properties and Methods
Understanding Parameters
The Object Browser
Understanding object hierarchy
Editing Specific Cells
Module 4: Storing Data In Variables
How and when to declare variables
Selecting data types
Fixed and dynamic arrays
Constants
Module 5: Control Structure And Program Flow
IF (Else If, Else)
Select Case()
For Next Loop
Do Until Loop and Do While Loop
Module 6: Building Procedure
Creating Sub procedures
Calling procedures
Passing arguments to procedures
Module 7: Building Intuitive Interface
Communicating with the user through the message box
Gathering user information with the input box
Module 8: Creating Customized Dialogs with User Forms
Command buttons
List and Combo boxes
Labels
Option buttons
Module 9: Functions
Using Excel Worksheet Functions in VBA
User-Defined Functions
Adding Help to User Defined Functions
Module 10: Error Handling
Run Time Error
GoTo line
Resume Next
TABLEAU
Module 1: - Introduction To Tableau
Why Data Visualization?
What is Tableau
Uses of Tableau
Tableau Installation
Saving and sharing your work
Module 2: Tableau Data Connections
Data Connections in the Tableau Interface
Types of Join
When to Use Joining
Creating Data Extracts in Tableau
What is Data Blending
When to Use Data Blending
Joining vs. Blending
Module 3: Organizing and Simplifying Data
Creating Filters
Customizing Filters
Sorting of Data
Using Parameters
Fixed Sized Bins
Formatting and Annotations
Applying Filters
Working with Sets
Creating Parameters
Tableau Bins
Module 4: – Data Visualization I
Bar Charts
Horizontal bar charts
Stacked bar charts
Side-by-Side bar chart
Text tables
Heat maps
Symbol maps
Filled Maps
Pie Charts
Tree maps
Area Charts
Scatter Plots
Histogram
Module 5: – Data Visualization II
Using Pareto Charts
Using Waterfall Charts
Using Gantt Charts
Using Box Plots
Module 6: Calculations
Working with string functions
Working with number functions
Working with Quick Table Calculations
Logic and Conditional Calculations
Working with Dates and Times
Working with aggregate options
Working with date functions
Conditional Filters
Module 7: Formatting
Introduction to Formatting
Options in Formatting Visualizations
Working with Labels and Annotations
Effective Use of Titles and Captions
Introduction to Visual Best Practices
Module 8: Mapping
Importing and Modifying Custom Geocoding
Working with Symbol Map and Filled Map
Module 9: Stories and Dashboards
Using Storytelling
Creating your first dashboard and Story
Adding interactivity to your Dashboard
Using Dashboard Actions
Use of Running Actions
Module 10: Working with Tableau Public Portal
Publishing to Tableau Public – Overview of publishing