![](https://veritasacademybd.com/backend/new_site/images/1701600607-1586039755Excel Intermidiate to advanced.jpg)
MS Excel Intermediate to Advance Level
কোর্স ইন্সট্রাক্টর
Md Tanzim Rahman
Expert in Risk Analysis and Mitigation, Data Visualization, and Project Management; BBA (AUST), Former Project manager at JAGGO Foundation
কোর্সটি করে যা শিখবেন
- Variety of advanced level Functions, Advanced Charts, Lookup, Paste Special, Scenario Formulas Auditing and Locking, and Security
- Extracting unique values from a list
- Auditing formulas and troubleshooting common Excel errors
- Importing data and cleaning it up before analysis
- Create advanced chart
ক্লাস রুটিন
Lessons | Modules | Topics |
---|---|---|
Class- 1 |
|
Conditional Formatting |
Class- 2
|
|
Advance Excel Charts and Graphs Quiz-Class (1 & 2) |
Class- 3
|
|
Data Validation Data Analysis Quiz- Class 3 |
Class-4 |
|
Mathematical & Statistical Functions |
Class- 5
|
|
VLOOKUP Function Quiz- Class (4&5) |
Class- 6 |
|
Nested Function Database Function |
Class - 7
|
|
Data Cleaning Formula Auditing and Comments Quiz- Class (6&7) |