Description
Curriculum
Instructor
These days, there are tons of data coming in from many sources. You are expected to import all of that data and get meaningful results from that data. This course is specifically designed to enable you on how to go about it effectively & efficiently.
On Completion of this course, you’ll be a pro in the following concepts & processes:
- Normal Pivot Table Formulas
- Sorting & Filtering the Pivot Table
- Calculated Items
- Calculated Fields
- Conditional Formatting in the PivotTable
- Consolidated Pivot Tables
- Importing data from Excel into PowerQuery–normal data
- Splitting & Merging Columns in the PowerQuery
- Calculate age in the PowerQuery
- Adding Custom Calculations in PowerQuery
- Importing data from a website into the PowerQuery
- PowerQuery–formatted tables
- Importing Access, SQL Server, and textfiles into PowerQuery
- Append Queries
- GroupBy Queries
- Merge Queries
- Managing Table Relationships
- Slicers & Timelines in PowerPivot
- Using Sets in PowerPivot
- Importing Data directly into the PowerPivot
- Measures & KPI’s in PowerPivot
Some exceptional benefits associated with this course enrolment are:
- Quality course material on Excel PowerQuery and PowerPivot
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
It’s time for you to grab the opportunity and make the most out of this course.
Enroll today!!
Tom Fragale
0 Students14 Courses
I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.
₹299.00
₹269.00
100% positive reviews
0 student
26 lessons
Language: English
0 quiz
Assessments: Yes
Available on the app
Unlimited access forever
Skill level All levels
Courses you might be interested in
The ability to study each potential buyer and respond immediately and appropriately to their verbal and physical cues. In this course, you” go through the history of psychology in...
-
15 Lessons
₹449.00
Discover The Hidden Secrets Of Beating Anxiety! On Completion of this course, you’ll be able to: Discover How To Banish Worry & Live An Anxiety Free Life! Learn How...
-
10 Lessons
₹599.00
Secrets They NEVER Taught You In School Or Life! On Completion of this course, you’ll be: Talking In A Way That Your Children Will Listen & Change! Knowing The...
-
13 Lessons
₹599.00
Using the Power of Social Media to Attract a Crowd of Loyal Customers. On Completion of this course, you’ll be: In no longer need to “run an ad” and...
-
39 Lessons
₹449.00