Basic Excel, Advance Excel and Excel with AI Course ( Week Day Batches)
Learn with Sawwant Surenndra
14 modules
English, Hindi, Marathi ( Live Training)
Certificate of completion
Lifetime access
Learn the basics of Excel and gain essential skills for better productivity.
Overview
Course Title: Basic and Advanced Excel Course Course Description: The Basic and Advanced Excel Course is designed to provide comprehensive knowledge and hands-on training in utilizing the features, functionalities, and formulas of Microsoft Excel. Whether you are a beginner looking to gain essential skills or an experienced user aiming to enhance your proficiency, this course offers a step-by-step learning experience to help you master Excel. The course starts by covering the basics of Excel, including navigating the user interface, creating and editing spreadsheets, and formatting data. You will learn how to enter and manipulate data, use formulas and functions to perform calculations, and create basic charts and graphs to visually represent your data. As you progress, the course delves into more advanced topics to expand your expertise. You will explore advanced functions such as VLOOKUP, INDEX-MATCH, and SUMIFS, enabling you to extract and analyze data effectively. Additionally, you will discover how to utilize conditional formatting, data validation, and pivot tables to enhance data presentation and analysis. The curriculum has macros and VBA introduction and exploring the power of Excel's built-in tools, such as Solver and Data Analysis. You will gain insights into efficient data sorting, filtering, and summarization techniques. Throughout the course, hands-on exercises and practical examples will reinforce your understanding and allow you to apply the learned concepts in real-world scenarios. By the end of this course, you will have the skills and confidence to handle complex data analysis, create dynamic reports, and streamline your workflow using Excel. Whether you are a student, professional, business owner, or anyone who deals with data on a regular basis, learning Excel is essential. Enroll in the Basic and Advanced Excel Course today and unlock the full potential of this powerful spreadsheet software.
Key Highlights
Fundamental concepts and features of Excel
Creating formulas without having remembering.
How to work fast using excel
Assignments , capstone project and Excel using AI
Data Analysis , new features, data cleaning, gaining accuracy and much more Discounted Price
Live Training, personal attention and guidance
What you will learn
Learn fundamental concepts and features
Understand the key concepts and features of Excel, such as worksheets, cells, formulas, and functions.
Navigate and use Excel's interface
Learn how to navigate using minimum short cuts which will make your life easy
Create and format spreadsheets
Learn How to write the formula without having remembering.
Get Practice on Assignments
Practical examples with assignments and Capstone Projects
Excel Tricks to speedup the work
Learn the tricks to work better and in efficient way.
Modules
Introduction to Excel
8 attachments • 36 sec
Overview of Excel
Live Class
Week 1-New Content- Practice Sheet
Entering and Editing Data
12 pages
Working with Cells and Ranges
Important Short Cuts in Excel
Quiz
Assignment on Shorcuts
Basic Formulas and Functions
5 attachments
Introduction to Formulas
Coming Soon
Using Basic Operators
Coming Soon
Sum, Average, Min, and Max Functions
Coming Soon
Count and Countif Functions
Coming Soon
Week 1 Assignment
Logical Operators and Working with Text
6 attachments
Week 2 - Content- Practice Sheet
Working with Multiple Conditions using & and Or
Data Validation
Working with Text
Text Manipulation Functions
Week 2 Assignment
Formatting and Customization
5 attachments
Formatting Cells and Text
Coming Soon
Working with Fonts and Colors
Coming Soon
Using Borders and Cell Styles
Coming Soon
Customizing the Worksheet
Coming Soon
Freeze panes
Managing Data and Sheets
4 attachments
Sorting Data
Coming Soon
Filtering Data
Coming Soon
Inserting and Deleting Rows and Columns
Coming Soon
Renaming and Moving Worksheets
Coming Soon
Advanced Functions
5 attachments
Week3- Content- Practice Filegraphy
Logical Functions
Coming Soon
Date and Time Functions
Coming Soon
Lookup and Reference Functions
Coming Soon
Week 3 assignment
Working with Charts
6 attachments
Pivot and Chart Content Graphy
Creating Charts
Coming Soon
Formatting and Customizing Charts
Coming Soon
Adding Data Labels and Titles
Coming Soon
Changing Chart Type
Coming Soon
Sparklines
Data Analysis and Visualization
6 attachments
Using PivotTables
Coming Soon
Creating PivotCharts
Coming Soon
Performing What-If Analysis
Coming Soon
Creating Data Tables
Coming Soon
Scenario Manager
Pivot and charts assignment
Protection of work sheet
6 attachments
Protection sheet content
Protecting Worksheets and Workbooks
Coming Soon
Hiding and Unhiding Data
Coming Soon
Using Conditional Formatting
Coming Soon
Hiding formulas
Assignment on Protecting ranges
Advance Formulas and Functions
9 attachments
Index match and Array Formulas Content
Index and match
Xlookup- Content
X Lookup
Choose , if error in vlookup
New formulas in Excel
Array Functions
Name Manager in Excel
Xlookup Assignment
Dashboards and Subtotal
5 attachments
Subtotal
Dashboard Creation
Database functions
Grouping
Statistical Formulas
Introduction to Macros and VBA
4 attachments
Introduction to macros and VBA settings
Recording the Macros
Writing First VBA code
Loops in VBA
AI and Excel
4 attachments
Introduction to the Chat GPT
Other tools to work faster
Tricks in excel
Power Piviot
Capstone Project
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
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
Learn with Sawwant Surenndra
Elevate your learning experience with Sawant Surendra, a passionate expert in Data analysis using Excel. I have 10-plus years of experience. I am V skill certified and have received many awards and certificates using excel
Rate this Course
₹ 5559.00
₹10000
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?