Microsoft Office & PowerBI

image description

Microsoft Word

  1. Basics
    • Objectives: Familiarize with the Word interface, create, and format documents.
    • Activities: Hands-on document creation, formatting exercises, and group feedback.
  2. Advanced
    • Objectives: Master advanced Word tools like templates and mail merge.
    • Activities: Create templates and perform mail merge using sample data.

Microsoft Excel

  1. Basics
    • Objectives: Understand the Excel interface, and enter and format data.
    • Activities: Create budget spreadsheets, and conduct quizzes on formatting.
  2. Advanced
    • Objectives: Analyze data using advanced tools like pivot tables and functions.
    • Activities: Work on case studies and perform hands-on data analysis.
  3. 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

  1. Basics
    • Objectives: Design effective presentations.
    • Activities: Create sample presentations and practice peer presentations.
  2. Advanced
    • Objectives: Develop advanced and interactive presentations with multimedia.
    • Activities: Implement animations, transitions, and multimedia elements.

Power BI

  1. Introduction
    • Objectives: Explore the interface and essential features of Power BI.
    • Activities: Load sample data and navigate dashboards.
  2. Connecting to Data Sources
    • Objectives: Learn to import data from multiple sources.
    • Activities: Practice data connection and exploration.
  3. Basic Data Transformation
    • Objectives: Clean and transform data using Power Query.
    • Activities: Rename, filter, and reformat columns.
  4. Creating Visualizations
    • Objectives: Build charts, graphs, and maps.
    • Activities: Use sample datasets to create basic visualizations.
  5. Building Interactive Reports
    • Objectives: Make dashboards interactive using slicers and filters.
    • Activities: Create and explore dynamic reports.
  6. Introduction to DAX
    • Objectives: Apply DAX formulas for calculations.
    • Activities: Use functions like SUM and COUNT with data.
  7. Using Power BI for Projects
    • Objectives: Implement Power BI skills in projects.
    • Activities: Create a report or dashboard on a chosen topic.
  8. Sharing and Collaboration
    • Objectives: Learn to share Power BI reports.
    • Activities: Publish and collaborate using Power BI Service.
  9. Final Project
    • Objectives: Showcase all learned skills in a comprehensive report.
Activities: Present findings and insights through a developed report.
Days : Monday- Saturday
Batches from : 10AM - 6PM
Duration of the Course : 3 Months - 24 hours
loader