Udemybeginneren

Excel 2016 Power BI - 10 Easy Steps for Beginners

Automate tasks & analyze data with Power Query and Power View. Learn to transform data & create insightful reports. Boost your data skills!

4.6(79)
534students
5h 8m
Certificate
Gilly Dow
Gilly DowIT Training Consultant

Course Content

Excel 2016 Power BI - 10 Easy Steps for Beginners is a beginner-level Udemy course taught by Gilly Dow. It runs 5h 8m, is taught in English, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 79 reviews, with 534 students enrolled. It is a paid course, last updated March 2019.

Unlock the Power of Data Visualization & Transformation with Power View & Power Query

Transform your Excel skills and gain powerful data analysis capabilities with this comprehensive course on Power View and Power Query for Excel 2016. Learn to create stunning, interactive reports and efficiently manipulate data from various sources.

What You'll Learn:

  • Power View: Discover the Power View canvas and create compelling data visualizations including charts, maps, matrices, cards, and callouts. Master data filtering techniques like Slicing and Tiling. Learn to work with multiple tables and establish relationships for deeper insights. Incorporate images and interactive maps to elevate your reports.
  • Power Query: Dive into the Query Editor and learn how to transform messy data into clean, usable datasets. Append multiple file types into a single data set. Merge tables – a powerful alternative to VLOOKUP! Combine multiple Excel files seamlessly. Utilize the Power Query "M" language to create custom columns. This powerful tool acts as an ETL tool, extracting, transforming, and loading data from almost any source.

Who is this course for?

  • Excel Users: Especially those using Excel 2016 daily and seeking to leverage the full potential of Excel Business Intelligence tools for improved reporting and data analysis.
  • IT & BI Specialists: Professionals responsible for data warehouse management who need to support analysts in extracting data from diverse analytical and relational sources.

What's Included:

  • Solid Instruction: Clear, step-by-step guidance to ensure you understand every concept.
  • Downloadable Files: Access all the necessary files to follow along with the course.
  • Practice Exercises & Solutions: Reinforce your learning with hands-on exercises and detailed solutions.
  • Supporting PDF User Guide: A comprehensive guide detailing all steps, practice exercises, and solutions.
  • Solution Video Lectures: Ensure you stay on track with video demonstrations before moving on to the next step.

Course Highlights:

This course focuses on practical skills you can immediately apply in your daily work. We'll build Power View reports and transform data with Power Query throughout the course. You'll have ample opportunity to practice creating your own queries and reports to consolidate, embed, and reinforce your learning.

System Requirements:

This course utilizes Excel 2016 and requires Power Pivot to be installed.

"Very enjoyable course with many real world examples. Gilly's enthusiasm for the Microsoft Wizardry is wonderful and spurs you on to master it. I look forward to more courses by Gilly!" - Douglas Paterson

"Very easy to understand" - Dale Pierce

Ready to take your Microsoft Excel skills to the next level? Click the TAKE THIS COURSE button to begin! Feel free to message me with any questions or explore the FREE preview lectures to learn more.

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0(76)
3h 51m
beginner
skillshare
5.0(179)
5h 59m
beginner
skillshare
5.0(308)
1h 35m
beginner
skillshare
5.0(234)
1h 36m
all
skillshare
5.0(346)
1h 6m
all
skillshare
skillshare