Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Excel Crash Course : From Beginner to Advanced
Rating: 4.4 out of 5(152 ratings)
1,327 students

MS Excel Crash Course : From Beginner to Advanced

Master data analysis & automation with Excel formulas, PivotTables, charts, data validation, and advanced functions.
Created byAkshatha Jain
Last updated 7/2025
English

What you'll learn

  • Master Excel from basics to advanced, including formulas, charts, pivot tables, and data analysis techniques.
  • Automate tasks using advanced Excel functions like VLOOKUP, INDEX-MATCH, IF statements, and dynamic ranges.
  • Create professional dashboards and reports using charts, slicers, conditional formatting, and data visualization tools.
  • Solve real-world business problems with Excel by applying analytical thinking, data cleaning, and productivity hacks.

Course content

3 sections • 15 lectures • 1h 27m total length

  • Getting Started with Excel7:08

    Lecture 1. Getting Started with Excel

    Learning Objectives

    1. How to start Microsoft Excel (3 easy methods)

    2. Understanding key terms: Workbook, Worksheet, Cells, Rows & Columns

    3. What is the Ribbon and its Tabs

  • Workbooks & Worksheets in Excel: Create, Save & Manage Files Efficiently6:27

    Lecture 2. Workbooks & Worksheets in Excel: Create, Save & Manage Files Efficiently

    Learning Objectives

    1. Create a new workbook and add, rename, move, or delete worksheets.

    2. Save Excel files in different formats (e.g., .xlsx, .xls, .pdf).

    3. Use Save and Save As options effectively to manage versions.

  • Excel Basics: Entering Data, Formatting & Using Simple Formulas8:33

    Lecture 3: Excel Basics: Entering Data, Formatting & Using Simple Formulas

    Learning Objectives

    1. Entering and editing data:

      • Work with text, numbers, and perform basic formatting.

    2. Apply basic formatting:

      • Change font styles, modify cell colors, add borders, adjust alignment.

    3. Basic formulas and functions:

      • Utilize formulas such as SUM, AVERAGE, MIN, and MAX.

  • Basic data organization: sorting, filtering, and using tables4:38

    Lecture 4: Basic data organization: sorting, filtering, and using tables

    Learning Objectives

    1. Learn about sort and filter.

    2. Sort and filter data to quickly find relevant information.

    3. How to remove duplicate values in Excel.

  • Working with Charts: Creating and Customizing Bar, Line, Pie, and Other Charts6:18

    Lecture 5: Working with Charts: Creating and Customizing Bar, Line, Pie, and Other Chart Types

    Learning Objectives

    1. Why charts are used for visualizing data trends and comparisons.

    2. Insert basic chart types in Excel.

    3. Add and modify key chart components.

  • Adjusting the Width & Height of Cells in Excel4:34

    Lecture 6: Adjusting the Width & Height of Cells in Excel

    Learning Objectives

    1. Understand the difference between column width and row height in Excel.

    2. Manually adjust the width of columns and height of rows.

    3. Set specific measurements for uniform cell size across rows or columns.

Requirements

  • No prior experience needed! Just a computer with MS Excel installed and a willingness to learn. Perfect for beginners to advanced learners alike.

Description

This comprehensive Excel course is designed to equip learners with essential spreadsheet skills for both personal productivity and professional data handling. The course begins by introducing the Excel interface, including how to open the application in multiple ways, and understanding foundational elements such as workbooks, worksheets, cells, rows, and columns. Learners also explore the Ribbon and its tabs—essential tools for accessing Excel’s features.

Building upon the basics, students learn how to efficiently create, organize, and manage Excel files, including saving work in formats like .xlsx and .pdf. They also gain proficiency in data entry, formatting text and numbers, and applying fundamental formulas like SUM, AVERAGE, MIN, and MAX for quick calculations.

The course then dives into organizing data using sorting, filtering, and table tools, along with techniques to remove duplicate entries for clean analysis. Learners work with PivotTables and PivotCharts to summarize large datasets and visualize trends effectively.

Data validation techniques help in setting input rules and creating drop-down lists to ensure consistency. Formatting skills are expanded with conditional formatting, custom number formats, and style applications.

The course also covers chart creation, logical functions like IF and IF+AND, and advanced data retrieval using XLOOKUP. Students learn to adjust column widths and row heights for better readability and build dynamic dropdowns that respond to changes.

Text functions such as LEFT, RIGHT, and MID are introduced to extract and clean data efficiently. Finally, learners enhance presentation and consistency by applying and customizing cell styles.

By the end, participants will confidently navigate Excel, utilize powerful functions, and build streamlined, professional spreadsheets.

Who this course is for:

  • This course is for students, professionals, and entrepreneurs who want to master MS Excel from basics to advanced level for data, analysis, or business use.

Report abuse