icmt.in

ICMT

Academy

WEST BENGAL GOVT. REGD. NO. : L/78128 

AN ISO 9001 : 2015 CERTIFIED INSTITUTE

ADVANCE EXCEL

Have you been looking for a Professional Training Institute where you can learn Microsoft Excel in depth? Join ICMT’s Basic & Advanced Excel Training in Kolkata to learn Excel from scratch or brush up on your skills with the help of our seasoned professionals. Our Basic & Advanced Excel Course Syllabus will teach you everything you need to know to analyze data at any level.

We at ICMT offer an application-oriented Basic & Advanced Excel Course Syllabus that has been expertly crafted by subject matter specialists to meet the needs of the international corporate sector. Our Basic & Advanced Excel course curriculum, which is put together by industry experts, includes an understanding of how to set up Excel sheets with various functions and formulas, pivot tables, and data visualization. Explore our comprehensive Advanced Excel training in Kolkata whose courseware covers everything from the fundamentals to advanced skills.

Basic Excel Course Syllabus

  • Font formatting
  • Number formatting
  • Table formatting
  • Conditional formatting
  • Hide / Unhide
  • Sort/filter
  • Paste special
  • Find and select

Insert

  • Illustrations
  • Charts
  • Text

Page Layout 

  • Page Setup
  • Sheet Options
  • Themes

Basic Functions

  • Adding extra columns, rows and clear function
  • Sum / Average / Count / Max / Min / Product / Quotient / Percentage
  • Basic Text / date / time / lookup / information functions
  • Name manager
  • Formula Auditing
  • Absolute, Mixed and Relative Referencing
  • General Formula
  • Blank Rows or, Column Emission
  • Insert function

Text Functions

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Extract
  • Concatenate
  • Find, Substitute

Arithmetic Functions

  • SumIF, SumIFs, CountIFs, AverageIF, AverageIFs

Data

  • Import from web
  • Import from text
  • Text to columns
  • Remove duplicates
  • Grouping and ungrouping

Review

  • Proofing
  • Comments
  • Protection

Views

  • Types of views
  • Zoom
  • Windows
  • Freeze panes

Developer

  • Enable developer
  • Using checkbox/option buttons
  • Marcros

 

Date / Time Functions

  • Using The Today
  • Now & Date Functions

Validations

  • Input Messages / Error Alerts / Drop-Down Lists
  • Conditional Formatting

Hyper / Data Linking

  • Hyper linking data, within sheet / workbook
  • Linking & Updating links between workbooks & application

Sharing and Protecting Workbooks

  • Sharing Workbooks & Tracking Changes
  • Protecting sheets/workbooks / Files