Advanced Excel

by ICS India Group of Institutions Claim Listing

Advanced Excel course is offered by ICS India Group Of Institutions. The goal of ICS Group of Institutions is to mould the student in the right way as they can analyze themselves and explore the hidden talents and helps the existing talents improved.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

ICS India Group of Institutions Logo

img Duration

Please Enquire

Course Details

Advanced Excel course is offered by ICS India Group Of Institutions. The goal of ICS Group of Institutions is to mould the student in the right way as they can analyze themselves and explore the hidden talents and helps the existing talents improved. We care each and every student who comes in with hope to build their future brighten. 

Our faculties are good experts in the domain which they educate students. To drive the sessions interactive we will let them involve in practical activities in terms of being part of our real time projects, sharing tasks, developing innovative projects.

 

Content:

  • Excel Introduction
    • An overview of the screen, navigation and basic spreadsheet concepts
    • Various selection techniques
    • Shortcut Keys
  • Customizing Excel
    • Customizing the Ribbon
    • Using and Customizing AutoCorrect
    • Changing Excel’s Default Options
  • Using Basic Functions
    • Using Functions – Sum, Average, Max,Min, Count, Counta
    • Absolute, Mixed and Relative Referencing
  • Formatting And Proofing
    • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
    • Basic conditional formatting
  • Mathematical Functions
    • SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs
  • Protecting Excel
    • File Level Protection
    • Workbook, Worksheet Protection
  • Text Functions
    • Upper, Lower, Proper
    • Left, Mid, Right
    • Trim, Len, Exact
    • Concatenate
    • Find, Substitute
  • Date And Time Functions
    • Today, Now
    • Day, Month, Year
    • Date, Date if, DateAdd
    • EOMonth, Weekday
  • Advanced Paste Special Techniques
    • Paste Formulas, Paste Formats
    • Paste Validations
    • Transpose Tables
    • New in Excel 2013 / 2016 & 365
    • New Charts – Tree map & Waterfall
    • Sunburst, Box and whisker Charts
    • Combo Charts – Secondary Axis
    • Adding Slicers Tool in Pivot & Tables
    • Using Power Map and Power View
    • Forecast Sheet
    • Sparklines -Line, Column & Win/ Loss
    • Using 3-D Map
    • New Controls in Pivot Table – Field, Items and Sets
    • Various Time Lines in Pivot Table
    • Auto complete a data range and list
    • Quick Analysis Tool
    • Smart Lookup and manage Store
    • Sorting and FILTERING
    • Filtering on Text, Numbers & Colors
    • Sorting Options
    • Advanced Filters on 15-20 different criteria(s)
  • Printing Workbooks
    • Setting Up Print Area
    • Customizing Headers & Footers
    • Designing the structure of a template
    • Print Titles –Repeat Rows / Columns
    • Advance Excel
  • What If Analysis
    • Goal Seek
    • Scenario Analysis
    • Data Tables (PMT Function)
    • Solver Tool
  • Logical Functions
    • If Function
    • How to Fix Errors – iferror
    • Nested If
    • Complex if and or functions
  • Data Validation
    • Number, Date & Time Validation
    • Text and List Validation
    • Custom validations based on formula for a cell
    • Dynamic Dropdown List Creation using Data Validation – Dependency List
  • Lookup Functions
    • Vlookup / HLookup
    • Index and Match
    • Creating Smooth User Interface Using Lookup
    • Nested VLookup
    • Reverse Lookup using Choose Function
    • Worksheet linking using Indirect
    • Vlookup with Helper Column
  • Pivot Tables
    • Creating Simple Pivot Tables
    • Basic and Advanced Value Field Setting
    • Classic Pivot table
    • Grouping based on numbers and Dates
    • Calculated Field & Calculated Items
    • Arrays Functions
    • What are the Array Formulas, Use of the Array Formulas?
    • Basic Examples of Arrays (Using ctrl+shift+enter).
    • Array with if, len and mid functions formulas.
    • Array with Lookup functions.
    • Advanced Use of formulas with Array.
    • CHARTS and slicers
    • Various Charts i.e. Bar Charts / Pie Charts / Line Charts
    • Using SLICERS, Filter data with Slicers
    • Manage Primary and Secondary Axis
  • Kochi Branch

    V. P. Marakkar Building, V. P. Marakkar Road, Near Lulu Mall Toll Junction, Kochi
  • Palakkad Branch

    Century Tower, Near Bismi Hypermarket, Palakkad

Check out more MS Excel courses in India

ICT (Institute Of Computer Training) Logo

MS Access

MS Access course is offered by ICT (Institute Of Computer Training). ICT offers a variety of courses – technology courses for IT students, career programs, project training for students wanting to enter the IT sector, certification courses for IT professionals.

by ICT (Institute Of Computer Training) [Claim Listing ]
Ahmed Architect Logo

MS Office

We train MS office thoroughly because it can be utilised in many ways in construction services which includes Easy access to email, Simplify document management with SharePoint, your data is safe in OneDrive for Business, and Skype for Business reduces costs and get more for your money. 

by Ahmed Architect [Claim Listing ]
Paathfind Education & Computer Classes Logo

Advance Excel Training Course

Learn advance excel from scratch. Our course is planned by industry specialists. You will get 100% practical clarification in our live classes. You will get numerous assignments and projects incorporated with every subject of this training program.

by Paathfind Education & Computer Classes
  • Price
  • Start Date
  • Duration
VMM Education Logo

MS Office

MS Office course is offered by VMM Education. Our commitment extends beyond traditional education, as we also provide specialized training in various industrial technologies through our intensive 6-months and 6-week training programs.

by VMM Education [Claim Listing ]
Edu4Sure Logo

MS Excel Course (Basic)

MS Excel course is offered by Edu4Sure. We at Edu4Sure are proud of our experienced and reputed trainers who aid us in delivering quality education, which is at par with the world. Our trainers go beyond national boundaries and include international experts in various fields.

by Edu4Sure [Claim Listing ]

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