Certificate Courses IN ADVANCE EXCEL

Last updated Nov, 2025
Certified Course

₹4,999 ₹5,999

Enquire Now

Duration3 Months
Enrolled0
Lectures90
Videos0
Notes0
CertificateYes

What you'll learn

The Advanced Excel Course is designed to enhance your data analysis and reporting skills using Microsoft Excel. It covers advanced formulas, functions, data validation, pivot tables, charts, dashboards, and automation using macros. This course helps students and professionals improve productivity, accuracy, and decision-making in business and data management tasks.

Course Syllabus

Introduction to MS Excel and Understanding Basic Working with it
Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets, and the Difference between Excel 2003, 2007, 2010, and 2013
Saving Excel File as PDF, CSV, and Older versions
Using Excel Shortcuts with Full List of Shortcuts
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns, and Sheets Using Paste Special Options
Formatting Cells, Rows, Columns, and Sheets
Protecting & Unprotecting Cells, Rows, Columns, and Sheets with or without a Password
Page Layout and Printer Properties
Inserting Pictures and Other Objects in Worksheets
Conditional Formatting
Using Conditional Formatting
Using Conditional Formatting with Multiple Cell Rules
Using Color Scales and Icon Sets in Conditional Formatting
Creating New Rules and Managing Existing Rules
Data Sorting and Filtering
Sorting Data A-Z and Z-A
Using Filters to Sort Data
Advance Filtering Options
Pivot Tables
Creating Pivot Tables
Using Pivot Table Options
Changing and Updating Data Range
Formatting Pivot Table and Making Dynamic Pivot Tables
Pivot Charts
Creating Pivot Charts
Types of Pivot Charts and Their Usage
Formatting Pivot Charts and Making Dynamic Pivot Charts
VBA Macro
Introduction to VBA Macro
Recording Macro & Understanding Code Behind
Editing, Writing VBA Code, and Saving as Macro or Add-In
Adding Add-Ins in Excel

Course Fees

₹5999/-

Discounted Fees

₹ 4999/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Certificate Courses IN ADVANCE EXCEL

What you'll learn

Course Syllabus

Course Fees

Review

Featured review

More Popular Courses

ADVANCE DIPLOMA IN COMPUTER APPLICATION

DIPLOMA IN COMPUTER APPLICATION

Related Courses

CERTIFICATE COURSE IN BASIC COMPUTER

CERTIFICATE COURSE IN TALLY PRIME