Home

/

Courses

/Basic Excel, Advance Excel and Excel with AI Course ( Week Day Batches)

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.

Course Certificate

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

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!

Illustration | Payment success

Share this course

https://undefined/courses/Basic-Excel-Advance-Excel-and-Excel-with-AI-Course--Week-Day-Batches-650acd84e4b00ea523e6333e-650acd84e4b00ea523e6333e

or

×

Wait up!

We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?

Illustration | Already enrolled in course