MS Excel - Zero to Hero - For Beginners
CA Alok Sethi
3 modules
English
Lifetime access
<p>Customised course for Beginners to enable them to get familiar with the functions and formulas of MS Excel and to get an insight into how to use Excel for getting productive results at work !</p>
Overview
In this beginner-friendly course, you will go from being a complete novice to a proficient Excel user, mastering essential skills and functionalities along the way. Whether you have never opened Excel before or have only a basic understanding of the program, this course will build your expertise from zero to hero. You will start by familiarizing yourself with the Excel interface and learn how to navigate workbooks efficiently. Step-by-step guidance will help you grasp the core concepts of data entry, basic formulas, and formatting techniques. Through hands-on practice sessions and real-world examples, you will gain confidence in using functions, creating charts, and analyzing data effectively. As you progress, you will delve into more advanced features such as conditional formatting, pivot tables, and data validation. These tools will enable you to organize and visualize data in a meaningful way, making your Excel projects more professional and insightful. By the end of the course, you will have the skills to automate tasks using macros and optimize your workflow with time-saving tips and tricks. With a focus on practical applications and problem-solving, this course equips you with the knowledge and confidence to tackle Excel tasks with ease. Whether you are a student, professional, or simply looking to enhance your spreadsheet skills, "MS Excel - Zero to Hero - For Beginners" will empower you to unleash the full potential of Excel and elevate your productivity to new heights.
Modules
Introduction to Excel - Day1
5 attachments • 1 hrs
Introduction to Excel Interface and Terminologies
Excel Shortcut Keys - Excel Vibez
Excel Literate - Day1: Terminology
Excel - Different Approach !! || CA Alok A Sethi
Office 365 on One Drive !!
Cell Referencing & Freezing
2 attachments • 1 hrs
Cell Freezing and Referencing - Excel Vibez
video1594280187
Mathematical & Statistical Functions
27 attachments • 28.16 mins
SUM, SUMIF, SUMIFS, SUBTOTAL - ExcelVibez
video1225964084
SUM, SUMIF, SUMIFS, SUBTOTAL, COUNT, COUNTIF, COUNTIFS - Case Studies
Mathematical & Statistical Functions - Case Study
Grades-Merit-performance-ExcelVibez
Mathematical Functions with Drop Down List
SUM IF FUNCTIONS -2
Sum Function
Automize Calculations using Dynamic Functions
IF Function - Case Study - Students Result
Drop Down Functions in Excel
Katrisa Excel Session
Katrisha Excel Session - 15th Jun 24
Katrisa Excel Session - 16th Jun 24
Katrisha Excel Session - 16th Jun 24
Katrisa Excel Session - 19th Jun 24
Katrisha Excel Session - 20th Jun 24
Katrisha - 21Jun24
Katrisha - 22-6-24
Katrisha - 26-6-24
Katrisha - 27 jun 24
Katrisha - 28th jun 24
Katrisha - 30-6-24
Katrisha - 1 July 24
Katrisha - 2 july 24
Katrisha - 3th july 24
Katrisha - 4-7-24
About the creator
CA Alok Sethi
A result oriented professional, 10+ years overall experience in Corporate Training and Development. Possessing exceptional team building skills for increasing a company's productivity by imparting new skills and upskilling employees/students. I conduct seminars, lectures, webinars and workshops on Academic, Technical, Financial & Soft Skills to update employees/students on company goals and procedures and help them upskill themselves to make them more efficient and effective.
Rate this Course
Free
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?