top of page

A Premier IT Software Training Institute I Call Us Behala: 9874268039 / 9330148679, Hazra: 9339408422 / 03340731111

Aptech Learning | Unleash Yor Potential

website decoration

website decoration

Learn basics of Advanced Excel

Advanced MS Excel

MS Excel Courses in West Bengal

Duration: 2 months

Eligibility: Basic Excel Knowledge

Languages: English

Leave Your Phone Number We Will Arrange a Call Back

How to be a financial analyst in kolkata

Exit Profile

Financial Analyst

Explain the new features of MS Excel 2013

Explain customization of the Ribbon and the Quick Access Toolbar

Explain the procedure to add data by using FlashFill, AutoFill, and AutoComplete

Explain proofing and management of Add-ins

Describe built-in and custom templates in Excel

Describe worksheet protection and locking/unlocking of cells

Explain protection, finalization, and encryption of a workbook

Explain the concept of shared workbooks

Explain the procedure for change tracking in a shared workbook

Explain the process of recovering unsaved versions of a file

Trace formula precedents and dependents

Use the data validation tool and check for errors in a file

Implement iterative calculations

Use single cell and multi cell array formula

Use SUMIFS(), COUNTIFS(), and basic counting functions

Describe the Quick Analysis Tool for Data Analysis

Describe Data consolidation

Describe mathematical, trigonometry, statistical, and financial functions , Date, Time, Data Type and Conversion Functions

Describe Text, Logical, and LookUp functions

Conditional Formatting

Understand conditionally control code flow (loops & control structures)

Use PL/SQL packages to group & contain related constructs

Create triggers to solve business challenges

Use PL/SQL packages to generate screen & file output

Create anonymous PL/SQL blocks, functions & procedures

Declare PL/SQL variables

Manage PL/SQL subprograms, triggers, declaring identifiers & trapping exceptions

Understand & influence PL/SQL compiler and manage dependencies

Create anonymous PL/SQL blocks, focusing on stored procedures & functions

Understand conditionally control code flow (loops & control structures)

Use PL/SQL packages to group & contain related constructs

Create triggers to solve business challenges

Use PL/SQL packages to generate screen & file output

Create anonymous PL/SQL blocks, functions & procedures

Declare PL/SQL variables

Manage PL/SQL subprograms, triggers, declaring identifiers & trapping exceptions

Understand & influence PL/SQL compiler and manage dependencies

Create anonymous PL/SQL blocks, focusing on stored procedures & functions

Understand conditionally control code flow (loops & control structures)

Use PL/SQL packages to group & contain related constructs

Create triggers to solve business challenges

Use PL/SQL packages to generate screen & file output

Create anonymous PL/SQL blocks, functions & procedures

Declare PL/SQL variables

Manage PL/SQL subprograms, triggers, declaring identifiers & trapping exceptions

Understand & influence PL/SQL compiler and manage dependencies

Create anonymous PL/SQL blocks, focusing on stored procedures & functions

Understand conditionally control code flow (loops & control structures)

Use PL/SQL packages to group & contain related constructs

Create triggers to solve business challenges

Use PL/SQL packages to generate screen & file output

Create anonymous PL/SQL blocks, functions & procedures

Declare PL/SQL variables

Manage PL/SQL subprograms, triggers, declaring identifiers & trapping exceptions

Understand & influence PL/SQL compiler and manage dependencies

Create anonymous PL/SQL blocks, focusing on stored procedures & functions

Related Course

R programming Courses in West Bengal

R Programming

2 months

advanced GST Courses in West Bengal

GST Pro

1 months

ecommerce website development Courses in West Bengal

Smart Pro E-Commerce

7 months

Autocad Courses in West Bengal

Autocad

3 months

website decoration

Advanced Ms Excel Courses in West Bengal

25 K

Learner

#STARTYOURCAREER

Take your career to new heights

bottom of page