Advance Excel – Professional Level - Excelcomputerinstitute

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.

1. Formulas for Financial Application

Loan Calculation
PMT
PPMT
IPMT
RATE
NPER
PV

2. Performing spreadsheet what-if analysis

Types of what if analysis
Creating data table
Use of Scenario of manager
Managing Scenario manager
Displaying Scenarios
Introduction of solver
Appropriate of Solver

3. Count and sum Function

Count
COUNTA
COUNTBLANK
COUNTIF
SUMIF
SUMIFS

4. Macro

What is macro
Assign macro
Delete Macro
Run Macro

5. Using Data Validation

About data Validation
Specifying validation criteria
Types of Validation
Drop down list of data validation
Setup of Stop, Information, warning

6. Using Excel in a workgroup

Using Excel on a Network
Sharing workbook
Understanding shared workbook
Controlling the advance sharing setting
Resolving conflicting changes between users

7. Analysing data with pivot table

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

8. Making Worksheet error free

Finding and correcting formula errors
Cells are filled with hash marks
Formulas running an error

9. Dashboard in Excel

Import data
Filter data
Audit report
Create charts
Polish charts
Connection with charts and data

10. Share

PDF
Share Workbooks
Online
Import Access Data
Microsoft Query
Import/Export Text Files
XML

11. Formulas and Functions

Enter a Formula
Edit a Formula
Operator Precedence
Copy/Paste a Formula
Insert Function
Most Used Functions

12. Logical Functions

If
And
OR
Not
Absolute Value

13. Date & Time Functions

Year, Month, Day
Date Function
Current Date & Time
Hour, Minute, Second
Time Function
Today’s Date
Calculate Age
Weekdays

14. Text Functions

Left
Right
Mid
Len
Find
Substitute
Text to Columns
Flash Fill

15. Statistical Functions

Average
Averageif
Median
Mode
Min
Max
Large
Small

16. Round Function

Round
RoundUp
RoundDown

Overview
Eligibility Criteria
Certification
Duration

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.

DiTRP ( Digital Information Technology & Research For Professional)

CBITVT : Central Board of IT & Vocational Training.

MKCL : Maharashtra Knowledge Corporation Limited

45 Days.

Overview