Advance MS Excel

by Sisoft Claim Listing

The goal of Advance Excel Training is to give you a solid understanding of Advance Excel. This course is designed for those, Who are willing to make a carrier in Advance Excel.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Sisoft Logo

img Duration

15 Hours

Course Details

The goal of Advance Excel Training is to give you a solid understanding of Advance Excel. This course is designed for those, Who are willing to make a carrier in Advance Excel.

 

Course Structure:

  • Topic-1
    • Introduction Of Ms Excel
    • Overview Of Excel
    • Row, Column, Cell, Range, Ribbon
    • Insert Sheet, Delete Sheet
    • Formatting, Border, Merge, Wrap Text
    • Excel Shortcuts
  • Topic-2
    • Text Functions
    • Upper
    • Lower
    • Proper
    • Len
    • Left
    • Right
    • Mid
    • Trim
    • Find
    • Concatenate
    • Text To Column
  • Topic-3
    • Date & Time
    • Date Function
    • Time Function
    • Today ()
    • Now ()
    • Networkdays
    • Workdays
    • Datedif
  • Topic-4
    • Excel Functionalities
    • Filters
    • Sorting
    • Advance Filter
    • Remove Duplicate
    • Move Or Copy A Sheet
    • Conditional Formatting
    • Group And Ungroup
    • Subtotal Analysis
  • Topic-5
    • Advance Functions
    • Absolute Reference
    • Relative Reference
    • Rank Function
    • Small And Large Function
    • Iferror Function
    • Iferror Function
    • Password Protection
    • Locking Cells Containing Formulas
    • Protecting Specific Cells
  • Topic-6
    • Excel Advance Functionalities
    • Data Validation
    • Data Consolidation
    • Goal Seek
    • Linking Sheets And Workbooks
    • Drop Down List
    • Dependent Drop Down List
    • Naming Manager
    • Scenario Manager
  • Topic-7
    • Pivot Table, Match And Index Function
    • Pivot Table
    • Pivot Chart
    • Adding Calculated Field
    • Changing Data In Pivot
    • Pivot From Multiple Tables
    • Index
    • Match
  • Topic-8
    • Lookup And Conditional Functions
    • Vlookup
    • Hlookup
    • Countif
    • Sumif
    • Sumifs
    • Averageif
    • Averageifs
    • If Function
    • Nested If Fuction
  • Topic-9
    • Charting And Dashboard
    • Chart Interpretation
    • Column Chart
    • Pie Chart
    • Line Chart
    • Combined Chart
    • Dashboard
    • Dynamic Chart
  • Topic-10
    • Macro & Advance Functions
    • Macro Overview
    • Recording Of Macro
    • Execution Of Macro
    • Assigning Macro To Command Button
    • Index And Match
    • Offset Function
  • Ghaziabad Branch

    SRC E7-E8, Shipra Riviera, Gyan Khand-3,Indirapuram, Ghaziabad

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy