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

₹964
10999
92% off

Contact

Quick Links

Download App

Follow us

Digital Products

₹964 1099992% off

Contact

Quick Links

Download App

Follow us

₹964
10999
92% off