MS Excel Basic to Intermediate Free Course
About Course
MS Excel Basic Course is designed to help you get started with Microsoft Excel by covering key features and essential functions, from basic operations to customization for improved efficiency. By the end of this course, you will have gained advanced knowledge of Pivot Tables, allowing you to summarize and analyze data more effectively. You will also be equipped to create dynamic reports, dashboards and apply advanced Excel formulas. The session will be wrapped up with a comprehensive quiz and final exam to test your mastery of the content.
Course Content
Class 01- Excel Interface Overview
-
Class 01- Excel Interface Overview
05:58
Class 02 Basic Arithmatic Furmulas
Class- 03 Reference
Class- 04 Sort by Column & Row
Class-05 Conditional Formatting
Class-06 Data Validation
Class-07 Text to Columns, Flash Fill & Remove Duplicate
Class-08 Chart
Class-09 DATE Function
Class-10 SUMIF, AVERAGRIF & COUNTIF
Class-11 IF Function
Class-12 Clean and Trim Function
Class-13 Lookup & Reference Function 01
Class-14 Lookup & Reference Function 02
Class-15 Vlookup with Choose Function
Class-16 How to Import JSON File
Class-17 What If Analysis
Class-18 Without Password Recover Your Protect Sheet
Class-19 Enigma Machine in Excel 1
Conclusion with Bonus and Quiz
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet