Advance Excel
Course Content
Introduction to MS Excel
-
Intro
00:00
Basics and Shortcuts
Understanding Cell References Intro
Understanding Cell References
Basic Functions of Excel Intro
Text to column and Flash fill
Name Ranges in Excel
Protection in Excel
Sorting and Filtering
Basics of Formula
Logical Formula
Date and Time Formula
Countlifs, and Sumlfs
Lookup Functions
Conditional formatting
Data Validation
Dynamic Array
Tables
Pivot Table
Slicer
Power Query
Power Pivot
Visualization
Student Ratings & Reviews
No Review Yet