Advance Excel LIVE Course (Basic to Advance)

Syllabus of Live Class of Excel    ( Kindly check the Detailed Syllabus inside the Course in PDF Form)

New Live Course will start from 20th of Jan. 2025

Class 1    Introduction
Part 1:     1. What is Microsoft Excel?
    2. Versions of Excel
    3. Excel Interface Overview
    4. Excel File Formats
    5. Opening and Closing Excel
Part 2:     Working with Excel Basics
    6. Navigating Worksheets
    7. Entering Data
    
class 2    Basic Data Entry & File Tab
Part 1:      Introduction 
    Quick recap of the first class (Introductory Overview of Excel)
    Overview of today's topics: Basic Data Entry & File Tab functions
Part 2:      Basic Data Entry 
Part 3:     Introduction to the File Tab 
class 3    Home Tab - Essential Features and Functions
Part 1:     Introduction 
    Quick recap of the previous class (Basic Data Entry & File Tab)
    Overview of today's topic: Home Tab and its features
Part 2:     Home Tab Overview
Part 3:      Clipboard Group 
Part 4:     Font Group
Part 5:     Alignment Group 
Part 6:      Number Group 
    Number Formatting 
    Applying different number formats (Currency, Percentage, Date, Time)
    Custom Number Formatting 
    Introduction to custom number formats
    Basic examples (e.g., phone numbers, custom date formats)
Part 7:     Styles Group
    Cell Styles 
    Applying built-in cell styles
    Creating and modifying custom styles
    
class 4 :     Home Tab - Advanced Features and Functions
Part 1:    Introduction 
    Quick recap of the previous class (Home Tab Essential Features)
    Overview of today’s topics: Styles, Cells, and Editing groups
Part 2:     Styles Group 
Part 3:      Cells Group
Part 4:      Editing Group
    
class 5 :    Basic Excel Formulas
Part 1:     1. Introduction 
    Quick recap of the previous class (Home Tab: Styles, Cells, and Editing)
    Overview of today’s topic: Basic Excel Formulas
Part 2:     2. Understanding Formulas 
Part 3:     3. Basic Arithmetic Formulas 
    Order of Operations 
    Understanding the order of operations (PEMDAS/BODMAS)
    Examples of complex formulas involving multiple operations (=(A1 + B1) * C1)
Part 4:     4. Cell References 
Part 5:     5. Basic Functions     
class 6 :     Overview of the Insert Tab
Part 1:     Introduction 
    Quick recap of the previous class (Basic Excel Formulas)
    Overview of today’s topic: Insert Tab features focusing on Illustration, Basic Chart, Text, Symbol, Link, and Comment groups
Part 2:     Illustration Group
Part 3:      Basic Chart Group 
    Inserting Charts
    Overview of common chart types (Column, Line, Pie, Bar)
    How to select data and insert a chart
    Basic chart customization (chart title, axis labels, legend)
    Changing chart type and style
Part 4:     Text Group 

Part 5:      Symbol Group
    Inserting Symbols 
    How to insert symbols using the Symbol dialog
    Commonly used symbols (currency symbols, mathematical symbols)
Part 6:     Link Group
    Inserting Hyperlinks 
    How to create hyperlinks to other worksheets, external files, or web pages
    Editing and removing hyperlinks
Part 7:      Comment Group 
    Inserting and Managing Comments 
    How to add comments to cells
    Editing and deleting comments
    Viewing and navigating comments
    
class 7 :    Advanced Features of the Insert Tab
Part 1:      Introduction
    Quick recap of the previous class (Overview of the Insert Tab)
    Overview of today’s topics: Pivot Tables, Pivot Charts, and detailed Chart functionalities
Part 2:     Pivot Tables 
    
Part 3:     Pivot Charts 
    
Part 4:     Detailed Charts 
class 8 :     Creating a Sales Report Project
Project 1    
Part 1:    Introduction
    Quick recap of the previous class (Advanced Features of the Insert Tab)
    Overview of today’s project: Creating a comprehensive sales report using features learned in previous classes
Part 2:    Project Overview
Part 3:    Data Preparation
    Importing and Organizing Data 
    Importing sample sales data into Excel (provide a sample dataset)
    Structuring data: Cleaning up and organizing columns (e.g., Date, Product, Region, Sales Amount)
    Creating a Table 
    Converting data range to a table for better management and analysis
Part 4:    Data Analysis
Part 5:    Data Visualization
    Creating Charts 
    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:    Adding Final Touches
class 9 :    Formulas - Text, Number, and Logic
Part 1:    Introduction
    Quick recap of the previous class (Creating a Sales Report Project)
    Overview of today’s topics: Text, Number, and Logic formulas
Part 2:    Text Formulas
Part 3:    Number Formulas
    
Part 4:    Logic Formulas
    
class 10 :    Comprehensive Formulas - Financial, Date, Day, Time, and Workdays
Part 1:    Introduction
    Quick recap of the previous class (Text, Number, and Logic Formulas)
    Overview of today’s topics: Financial, Date, Day, Time, and Workdays formulas
Part 2:    Financial Formulas
    PMT 
    Purpose: Calculates the payment for a loan based on constant payments and a constant interest rate
    FV 
    Purpose: Calculates the future value of an investment based on periodic, constant payments and a constant interest rate
    NPV 
    Purpose: Calculates the net present value of an investment based on a