Data Science
Finance Account
Health and Fitness
Management
Marketing
Personal Development
UI / UX Design
Web Development
Home
Home 1
Home 2
Courses
Courses Style 1
Courses Style 2
Course Detials 3
Pages
Standard Blog
About
Instructors
Cart
Checkout
Instructor Registration
Student Registration
Login
404
Blog
Contact
Home
Home 1
Home 2
Courses
Courses Style 1
Courses Style 2
Course Detials 3
Pages
Standard Blog
About
Instructors
Cart
Checkout
Instructor Registration
Student Registration
Login
404
Blog
Contact
Type to search..
Excel & Advance Excel
Home
Courses
Excel & Advance Excel
M
Instructor:
MadsInstitue
Category:
Uncategorized
Last Update:
May 30th, 2025
Ratings:
Excel & Advance Excel
Overview
Curriculum
Review
Instructor
Topics of Course
Excel Introduction
An Overview and Introduction
Various Selection Techniques
Shortcut Keys
Customizing Excel
Customizing the Ribbon
Using and Customizing Auto Correct
Using Basic Functions
Sum, Average, Max, Count
Absolute, Mixed and Relative Referencing
PMT/PPMT/IPMT/ETC
Formatting and Proofing
Currency Format
Format Painter
Formatting Dates
Custom and Special Formats
Formatting Cells with Number Formats
Conditional Formatting
Tables
Mathematical Functions
SumIf, SumIfs
Counta, Count Blanlk, Countif, Countifs
AverageIf, AverageIfs, AND, OR, NOT
Text Functions
Upper, Lower, Proper
Left, Mid, Right
Trim, Len, Exact, Concatenate
Date and Time Functions
Today, Now
Day, Month, Year
Date, Date if, Date add
Month, Weekday
Advanced Paste Special Techniques
Paste Formulas, Paste Formats
Paste Validations
Transpose Tables
Sorting and Filtering
Filtering on Text, Numbers & Colors
Sorting Options
Advanced Filters Different Criteria(S)
Printing Workbooks
Setting Up Print Area
Customizing Headers & Footers
Designing the Structure of A Template
Print Titles –Repeat Rows / Columns
Logical Functions
If Function
How to Fix Errors – If error
Nested If
Data Validation
Number, Date & Time Validation
Text and List Validation
Custom validations
Dynamic Dropdown List
Lookup Functions
Vlookup
Hlookup
Creating Smooth
User Interface Using Lookup
Pivot Tables
Creating Simple Pivot Tables
Basic and Advanced Value Field Setting
Classic Pivot table
Choosing Field
Filtering Pivot Tables
Modifying Pivot Table Data
Grouping Based on Numbers and Dates
Calculated Field & Calculated Items
Charts and Slicers
Bar Charts / Pie Charts / Line Charts
Using Slicers, Filter Data with Slicers
VBA Macro
Introduction to VBA
Variables in VBA
If and Select Statements
Looping in VBA
Project
Stock Management System
Advanced Attendance Sheet
Hotel Booking System
Retail Management System (MIS)
Automated Certificate Generation
Your Instructor
M
Follow Me:
MadsInstitue
33 Students
14 Courses
Free
Enroll Now
Free access this course
Hi, Welcome back!
Keep me signed in
Forgot Password?
Sign In
Share This Course
Share Course
Page Link
Share On Social Media
Courses You May Like
Free
(0)
Certificate in Ms Office
0 Students
MadsInstitue
Free
(0)
Advance Diploma in Computer Application
0 Students
MadsInstitue
Free
(0)
Diploma in Computer Application
0 Students
MadsInstitue
Copyright © 2024
Edumon
. All rights reserved.
