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