MS Excel Application
কোর্স ইন্সট্রাক্টর
কোর্সটি করে যা শিখবেন
- Budgeting and financial planning
বাজেটিং এবং ফাইন্যানশিয়াল প্ল্যানিং করতে পারা - Visually presenting data histogram, Pareto, descriptive statistics
-
Data Histogram, Pareto and Descriptive Statistics
ভিজুয়ালি উপস্থাপন করা
-
Data modeling and Pivot table
ডেটা মডেলিং এবং পিভট টেবিল সম্পর্কে শেখা -
Data validation
ডেটার শুদ্ধি পরীক্ষা
ক্লাস রুটিন
Sessions | Contents & Takeaways | Learning Hierarchy |
---|---|---|
Session 1: |
Introduction to Excel Interface |
▪ Interface of Excel |
Session 2: |
Worksheet Format |
▪ Row Height & Column Width Scale. |
Session 3: | Manage Workbook |
▪ Insert & Delete Worksheet |
Session 4: | Print Solutions |
▪ How to print large worksheet properly in A4 size page |
Session 5: | Data Entry Tricks |
▪ Paste Options |
Session 6: | Conditional Formatting |
▪ Highlight Cell As Per Various Rules |
Session 7: | Data Validation | ▪ Drop Down List for Easy Data Entry ▪ Dependent Drop-down List ▪ Create Custom Data Validation Messages ▪ Encrypt a File & Protect Structure from unauthorized Data Entry |
Session 8: | Dynamic Table | ▪ How to Insert Excel Table ▪ Various features of Table ▪ Dynamic Calculation in Table ▪ Duplicate Data Remove in Table ▪ Slicer in Table |
Session 9: | Formula & Functions | ▪ Difference between Formula & Function ▪ Functions Basic Arithmetic Operations ▪ Edit & Copy Formulas ▪ Cell References practical example ▪ Formula Audit ▪ Text Function ▪ Trim ▪ Vlook-up ▪ Advance V-lookup ▪ Index Match ▪ If/ Ifs /Iferror ▪ Is, CountIf, Sumif, CountIfs, Sumifs, CountA, Countblank, Count, Concatenate, etc) ▪ Detail practical use of logical functions to prepare report with multiple conditions. |
Session 10: | Charts | ▪ Create Charts ▪ Move and resize & change Chart ▪ Format and Edit Objects in a Chart ▪ Change Chart Source Data ▪ Change Chart Type and workwith Pie Chart. ▪ Dual Axis/ Combo Chart ▪ Sparkline ▪ Forecast Chart |
Session 11: | Pivot Table & Pivot Chart | ▪ Summarizing Data: ▪ Grouping and Categorizing: ▪ Filtering and Sorting: ▪ Calculating Percentages and Ratios: ▪ Identifying Trends and Patterns: ▪ Comparing Data Sets: ▪ Visualizing Data: ▪ Drilling Down into Details: ▪ Handling Missing or Incomplete Data: |
কোর্স সম্পর্কে বিস্তারিত
Take your Excel skills to the next level with our Practical Excel Applications course. In this hands-on program, you'll delve into the real-world applications of Excel, solving common business and data management challenges.