Excel 2013 PowerPivot Playlist of Videos faq

instructor Instructor: / instructor-icon
duration Duration: duration-icon

Gain an introduction to Excel 2013 PowerPivot Playlist of Videos

ADVERTISEMENT

Course Feature Course Overview Course Provider Discussion and Reviews
Go to class

Course Feature

costCost:

Free

providerProvider:

Youtube

certificateCertificate:

No Information

languageLanguage:

English

Course Overview

❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 24th, 2023]

Throughout the course, students will learn how to import large non-normalized datasets and reduce file sizes, effectively replacing VLOOKUP with Excel 2013 Data Model and Relationships. They will discover the power of DAX formulas, which can offer greater efficiency and speed compared to array formulas. Furthermore, the course delves into importing external Excel tables and building a data model using the SUMX function.

Learners will also become proficient in editing existing connections, importing new data, and updating existing reports, gaining a deeper understanding of measures (calculated fields) and various DAX functions through nine practical examples. The course showcases the CALCULATE function's capabilities to change filter contexts with 14 illustrative examples.

Moreover, the course explores group-by-date functionalities in both Excel PivotTable and PowerPivot PivotTable, as well as creating calendar table calculated columns for enhanced data analysis. Learners will also learn how to simulate VLOOKUP helper columns using array formulas and discover how to perform approximate match lookups without VLOOKUP using Excel and PowerPivot DAX formulas.

After completing this course, students will be equipped to navigate and exploit the PowerPivot feature confidently, enhancing their data modeling and analysis skills. They can apply their newfound knowledge to optimize data manipulation, derive valuable insights, and build dynamic reports and dashboards efficiently. With a solid foundation in PowerPivot and DAX formulas, learners can unlock a world of possibilities for advanced data analysis in Excel.

Course Provider

Provider Youtube's Stats at AZClass

Discussion and Reviews

0.0   (Based on 0 reviews)

Start your review of Excel 2013 PowerPivot Playlist of Videos

faq FAQ for Power Pivot Courses

Q1: How do I contact your customer support team for more information?

If you have questions about the course content or need help, you can contact us through "Contact Us" at the bottom of the page.

Q2: Can I take this course for free?

Yes, this is a free course offered by Youtube, please click the "go to class" button to access more details.

Q3: How many people have enrolled in this course?

So far, a total of 0 people have participated in this course. The duration of this course is hour(s). Please arrange it according to your own time.

Q4: How Do I Enroll in This Course?

Click the"Go to class" button, then you will arrive at the course detail page.
Watch the video preview to understand the course content.
(Please note that the following steps should be performed on Youtube's official site.)
Find the course description and syllabus for detailed information.
Explore teacher profiles and student reviews.
Add your desired course to your cart.
If you don't have an account yet, sign up while in the cart, and you can start the course immediately.
Once in the cart, select the course you want and click "Enroll."
Youtube may offer a Personal Plan subscription option as well. If the course is part of a subscription, you'll find the option to enroll in the subscription on the course landing page.
If you're looking for additional Power Pivot courses and certifications, our extensive collection at azclass.net will help you.

close

To provide you with the best possible user experience, we use cookies. By clicking 'accept', you consent to the use of cookies in accordance with our Privacy Policy.