XLNC
XLNC Logo

Excel and Big Data 

  • Offered byXLNC

Excel and Big Data
 at 
XLNC 
Overview

This course will allow you to unleash the power of Excel to make accurate decisions based on students data and Excel's power

Duration

6 months

Total fee

4,999

Mode of learning

Online

Official Website

Go to Website External Link Icon

Credential

Certificate

Excel and Big Data
Table of content
Accordion Icon V3
  • Overview
  • Highlights
  • Course Details
  • Curriculum

Excel and Big Data
 at 
XLNC 
Highlights

  • Earn a certificate after completion of course from XLNC
Details Icon

Excel and Big Data
 at 
XLNC 
Course details

Skills you will learn
Who should do this course?

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

What are the course deliverables?

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

More about this course

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

Other courses offered by XLNC

1.5 K
6 months
– / –
1.5 K
6 months
– / –
1.5 K
6 months
– / –
2 K
6 months
– / –
View Other 67 CoursesRight Arrow Icon
qna

Excel and Big Data
 at 
XLNC 

Student Forum

chatAnything you would want to ask experts?
Write here...