Advance MS Excel

Name: Advance MS Excel
Availability: InStock

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.

Contact the Institutes

Fill this form

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

Sisoft offers learning services and learning solutions catering to the needs of enterprise, institute and individuals. Sisoft specializes in skilling and training people in areas of IT Technical, Project Management and Soft Skills.

Our modules are industry oriented and assist Business Houses/Companies in improving employee productivity, enhance employee engagement, facilitate job satisfaction and retention of high performers. We provide job-oriented modules for fresh graduates.

Sisoft provides classroom or remote instructor led training and assessment solutions. Our learning solutions include preparing cuurse content, learning management, assessment and proctoring.

View Detailed Profile

Ghaziabad Branch

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

About Coursetakers.com

Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the USA, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.

Advance MS Excel

Contact the Institutes

Advertisement

Duration

Course Details

Ghaziabad Branch

Courses

Quick Links