Entry Levels
Executives
Mid LevelsMs Excel Intermediate
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.
কোর্স ইন্সট্রাক্টর
কোর্সটি করে যা শিখবেন
- Professional Level Tables
- Important Functions
- Charts & Graphs
- Pivot Table & Chart
- Introduction to Dashboard
ক্লাস রুটিন
ডাউনলোড রুটিন| Sessions | Modules | Takeaways |
|---|---|---|
| Sessions 1: Professional Level Tables |
1 Benefits of Excel Table |
Class Practice Quiz 1 |
| Sessions 2: Important Functions | 7 Date & Time, Count and Sum Functions 8 Text Functions, Lookup Functions 9 Logical Functions, Use of Functions |
Class Practice Quiz 2 |
| Sessions 3: Charts & Graphs | 10 Benefits of Charts 11 Sort Data Before Charting Chart 12 Creating a Chart, Change Chart Type 13 Switch Row/Column, Chart Title 14 Data Labels, Display/Hide Gridlines 15 Remove Noise 16 Bar Chart, Column Chart, Line Chart 17 Pie Charts, Area Charts, Combined Chart 18 Gantt Chart, Histogram, Organization Chart 19 Gauge Chart, Sparkline |
Class Practice Quiz 3 |
| Sessions 4: Pivot Table & Chart | 20 Benefits of PivotTable & Pivot Chart 21 Creating a PivotTable 22 Formatting PivotTables * Arranging / Pivoting Data * Sorting and Filtering Data * Refreshing a PivotTable 23 Recommended PivotTables 24 Changing the Way Values are Displayed 25 Insert Slicers 26 Using Various Conditional Formatting Styles |
Class Practice Quiz 4 |
| Sessions 5: Introduction to Dashboard | 27 What is a Dashboard? 28 How Dashboard Differs from a Report? 29 Benefits of Dashboard 30 Things to Consider Before Creating a Dashboard 31 Tips to Create a Dashboard 32 Interactive Tools for Dashboard 33 Dashboard Do`s and Don'ts 34 Preparing Raw Data in Tabular Format |
Class Practice Quiz 5 |
কোর্স সম্পর্কে বিস্তারিত
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.