Let's Excel With Microsoft Excel
CA Supreet Agrawal
7 modules
English
Certificate of completion
Lifetime access
Learn & Understand Microsoft Excel Tool starting from Fundamental Level to the Most Advanced Level.
Overview
Unlock the full potential of Microsoft Excel through our comprehensive and captivating course, 'Let's Excel with Microsoft Excel'. Delve into the world of spreadsheets and data manipulation as you embark on a journey through six skill-enhancing levels. From mastering basic data entry to harnessing the advanced capabilities of Power Pivot and Power Query, this course is designed to elevate your Excel prowess and boost your productivity.
What Makes This Course Stand Out?
-
Comprehensive Learning: Our course takes you from the basics of Microsoft Excel, ensuring a strong foundation, and gradually progresses to advanced functionalities like What-if Analysis and Power Pivot.
-
Practical Examples: Learn by doing! We supplement each topic with practical examples and reference files, allowing you to apply your knowledge immediately and retain key concepts.
-
Visual Learning: Engage with 35 video lectures, each lasting an average of 4 minutes, ensuring ease of learning and quick reference for future use.
-
Lifetime Access: Once enrolled, you'll have lifetime access to the course, allowing you to revisit and refresh your skills whenever needed.
What You'll Learn:
By the end of the course, you'll possess an arsenal of Excel skills that will empower you in both your personal and professional life, enabling you to:
-
Harness the utility of Microsoft Excel for various tasks in daily life and work settings.
-
Create visually engaging reports using Pivot Tables, Charts, Power Pivot, Power Query, and more.
-
Gain confidence in working with formulae, from the basic to advanced, to solve complex data challenges.
-
Automate routine tasks through the mastery of Macros, streamlining your workflow.
Enroll today to access 35 video lectures with an average duration of 4 minutes each, and embark on a journey of Excel mastery!
Key Highlights
Learn the fundamentals of Microsoft Excel
Master the use of formulas and functions
Create professional-looking spreadsheets and charts
Automate tasks using features like macros and VBA
Gain proficiency in data analysis and visualization
Optimize efficiency with tips and tricks
Collaborate and share workbooks with others
Troubleshoot and debug common issues
Advance your Excel skills for career growth
What you will learn
Mastering Excel Basics
Learn essential functions, formulas, and formatting techniques to efficiently use Microsoft Excel.
Creating Effective Spreadsheets
Discover how to design and structure spreadsheets with tables, charts, and conditional formatting for improved data visualization and analysis.
Data Analysis and Visualization
Explore advanced techniques like pivot tables, data filtering, and data validation to analyze and visualize data effectively in Excel.
Automating Tasks with Macros
Learn how to record and write macros to automate repetitive tasks, saving time and increasing productivity in Excel.
Modules
Introduction to Microsoft Excel
3 attachments • 10.77 mins
Introduction to Microsoft Excel
Key Terminologies Used in the Microsoft Excel
Main Functions of the Microsoft Excel's Ribbon
Data Entry and Most Frequently Used Shortcut Keys
2 attachments • 5.01 mins
Data Entry & Analysis
Most Frequently Used Shortcut Keys
Most Frequently Used Formulae
4 attachments • 7.1 mins
Meaning of Fomulae & Steps to Apply Formulae
Most Frequently Used Formulae
VLOOKUP - Syntax & Rules
VLOOKUP - Practical Example
Pivot Tables & Charts
3 attachments • 9.43 mins
Basics of Pivot Tables
Pivot Tables - Practical Example
Charts
Special Functionalities Available in the Microsoft Excel
10 attachments • 57.66 mins
Special Functionalities - File Extensions
Special Functionalities - Home Tab
Special Functionalities - Insert Tab
Special Functionalities - Page Layout Tab
Special Functionalities - Formulas Tab
Special Functionalities - Data Tab
Special Functionalities - Review Tab
Special Functionalities - View Tab
Special Functionalities - Help Tab
Special Functionalities - File Extensions
Advanced Functionalities available in Microsoft Excel
12 attachments • 57.24 mins
Advanced Functionalities - Consolidate Button
Advanced Functionalities - Relationships & Power Pivot
Advanced Functionalities - What-if Analysis
Advanced Functionalities - Forecast Sheet & Outline Section
Advanced Functionalities - Advanced Formulae & Cell Referencing
Advanced Functionalities - Microsoft Excel Templates
POWER QUERY - Text Functions
POWER QUERY - Date Functions
POWER QUERY - Merge Tables or VLOOKUP
POWER QUERY - Merge Queries From Different Workbooks
POWER QUERY - Find Only Working Days
Advanced Functionalities - Printing the Workbook
Course Wrap Up & Next Steps
1 attachment • 2.52 mins
Course Wrap Up
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
Testimonials
Comprehensive and well explained. Must watch for beginners. > Valuable Information > Clear Explanations > Engaging Delivery > Helpful Practice Activities > Accurate Course Description > Knowledgable Instructor
Anula Wagle
Senior Associate at PWC
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 Supreet Agrawal
Supreet Agrawal is a Chartered Accountant by profession and a teacher & trainer by passion.
He is experienced in teaching in Offline as well as Online mode.
He is a trainer for CA, ACCA, US CPA, US CMA and for Finance-related Certification Courses.
He also provides services related to CV review, CV preparation, Interview Preparation & Career Counselling.
Rate this Course
₹ 299.00
₹1999
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?
