Advanced Excel Course by Internshala
Learn Excel formulas, data visualization, pivot tables & more and earn a certificate accredited by IIT-Madras Pravartak.
Skills you will learn!
Curriculum
11 Topics
Training Overview Video
Get Started with Internshala Trainings
Introduction to Excel
Why Should we Learn Excel?
Orientation/Tour
Interface & Terminology
Excel Worksheets
Excel Ribbon
Backstage View
Quick Access Toolbar
Keyboard Shortcuts
12 Topics
Introduction-Food2Go
Cell Basics
Modifying Cells/Rows/Columns
Basic Cell Formatting
Cell Number Formats
Cut Copy & Paste
Format Painter
Personalizing Worksheets
Multiple Worksheets
Find & Replace
Sheet Protection
Printing & Page Layout
13 Topics
Introduction
Basic Formulas
Advanced Formulas
Cell References
Excel Functions
Date/Time Functions
Text Functions
Financial Functions
Logical Functions
Lookup Functions-1
Lookup Functions-2
Data Validation
Troubleshooting
6 Topics
Working with data
Freezing Options
Data Sorting
Data Filtering
Tables
Charts
4 Topics
Conditional Formatting
What-If Analysis
Pivot Tables
The End
2 Topics
Built-in Excel AI tools
Getting Started with Prompting
Advanced Excel Course
Related Excel Courses
Thank You!
Your review has been submitted successfully.