Easy Installment Options Available

  • +91 9433200639
Book A Free Demo Class
Aptech Sonarpur Logo
Aptech Sonarpur Logo
Enroll Now
Book A Demo Class
Enroll Now

Advance excel

Course Curriculum

Course Overview

The Advanced Excel Course at Aptech Sonarpur is designed to help students, professionals, and entrepreneurs master the powerful tools and functions of Microsoft Excel. Whether you are managing data, generating reports, or analyzing business performance, this course equips you with practical, job-ready skills to work efficiently and make data-driven decisions.

Our hands-on training approach focuses on real-world business scenarios, enabling learners to confidently handle complex spreadsheets, automate repetitive tasks, and present data with clarity and precision.

By the end of this course, you’ll be ready to take on roles in data analysis, MIS reporting, accounting, and business management with a solid command over Excel’s advanced features.

What You Will Learn?

Sharing and Maintaining Workbook
  • Explain the new features of MS Excel 2013
  • Explain changing of the chart type of a PivotChart Report
  • Explain the procedure to add data by using FlashFill, AutoFill, and AutoComplete
  • Describe Text, Logical, and LookUp functions
  • 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

Course Curriculum

  • Duration

3 Months

  • Skill Level

Advance

  • Language

English, Bengali,Hindi

  • Certificate

After Completed

  • Eligibility

Anyone

  • Exit Profile

Excel specialist/ Data entry Specialist

Enroll Now

Fill up the below form and our team will get back to you regarding your query.

Fill the Form For Demo Class

Quick Enrollment Form