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

NIMACT Logo

Excel Smart Professional (Advanced)

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned.

by NIMACT [Claim Listing ]
  • Price
  • Start Date
  • Duration
Royal Computer Institute Logo

Excel

Excel course is offered by Royal Computer Institute.

by Royal Computer Institute [Claim Listing ]
Syntax World Logo

MS Word

Give yourself the best opportunity to advance your microsoft word career with Syntax World. We provide you work as well as help students gain knowledge and experience in the word . Syntax World is the best and top institute of MS-word in Delhi.

by Syntax World [Claim Listing ]
G-tec Computer Education Logo

Advanced Excel

This course is outlined in a way that it covers majority of enriched features in Microsoft Excel 2021, including Macros, Pivot tables, Audit and Analyze worksheets, Use Advance Formulas and Functions, work with multiple Worksheets and Workbooks.

by G-tec Computer Education [Claim Listing ]
Webdox Computer Institute Logo

Advanced Excel Course

This complete program delves into the intricacies of Excel, overlaying advanced features, formulas, and techniques to manipulate and analyze data like never before. Our experienced instructors will guide you through hands-on projects and real-world examples.

by Webdox Computer Institute [Claim Listing ]

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