Data Analysis with Excel Track - Online Learning with Certificate

Data Analysis with Excel

Beginner

5.0

1 reviews

16 Learners

This track guides beginners through the essential skills needed for data analysis using Microsoft Excel. You'll start by mastering the Excel interface…

118

Chapters

Learning hours

120

Assignments

AI Assistant

Shareable Certificate

Outcomes

Track content

Related courses and projects

Testimonials

Features

Pricing

Outcomes

Track content

Related courses and projects

Testimonials

Features

Pricing

What you will learn

Navigate and manage Excel workbooks and worksheets

Build and analyze data models using tables and pivot tables

Enter, organize, and structure data effectively

Clean and prepare data for accurate analysis

Apply formulas and functions for analysis and automation

Create clear and effective data visualizations in Excel

Learning track content

Course Overview

Excel Interface

Excel Cell Formatting

Text Formatting in Excel

Number Formatting in Excel

Formulas and Functions in Excel

Working with Excel Cell References

Working with Cell Ranges in Excel

Essential Excel Functions

Insert Function Tool in Excel

Displaying and Highlighting Excel Formulas

Mastering IF Logical Tests and Relational Operators in Excel

Using Nested IF Statements

Combining AND & OR in Excel

Auditing Excel Tools

Excel Conditional Formatting

Sorting Data in Excel

Filtering Data Using AutoFilter

Clearing and Reapplying Filters in Excel

Excel Rules and Advanced Search Techniques

Creating and Managing Tables in Excel

Excel Table Styles and Quick Formatting

Using Excel Table Tools

Excel Chart Types

Creating a Basic Chart in Excel

Customizing Excel Chart Elements

Changing Chart Styles and Colors in Excel

Adding and Removing Chart Elements

Editing Chart Data in Excel

Adding Trendlines to Excel Charts

Managing Excel Worksheets: Add, Delete, Rename, and Rearrange

Grouping and Ungrouping Worksheets in Excel

Using the Format Painter in Excel

Inserting and Deleting Columns, Rows, and Cells in Excel

Hiding and Unhiding Columns and Rows in Excel

Saving Workbooks in Excel

Opening and Closing Workbooks

Protecting Excel Workbooks with Passwords

Using Excel Templates

What Is Dirty Data?

Common Types of Data Issues in Excel

Working with Raw Imported Data

Removing Extra Spaces with TRIM

Removing Hidden Characters with CLEAN

Changing Text Case

Splitting Text with Text to Columns

Extracting Text with LEFT, RIGHT, MID

Using SUBSTITUTE for Dynamic Replacement

Converting Text to Numbers

Fixing Date Formats

Handling Currency and Decimal Issues

Dealing with Missing or Invalid Values

Finding and Removing Duplicates

Identifying Outliers and Errors

Using Conditional Formatting for Errors

Validating Data Consistency

Column and Bar Charts

Line Charts for Trends

Pie and Doughnut Charts

Scatter Plots and Basic Correlation

Combo Charts and Secondary Axes

Trendlines and Forecasting

Waterfall Charts

Professional Formatting and Design Standards

Charts Connected to Excel Tables

Slicers and Interactive Filtering

Dynamic Charts with Formulas

Sparklines and In-Cell Visualizations

Building the Sales Dataset

Creating a Relational Model

Creating Business Logic

Conditional Aggregation and First KPIs

Fixing Broken Models

Preparing Clean Data

Dynamic Arrays Introduction

Interactive Reports with FILTER

Ranking Performance

Advanced Sorting with SORTBY and LARGE

Structuring Unique Lists

Reshaping Data for Visualization

Connecting Tables with XLOOKUP

Expanding XLOOKUP for Real Use Cases

Solving Real Lookup Problems

INDEX, MATCH and XMATCH

Dynamic and Parameter-Driven Lookups

Expanding Models Automatically

Time-Based Analysis

Loan and Payment Modeling

Investment Analysis

Weighted Calculations and Conditional Logic

Building Scenario Logic

Sensitivity Analysis

Dynamic KPI Engine

Advanced Formula Combinations

Final System Output and Dashboard Logic

Course Overview

The Project Overview

Preparing Clean Tables for the Data Model

Designing Fact and Dimension Tables

Keys, IDs, and Surrogate Keys

Refactoring Flat Data into Relational Tables

Getting Started with Power Pivot

Loading Tables into the Data Model

Creating Relationships and Validating with PivotTables

Star Schema Patterns for Excel Users

Diagnosing and Fixing Relationship Problems

From Excel Formulas to DAX

Core DAX Measures for KPIs

Calculated Columns vs. Measures

Understanding Row and Filter Context

Intro to Time Intelligence

From Data Model to Reporting

Model-Based PivotCharts

Designing Question-First Dashboards

Refresh, Reuse, and Recurring Reporting

Model Review and Readiness

Building a Reusable Model Template

Capstone Project and Reflection

Boost your Tech Skills!

with up to 55% off

Features:

*Tracks not included in Pro plan

500+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks40+ hands-on real-world projects

Without cancellation, before the selected discounted intro plan ends, I accept that Codefinity will automatically charge $104 every 3 months until I cancel. Learn more about cancellation and refund policy in Subscription Terms.

Recommended Courses and Projects

Excel for Beginners

Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

Excel Formulas

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

Data Analysis with Excel

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Excel Adventure

Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.

Mastering Discounted Cash Flow Analysis with Excel

Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.

Excel Pivot Tables for Reporting and Dashboards

Master Excel Pivot Tables from the ground up. Learn how to prepare structured data, build powerful summaries, analyze results across multiple dimensions, and create interactive reports and dashboards using slicers, timelines, and Pivot Charts.

Excel Lookup Mastery

Master data retrieval in Excel using both classic and modern lookup techniques. Learn how to work with VLOOKUP, XLOOKUP, INDEX, XMATCH, and dynamic array functions to find, filter, and organize information efficiently. Build flexible lookup formulas used in real business spreadsheets.

Excel Charts and Data Visualization

Master column, line, pie, scatter, combo, and waterfall charts to communicate data clearly in Excel. Apply trendlines, secondary axes, Excel Tables, slicers, dynamic formula-driven ranges, and sparklines to build interactive visual reports.

Clean Data in Excel

Study how to clean, organize, and prepare data in Excel to ensure accuracy and reliability in your analysis. You'll understand why raw data is often messy and how improper formatting or errors can lead to incorrect results.

Excel Dynamic Arrays

Master Excel's dynamic array features through practical, column-based tasks. Learn to leverage spill behavior, core dynamic array functions, and advanced multi-step logic for efficient, modern spreadsheet solutions.

Excel Data Modeling

Learn how to turn raw Excel data into a connected data model with Power Pivot, DAX measures, and an interactive dashboard that updates automatically. Starting from a flat table, you will build relationships between multiple tables, write calculated metrics, and deliver a polished, reusable report — all inside Excel. Suitable for Excel users with basic experience who want to move beyond flat-sheet reporting.

Excel Productivity and Speed

Boost your efficiency in Excel with this course designed for business professionals. Learn essential techniques for navigating and selecting data, using Flash Fill and Paste Special, working with named ranges, streamlining formula workflows, and getting started with automation tools like macros and Power Query. All chapters focus on practical skills to help you work faster and smarter in Excel.

Discover more Learning Tracks

track

Essential Office Skills

Beginner

DevOps Specialist

Beginner

Supervised Learning Foundations

Beginner

Python from Zero to Hero

Beginner

C Programming Fundamentals

Beginner

Project Management Fundamentals

Beginner

Data Analyst with Python

Beginner

Java Foundations

Beginner

Data Visualization with Python

Intermediate

Frontend Development with Angular

Beginner

Machine Learning Engineer

Intermediate

Deep Learning Engineer

Advanced

Why People Choose Codefinity

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Step-by-Step to Stellar Results

Interactive coding environment

Jump into our interactive environment: write and run your code with real‑time feedback and success metrics—learn by doing at every step.

AI‑powered support

Leverage the built‑in AI assistant to explain errors, suggest fixes, or answer any question about your code—so you stay productive and never get stuck.

Check your progress

Wrap up each module with a quick quiz that delivers instant feedback, tracks your progress, and ensures you’ve mastered key concepts.

Promote your expertise

Earn your industry‑recognized certificate upon completion and share it on LinkedIn with one click—let your network see what you can do.

Trusted by Employees of Leading Companies
and Students from Top Universities

Full catalog access

One subscription opens up this course and our entire catalog of projects and skills.

Features:

500+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks40+ hands-on real-world projects

Try Codefinity with confidence – 30-day money-back guarantee included

To welcome you to Codefinity, we're offering up to 64% off on our courses. Plus, we have a 30-day money-back guarantee, so you can try us out risk-free.We truly look forward to welcoming you to our platform and are committed to making your learning experience easy, interactive, and fun.

Ready to get started?

Pro

Best intro offer

Ultimate

A complete experience
to kickstart your career

500+ Top-Rated courses

Completion certificates

Early access to new courses

40+ hands-on Real-world projects

Personalized study tracks

Unlimited workspaces

Instantly access 500+ courses

Unlimited Learning, Instant AccessGet full access to all courses and tracks, including video content, quizzes, and in-depth materials—start learning anytime.

Industry-Recognized CertificatesEarn certificates that validate your expertise and boost your career in tech, AI, data, marketing, and beyond.

AI-Assisted LearningGet personalized hints, real-time feedback, and AI-powered explanations to accelerate your progress.

Constantly Expanding: New Courses & Career TracksStay ahead with constantly updated courses, career roadmaps, challenges, and hands-on practice tests.

Build Skills That MatterMaster in-demand skills with courses in AI, data science, programming, marketing, automation, web development, and more.

Interactive & Seamless LearningEngage with hands-on projects, real-world exercises, and an intuitive learning experience — no extra tools needed.

What you will learn

Essential Office Skills

DevOps Specialist

Supervised Learning Foundations

Python from Zero to Hero

C Programming Fundamentals

Project Management Fundamentals

Data Analyst with Python

Java Foundations

Data Visualization with Python

Frontend Development with Angular

Machine Learning Engineer

Deep Learning Engineer

Why People Choose Codefinity

Trusted by Employees of Leading Companies and Students from Top Universities

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Instantly access 500+ courses

Trusted by Employees of Leading Companies
and Students from Top Universities