Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Power BI and Excel Business Modeling Combo Pack
Rating: 4.6 out of 5(32 ratings)
1,139 students

Microsoft Power BI and Excel Business Modeling Combo Pack

Build Powerful Models: Design & Build High-Performance Data Models in Excel & Power BI
Created bySaad Nadeem
Last updated 1/2025
English

What you'll learn

  • At the end of this course students will be able to analyse data from different data sources and create their own datasets
  • Explore powerful artificial intelligence tools and advanced visualization techniques
  • Blend and transform raw data into beautiful interactive dashboards
  • Showcase your skills with two practical projects (with step-by-step solutions)
  • Business Intelligence
  • Dashboarding
  • DAX
  • Data Modeling
  • Master Microsoft Excel and its many powerful features
  • Get routine tasks faster than ever
  • Create Business models with multiple scenarios
  • Become a skilled user who can work with Excel functions, summary tables, previews, and advanced features
  • Become one of the best Excel users on your team
  • Get Business modeling skills
  • Design professional, good-looking advanced diagrams

Course content

2 sections • 44 lectures • 5h 42m total length

  • Business Plus Financial Modeling Course Info1:47
  • Data Cleaning and Reformatting Tricks9:37
  • Calculate Employee Age10:05
  • Inserting Cell Fitted Pictures Automatically in One Click10:10
  • Apply Auto Search Boxes8:33

    Learn to build an auto search box in excel using an ActiveX combo box, named range employees, linked cell, and macro-enabled workbook steps for autocomplete and dropdown.

  • Employee Data Extraction Technique8:24

    Apply vlookup and match functions in Excel to automatically retrieve an employee's joining date by typing the name, using named ranges and dynamic column indexing.

  • Employees Lookup Formula Application to All6:54
  • Creating Picture Lookups9:21

    Use index match to retrieve employee data and related pictures by naming ranges and creating a picture lookup defined name, replacing vlookup where needed.

  • Formatting Cells and Currency Defaults6:48

    Learn to use mail merge with Excel and Word to automate personalized salary notices and cheques, and format cells and currencies, including rupees, for bulk payroll and supplier payments.

  • Convert Amount In Figures to Amount in Words5:57
  • Edit Fields and Merge Results in Main Merge4:09
  • Toggle Field Codes to Apply Comma Style4:16
  • Configure Gmail Account on Outlook 20164:14

    Configure Gmail with Outlook 2016 to enable mail merge from Word using Excel data, sending personalized emails to hundreds of customers with a pending balance.

  • Sending Emails From Outlook Final6:05
  • Database Management Part 111:45
  • Database Management Part 27:06
  • Database Management Part 31:14
  • Database Management Part 48:42
  • Database Management Part 55:15
  • Database Management Part 65:33
  • Database Management - Creating Charts and Static Dashboards11:46
  • Database Management - Convert Static Charts to Dynamic Charts4:49

    Convert a static dashboard into a dynamic one by using a timeline and slicers to filter pivot charts and connect to pivot tables via report connections.

  • Power Pivot Introduction14:56
  • Using Power Pivot for Pivot Table11:10
  • Using Scenario Manager11:40
  • Collecting Bulk Data From People Automatically16:48
  • Customizing Google Forms7:59

    Change the theme color, header image, and logo to tailor Google Forms. Use templates, sections, and end messages to streamline data collection and present a professional survey.

  • How to Email Google Forms Professionally6:13
  • Automated Cloud Backup for Files7:06
  • Funds Management Part 16:00
  • Funds Management Part 29:42
  • Funds Management Part 34:39

    Learn to calculate days left on emi payments in Excel, using today(), subtraction, and if to show upcoming payments, filter out past due items, and set auto reminders.

  • Funds Management Part 49:59
  • Depreciation Schedule Part 18:09
  • Depreciation Calculation Straight Light Part 26:21
  • Depreciation Calculation Straight Light Part 34:56

Requirements

  • Microsoft Power BI Desktop (free download)
  • This course is designed for PC/Windows users (currently not available for Mac)
  • Absolutely no experience is required. We will start from the basics and gradually build up your knowledge with clear and concise step by step instructions

Description

Unleash the full potential of your data with this comprehensive combo pack!

Do you spend countless hours wrestling with spreadsheets and struggling to find meaningful insights? Are you ready to level up your data analysis skills and unlock the power of visual storytelling? This dynamic course is your ticket to mastering the dynamic duo of Microsoft Excel and Power BI, equipping you with the tools and techniques to transform raw data into actionable insights.

What You'll Learn:

  • Excel Business Modeling: Deepen your understanding of Excel functions, formulas, and data manipulation techniques to build robust and flexible data models.

  • Power BI Power Play: Master Power Query, the data cleansing and shaping engine, and DAX, the powerful formula language, to transform and analyze your data with ease.

  • Visual Storytelling: Craft compelling visuals using Power BI's stunning charts and graphs to tell a clear and impactful data story.

  • Automated Insights: Streamline your workflow with automated reports and dashboards, freeing up your time for deeper analysis.

  • Real-World Applications: Put your skills to the test with practical case studies and exercises, tackling real-world business challenges across various industries.

By the end of this course, you'll be able to:

  • Design and build high-performance data models in both Excel and Power BI.

  • Clean, shape, and analyze your data with confidence using Power Query and DAX.

  • Create stunning visuals and interactive reports that communicate insights effectively.

  • Automate routine tasks and generate dynamic reports to increase efficiency.

  • Make data-driven decisions that drive business growth and optimize performance.

This course is perfect for:

  • Business analysts, data analysts, and financial analysts

  • Marketing professionals, sales managers, and operations leaders

  • Entrepreneurs and anyone who wants to gain valuable data analysis skills

  • Beginners with basic Excel knowledge and those wanting to transition to Power BI

Don't just manage data, master it! Enroll today and experience the power of data analysis with Excel & Power BI.

Bonus: Includes access to exclusive practice files, downloadable resources, and instructor support to ensure your success.

This course description includes strong keywords, highlights the benefits of learning both Excel and Power BI, outlines specific learning outcomes, and speaks directly to the target audience. It also incorporates a call to action to encourage enrollment.

Remember to customize the description further to reflect your specific course structure and unique selling points.

I hope this gives you a strong starting point!

Who this course is for:

  • Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Aspiring data professionals looking to master the #1 business intelligence tool on the market

Report abuse