Master Microsoft Excel from the Ground Up – Learn Formulas, Functions, Pivot Tables, Data Analysis, Automation, & More!
What you will learn
Get Instant Notification of New Courses on our Telegram channel.
Note➛ Make sure your 𝐔𝐝𝐞𝐦𝐲 cart has only this course you're going to enroll it now, Remove all other courses from the 𝐔𝐝𝐞𝐦𝐲 cart before Enrolling!
Basic Excel Interface: Navigating the Ribbon and Workbooks
Basic Arithmetic Operations: Addition, Subtraction, Multiplication, Division
Understanding Cell References: Relative, Absolute, and Mixed
Statistical Functions: (AVERAGE, SUM, COUNT, EOUND, MAX, MIN)
Sorting and Filtering Data
Using VLOOKUP and HLOOKUP Functions
Conditional Formatting: Highlight Cell Rules, Data Bars, Color Scales
Creating Basic Charts: Line, Bar, Pie, and Scatter Plots
Power Pivot: Data Modeling and Analysis
Macro Recording and VBA Basics
Data Validation and Error Handling
Create a daily sales report with deshboard
English
language