Microsoft Excel From Basics To Advance With Generative Ai

Unlock the Power of Excel: From Fundamentals to AI-Driven Analysis.

What you'll learn

Learn Microsoft Excel from Basics

Master Excel with Charts

Use AI to write functions in Excel

Capstone projects to test your knowledge

Requirements

No Programming Knowledge Required

Description

Unlock the power of Excel, in-depth course designed to equip you with essential data analytics skills. Whether you're a beginner or looking to enhance your expertise, this course covers fundamental concepts, including data visualization, statistical analysis, and real-world data interpretation.Through hands-on exercises, you will learn how to organize, analyze, and visualize data efficiently, making it easier to draw meaningful insights. You'll explore key statistical techniques to interpret trends, identify patterns, and make data-driven business decisions with confidence.Course emphasizes on practical learning, allowing you to work with real-world datasets to solve business problems. You'll master Excel functions, pivot tables, charts, and advanced analytical tools that are crucial for professionals in any industry.By the end of this course, you’ll be proficient in using Excel for data analytics, enabling you to make informed decisions based on data insights. Whether you’re a business professional, analyst, or student, this course will help you enhance your analytical skills and boost your career prospects.Additionally, you'll gain expertise in automating data analysis using Excel formulas, conditional formatting, Pivot Charts and data validation techniques. This course is designed to make you confident in handling complex datasets and deriving actionable insights to improve business efficiency and strategic planning.

Overview

Section 1: Introduction

Lecture 1 Installation Guide

Lecture 2 Class 1-Starting Your Spreadsheet Journey

Lecture 3 Class Notes

Lecture 4 Excel Navigation (Assignment)

Section 2: Go To Special and Paste Special

Lecture 5 Brief overview

Lecture 6 Class 2-Go to Special and Paste Special

Lecture 7 Class Notes

Section 3: Basic Formatting in Excel

Lecture 8 Brief overview

Lecture 9 Class 3-Formatting In Excel

Lecture 10 Class Notes

Lecture 11 Formatting_Assignment1

Lecture 12 Formatting_Assignment2

Lecture 13 Class 4-Grouping, Sorting, Filter, Data Tools

Lecture 14 Excel Data to Practice

Lecture 15 Class 5-Data Tools Continued, Find And Replace

Lecture 16 DataCleaning_Assignment

Lecture 17 Find and Replace -Assignment

Section 4: Conditional Formatting in Excel

Lecture 18 Class 6-Conditional Formatting

Lecture 19 Class Notes

Lecture 20 Conditional Formatting_Assignment

Section 5: Functions in Excel

Lecture 21 Class 7 - Text Functions

Lecture 22 Doubt Session

Lecture 23 Class 8 - Functions Continued

Lecture 24 Functions Assignment - 1

Lecture 25 Class 9 - Logical Functions

Lecture 26 Class 10 - Logical Functions Continued

Lecture 27 Class 11 - Date Functions

Lecture 28 Functions Assignment - 2

Lecture 29 Functions Assignment - 3

Lecture 30 Class 12 - Lookup Functions

Lecture 31 Functions Assignment - 4

Lecture 32 Class 13 - Index, Match and Name Range

Lecture 33 Functions Assignment - 5

Lecture 34 Excel Formulas and Functions Notes

Lecture 35 Advanced Excel Assignment - 6

Section 6: Excel Quiz

Section 7: Pivot Tables in Excel

Lecture 36 Class 14 - Pivot Tables

Lecture 37 Class 15 - Pivot Tables Continued

Lecture 38 PivotTable-Assignment

Lecture 39 Class 16 - Pivot Charts

Lecture 40 Class 17 - Pivot Charts Continued

Lecture 41 Basic Chart Types Hands on Practice

Section 8: AI in Excel

Lecture 42 Class 18 - AI in Excel

Lecture 43 Class 19 - AI in Action

Lecture 44 Doubt Discussion

Lecture 45 Doubt Session Continued

Lecture 46 Excel - Shortcuts

Section 9: Projects

Lecture 47 Capstone_Project - 1

Lecture 48 Dataset_Project - 1

Lecture 49 Capstone_Project - 2

Lecture 50 Dataset_Project - 2

It is for all the learners who are starting their analytics journey