Microsoft Excel from Basics to Advanced with AI

You can earn Rs.50,000 per month working at home by leanring this short course which covers almost all of MS-Excel from basic to advance.

 Hi, I am a Microsoft Exel Trainner. Here I cover all the formulas and functions from basics to advance including how we use AI in making attractive dashboards to make you job ready.

Getting started with Exel

The Quick Access Toolbar

Customizing the QAT

Customizing the ribbons

Exel shortcuts: Navigation, Editing, Selection, Formatting, Paste Special, Formulas, Power Moves

Working with data: cell referencing

Essential formulas: MIN, MAX, SUM, AVERAGE, COUNT, COUNTA, COUNTIF, SUMIF, SUMIFS, AVERAGEIF, AVERAGE IFS, UNIQUE

Coditional Formating

Sorting, filtering, removing duplicates

Text to column

Data Analysis with Exel using AI

Charts

Pivot Table

Pivot Charts

Lookup & Reference Functions: VLOOKUP, HLOOKUP, and INDEX/MATCH.

Logical Functions: IF, IFS, AND, OR, and IFERROR.

Data Summarization: Building and formatting Pivot Tables and Pivot Charts.

Data Manipulation: Text to columns, removing duplicates, and advanced data cleaning.

Dashboards: Advanced charts (Combo, Dynamic), slicers, and interactive dashboard design.

Macros

and many more.