dots bg

Advance EXCEL - Professional Level

Grow your career by becoming an expert in a new field. Develop your skill over time and start small. Set up a portfolio of work that highlights your abilities and success, including samples of key customer engagements, industry awards and recognitions, case studies and recommendations.

 

₹11500.00 ₹15000.00 23% OFF

To enroll in this course, please contact the Admin
Contact Admin
dots bg

What You’ll Learn

  • 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