Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Video quality	The size	Download

Information Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Title	:	Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
Lasting	:	14.48
Date of publication	:
Views	:	13 jt

Sir, very easy to understand, nicely explained, and humorous too which is nice for the learning process
Comment from : Random Learning

Hey Jon I really hope you answer my question, so I have a sheet that has empty cells and once I follow your video the values don’t show is this problem due to the empty cells if so is there a way to solve it?
Comment from : Nou Al

wow your explanation was so clear!!
Comment from : Lynn Neroli

I really ❤ this brMakes Pivot table really easy😊
Comment from : Casey Emmanuel

is the source file available to download ?
Comment from : yulen_li

Jon thank you 🙏🏻🙌
Comment from : Sangetha Ramasamy

Hi Jon I've taken many tutorials on Excel and Pivot tables, but your tutorial and exercises along with the worksheets are the best Though I had a little trouble downloading the worksheet for this video, I was able to grab another data set from another one of your tutorials and practice along I feel so much more comfortable in doing V lookups and pivot tables Just what I needed as a refresher course This was great!
Comment from : C Wray

Hello John Your video was helpful and has contributed to improving on my excel and presentation skills I remain grateful and will continue to follow up on your new videos
Comment from : Sahr Kellie

I wish some of the webinars were offered on the weekends
Comment from : Viola Jackson

Thank you soo much for sharing this
Comment from : Viola Jackson

thanks
Comment from : Opeyemi Odedere

What a great explanation, Thank you Sir 🙏👍
Comment from : its mer

Great
Comment from : Cynthia Amaechi

A good Instructor could make his student understand better and are one of those
Comment from : Darna kUNO

Thank you for sharing
Comment from : Gisann T

Love it and you explained it so well-thanks
Comment from : Zahida Bibi Elaheebocus

😊
Comment from : AnonymusCro anonymus

I need the excel files, please @Jon
Comment from : nd

Thank you !
Comment from : Zaheer Siddiqui

Jon this is the best pivot tables explanation one could ever ask for Thanks
Comment from : Alfred Kaburuk

Useful, Didactic, Simple Straight to the point Well done
Comment from : Francois Simonpietri

Jon, I'm watching your Class down here in Tanzania, East Africa I learnt quite much from your friendly lecture Thank you very much and GOD Bless you AmenbrbrI have a question; Which Program of Microsoft excel are you using!!? From my Computer I couldn't find "pivot pal" How can I get a latest program and enjoy what you are guiding in your Classes!!? Thanks
Comment from : amani Msuya

I do understand what data to place on role, but what metric do I use to differentiate data for column and values
Comment from : shedrack johnny

its really hard to locate the file to download please make it easier
Comment from : Earthy Mountain Bike

thanks so much u have clearly made undastand this lesson
Comment from : Muhammed Lamin Ceesay

You are a God saver
Comment from : Okey Ani

Amazing video The way you tackle every details was really understandable You explain very well This the one i'm looking for Thank you very much Jon
Comment from : carmelo ducusin

Sir thanks you for helping me ace my assessment ❤
Comment from : Butcher in Gaming

Where can I download your exercise table
Comment from : Michael Brayan Uy

Can you pls share this excel file for practise
Comment from : Ganesh Pansare Education

Thank you
Comment from : ALIBUGHA, JOSHUA

I'm excited I will now use this to analyses my trades Thanks so much
Comment from : Zapp Zap

What type of jobs we can try with this
Comment from : anu arunachalam

Jon, you made the Pivot table and PivotalPal so easier I could catch in one go Thank you so much!
Comment from : Indra Adhikari

My pivot chart is blank
Comment from : Crystal Little

Thanks for the update and videos for am adding more to My knowledge
Comment from : JULIET UZOAMAKA

your excellency thanks sir a question the the each head in head-row is named as row labels ? these are head row head names
Comment from : waqas ahmad

Where can I get the data used in this video?
Comment from : Tonye Jim-George

Where is the 🔗 to download the data in pdf format
Comment from : waqas ahmad

I’m tardy, but this was very thorough
Comment from : Kenneth Davis

MrJon I learned Pivot table through your channelIts really amazing great work,continue it for career growth of people through out the universe
Comment from : mgrnmgrn

Great video! Thank you!
Comment from : AJ

Hello Thanku so much very useful video any freelance websites other than upwork and fiverr to get jobs
Comment from : PriyasCrochet

do you have data used in this video?
Comment from : Daku berbicara

Wondering if you could share that data sheet or have a recommendation of where to download any samples
Comment from : C-LOS

Thank You for making such a nice & informative video! Now to practice!
Comment from : Hugh Atkins

Best tutorial video
Comment from : colleen motshidisi

Thank you so mach it was very useful ,but I could not find the way how you make a shortcut PivotPal because I don't find the XL Campus in my Excel
Comment from : Wa3d 04

Thank you so muchbrbrThis is in deep one of the best videos I've come across on herebrbrThat being said, I can lay my hands on the raw data even after going through the link provided Any help?
Comment from : Ayodeji odunukan

UR A LIFESAVER LOVE YOU
Comment from : Kelsey Elizondo

Pivot Tables (Excel) Crosstab Query (SQL)
Comment from : mehmet mustafa aslan

HELLO
Comment from : Myka Antoinnette Chelsea LIM

Excel is indeed a powerful tool and knowing how to use it is a great differentiator and can bring you a huge professional prominence Knowing different functions, graphics and knowing how to apply them to your problems, will certainly bring you an absurd differential
Comment from : Office Faixa Preta

what if we dont want see sum of values, and want individual values shown ?
Comment from : Best Only

Thank you so much this is really easy to understand and follow appreciate it, big time 👍👍👍
Comment from : Edzel Bagorio

Made this so simple compared to any other videos that these "Excel Experts" post
Comment from : GT MOTORCARS LLC

I learned something new and it's wowthank you
Comment from : Jeanita Murugan

I love you! I work on management systems, and analyze data a lot, this is so helpful!
Comment from : Mariele Dhane Bael

Thank you so much Jon 🌺 this is very useful for my new role brbrLike I said to my boss five million times “I’m going to be excellent at Excel !” 😂😅
Comment from : Gayathree Goonewardene

Awsome help, I learned alot
Comment from : Ramon Tinoco

Hi Jon - Pivot Pal is just out of the box No one would have expected or thought about this You are just awesome Can I get your linkedin id please?
Comment from : Saifnsay

@6:32 Question: If you update the data set will the Pivit tables update themselves?
Comment from : Jeff Baker

you're saving lives here Jon Thanks
Comment from : actionong

could do hospital data
Comment from : Jacko Namoka

Jon made me laugh when he kept saying this was "very easy" even though there are a large number of steps for wach function and he is an expert in this For the nivice it is VERY complex and confusing
Comment from : Doug jOHNSON

Amazing thank you!
Comment from : JN

Hi Jon! Thank you for this video, it was very helpful and pretty easy However I noticed that number 19 has blank columns for the shipped date and shipped name columns Kindly advise
Comment from : Judith Lolomari

I am andy 😭
Comment from : Harshal Mahadik

What is the formula for restating a date in a separate cell from mm/dd/yyyy to yyyy-mm?
Comment from : Jay Byrne

This was a tremendous tutorial I choose to decline a job offer because my lack of knowledge however, I have studied and practised I have made excellent process and will continue to practice and reapply for another role with confidence Thank you!
Comment from : 9

Short Video with huge value 👌brbrThank you
Comment from : Adekunle Enitan

Great video I received a promotion at my job and I'm using your videos to help me with my trainings I will be working on several reports and metrics, so I appreciate this video I took an excel training that involved pivot tables and charts, and I must say, if you don't use it, you'll lose it Your video will be saved
Comment from : Isharah Knox

What MS Excel version has the pivot Tables
Comment from : Lewis Chris Puringi

sir, Good eve ,where do we get the XL Campus Ribbon in Excel sheet🙂
Comment from : TRUST IS MORE PRECIOUS

Thanks men Really appreciated
Comment from : Aj christian delos santos Manliguez

can we create pivot table from a table? i see youre using a filter in data tab
Comment from : Microsoft1

I appreciated the clarity of the explanation I am quite new to Excel and everything was clearly explained
Comment from : Andreea Sandra Marian

hey john, what excel do you use, i have no pivotpal in my excel
Comment from : Lea Lyn AVILA

Thanks for this video Can this be used with qualitative data as well?
Comment from : Lillian McDonald

No doubt being a great teacher implies being an artist too, you are both a great teacher and an artist showing us how to use excel
Comment from : Topsy Turvyy

Thank you so much for this video, I started a new position and they were talking about pivot table, I thought it was the hardest thing ever
Comment from : Nondumiso Khumalo

I was afraid of pivot tables and charts but you made it clear and easy for me THANK YOU so much 👍👍👍👍
Comment from : Flor Bermudez

Wish he had explained how to find blank cells in a heap of data and how to deal with them prior to proceeding with the process
Comment from : Alex Wainaina

I recently started to learn the different functions in using a pivot table and adding charts for work My boss is letting me take charge in creating analysis around different areas for our department This was most helpful
Comment from : Simply Nayeli

Great, we'll elaborate thanks for sharing
Comment from : LEARNING AND TRAVEL WITH HAZEL

Hello, I want to inform you that the video was really helpful to me I was practising it along with you and enjoyed the process I missed a job opportunity because I could not generate the pivot Table as directed This is a wao!!!! moment for me now
Comment from : Victor Malaolu, PhD

Good morningbrPlease say maybe the series in one video to be arrangedbrI would be very grateful to you
Comment from : محمد السيد عبدالنبى عبده مراد

Dear please tell me how can we add xl campus in bar, As this is not shown in excel
Comment from : MNaveed Khalid

goood one
Comment from : Payuer tut

Amazing, a kinda big help More power Excel Campus-Jon!
Comment from : Larry Cruz

life best tool in excel and really surprised for results its superb
Comment from : Basit Sheikh

SUPER HELPFUL
Comment from : Emily Spencer

Andy could save himself a lot of work if he wasn't such a people pleaser LOL
Comment from : A Mind In OverDrive

thank ufor make it it easy
Comment from : The Batik’s Traveller

gr8
Comment from : kairavi Dave

Thank you for this! what a life saver!
Comment from : Jerome Mae Borlasa

i can't believe how much i have learned in such a short time by watching your videos Thank you so much
Comment from : Ravi Kumar

This video is literally saving my life right now lol! I have worked in AR and considered myself to be an expert at Excel until I started my new job! My new job is very Excel-heavy I am familiar with Pivot Tables, but I didn't realize how much I did not know until I started this job I didn't understand the sum column in the Pivot Table until I saw your tutorial Now it all makes sense! I'm not even done watching this yet, but I had to come here and comment while I was having my lightbulb moment Thanks!
Comment from : Phoenix Blacc