Skip to Main Content

7 sessions
4 Quizzes
Certificate

কল করুন নম্বরে +8801896037201

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	Use a formula to combine multiple conditions. Use VBA code to apply additional formats	Conditional Formatting
Class- 2	Sankey Diagram Likert Scale Chart Comparison Bar Chart Gauge Chart Multi-Axis Line Chart Sunburst Chart Radar Chart Redial Bar Chart Dot Plot Chart	Advance Excel Charts and Graphs Quiz-Class (1 & 2)
Class- 3	Drop Down List One Variable Data Table in Excel Two Variable Data Tables in Excel Scenarios Goal Seek in Excel	Data Validation Data Analysis Quiz- Class 3
Class-4	Count Function Counta Function Countblank Function Countifs Function Average, Min, Mode, Median, Standard Deviation Function SQRT, Product Function	Mathematical & Statistical Functions
Class- 5	Value to return	VLOOKUP Function Quiz- Class (4&5)
Class- 6	If Function Count If Sum Average	Nested Function Database Function
Class - 7	Text Function Error-checking Trace errors Circular References	Data Cleaning Formula Auditing and Comments Quiz- Class (6&7)

কোর্স সম্পর্কে বিস্তারিত

আরও কোন জিজ্ঞাসা আছে?

কল করুন +8801896037201 নম্বরে