Advanced Excel Data Analysis

About this Course

Excel is considered one of the most common programs in the world of data. Its friendliness and convenience make the data analysis process simple and easy for the novice user. And at the same time – Excel is a very powerful and sophisticated tool for the experienced user.

This course teaches in depth the use of complex functions and formulas, through which dynamic and powerful data analysis can be performed.

Audience

Various units in the organization that wish to deepen their Excel knowledge and use it for advanced data analysis.

Prerequisites

Previous background and experience in Excel

Module 1 – Conditional Statements

Simple Conditional Statements (If Statements)
Combining (Nesting) Multiple If Statements
Integrating And and Or Statements
Using The Not (Or <>) Clause
Using Excel’s IFERROR Statement
IS Statements

Module 2 – Statistical Functions

Basic Excel Statistical Functions
Using SMALL,LARGE,RANK/PERCENTRANK
Generating Random Values
Applying A Row-Level Calculations
Conditional Stats Functions

Module 3 –Reference & Lookup Functions

Using Named Ranges To Simplify Excel Formulas
Introducing ROW,ROWS,COLUMN,and COLUMNS Functions
Using VLOOKUP/HLOOKUP
Error Handling With IFERROR & VLOOKUP
VLOOKUP Array Options
Approximate Match Lookups
Navigating Cell Ranges
Matching Values
Defining Ranges With OFFSET

Module 4 – Text Functions

Common Text Functions
Concatenating Text
Extracting Sub-Texts
Converting Text To Values
Using The Search and Find Functions
Categorizing Data
Replacing Text

Module 5 - Date Functions

Formatting Dates
Automatically Generate Lists Of Dates
Extracting Time Periods
Defining Time Periods
Calculating Differences Between Dates

Module 6 - Formula-Based Functions

Managing Formula-Based Functions
Highlighting Rows
Formatting Rules Based On Another Cell
Apply Formats Based On Statistical Operations
Apply Formats Based On Logical Operator

Module 7 - Dynamic Array Formulas

Introduction To Excel’s Dynamic Array
Common Dynamic Array Functions

Module 8 - Pivot Table Deep Dive

Formatting Data With Pivot Table
Filtering, Sorting & Aggregating Data Using Pivot Table
Calculated Fields And Values
Visualizing Data With Excel Pivot Charts

Contact Us

Latest courses

About Us

UpScale Analytics specializes in training solutions for organizations and individuals in the fields of data.

UpScale Analytics is also one of the largest platforms in the world for learning SQL by doing.

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links

Upscale Analytics 2022 © All Rights Reserved