Skip to content
Advanced Excel Certification Course with AI & ChatGPT
About the Course
Expand
About the Course
2 Topics
Welcome to TechVidvan
Important Note
Getting Started with Excel
Sample Lesson
Collapse
Getting Started with Excel
7 Topics
Introduction to Interface
Navigating Sheets and Workbooks
What is Ribbon
Entering and Editing Data
Basic Formatting: Fonts, Alignment, Number Formats
Working with Cell Ranges and Selections
Saving, Sharing and Collaborating
CR1
Working with Formulas and Functions
Expand
Working with Formulas and Functions
9 Topics
Understanding Formulas: Operators and Cell References
Basic Functions: SUM, AVERAGE, COUNT
Working with Dates and Times
Introduction to Logical Functions: IF, AND, OR
Common Text Functions: CONCATENATE, LEFT, RIGHT, MID
More on Functions: MIN, MAX, MEDIAN
Array Formulas Basics
Error Handling in Formulas
ISNA and IFERROR Function in Excel
CR-2
Managing Sheets and Workbooks
Expand
Managing Sheets and Workbooks
5 Topics
Advanced Sheet Operations
Jumping Between Sheets
Mastering Multiple Workbooks
Hiding and Unhiding Rows and Columns
Freezing Panes and Splitting Screens
Data Formatting and Presentation
Expand
Data Formatting and Presentation
7 Topics
Conditional Formatting: Highlighting Data
Creating and Applying Cell Styles
Working with Tables
Sorting and Filtering Data
Charts and Graphs: Creating Visualizations
Customizing Charts: Formatting and Design
Sparklines: Visual Data in Cells
CR-3
Data Analysis Tools
Expand
Data Analysis Tools
7 Topics
Sorting and Filtering Data Advanced Techniques
Working with Pivot Tables Creating Interactive Reports
Pivot Charts Visualizing Pivot Table Data
What if Analysis Goal Seek
Data Tools in Excel
Data Validation Ensuring Data Integrity
Importing and Exporting Data CVS Excel
CR-4
Advanced Formulas and Functions
Expand
Advanced Formulas and Functions
7 Topics
Lookup Functions Vlookup Index Match Xlookup
Statistical Functions: COUNTIFS, AVERAGEIFS, STDEVIFS
Array Formulas Working with Ranges of Data
Financial Functions PMT, NPV, IRR, FV, PV
Advanced Text Functions LEN, PROPER, TRIM, FIND, SEARCH
Advanced Working with Dates and Times
Advanced Logical Functions
Power Query for Data Transformation
Expand
Power Query for Data Transformation
6 Topics
Introduction to Power Query and Data Import
Data Cleaning and Transformation
Adding Columns and Combining Data
Power Query Automation and Web Scraping
Loading Data and Best Practices
Power Pivot
CR-6
Excel Automation with Macros and VBA
Expand
Excel Automation with Macros and VBA
6 Topics
Introduction to Excel Automation and Macros
Getting Started with the VBA Editor
VBA Fundamentals Variables and Data Types
Working with Objects: Ranges, Worksheets, and Workbooks
Automating Tasks and User Interaction
Debugging Error Handling and Macro Security
AI Features in Excel
Expand
AI Features in Excel
3 Topics
Analyze Data Feature, Generating Insights and Visualizations
Data From Picture Extracting
Forecasting with Forecast Sheet – Predicting Future Trends
CR-7
Tips and Tricks
Expand
Tips and Tricks
2 Topics
Keyboard Shortcuts and Productivity Tips
Optimizing Performance for Large Datasets
Building Interactive Dashboards
Expand
Building Interactive Dashboards
2 Topics
Planning and Designing Dashboards
Slicers and Timelines for Interactive Filtering
CR-8
Previous Topic
Next Topic
Navigating Sheets and Workbooks
LMS
Advanced Excel Certification Course with AI & ChatGPT
Getting Started with Excel
Navigating Sheets and Workbooks
Previous Topic
Back to Lesson
Next Topic
Fill the form to proceed
Upskill & get ready for AI-era
Please leave this field empty.
Δ
Our executives will contact you shortly
X
Have Questions?
Talk directly to the Instructor
Please leave this field empty.
Δ
Our executives will arrange a call with the Instructor shortly
X
Career Counselling
Please leave this field empty.
Δ
X
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Signup / Login with
Google
Signup / Login with
X
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
