• Home
  • Blog
  • Newsletter
  • Site Map

Best Online Short Courses

Self-paced and Tutor-led Online Education Suggestions:

Learn Business Data Analysis with Microsoft Excel and Power BI

August 14, 2020

Microsoft Excel is the world’s most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will increase your productivity and you will be seen as a very efficient, highly competent and indispensable partner in the organization’s progress. Power BI is Microsoft’s business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it, you can create reports with drill-down features, access-level restrictions, auto-refresh, alerts/triggers, and interactivity.

The Udemy course “Business Data Analysis with Microsoft Excel and Power BI” focuses on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. This course is designed mainly for business professionals who use Excel a lot at work.

Business Data Analysis

Business Data Analysis with Microsoft Excel and Power BI Course Content

This course teaches you how to be more productive and creative in your use of Microsoft Excel and Power BI for business and reporting. It enables you to:

  • Become proficient in using PivotTables for analyzing a large data;
  • Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get the last item, INDEX and MATCH to make automated dynamic dashboards/reports;
  • Use Sorting in more advanced ways: multi-level sorting, sorting left to right;
  • Create professional and great looking charts in Excel and understand when to use a particular chart type;
  • Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time;
  • Make a sample Excel VBA user form that gets data from user and input into a table in Excel;
  • Learn Power BI and other new interesting business data analysis tools by Microsoft.

The training is constantly being updated with new interesting content. The goal is to have the most comprehensive and up-to-date business data analysis with Excel and Power BI course. The Course currently comprises 53 Lectures organized into the following sections:

  • Introduction
  • Data Manipulation in Excel and setting the foundation.
  • Charts
  • Creative Excel Use and Tips
  • Business Data Analysis
  • Live Session on Advanced Filtering, Custom List, Data Validation, Charts…
  • Power BI
  • Excel VBA
  • Difference Between Data Analysis, Business Analysis, BI and Big Data
  • Demonstration of Pivot Table vs Power Pivot vs Power BI

Requirements

  • The training requires having Excel 2010 and above. Excel 2007 will also work but you won’t be able to practice the PowerPivot example.
  • You will also need Power BI Desktop installed, it is free from Microsoft.
  • You also must be ready to practice every topic covered as there are companion practice-files for every topic.

Summary of Course Main Features

  • Instructor: Michael Olafusi
  • Lectures: 54
  • Article: 1
  • On-demand video: 12.5 hours
  • Downloadable Resources: 37
  • Includes:
    • 30-Day Money-Back Guarantee
    • Full lifetime access
    • Access on mobile and TV
    • Certificate of Completion

Click the link below for details of any special offers on this course

Visit the Course Page

 

Related

Similar Posts You May Like:

alison business intelligenceLearn How to Use Excel 2013 Power Business Intelligence – Free Course Excel From Beginner To AdvancedMaster Microsoft Excel from Beginner to Advanced Data AnalysisLearn About Data Manipulation in R Programming – Free Course Learning ExcelMicrosoft Excel: From Beginner to Advanced Udemy Excel Crash CourseLearn Excel Shortcuts, Formulas & Functions for Financial Modeling big dataData to Insight: An Introduction to Data Analysis – A Free Course Alison R ProgrammingLearn About R Programming for Data Statistical Computing – Free Course Udemy SQL for NewbsSQL for Newbs: Data Analysis for Beginners Linked DataLearn The Power Of Linked Data With This Free Online Course tableau 10Learn Tableau 10 for Data Science with Real-Life Data Analytics Exercises

Filed Under: Business Management, Lectures, Statistics & Data Analysis Tagged With: BI, Big data, Business Analysis, Data Analysis, Excel, Microsoft Excel, Power BI

Search this Site

About This Site

This site provides information on self-paced and tutor-led online short courses - some of them are free, some are on special offer, and all are excellent value. Use the Search Box, the Main Topics drop-down box, or the Tag Page to find courses that interest you.

Main Topics

Tag Page

Complete List of Tags

Video Marketing Machine

Video Templates

*New customer offer! Top courses from $12.99 when you first visit Udemy.

*New customer offer! Top courses from $12.99 when you first visit Udemy.

*New customer offer! Top courses from $12.99 when you first visit Udemy. End Date: 03/31/2021.

Web Hosting Deal

Web Hosting

Get a Career in Computer Science

Coursera Purple CS Design 3

Textbooks: Rent. Buy. Sell.

Check Your Grammar

The #1 Writing Tool

Free Trial to Create Awesome Videos

Content Samurai Free Trial

Lifetime Learning Access to Eduonix – Only A Few Places Left

Lifetime Access to Eduonix Courses

Amazon Offers

Amazon Prime Free Trial

Sign up for Free Weekly Newsletter

Best Online Courses Newsletter

Enter your email address below to receive a weekly summary with new learning suggestions.

Amazon Gift Ideas

Follow

RSS feed RSS - Posts

Important Links

Contact Us

Terms of Use

Privacy Policy

Best Degree Programs

Online and Distance Learning Degrees

Job Search

Job Search

Copyright © 2023  Best Online Short Courses