Advanced Excel Course Content

Learn Advanced Excel with AI, VBA and Google Sheets for a successful career.

Excel Fundamentals

Interface, workbooks and sheets

Cells, data entry and formatting

Cell references and AutoFill

Paste Special and data tools

Find, Replace and Freeze Panes

Printing and worksheet protection

Excel Tables and Formulas

Excel Tables and structured refs

Table expansion and calculated cols

Sorting, filtering and duplicates

Validation, drop-downs and ranges

Data-entry templates and controls

Formula syntax, operators and refs

SUM through SUBTOTAL and auditing

Logical Functions

IF and nested IF formulas

IFS for multiple conditions

AND, OR and NOT logic

IFERROR and IFNA handling

SWITCH for multiple choices

Multiple-condition calculations

Excel Text Functions

LEFT, RIGHT, MID and LEN

TRIM, CLEAN and text cleanup

UPPER, LOWER and PROPER

CONCAT and TEXTJOIN methods

FIND and SEARCH techniques

SUBSTITUTE and REPLACE text

TEXT and VALUE conversions

Date and Time Functions

TODAY, NOW and DATE

DAY, MONTH and YEAR

DAYS and date differences

EDATE and EOMONTH functions

WEEKDAY and WEEKNUM methods

WORKDAY and NETWORKDAYS

YEARFRAC, age and tenure

Lookup and Formula Design

VLOOKUP and HLOOKUP methods

XLOOKUP and LOOKUP methods

INDEX, MATCH and XMATCH

INDEX-MATCH and two-way lookup

Multiple-criteria lookup methods

CHOOSE, OFFSET and INDIRECT

LET, LAMBDA and reusable formulas

Conditional Aggregation

SUMIF and SUMIFS methods

COUNTIF and COUNTIFS methods

AVERAGEIF and AVERAGEIFS

MAXIFS and MINIFS functions

Multiple criteria analysis

Wildcard criteria techniques

Date and text conditions

Dynamic Arrays and Cleaning

Dynamic arrays and spill ranges

FILTER, SORT and SORTBY

UNIQUE, SEQUENCE and RANDARRAY

TRANSPOSE, TAKE and DROP

VSTACK, HSTACK, TOCOL and TOROW

Choose rows, cols, EXPAND and WRAP

Missing, duplicate data and types

Formatting and Excel Charts

Highlight and top-bottom rules

Data bars, scales and icon sets

Formula-based dynamic formatting

KPI and alert highlighting

Column, bar, line and pie charts

Scatter, combo and histogram charts

Pareto, waterfall, funnel and tree

Pivot Tables and Charts

Pivot Tables and field layout

Rows, columns, values and filters

Grouping and date grouping

Calculated fields and percentages

Running totals and ranking

Pivot Charts, slicers and timelines

What-If Analysis

Goal Seek for target values

Scenario Manager and scenarios

One-variable data tables

Two-variable data tables

Break-even and target profit

Pricing, loan and sensitivity

Financial Excel Skills

Financial statements and revenue

Costs, profit and margins

ROI and CAGR calculations

Budgeting and financial forecasts

Cash flow analysis methods

EMI, PMT, IPMT and PPMT

PV, FV, NPV, IRR and XIRR

Advanced Data Analysis

Descriptive statistics and mean

Median, mode and variance

Standard deviation and percentiles

Quartiles and outlier analysis

Correlation and covariance

Trends, growth and moving averages

Forecasting and business analysis

Business Reporting and MIS

Sales MIS and target reports

HR MIS and attendance reports

Finance MIS and expense reports

Inventory and stock reports

Achievement and performance reports

Receivables and payables reports

Stock ageing and management reports

Power Query Advanced Skills

Import files, folders and databases

Web data import and refresh

Cleaning and transformation steps

Merge, append, pivot and unpivot

Parameters and custom columns

Conditional and index columns

Functions, errors and refresh

Power Pivot and Data Model

Data Model and table relationships

Primary and foreign keys

Fact, dimension and star schema

Date tables for analysis

Calculated columns and measures

Stocks, Geography and linked types

Data types, formulas and structure

DAX and Advanced Power Pivot

KPI creation in Power Pivot

CALCULATE and filter context

Row context and context transition

Active and inactive relationships

Basic time intelligence methods

YTD, MTD and QTD analysis

YoY growth, variance and ranking

Excel Dashboard Development

Dashboard planning and layouts

KPI cards and key metrics

Slicers and timeline controls

Dynamic charts and reports

Dashboard navigation techniques

Sales, HR and finance dashboards

Inventory and executive reporting

VBA Programming

VBA Editor and macro basics

Modules, procedures and variables

Data types and conditions

Loops and custom functions

Arrays and collections in VBA

Error handling and debugging

Excel Object Model fundamentals

VBA Automation Skills

Workbook and worksheet automation

Range automation and processing

Automated formatting and reports

PDF creation and output

File and folder management

Email and report automation

Scheduled reporting workflows

Google Sheets Fundamentals

Sheets interface and spreadsheets

Worksheets and Drive integration

Data entry and formatting

References and Paste Special

Find, Replace and Freeze Panes

Sheet management and history

Sheets Data and Formulas

Sorting, filtering and filter views

Data validation and drop-downs

Checkboxes and smart chips

Duplicate data and templates

Protected ranges and protection

SUM, AVERAGE, COUNT and COUNTA

IF, SUMIF, COUNTIF and AVERAGEIF

Sheets Text and Date Tools

LEFT, RIGHT, MID and LEN

TRIM, CLEAN and text cleanup

UPPER, LOWER and PROPER

CONCAT, TEXTJOIN and SPLIT

FIND, SEARCH and SUBSTITUTE

REPLACE and REGEX functions

Dates, tenure and SLA calculations

Sheets Lookup Functions

VLOOKUP and HLOOKUP methods

XLOOKUP and LOOKUP methods

INDEX, MATCH and XMATCH

FILTER and QUERY lookups

CHOOSE, INDIRECT and OFFSET

UNIQUE, SORT and SORTN

TRANSPOSE and lookup arrays

Sheets Advanced Arrays

ARRAYFORMULA for full columns

FILTER, SORT and SORTN

UNIQUE and SEQUENCE arrays

TRANSPOSE and FLATTEN methods

TOCOL and TOROW functions

CHOOSECOLS and WRAP functions

HSTACK and VSTACK arrays

Sheets QUERY Function

SELECT and WHERE clauses

GROUP BY and ORDER BY

LABEL and FORMAT clauses

LIMIT and OFFSET controls

PIVOT and aggregation

Multiple-condition filtering

QUERY-based MIS reporting

Sheets Data Integration

IMPORTRANGE between workbooks

IMPORTDATA for external files

IMPORTHTML and IMPORTXML

Excel and CSV imports

Web and Drive data sources

Cross-sheet data connections

Cross-workbook reports and refresh

Sheets Collaboration & Pivot

Viewer, commenter and editor access

Link sharing and permissions

Comments, mentions and assignments

Version history and collaboration

Protected ranges for teams

Pivot Tables, charts and slicers

Interactive Pivot reports

Sheets Charts and Visuals

Column, bar and line charts

Pie, doughnut and area charts

Scatter, combo and histogram

Geo charts and scorecards

Gauge charts and sparklines

Dynamic and interactive charts

Sheets Dashboard Development

Dashboard planning and structure

KPI cards for key metrics

Sales, HR and finance dashboards

Inventory, lead and student reports

Slicers, filters and dynamic charts

Navigation and management reporting

Google Apps Script

Apps Script and SpreadsheetApp

Read and write spreadsheet ranges

Loops, conditions and functions

Custom functions and buttons

Automated emails and reports

PDF generation and time triggers

Forms, Drive and Gmail integration

AI for Excel and Sheets

Copilot, ChatGPT and Gemini

Generate formulas from English text

Explain, debug and convert formulas

Clean, categorize and extract data

Analyze datasets and find anomalies

Generate summaries and chart ideas

Generate VBA, Apps Script and docs

AI Verification and Quality

Test AI-generated formulas

Validate results and calculations

Check edge cases and exceptions

Review AI-generated VBA and scripts

Identify wrong functions and logic

Compare AI with manual results

AI Automation and Analysis

AI-generated VBA and Apps Script

Explain, debug and optimize code

Automation workflows and functions

Reusable automation design

Error handling with AI assistance

Code improvement and maintenance

Sales and HR MIS Projects

Sales data cleaning and formulas

Sales Pivot analysis and KPIs

Sales dashboard and management

HR employee, attendance and leave

HR salary and performance analysis

HR KPIs and dashboard development

Management reports for sales and HR

Finance and Inventory MIS

Finance revenue and expense data

Profit, receivables and payables

Cash flow and finance KPIs

Finance dashboard and management

Inventory, purchases and sales data

Closing stock, ageing and reorder

Inventory KPIs and dashboard

Students learning in an interactive classroom at Oxford School of Accounting Delhi

Accounting student preparing for a mock interview session at Oxford School of Accounting Delhi

A student gets ready for a mock interview, gaining real-world experience at Oxford Software Institute's professional training setup.

Student delivering a mock presentation to build communication skills at Oxford School of Accounting Delhi

Student confidently presents during a mock session, building communication and public speaking skills at Oxford Software Institute.

Accounting students celebrating together at a post-class party at Oxford School of Accounting Delhi

Students unwind and bond during a lively after-class party, celebrating learning and friendship at Oxford Institute.

Group of accounting students posing proudly after completing training at Oxford School of Accounting Delhi

After completing training, students confidently pose together, showing pride and achievement at Oxford Software Institute.

Students celebrate with fun games and team activities post class

Students taking part in group games and team building activities at Oxford School of Accounting Delhi

Accounting students gathered for a group photo after completing their batch at Oxford School of Accounting

A cheerful group of students gathers to celebrate completion of their computer training batch at Oxford Institute.

Students enjoying a creative tattoo making activity during a fun session at Oxford School of Accounting Delhi

Students participate in a fun and artistic tattoo-making session during their creative activity day at Oxford.

Accounting students relaxing and sharing light moments after class at Oxford School of Accounting Delhi

Students gather joyfully and share light moments after finishing their engaging computer class at Oxford.

Male students in ethnic outfits celebrating a festival at Oxford School of Accounting Delhi

Boys dressed in ethnic outfits celebrate a festive moment with joy and tradition at Oxford Software Institute.

Female students in traditional attire celebrating a cultural event at Oxford School of Accounting Delhi

Students proudly stand together after finishing their computer course batch at Oxford Institute, celebrating achievement and friendship.

Students holding certificates after completing their accounting course at Oxford School of Accounting Delhi

Female students at Oxford Software Institute in Delhi enjoy a cultural celebration, showcasing unity and festive spirit in traditional attire.

Students in vibrant traditional wear enjoying Garba dance on Dandiya Night at Oxford School of Accounting

Students proudly display their certificates after completing computer training at Oxford Software Institute, celebrating success and academic achievement.

Students attending a practical accounting training session in the computer lab at Oxford School of Accounting

Students of Oxford Software Institute enthusiastically celebrate Dandiya Night in Delhi, dressed vibrantly and enjoying traditional Garba dance together.

Students attending computer course classroom session at Oxford School of Accounting

A focused group of learners participate in a computer training session at Oxford Software Institute, gaining industry-relevant technical skills.

Accounting students celebrating Diwali with group photos and festive decorations at Oxford School of Accounting

Diwali celebration at Oxford Software Institute includes group photos, cheerful gestures, and festive ambiance highlighting team bonding and happiness.

Students building confidence and teamwork through a classroom roleplay activity at Oxford School of Accounting

Classroom roleplay sessions at Oxford Software Institute help students build confidence, communication skills, and teamwork through engaging activities.

Students performing Ramayan scenes in traditional costumes during a cultural fest at Oxford School of Accounting

Oxford Software Institute students artistically perform Ramayan scenes in traditional costumes, celebrating Indian heritage during a vibrant cultural fest.

Students and staff celebrating Christmas around a decorated tree at Oxford School of Accounting Delhi

Oxford Software Institute spreads Christmas cheer with a festive party, decorations, and students exchanging greetings in a joyful environment.

Students attentively following a computerised accounting class at Oxford School of Accounting Delhi

A disciplined classroom environment at Oxford Software Institute where students attentively follow computer training sessions to enhance technical expertise.

Accounting students taking a selfie and enjoying an interactive classroom session at Oxford School of Accounting

Interactive classroom at Oxford Software Institute where students take selfies, express joy, and celebrate camaraderie during learning sessions.

Students dressed as different characters during a creative cosplay party at Oxford School of Accounting Delhi

Students participated in a cosplay party at the institute, dressing up as various characters and celebrating with creativity and excitement in the classroom.

Cheerful accounting students raising hands and celebrating together in class at Oxford School of Accounting

A group of happy students cheerfully pose with raised hands, celebrating success and friendship in a vibrant and energetic classroom atmosphere.

Students in black and ethnic wear posing for a group photo after a celebration at Oxford School of Accounting

After a fun celebration, students dressed in black and ethnic wear gathered for a stylish group photo inside the institute’s corridor.

Faculty and students posing together after a campus placement drive at Oxford School of Accounting Delhi

Faculty and students pose together at the institute after a successful campus placement drive, celebrating learning, opportunity, and career preparation.

Students in colourful ethnic outfits celebrating a festive event in class at Oxford School of Accounting Delhi

Students dressed in vibrant ethnic outfits celebrated a festive cultural event, spreading joy and showcasing traditional Indian wear in the classroom.

WhatsApp your nearest Branch
Chat with Pitampura : 9953092792
Chat with Laxmi Nagar : 7217606821
Chat with Rajouri Garden : 9810735296
Chat with South Extension : 9810735296

WhatsApp your nearest Branch
Chat with Pitampura : 9953092792
Chat with Laxmi Nagar : 7217606821
Chat with Rajouri Garden : 9810735296
Chat with South Extension : 9810735296

Call your nearest Branch
Pitampura : 9540127373
Laxmi Nagar : 9540127878
Rajouri Garden : 9319608182
South Extension : 9810735296

Advanced Excel Course in Delhi

Master Advanced Excel , VBA with Google Sheets

Duration:

3 Months