Udemy - Microsoft Excel Masterclass - Learn Excel Step by Step
Microsoft Excel Masterclass: Learn Excel Step by Step
https://WebToolTip.com
Published 10/2025
Created by Logic Labs
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 28 Lectures ( 2h 45m ) | Size: 1.4 GB
Master Excel from the basics to advanced tools — learn formulas, functions, charts, and data analysis step by step.
What you'll learn
Overview of Excel's Interface
Understanding Ribbons, Tabs, and Menus
Navigating Excel
Using Cells, Rows, and Columns
Understanding The Excel Grid System
Entering and Editing Data
Copying, Cutting, and Pasting Data
Font Styles, Colors, and Cell Alignment
Applying Borders and Shading
Performing Basic Calculations (SUM, AVERAGE)
Using AutoFill and Flash Fill
Sorting and Filtering Data
Grouping and Ungrouping Worksheets
Logical Functions (IF, AND, OR)
Lookup and Reference Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Working With TODAY, NOW, and DATE Functions
Using LEFT, RIGHT, MID, CONCAT, and TEXT
Visualizing Data with Pivot Charts
Creating Dropdown Lists
Using Goal Seek, Data Tables, and Scenario Manager
Column, Line, and Pie Charts
Customizing Chart Elements and more
Requirements
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed