Tanvir Academy Excel Course Topics
Class No Topics/Outline Class No Topics/Outline
Office Update Version vs Old Version Name Manager
Excel Back Stage View/File Menu Go to Special
Excel Interface BODMAS
Quick Access Toolbar Add, Subtract, Multiply, Divided
Add or Remove Command Relative Reference
Create Tab Absolute Reference
Rename Tab Row Reference
Delete Tab Column Reference
Add Group Mixed Reference
Add Options in Groups Sum
Clipboard Group Sum IF
Font Group Sum IF (Wildcard)
Paste Special Sum IFS
Text Orientation Average
Wrap Text Average if
Merge & Center Average ifs
Merge Tricks Max
Shrink Fit Maxifs
Format Painter Min
Custom Currency and Comma Minifs
Custom Date Product
Date File Series Count
Class-01,02 and 03
Write Large Number Counta
Class-04,05 and 06
Mobile Number with Code CountBlank
Kg/Pcs with Number CountIf
Cell Style CountIfs
Cells Group Multiple Number Count Formula
Change sheet Color Is number
Sheets Hide/Unhide Is text
Sheets Copy/Move/Cut Exact
Group Magics/ Formatting worksheet after grouping. Indirect Formula
Custom List Text Restriction in Cell with Data Validation
Find and Replace Number Restriction in Cell Data Validation
Header & Footer Date Restriction in Cell
Page Number Double Entry Restriction in Cell
Watermark Text/Number Length Entry Restriction in Cell
Print Breaks Upper/Lower/Proper Case Restriction in Cell
Print Area Depending on Dropdown
Margins Hyperlink Existing Sheet
Orientation Link URL/Website
Size Link with Name Box
Print Titles Link with Name Box
Scaling Edit Hyperlink
Collated Remove and Clean Hyperlink
Hyperlink Screen tips
Stop Auto Hyperlink
Page 1 of 3
Tanvir Academy Excel Course Topics
Class No Topics/Outline Class No Topics/Outline
Round Subtotal
Round Up Group & Ungroup
Round Down Subtotal Function
Trunc Protect & Unprotect
Sort Protect Without Formatting
Sort by Column Protect Select Cell
Sort Color Hide Formula
Sort by Row Rank
Add Lebel (Sort) Rank Function with count if
Sort Function PV Function
Sortby Function FV Function
Filter Rate Function
Filter with blank rows PMT Function
Filtering & Sorting NPER Function
Picture Filter IPMT Function
Advanced Filter PPMT Function
Filter Unique Name CUMIPMT and CUMPRINC Function
Filter Function IF, IFS
Unique Function And, Or, Not
Split Full Name to First & Last Name And+IF
Flash Fill Or+IF
Text to Columns Type of Error
(&) Formula Row and Column Function
Class- 07 and 08 Class- 9, 10 and 11
Text join and Concatenate Serial number
Substitute Formula Dynamic Serial Number With Subtotal
Text and Data Cleanup Serial Number with if Formula
ToCol Serial Number with IF & Aggrement Formula
ToRow Conditional Formatting
Time Calculation Duplicate and Unique Value Formatting
Time Formula Text Formatting
Import PDF Data Conditional Formation with Formula
Import Website Data Clear Rules
Text Functions Date Formatting, Date Wise Formatting
Today Weekday wise Formatting
Edate Between Date Formatting
Expiry Date Excel Grater/Less Then Value Formatting
Eomonth Top/Bottom Value Wise Formatting
Date Value Data Bars, Color Scale
Weeknum Blank Cell Conditional Formatting
Weekday Error Cell Conditional Formatting
Day, Days Conditional Formatting Entire Row and Columns
Year, Yearfrac Expiry Date Conditional Formatting
Dated if Retirement Age wise formatting
Age Calculation Auto Border
Workday Highlight Fri and Sat
[Link] 2 Data Compeer with Conditional Formatting
Page 2 of 3
Tanvir Academy Excel Course Topics
Class No Topics/Outline Class No Topics/Outline
Convert Number to Word English Chart
Convert Number to Word Bangla Customized Chart
Advance Table (Format as Table) Bar Chat
Table Properties Column Chart
Table Tools Line Chart
External Table Data Pai Chart
Table Style Doughnut Chart
Excel To PowerPoint Area Chart
How to Use Macro Map Chart
Record Macro Sparklines
Create Default Font Short cut. Scenario Manager
Make Own Macro Goal seeks.
Macros Some Project Pivot Table Basic
Lookup Class- 14,15 and 16 Grouping
Class- 12 and 13 Hlookup Custom Grouping
Vlookup Basic Show value as
Double Vlookup Pivot Table Options/Setting
Vlookup with IF Error Calculated Fields
Vlookup with others sheet Filter & filter reports Page
Index Timeline in Pivot
Match Slicer & Slicer settings
Vlookup with Match Filter & filter reports Page
Vlookup vs Index Match Pivot Chart
Duplicate Value Lookup MIS Report
XLookup Data Model
Lookup Multiple Reference Relationship in Pivot Table
Picture Lookup Dashboard Design
Choose Salary Sheet (Recorded Video)
Vlookup with choose Marksheet (Recorded Video)
Recorded Video Invoice (Recorded Video)
Data Entry Form (Recorded Video)
Final Exam
Page 3 of 3