Reset Password

Advance Excel 

(Professional Level)

 

At the advance level, most users typically process large quantities of data using spreadsheets, graphs, data tables, calculations, and automation to produce results. Advanced level users can also build Excel spreadsheet models, dashboards, and templates that basic and intermediate users can use. 

  • Loan Calculation
  • PMT
  • PPMT
  • IPMT
  • RATE
  • NPER
  • PV
  • Types of what if analysis
  • Creating data table
  • Use of Scenario of manager
  • Managing Scenario manager
  • Displaying Scenarios
  • Introduction of solver
  • Appropriate of Solver
  • Count
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • SUMIF
  • SUMIFS
  • What is macro
  • Assign macro
  • Delete Macro
  • Run Macro
  • About data Validation
  • Specifying validation criteria
  • Types of Validation
  • Drop down list of data validation
  • Setup of Stop, Information, warning
  • Using Excel on a Network
  • Sharing workbook
  • Understanding shared workbook
  • Controlling the advance sharing setting
  • Resolving conflicting changes between users
  • Pivot table from non-numeric data
  • Grouping pivot table items
  • Automatic grouping
  • Filtering pivot table with slicers
  • Connection for two or more pivot table
  • Creating Pivot Charts
  • Finding and correcting formula errors
  • Cells are filled with hash marks
  • Formulas running an error
  • Import data
  • Filter data
  • Audit report
  • Create charts
  • Polish charts
  • Connection with charts and data
  • PDF
  • Share Workbooks
  • Online
  • Import Access Data
  • Microsoft Query
  • Import/Export Text Files
  • XML
  • Enter a Formula
  • Edit a Formula
  • Operator Precedence
  • Copy/Paste a Formula
  • Insert Function
  • Most Used Functions
  • If
  • And
  • OR
  • Not
  • Absolute Value
  • Year, Month, Day
  • Date Function
  • Current Date & Time
  • Hour, Minute, Second
  • Time Function
  • Today’s Date
  • Calculate Age
  • Weekdays
  • Left
  • Right
  • Mid
  • Len
  • Find
  • Substitute
  • Text to Columns
  • Flash Fill
  • Average
  • Averageif
  • Median
  • Mode
  • Min
  • Max
  • Large
  • Small
  • Round
  • RoundUp
  • RoundDown

Whether you are considering a career in data analytics or looking to enhance your skills on the job, Excel training can be valuable in preparing you for a variety of promising roles.

  • SSC Completed / HSC Completed
  • Pursuing or Completed  B.COM / BMS / BBA / BBI / BAF / BFM / M.COM / CA / CS.
  • Accounting Students
  • Other Undergraduates / Graduates.
  • SSC : Smart Skill Council Certification.

OR

  • DiTRP ( Digital Information Technology & Research For Professional)

OR

  • CBITVT : Central Board of IT & Vocational Training.

OR

  • MKCL : Maharashtra Knowledge Corporation Limited

45 Days.

Overview

Whether you are considering a career in data analytics or looking to enhance your skills on the job, Excel training can be valuable in preparing you for a variety of promising roles.

Eligibility Criteria
  • SSC Completed / HSC Completed
  • Pursuing or Completed  B.COM / BMS / BBA / BBI / BAF / BFM / M.COM / CA / CS.
  • Accounting Students
  • Other Undergraduates / Graduates.
Certification
  • SSC : Smart Skill Council Certification.

OR

  • DiTRP ( Digital Information Technology & Research For Professional)

OR

  • CBITVT : Central Board of IT & Vocational Training.

OR

  • MKCL : Maharashtra Knowledge Corporation Limited
Duration

45 Days.

×