Advanced Excel – kavitacomputers.in

About Course

Master powerful Excel tools for data analysis and reporting. Learn formulas, Pivot Tables, dashboards, and automation techniques. Ideal for professionals, accountants, and data-focused roles.

Master advanced Excel formulas and nested functions
Use Pivot Tables & Pivot Charts for powerful data analysis
Automate tasks using Macros and basic VBA
Build interactive dashboards with slicers and charts
Apply advanced lookup functions (XLOOKUP, INDEX-MATCH)
Use Power Query for data cleaning and transformation
Perform advanced data validation and conditional formatting
Analyze large datasets efficiently

Course Content

Excel Tutorial

Excel Introduction
Excel Get Started
Excel Overview
Excel Syntax
Excel Ranges
Excel Fill
Excel Move Cells
Excel Add Cells
Excel Delete Cells
Excel Undo and Redo
Excel Formulas
Excel Relative References
Excel Absolute References
Excel Addition Operator
Excel Parentheses
Excel Functions

Excel Formatting

Excel Data Analysis

Excel Sort
Excel Filter
Excel Tables
Excel Conditional Formatting
Excel Highlight Cell Rules
Excel Top/Bottom Rules
Excel Data Bars
Excel Color Scales
Excel Icon Sets
Excel Manage Rules
Excel Charts

Table Pivot

Excel Case

Excel Functions

Excel AND Function
AVERAGE Function
Excel AVERAGEIF Function
Excel AVERAGEIFS Function
Excel CONCAT Function
Excel COUNT Function
Excel COUNTA Function
Excel COUNTBLANK Function
Excel COUNTIF Function
Excel COUNTIFS Function
Excel IF Function
Excel IFS Function
Excel LEFT Function
Excel LOWER Function
Excel MAX Function
Excel MEDIAN Function
Excel MIN Function
Excel MODE Function
Excel NPV Function
Excel OR Function
Excel RAND Function
Excel RIGHT Function
Excel STDEV.P Function
Excel STDEV.S Function
Excel SUM Function
Excel SUMIF Function
Excel SUMIFS Function
Excel TRIM Function
Excel VLOOKUP Function
Excel XOR Function

Excel How To

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Excel Tutorial

Excel Introduction

Excel Get Started

Excel Overview

Excel Syntax

Excel Ranges

Excel Fill

Excel Move Cells

Excel Add Cells

Excel Delete Cells

Excel Undo and Redo

Excel Formulas

Excel Relative References

Excel Absolute References

Excel Addition Operator

Excel Parentheses

Excel Functions

Excel Formatting

Excel Formatting

Excel Format Painter

Excel Format Colors

Excel Format Fonts

Excel Format Borders

Excel Number Formats

Excel Format Grids

Excel Regional Format Settings

Excel Data Analysis

Excel Sort

Excel Filter

Excel Tables

Excel Conditional Formatting

Excel Highlight Cell Rules

Excel Top/Bottom Rules

Excel Data Bars

Excel Color Scales

Excel Icon Sets

Excel Manage Rules

Excel Charts

Table Pivot

Introduction Excel PivotTable

Excel Case

Excel Case: Poke Mart Shop Cart

Excel Case: Poke Mart, Styling

Excel Functions

Excel AND Function

AVERAGE Function

Excel AVERAGEIF Function

Excel AVERAGEIFS Function

Excel CONCAT Function

Excel COUNT Function

Excel COUNTA Function

Excel COUNTBLANK Function

Excel COUNTIF Function

Excel COUNTIFS Function

Excel IF Function

Excel IFS Function

Excel LEFT Function

Excel LOWER Function

Excel MAX Function

Excel MEDIAN Function

Excel MIN Function

Excel MODE Function

Excel NPV Function

Excel OR Function

Excel RAND Function

Excel RIGHT Function

Excel STDEV.P Function

Excel STDEV.S Function

Excel SUM Function

Excel SUMIF Function

Excel SUMIFS Function

Excel TRIM Function

Excel VLOOKUP Function

Excel XOR Function

Excel How To

How to Convert Time to Seconds using Excel

How to Find the Difference Between Two Times Using Excel