technojee
Technojee online fundamentals and advanced excel free course with certificate for beginners and professionals.
Advanced Excel Course Online Hindi. Introduction & Basic Excel - 90 Minutes. Pivot Tables & Charts: Advanced filtering, slicers, timelines, and grouping data. - 75 Minutes. Data Validation: Creating dropdown lists and custom data validation rules. - 50 Minutes. Conditional Formatting - 45 Minutes. What-If Analysis - 40 Minutes. AI-Copilot - 55 Minutes. Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP - 90 Minutes. Logical Functions: IF, AND, OR, IFERROR, Nested IF - 75 Minutes. Math/Stats Functions: SUMIFS, COUNTIFS, AVERAGEIFS, SUMPRODUCT, SUBTOTAL. - 30 Minutes. SQL - Introduction - 35 Minutes. SQL - Create Database,Table - 25 Minutes. SQL - Insert, Update, Delete, Revok, Drop, Alter, Index - 40 Minutes. SQL - 50 SQL Smart Command - 60 Minutes.