What we&#39;ll cover in this Course -&nbsp;
1 INTRO OF COURSE 
2 ENTIRE SYLLABUS OF ADVANCED EXCEL 
3 GUI OF EXCEL 
4 FILE TAB 
5 FONT PANNEL 
6 CLIPBOARD PANNEL 
7 ALIGNMENT PANNEL 
8 NUMBERS PANNEL 
9 CONDITIONAL PANNEL 
10 FORMAT AS TABLE OPTION 
11 CELL STYLES OPTION 
12 INSERT OR DELETE 
13 FORMAT OPTIONS 
14 FILL AND CLEAR OPTION 
15 SORT AND FILTER OPTION 
16 FIND AND SELECT 
17 PIVOT TABLE 
18 PIVOT CHART 
19 PICTURE OPTION WITH DETAIL 
20 SHAPE OPTION WITH ITS MODIFICATION 
21 ICON AND 3D MODELS 
22 SMART ART AND SCREENSHOT 
23 ADD INS PANNEL 
24 3D MAP 
25 SPARKLINES PANNEL 
26 HYPERLINK OPTION 
27 TEXT PANNEL 
28 THEMES PANNEL 
29 MARGIN, ORIENTATION, AND PAGE SIZE 
30 PRINT AREA, PAGE BREAK, AND PRINT TITLES 
31 GRIDLINES, HEADING AND ARRANGE PANNEL 
32 ALL OPTIONS OF PRINT PREVIEW 
33 SPELLING, THESAURUS, AND STATISTICS 
34 SMART LOOKUP OR TRANSLATE OPTION 
35 COMMENT OPTION 
36 HOW TO SET UP THE PASSWORD ON EXCEL SHEET OR WORKBOOK 
37 WORKBOOK VIEWS 
38 ZOOM OPTIONS 
39 SHOW PANNEL IN VIEW TAB 
40 WINDOW PANEL 
41 SWITCH WINDOWS AND MACROS OPTION 
42 HOW TO IMPORT THE DATA IN EXCEL 
SR NO. TOPICS 
43 TEXT TO COLUM, FLASH FILL, AND DUPLICATE OPTIONS 
44 ADVANCE FILTER 
45 COMPLETE DATA VALIDATION OPTION 
46 CONSOLIDATE OPTION 
47 SCENARIO MANAGER 
48 GOAL SEEK AND DATA TABLE OPTION 
49 GROUP, UNGROUP AND SUBTOTAL 
50 ALL METHODS OF SUM FUNCTION 
51 DIVIDE, MULTIPLY, AND SUBTRACTION OPTION 
52 AVERAGE, COUNT, MIN, MAX 
53 ADVANCE LOOKUP FORMULA 
54 VLOOKUP ADVANCE FUNCTION 
55 HOOKUP FORMULA 
56 ROW, ROWS, COLUM,N AND COLUMNS 
57 RANDOM AND RANDOM BETWEEN FORMULA 
58 HOW TO CALCULATE EMI BY PMT FORMULA 
59 IPMT AND PPMT FORMULA 
60 AVERAGEIF AND AVERAGES 
61 COUNT, COUNT AND COUNTBLANK FORMULAS 
62 COUNTIF ANF COUNTIES 
63 UPPER, LOWER AND PROPER FORMULA 
64 LCM FORMULA 
65 POWER FORMULA 
66 TRIM AND SUBSTITUTE FORMULA 
67 IF FORMULA

Syllabus of Live Class of Excel&nbsp;&nbsp; &nbsp;( Kindly check the Detailed Syllabus inside the Course in PDF Form)
New Live Course will start from 20th of Jan.&nbsp;2025
Class 1&nbsp;&nbsp; &nbsp;Introduction 
Part 1: &nbsp;&nbsp; &nbsp;1. What is Microsoft Excel? 
&nbsp;&nbsp; &nbsp;2. Versions of Excel 
&nbsp;&nbsp; &nbsp;3. Excel Interface Overview 
&nbsp;&nbsp; &nbsp;4. Excel File Formats 
&nbsp;&nbsp; &nbsp;5. Opening and Closing Excel 
Part 2: &nbsp;&nbsp; &nbsp;Working with Excel Basics 
&nbsp;&nbsp; &nbsp;6. Navigating Worksheets 
&nbsp;&nbsp; &nbsp;7. Entering Data 
&nbsp;&nbsp; &nbsp; 
class 2&nbsp;&nbsp; &nbsp;Basic Data Entry &amp; File Tab 
Part 1: &nbsp;&nbsp; &nbsp; Introduction&nbsp; 
&nbsp;&nbsp; &nbsp;Quick recap of the first class (Introductory Overview of Excel) 
&nbsp;&nbsp; &nbsp;Overview of today&#39;s topics: Basic Data Entry &amp; File Tab functions 
Part 2: &nbsp;&nbsp; &nbsp; Basic Data Entry&nbsp; 
Part 3: &nbsp;&nbsp; &nbsp;Introduction to the File Tab&nbsp; 
class 3&nbsp;&nbsp; &nbsp;Home Tab - Essential Features and Functions 
Part 1: &nbsp;&nbsp; &nbsp;Introduction&nbsp; 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Basic Data Entry &amp; File Tab) 
&nbsp;&nbsp; &nbsp;Overview of today&#39;s topic: Home Tab and its features 
Part 2: &nbsp;&nbsp; &nbsp;Home Tab Overview 
Part 3: &nbsp;&nbsp; &nbsp; Clipboard Group&nbsp; 
Part 4: &nbsp;&nbsp; &nbsp;Font Group 
Part 5: &nbsp;&nbsp; &nbsp;Alignment Group&nbsp; 
Part 6: &nbsp;&nbsp; &nbsp; Number Group&nbsp; 
&nbsp;&nbsp; &nbsp;Number Formatting&nbsp; 
&nbsp;&nbsp; &nbsp;Applying different number formats (Currency, Percentage, Date, Time) 
&nbsp;&nbsp; &nbsp;Custom Number Formatting&nbsp; 
&nbsp;&nbsp; &nbsp;Introduction to custom number formats 
&nbsp;&nbsp; &nbsp;Basic examples (e.g., phone numbers, custom date formats) 
Part 7: &nbsp;&nbsp; &nbsp;Styles Group 
&nbsp;&nbsp; &nbsp;Cell Styles&nbsp; 
&nbsp;&nbsp; &nbsp;Applying built-in cell styles 
&nbsp;&nbsp; &nbsp;Creating and modifying custom styles 
&nbsp;&nbsp; &nbsp; 
class 4 :&nbsp;&nbsp; &nbsp; Home Tab - Advanced Features and Functions 
Part 1:&nbsp;&nbsp; &nbsp;Introduction&nbsp; 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Home Tab Essential Features) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topics: Styles, Cells, and Editing groups 
Part 2: &nbsp;&nbsp; &nbsp;Styles Group&nbsp; 
Part 3: &nbsp;&nbsp; &nbsp; Cells Group 
Part 4: &nbsp;&nbsp; &nbsp; Editing Group 
&nbsp;&nbsp; &nbsp; 
class 5 :&nbsp;&nbsp; &nbsp;Basic Excel Formulas 
Part 1: &nbsp;&nbsp; &nbsp;1. Introduction&nbsp; 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Home Tab: Styles, Cells, and Editing) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topic: Basic Excel Formulas 
Part 2: &nbsp;&nbsp; &nbsp;2. Understanding Formulas&nbsp; 
Part 3: &nbsp;&nbsp; &nbsp;3. Basic Arithmetic Formulas&nbsp; 
&nbsp;&nbsp; &nbsp;Order of Operations&nbsp; 
&nbsp;&nbsp; &nbsp;Understanding the order of operations (PEMDAS/BODMAS) 
&nbsp;&nbsp; &nbsp;Examples of complex formulas involving multiple operations (=(A1 + B1) * C1) 
Part 4: &nbsp;&nbsp; &nbsp;4. Cell References&nbsp; 
Part 5: &nbsp;&nbsp; &nbsp;5. Basic Functions &nbsp;&nbsp; &nbsp; 
class 6 :&nbsp;&nbsp; &nbsp; Overview of the Insert Tab 
Part 1: &nbsp;&nbsp; &nbsp;Introduction&nbsp; 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Basic Excel Formulas) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topic: Insert Tab features focusing on Illustration, Basic Chart, Text, Symbol, Link, and Comment groups 
Part 2: &nbsp;&nbsp; &nbsp;Illustration Group 
Part 3: &nbsp;&nbsp; &nbsp; Basic Chart Group&nbsp; 
&nbsp;&nbsp; &nbsp;Inserting Charts 
&nbsp;&nbsp; &nbsp;Overview of common chart types (Column, Line, Pie, Bar) 
&nbsp;&nbsp; &nbsp;How to select data and insert a chart 
&nbsp;&nbsp; &nbsp;Basic chart customization (chart title, axis labels, legend) 
&nbsp;&nbsp; &nbsp;Changing chart type and style 
Part 4: &nbsp;&nbsp; &nbsp;Text Group&nbsp;
Part 5: &nbsp;&nbsp; &nbsp; Symbol Group 
&nbsp;&nbsp; &nbsp;Inserting Symbols&nbsp; 
&nbsp;&nbsp; &nbsp;How to insert symbols using the Symbol dialog 
&nbsp;&nbsp; &nbsp;Commonly used symbols (currency symbols, mathematical symbols) 
Part 6:&nbsp;&nbsp; &nbsp; Link Group 
&nbsp;&nbsp; &nbsp;Inserting Hyperlinks&nbsp; 
&nbsp;&nbsp; &nbsp;How to create hyperlinks to other worksheets, external files, or web pages 
&nbsp;&nbsp; &nbsp;Editing and removing hyperlinks 
Part 7: &nbsp;&nbsp; &nbsp; Comment Group&nbsp; 
&nbsp;&nbsp; &nbsp;Inserting and Managing Comments&nbsp; 
&nbsp;&nbsp; &nbsp;How to add comments to cells 
&nbsp;&nbsp; &nbsp;Editing and deleting comments 
&nbsp;&nbsp; &nbsp;Viewing and navigating comments 
&nbsp;&nbsp; &nbsp; 
class 7 :&nbsp;&nbsp; &nbsp;Advanced Features of the Insert Tab 
Part 1: &nbsp;&nbsp; &nbsp; Introduction 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Overview of the Insert Tab) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topics: Pivot Tables, Pivot Charts, and detailed Chart functionalities 
Part 2: &nbsp;&nbsp; &nbsp;Pivot Tables&nbsp; 
&nbsp;&nbsp; &nbsp; 
Part 3: &nbsp;&nbsp; &nbsp;Pivot Charts&nbsp; 
&nbsp;&nbsp; &nbsp; 
Part 4: &nbsp;&nbsp; &nbsp;Detailed Charts&nbsp; 
class 8 :&nbsp;&nbsp; &nbsp; Creating a Sales Report Project 
Project 1&nbsp;&nbsp; &nbsp; 
Part 1:&nbsp;&nbsp; &nbsp;Introduction 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Advanced Features of the Insert Tab) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s project: Creating a comprehensive sales report using features learned in previous classes 
Part 2:&nbsp;&nbsp; &nbsp;Project Overview 
Part 3:&nbsp;&nbsp; &nbsp;Data Preparation 
&nbsp;&nbsp; &nbsp;Importing and Organizing Data&nbsp; 
&nbsp;&nbsp; &nbsp;Importing sample sales data into Excel (provide a sample dataset) 
&nbsp;&nbsp; &nbsp;Structuring data: Cleaning up and organizing columns (e.g., Date, Product, Region, Sales Amount) 
&nbsp;&nbsp; &nbsp;Creating a Table&nbsp; 
&nbsp;&nbsp; &nbsp;Converting data range to a table for better management and analysis 
Part 4:&nbsp;&nbsp; &nbsp;Data Analysis 
Part 5:&nbsp;&nbsp; &nbsp;Data Visualization 
&nbsp;&nbsp; &nbsp;Creating Charts&nbsp; 
&nbsp;&nbsp; &nbsp;Insert various charts (e.g., Column Chart for total sales, Pie Chart for sales by product, Line Chart for sales trends over time) 
Part 6:&nbsp;&nbsp; &nbsp;Adding Final Touches 
class 9 :&nbsp;&nbsp; &nbsp;Formulas - Text, Number, and Logic 
Part 1:&nbsp;&nbsp; &nbsp;Introduction 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Creating a Sales Report Project) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topics: Text, Number, and Logic formulas 
Part 2:&nbsp;&nbsp; &nbsp;Text Formulas 
Part 3:&nbsp;&nbsp; &nbsp;Number Formulas 
&nbsp;&nbsp; &nbsp; 
Part 4:&nbsp;&nbsp; &nbsp;Logic Formulas 
&nbsp;&nbsp; &nbsp; 
class 10 :&nbsp;&nbsp; &nbsp;Comprehensive Formulas - Financial, Date, Day, Time, and Workdays 
Part 1:&nbsp;&nbsp; &nbsp;Introduction 
&nbsp;&nbsp; &nbsp;Quick recap of the previous class (Text, Number, and Logic Formulas) 
&nbsp;&nbsp; &nbsp;Overview of today&rsquo;s topics: Financial, Date, Day, Time, and Workdays formulas 
Part 2:&nbsp;&nbsp; &nbsp;Financial Formulas 
&nbsp;&nbsp; &nbsp;PMT&nbsp; 
&nbsp;&nbsp; &nbsp;Purpose: Calculates the payment for a loan based on constant payments and a constant interest rate 
&nbsp;&nbsp; &nbsp;FV&nbsp; 
&nbsp;&nbsp; &nbsp;Purpose: Calculates the future value of an investment based on periodic, constant payments and a constant interest rate 
&nbsp;&nbsp; &nbsp;NPV&nbsp; 
&nbsp;&nbsp; &nbsp;Purpose: Calculates the net present value of an investment based on a

Digital Products

₹389
2500
85% off

₹964
10999
92% off

Contact

Quick Links

Download App

Follow us

Digital Products

₹389 250085% off

₹964 1099992% off

Contact

Quick Links

Download App

Follow us

₹389
2500
85% off

₹964
10999
92% off