Pivot table basics in 30 minutes
Pivot table basics in 30 minutes, available at $19.99, with 9 lectures, and has 2 subscribers.
You will learn about Basic pivot table usage Defining the data Creating the first pivot Copying pivots, moving pivots and refreshing pivots Basic filters Manipulating pivot fields to display your summary Adding slicers to simplify your pivot analysis This course is ideal for individuals who are Anyone who work with lists of data who need to quickly slice and dice to summarise It is particularly useful for Anyone who work with lists of data who need to quickly slice and dice to summarise.
Enroll now: Pivot table basics in 30 minutes
Summary
Title: Pivot table basics in 30 minutes
Price: $19.99
Number of Lectures: 9
Number of Published Lectures: 9
Number of Curriculum Items: 9
Number of Published Curriculum Objects: 9
Original Price: £64.99
Quality Status: approved
Status: Live
What You Will Learn
- Basic pivot table usage
- Defining the data
- Creating the first pivot
- Copying pivots, moving pivots and refreshing pivots
- Basic filters
- Manipulating pivot fields to display your summary
- Adding slicers to simplify your pivot analysis
Who Should Attend
- Anyone who work with lists of data who need to quickly slice and dice to summarise
Target Audiences
- Anyone who work with lists of data who need to quickly slice and dice to summarise
Pivot tables made simple.
The techniques you need to master pivot tables and make your data analysis easier.
100s of hours of study and practice package into 30 minutes of practical and memorable ways to learn pivot tables and bring them into your toolkit.
What we’ll study:Defining and preparing the data, Creating pivot tables, Moving and copying pivots, Basic pivot analysis, Basic filters,
Advanced filters, Manipulating the pivot to display your summary and more!
Who I made this course for
Anyone who work with lists of data who need to quickly slice and dice to summarise
Meet your instructor
Adam Kramer
Spreadsheet fanatic Many years developing systems for organisations. Taught hundreds of in person and online sessions.
Frequently Asked Questions
1 Is this chalk and talk? No – we encourage you to work on the data as we go
2 I’ve tried to learn pivot tables before. Why will this work? We have a themed way to teach the syllabus in a memorable and easy to recall way
3 Do you do this course for Google Sheets? Yes, we do
4 Do I need prior experience of Pivot tables? No – we will take you from first principles, but you will need to have basic familiarity with Excel
Course Curriculum
Chapter 1: Introduction
Lecture 1: Basics of pivot tables
Lecture 2: Loading Sample data
Lecture 3: Creating our first pivot table
Lecture 4: Filtering and slicing
Lecture 5: Adding new data, refreshing pivots and multi reset of slicers
Lecture 6: Selecting, moving and copying pivot tables
Lecture 7: Tidying the summary page
Lecture 8: Numerical data – sum, count, average and max values
Lecture 9: Conclusion
Instructors
-
Adam Kramer
Trainer
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 0 votes
- 4 stars: 0 votes
- 5 stars: 0 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Learn to Fix iPhones and Start a Delivery Service
- Make Money With High Ticket Sales (Even If You're A Newbie)
- Masterclass: Start a Profitable Internet Cafe Business
- Google Analytics for Shopify: A Complete Step-by-Step Guide
- Creating Amazing Property Video (Using Your Smartphone)
- The Fundamentals of Business Intelligence (BI)
- Outsource Easier!
- Amazon SEO & Listing Optimization SECRETS to Double Sales
- Strategic Workforce Planning: A Fundamental Beginner's Guide
- Start A Start Hustle And Build A Second Income
- SPA RETAIL 101 – how to create a sales culture in your Spa?
- Beyond Upwork: How to Find Freelance Clients Outside Upwork
- How to manage event venue
- Ultimate Amazon FBA Mastery Course – Start With Any Budget
- The Gaming Youtube Masterclass
- Power BI Business User
- PMI – PgMP | 2024 Real Practice Exams (1150 Questions)
- Six Sigma: Certified Lean Six Sigma Green Belt | Accredited
- International B2B Trade Shows Management
- Project Management Guide for Human Resources (HR)