

Excel and Big Data
- Offered byXLNC
Excel and Big Data at XLNC Overview
Duration | 6 months |
Total fee | ₹4,999 |
Mode of learning | Online |
Official Website | Go to Website |
Credential | Certificate |
Excel and Big Data at XLNC Highlights
- Earn a certificate after completion of course from XLNC
Excel and Big Data at XLNC Course details
For Software Developers and Architects
For Analytics Professionals
For Data Management Professionals
For Business Intelligence Professionals
For Project Managers
For Aspiring Data Scientists
For Anyone with a genuine interest in Big Data Analytics
For Graduates looking to build a career in Big Data Analytics
Introduction to Big Data Concepts
Techniques for importing and exporting large datasets into and from Excel
Creating interactive dashboards and reports using PivotTables, charts, and Power BI integration
Introduction to macros and VBA programming for automating repetitive tasks
The Excel and Big Data course is designed to equip professionals with the skills necessary to leverage Microsoft Excel for analyzing, manipulating, and visualizing big data
As big data continues to grow in importance across industries, proficiency in using Excel to handle large datasets has become a critical skill
This course covers key concepts in working with large-scale data within Excel and introduces techniques for processing, analyzing, and deriving insights from big data using advanced Excel tools, as well as integrating Excel with external data sources and technologies
Excel and Big Data at XLNC Curriculum
Introduction
Work Files
What is Big Data
Working with Large files
Connecting to the Web
Databases and Text Files
The Connections Dialog Box
File Size Connections
Reviewing the Basics
Tables
Filters and Sort
Filtering Tables with Slicers
Subtotal Troubleshooting
Subtotal Tricks
Patterns and Sparklines
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
R 1C1 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
Dashboards
Power of the Dashboard
Templates
Creating Dashboards
Business Intelligence