Excel – Datacrunch Academy

Know more about this course

This course will provide a comprehensive understanding of Microsoft Excel, covering everything from basic functions to advanced data analysis tools. It’s suitable for beginners as well as those looking to refine their Excel skills for professional use.

Course Content

Introduction to Excel

Understanding the Excel interface

00:00
Navigating worksheets and workbooks

00:00
Understanding the ribbon, toolbar, and basic commands

00:00

Basic Spreadsheet Operations

Basic Formulas and Functions

Data Management

Introduction to Charts and Graphs

Advanced Formulas and Functions

Data Analysis Tools

Advanced Charting Techniques

Data Cleaning and Preparation

Advanced Functions and Formulas

Data Analysis and Business Intelligence

Macros and VBA

Collaboration and Sharing

Excel for Financial Modeling

Excel for Data Science

Excel for Project Management

Hands-On Projects

Assessment and Certification

Student Ratings & Reviews

No Review Yet

Know more about this course

What will you learn in this course?

Course Content

Introduction to Excel

Understanding the Excel interface

Navigating worksheets and workbooks

Understanding the ribbon, toolbar, and basic commands

Basic Spreadsheet Operations

Creating, saving, and opening workbooks

Entering and editing data

Basic cell formatting (font, color, borders)

Using the fill handle and auto-fill features

Basic Formulas and Functions

Understanding formulas and cell references

Basic arithmetic operations (addition, subtraction, multiplication, division)

Introduction to common functions (SUM, AVERAGE, MIN, MAX)

Using AutoSum and other quick calculation tools

Data Management

Sorting and filtering data

Basic data validation techniques

Removing duplicates

Using find and replace

Introduction to Charts and Graphs

Creating simple charts (bar, column, pie)

Customizing chart elements (titles, labels, legends)

Understanding the different types of charts and their uses

Advanced Formulas and Functions

Understanding relative, absolute, and mixed cell references

Using logical functions (IF, AND, OR)

Working with text functions (LEFT, RIGHT, MID, CONCATENATE)

Introduction to lookup functions (VLOOKUP, HLOOKUP)

Data Analysis Tools

Using PivotTables to summarize and analyze data

Creating PivotCharts

Introduction to slicers and timelines

Using subtotals and grouping data

Advanced Charting Techniques

Creating and customizing advanced chart types (scatter, line, combo charts)

Using sparklines for data visualization

Conditional formatting for charts

Data Cleaning and Preparation

Using text-to-columns and Flash Fil

Advanced data validation techniques

Using the CLEAN and TRIM functions

Dealing with errors in formulas

Advanced Functions and Formulas

Mastering lookup functions (INDEX, MATCH, XLOOKUP)

Using array formulas and dynamic arrays

Advanced date and time functions

Using financial functions (NPV, IRR, PMT)

Data Analysis and Business Intelligence

Introduction to Power Query for data transformation

Using Power Pivot for data modeling

Creating and managing data relationships

Introduction to DAX (Data Analysis Expressions)

Macros and VBA

Recording and running macros

Introduction to VBA (Visual Basic for Applications)

Writing simple VBA scripts

Automating repetitive tasks with VBA

Collaboration and Sharing

Protecting and sharing workbooks

Using Excel online and co-authoring features

Integrating Excel with other Office applications (Word, PowerPoint)

Using OneDrive for business and collaboration

Excel for Financial Modeling

Building basic financial models

Sensitivity analysis

Scenario analysis and what-if analysi

Excel for Data Science

Introduction to statistical functions

Using Excel for data visualization

Introduction to Excel add-ins for data analysis (Solver, Analysis ToolPak)

Excel for Project Management

Creating Gantt charts

Tracking project progress

Resource allocation and management

Hands-On Projects

Real-world exercises and case studies

Group projects and collaborative exercises