Microsoft Excel Course for Beginners : Key Skills in 2 Hours

Name: Microsoft Excel Course for Beginners : Key Skills in 2 Hours
Rating: 4.4 (88 reviews)

Free Excel Course : Learn Excel Formulas, Logicals, VLOOKUP, Charting, Pivot Tables and Pivot Charts, Sort and Filter

Created byRanjit Kate

Last updated 2/2026

English

English [Auto],

What you'll learn

Efficient Data Preparation – Learn to organize, clean, and structure Excel data using tables, remove duplicates, and text functions for accurate analysis.
Master Key Formulas – Gain proficiency in essential formulas like VLOOKUP, XLOOKUP, IF, SUMIF, CONCAT, TEXT, and DATE functions to automate calculations.
PivotTables & Data Analysis – Build dynamic PivotTables, apply sorting, filtering, and conditional formatting to summarize and extract insights from large data
Apply Formulas Practically – Use nested, logical, and lookup formulas in real-world business, finance, or operational scenarios.
Boost Productivity – Implement Excel tips, keyboard shortcuts, Flash Fill, and Quick Analysis tools to save time and work efficiently.
Develop Core Excel Skills – Build confidence with cell referencing, named ranges, and formula auditing to ensure accurate and professional-level Excel work.

Course content

5 sections • 17 lectures • 1h 55m total length

Download All Courses Resources0:31
Download all course resources by clicking the resource button to download the course files required for this complete course.
Navigation and Selection Keyboard Shortcuts & Download Resources8:07
Master Excel navigation and selection shortcuts to work faster. Move with arrow keys, jump to edges with Ctrl End and Ctrl Home, and extend selections using Shift and Ctrl.
Functions in Excel3:59
Explore Excel functions, predefined formulas that simplify calculations like sum and average, and learn syntax for range inputs. Discover aggregation, logical, date and time, and database functions.
Mathematical Functions in Excel10:17
Explore essential Excel math functions such as sum, average, max, min, count, and rounding with round, round up, and round down, using ranges and cell references.
Logical Functions in Excel11:08
Explore logical functions in Excel, including booleans that return true or false, build if, and, or formulas, and use count if to evaluate credit period and balance in sales data.
Navigation ,Selection Shortcuts and Excel Functions
Relative, Absolute and Mixed Referencing in Excel9:29
Learn relative, absolute, and mixed referencing in Excel. Discover how formulas adjust with autofill, dollar signs, and practical examples.
SUM IF and COUNT IF7:22
Use sumif and countif to sum and count values based on criteria in Excel. Apply to invoices per customer, using criteria like advertising or city names.
Referencing and logical functions in Excel

Introduction to Excel Charts. Pie Chart & Download Resources8:27
Learn to visualize expense data in Excel by creating a pie chart for April, adding percentage data labels, and styling charts to support budget and actual comparisons in expense reports.
Column Chart3:58
Learn how to create a 2D clustered column chart in Excel to compare expense categories and show percentage changes, including adding data labels and axis titles.
Excel Charts

Creating and Using Named ranges & Download Resources7:19
Define and use named ranges in Excel via the name manager, such as inventory_list and go_down, to improve formula readability and avoid switching worksheets.
VLOOK UP to Search for a Value in Column6:36
Learn how to use VLOOKUP to search a value in a column and fetch matching data from inventory and go down data, with exact-match syntax and column indices.
Look Up Functions and Named Ranges In Excel

Sorting and Custom Sort & Download Resources4:38
Master sorting in Excel by text, numbers, color, and formatting, then perform custom sorts using lists to order departments and gender, creating multi-level, easy-to-read data.
Filtering Data and Using Advanced Filters for complex criteria11:33
Learn how to apply Excel filters, including inbuilt and advanced filters, to text, numbers, and formatting; filter complex criteria and copy results reliably.
Sorting and Filtering Data

Learning Pivot Tables & Download Resources9:01
Master pivot tables to group and summarize large data, compare sales by product and region, and apply sums, averages, counts, max and min aggregations.
Value Field Settings in Pivot Tables5:03
Learn how to use value field settings in pivot tables to apply count and average aggregations, format numbers, and refresh with new data.
Pivot Chart & Slicer7:20
Create pivot charts from pivot tables or source data, and customize with bar or pie charts. Use slicers to filter across multiple pivot tables for dashboard-style insights.
Pivot Tables and Pivot Charts
Congratulations on course completion0:48
Master essential Excel concepts and responsibly use AI tools, such as Copilot, to unlock AI features and boost your career after completing the course.

Requirements

No prior knowledge of formulas, functions, or PivotTables is required.
Excel 2016 or later (Microsoft 365 recommended) installed on your Windows or Mac computer.
Willingness to practice along with the course exercises for best results.

Description

Microsoft Excel Course for Beginners : Key Skills in 2 Hours

This course is designed to help you master all essential Excel functionalities quickly, focusing on formulas, functions, PivotTables, and core Excel tools—all in just 2 hours. Whether you are a student, professional, or Excel user, this course will equip you with practical skills to work faster, smarter, and more efficiently.

What you’ll learn:

Data Cleaning & Preparation (Tables, Text Functions)
- Learn to organize worksheets, remove errors, and structure data for smooth analysis. Efficient data preparation ensures accuracy and saves time when working with large datasets.
Key Formulas & Functions (VLOOKUP, IF, SUMIF, CONCAT, TEXT, DATE functions)
- Automate calculations, perform conditional analysis, and manage data effectively. Gain hands-on experience with formulas that are widely used in business, finance, and analytics.
Data Analysis & Manipulation (PivotTables, Sort, Filter, Tables)
- Summarize and explore data using PivotTables, apply filters and conditional formatting to highlight trends, and convert raw data into actionable insights.
Practical Application (Nested Formulas, Logical & Lookup Combinations)
- Apply formulas and PivotTables in real-world scenarios, such as financial reporting, sales analysis, and operational dashboards, to solve practical problems efficiently.
Productivity Enhancements (Keyboard Shortcuts, Quick Analysis)
- Save time and reduce repetitive work using Excel tips and shortcuts, improving efficiency when handling large datasets or complex calculations.
Core Skill Confidence (Cell Referencing, Named Ranges, Formula Auditing)
- Build a strong foundation for Excel, understand formula dependencies, and audit calculations to ensure accuracy and reliability.

Who this course is for:

Anyone looking to quickly level up their Excel skills.
Professionals in finance, analytics, operations, or reporting who want to boost productivity.

By the end of the course, you’ll have job-ready Excel skills, including formulas, PivotTables, and essential data tools, ready to apply immediately in any professional setting.

Who this course is for:

Anyone who wants to quickly master essential Excel skills in a short time.
Students, professionals, or job seekers looking to improve Excel proficiency for business, finance, or data tasks.
Analysts, operations staff, and office professionals who want to work faster, smarter, and more efficiently in Excel.
Beginners with no prior Excel experience as well as intermediate users who want a quick skills refresher.
Anyone aiming to automate calculations, analyze data, and use PivotTables confidently.

Microsoft Excel Course for Beginners : Key Skills in 2 Hours

What you'll learn

Explore related topics

Course content

Getting started with Excel and Download Course Resources7 lectures • 51min

Charting in Excel2 lectures • 12min

Look Up, Reference Functions and Named Ranges In Excel2 lectures • 14min

Sorting and Filtering Data2 lectures • 16min

Pivot Tables and Pivot Charts4 lectures • 22min

Requirements

Description

Who this course is for: