Home

/

Courses

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

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

Learn with Sawwant Surenndra

14 modules

English, Hindi, Marathi ( Live Training)

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.

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

7 attachments

Week 1 Session 2

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

5 attachments

Week 2 1st session

Sorting Data

Coming Soon

Filtering Data

Coming Soon

Inserting and Deleting Rows and Columns

Coming Soon

Renaming and Moving Worksheets

Coming Soon

Advanced Functions

6 attachments

Week 2 Session 2

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

7 attachments

Week 3 Session 1

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

7 attachments

Week 3 Session 2

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

7 attachments

Week 4 Session 1

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

11 attachments

Week 4 Session 2

Index match and Array Formulas Content

Index and match

Xlookup- Content

X Lookup

Choose , if error in vlookup

New formulas in Excel

Week 5 Session 1

Array Functions

Name Manager in Excel

Xlookup Assignment

Dashboards and Subtotal

7 attachments

Week 5 Session 2

Subtotal

Dashboard Creation

Week 6 Session 1

Database functions

Grouping

Statistical Formulas

Introduction to Macros and VBA

5 attachments

Week 6 Session 2

Introduction to macros and VBA settings

Recording the Macros

Writing First VBA code

Loops in VBA

AI and Excel

6 attachments

Week 7 Session 1

Introduction to the Chat GPT

Tricks in excel

Other tools to work faster

Power Piviot

Week 7 Session 2

Capstone Project

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-End-Batches-65321a2ee4b020072f205729-65321a2ee4b020072f205729

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