ADVANCE EXCEL COURSE (3 MONTHS)

Advanced Excel is all about mastery over formulas, VBA (Visual Basic for Applications) programming, and other Excel features for handling complex tasks. Experts can use Excel for more advanced purposes like data analytics and simulation.

Advance Excel Heading Concepts

1. Introduction of Advance Excel
      • Excel Introduction
      • Explain Type of cursor
      • Discuss Rows And Columns
      • Briefly Discuss of Excel Sheet
2. Style Group in Home Tab
      • Conditional Formatting
      • How To Highlight Row & Columns
3.How to Make Chess Board
4.Format As a Table
5. Cell Style
  • Cell Group

  • Cell color

  • Table styles

6. Rows and columns work
      • Rows & Columns Inserted
      • Rows & Columns Deleted
      • Rows & Columns Format
      • Editing Group
7. Editing works on data
      • AutoSum
      • How To Clear All Formatting
      • How to Sort Data & Filter
      • Find & Replace
8. Round Functions
      • Round Down
      • Round Up
      • Round Sum
      • Round Minus
      • Round Percentage Only
      • Round Average
      • Round Multiple
      • Round Minimum & Maximum
9. Count Functions
    • Count Numbers
    • Count Blank
    • CountA
    • Particular Name Count
    • Sum+Count
    • Count Negative & Positive
    • Number
    • Count Odd & Even Number
    • Count Weekday
10. Insert Tab
      • Pivot Table
      • Pivot Chart
      • Pictures
      • Shape
      • All Type of Chart
      • Hyperlink
      • Header & Footer
      • Equation
      • Symbols
11. Page Layout Tab
      • Page Setup
      • Margin
      • Orientation
      • Print Area
      • Background Image
      • Print Tiles
      • Size
      • Scale to Fit
      • Sheet Option
      • Arrange
12. Formulas Tab
      • Auto Sum
      • Financial Function
      • Logical Function
      • Text Function
      • Date Function
      • Lookup & References
      • Math’s & Trigo Function
      • Define Name
      • Calculations
13. Financial Function
    • PV
    • NPER
    • RATE
    • PMT
    • PPMT
    • IPMT
    • FV

ADVANCE EXCEL

Advanced Excel is all about mastery over formulas, VBA (Visual Basic for Applications) programming, and other Excel features for handling complex tasks.