ZERO TO HERO IN MS-EXCEL
CA Alok Sethi
10 modules
English
Lifetime access
"Master Microsoft Excel from the ground up and transform from zero to hero in no time!"
Overview
Learn how to go from being a complete beginner to a proficient user in Microsoft Excel with the "Zero to Hero in MS-Excel" course. This comprehensive training program is designed for individuals who have little to no experience with Excel and want to master the essential skills used in the workplace. You will start by understanding the basics of Excel, including navigating the interface, entering data, and formatting spreadsheets.
As you progress, you will learn how to create and manage worksheets, use formulas and functions for calculations, and analyze data effectively. Through hands-on exercises and real-world examples, you will gain practical experience in organizing data, creating charts and graphs, and automating tasks with macros.
By the end of the course, you will be able to confidently work with Excel to perform tasks such as budgeting, reporting, and data analysis. Whether you are a student, professional, or business owner, mastering Excel is a valuable skill that can enhance your productivity and decision-making abilities. With "Zero to Hero in MS-Excel," you will build a solid foundation in Excel that will set you on the path to becoming a proficient user in no time.
Key Highlights
Learn essential Excel functions and formulas from scratch
Create visually appealing charts and graphs for data analysis
Master time-saving tips and tricks to boost productivity
Understand how to use filters, pivot tables, and VLOOKUP
Automate tasks with macros and improve efficiency
Handle complex data sets with confidence and accuracy
Become proficient in data visualization and reporting
Gain practical skills for real-world Excel proficiency
What you will learn
Basic Excel Functions Mastery
Learn essential Excel functions, such as SUM, AVERAGE, and COUNT, to perform basic calculations and data analysis efficiently.
Data Visualization Techniques
Explore various data visualization techniques in Excel, including creating charts and graphs to present data effectively.
Advanced Formulas and Functions
Master advanced Excel formulas and functions like VLOOKUP, IF, and CONCATENATE to manipulate data and automate tasks.
Pivot Tables and Data Analysis
Understand how to use pivot tables in Excel for data summarization, analysis, and gaining valuable insights from large datasets.
Professional Excel Tips and Tricks
Discover pro tips and tricks in Excel to work more efficiently, format data professionally, and customize your spreadsheets.
Modules
Day1 :Excel Interface, Terms & Navigation Shortcuts
7 attachments • 2 hrs
Day2: Shortcut Keys in Excel - Ctrl Based A-Z
Day 3: Shortcut Keys - Ctrl + (A-Z & 0-9)
Day 4: Cell Referencing & Cell Freezing Concepts
Practice File - Cell Referencing & Freezing
100 Most Useful Excel Shortcut Keys
EXCEL WITH AI - AUTOMATION
Excel Automation with AI - 28-May-24
Zero to Hero - Day 6 - Count Functions
4 attachments • 1 hrs
Conditional Formatting
Recording - Conditional Formatting with Dynamic Selection
Power Pivot in Excel - Live Session
Recording - Excel Baics - Count & Sum Functions
Introduction to Excel- Bonus Sessions
10 attachments • 3 hrs
Excel for Beginners: 4 Easy Ways to Launch Excel in Windows || CA Alok A Sethi
Basic Formulas and Functions
18 pages
Introduction to Excel - Day 1 Practice File
Excel Mastery for Beginners: Unveiling the Power of Spreadsheets! Day 1🔥 || CA Alok A Sethi #excel
Mastering Excel: Shortcut Keys and Cell Referencing for Ultimate Productivity | CA Alok Sethi #excel
Excel Formula Auditing: Trace Precedents and Dependents for Error-Free Spreadsheets || CA Alok Sethi
Cell Freezing and Referencing - Day 2 & 3 Practice File
Sum and Sumif Functions in Excel || CA Alok A Sethi #excel
Sum & Sum If - Day 4 Practice File
100 Most Useful Excel Shortcut Keys - CA Alok A Sethi
Conditional Formatting with Formulas - Bonus Sessions
4 attachments • 52 mins
Conditional Formatting with Data Validation (LIST) ||
Conditional Formatting with Dynamic Selection
Doubt Solving Session
Brand New Functions in Excel 2024
Data Manipulation in Excel
8 attachments • 4 hrs
Custom Number Formatting - Bonus Session
Conditional Formatting - Basics - Part 1
Dashboard Class : 11 April 24
Pivot Tables & Charts & Dashboard Creation: 12 April 24
How to Use EXCEL as a JET PLANE !!!
Excel Baics - Count & Sum Functions
Excel - Merging Data from Different Excel Files
MACROS & AI IN EXCEL
Data Visualization in Excel
7 attachments
Financial Dashboard - Day 1
Advanced Charts Settings
Sparklines and Trendlines
Coming Soon
Creating Dashboards
Coming Soon
Dynamic Dashboard - Live Session
Dynamic Dashboard - 2
Norway Cars Sales Dashboard
Advanced Excel Features
4 attachments
Advanced Formulas and Functions
Coming Soon
Data Analysis with Goal Seek and Solver
Coming Soon
Using Lookup and Reference Functions
Coming Soon
Working with Macros
Coming Soon
Excel IF Function: Simple to Advanced (Multiple Criteria, Formatting, AND, OR functions)- Bonus sessions
Dashboards-Bonus sessions
2 attachments • 1 hrs
Dashboard in Excel - Part 1 || Advanced Excel
Dashboard in Excel - Part 2 || Advanced Excel
Mastering Power Query: Creating a New Column by Combining Year, Quarter, and Month -Bonus session
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
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
₹ 2999.00
₹4999
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?
