Microsoft Office & PowerBI
Microsoft Word
- Basics
- Objectives: Familiarize with the Word interface, create, and format documents.
- Activities: Hands-on document creation, formatting exercises, and group feedback.
- Advanced
- Objectives: Master advanced Word tools like templates and mail merge.
- Activities: Create templates and perform mail merge using sample data.
Microsoft Excel
- Basics
- Objectives: Understand the Excel interface, and enter and format data.
- Activities: Create budget spreadsheets, and conduct quizzes on formatting.
- Advanced
- Objectives: Analyze data using advanced tools like pivot tables and functions.
- Activities: Work on case studies and perform hands-on data analysis.
- Excel for Data Analysis
- Objectives: Use tools like Power Query and Power Pivot for analysis.
- Activities: Create dashboards and group projects analyzing datasets.
Microsoft PowerPoint
- Basics
- Objectives: Design effective presentations.
- Activities: Create sample presentations and practice peer presentations.
- Advanced
- Objectives: Develop advanced and interactive presentations with multimedia.
- Activities: Implement animations, transitions, and multimedia elements.
Power BI
- Introduction
- Objectives: Explore the interface and essential features of Power BI.
- Activities: Load sample data and navigate dashboards.
- Connecting to Data Sources
- Objectives: Learn to import data from multiple sources.
- Activities: Practice data connection and exploration.
- Basic Data Transformation
- Objectives: Clean and transform data using Power Query.
- Activities: Rename, filter, and reformat columns.
- Creating Visualizations
- Objectives: Build charts, graphs, and maps.
- Activities: Use sample datasets to create basic visualizations.
- Building Interactive Reports
- Objectives: Make dashboards interactive using slicers and filters.
- Activities: Create and explore dynamic reports.
- Introduction to DAX
- Objectives: Apply DAX formulas for calculations.
- Activities: Use functions like SUM and COUNT with data.
- Using Power BI for Projects
- Objectives: Implement Power BI skills in projects.
- Activities: Create a report or dashboard on a chosen topic.
- Sharing and Collaboration
- Objectives: Learn to share Power BI reports.
- Activities: Publish and collaborate using Power BI Service.
- Final Project
- Objectives: Showcase all learned skills in a comprehensive report.
Days : Monday- Saturday
Batches from : 10AM - 6PM
Duration of the Course : 3 Months - 24 hours