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

Check out more MS Excel courses in India

Vision Software Solutions Logo

MS Access

MS Access course is offered by Vision Software Solutions. Our motive is to make all classes of people Computer literate and take all possible advantages to make their future much brighter. Technology is ever-evolving and we pride ourselves on delivering the most updated software courses.

by Vision Software Solutions [Claim Listing ]
ACLM Institute of Professional Studies Logo

MS Office Training

Microsoft Office (MS Office Training) helps to create impressive home and school projects. Microsoft Office is a popular software package of Microsoft Inc., which includes programs, as Word, Excel, Access, PowerPoint, OneNote and Publisher.

by ACLM Institute of Professional Studies [Claim Listing ]
Icon Computer Training Center Logo

Advanced Excel Formulas & Functions

Icon Computer provide ?Advanced Microsoft Excel Training? with the level of excellent quality with life time support at very competitive price. We Cover all topics like calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

by Icon Computer Training Center [Claim Listing ]
Seldom India Technologies Logo

MS Access Training

MS Access course is offered by Seldom India Technologies for all skill level. We have a pool of Enthusiastic and Charismatic Trainers with us, who imbibe the finer aspects of the skills in the candidates subconsciously, and hence help to bring success to themselves and organization as well.

by Seldom India Technologies [Claim Listing ]
Dot Computer Solutions Logo

MS-Office & Internet Services

MS-Office & Internet Services course is offered by Dot Computer Solutions. We have highly experienced faculty members that have great acumen to offer project based training on regular basis.

by Dot Computer Solutions [Claim Listing ]

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