All articles with 'Learn Excel' Tag
In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity.
Note: This is a short format episode. Less time to listen, but just as much awesome.
What is in this session?
Pivot tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more.
In this podcast, you will learn,
- What is a Pivot Table?
- Example of business data & reporting needs
- Key pivot table terms to understand
- Creating your first pivot table
- Learning more about pivot tables
Time for another quick Excel tip.
Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.
How many hours did you play?
Of course 78/10 = 7.8 hours.
But we all know that 7.8 hours makes no sense.
We also know that 7.8 hours is really 7 hours 48 minutes.
So how to convert 7.8 hrs to 7:48 ?Continue »
Last week, we had an interesting homework problem – What is the average speed of this road trip?
We received more than 150 answers. But to my surprise, 57 of them are wrong. So today, lets learn how to calculate the average speed correct way.Continue »
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people.
Demo of interactive network chart in Excel
First take a look at what we are trying to build.
Looks interesting? Then read on to learn how to create this.Continue »
Its homework time again. This time, lets tackle an interesting & everyday problem. Lets introduce our protagonist of the story – Jack. Jack likes long road trips, smell of freshly brewed Colombian coffee, clicky-clack sound of his computer keyboard. He hates toll plazas (they slow him down) & Potassium permanganate. And oh yes, Jack is […]Continue »
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?
By learning & practicing of course.
And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.
So in this episode, let me share 3 must have books for (aspiring) analysts.Continue »
Ok people. Let me tell you that this post is almost not about Excel. It is about how one Excel blogger’s (yours truly) dream of long distance cycling came true. So sit back, grab your favorite drink and read between sips.
So what is this all about?
Last Sunday (27th July) & Monday (28th), I finished my first ever 200KM bicycle ride. I rode for a little more than 12 hours, burned 5,179 calories & rode 206 kilometers.
It is definitely one of the most memorable, tiresome & uplifting experiences in my life. So naturally, I want to share the story with you.Continue »
Let me stop our broadcast of Excel tips to bring an announcement.
Houston, we are going to get awesome
As you may know, I am doing 4 days of live masterclasses on Advanced Excel, Dashboards, Power Pivot & Data Analytics in Houston (Texas) this September.
- 15 & 16 September (Mon & Tue) on Advanced Excel & Dashboard Reporting
- 17 & 18 September (Wed & Thu) on Power Pivot & Data Analytics
This 4 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Data Analytics, Advanced Excel, Dashboard reporting.Continue »
CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO
In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions.
What is in this session?
Around last week, I invited you to ask me anything. More than 150 people responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this episode of Chandoo.org podcast.
In this podcast, you will learn,
- How to fill blank cells with data from above
- How to work with Big data in Excel
- How to combine data from multiple sources & analyze it in Excel
- How I am managing my life after starting Chandoo.org
- How to create and distribute stand-alone Excel products
- How to control a model railroad set using Excel VBA (not fully answered)
- & more…
Time for another round of open-mic weekend.
As you know, Chandoo.org has been running a podcast show for last few months. We have completed 14 episodes as of today. For the 15th episode, lets have an “Ask Chandoo” as the theme.
What you need to do:
Simple. Head over to ask.chandoo.org and submit your questions. You can leave me a voice-mail or post your questions
What happens next?
I will listen (or read) your questions and choose a handful for the session 15 of our podcast.
What you get:
If your question is picked up for the podcast, you will receive the 25 Excel tips e-book.Continue »
Today lets learn about Excel CHOOSE() function.
CHOOSE eh? What does it do?
To understand CHOOSE() and appreciate its uses, lets invent an imaginary boos-subordinate pair.
Jasmine is the boss. She is, well, lets call her peculiar. She likes olives, Tuesdays & color Red. She hates potatoes.
Martin is the faithful butler of Jasmine. He is obedient, quirky and tall. He likes lotuses, Fridays & color blue. He hates potassium.
Enter Jasmine’s scarf problem:
Jasmine likes to wear a different colored scarf every weekday. She likes to wear Red colored scarf on Mondays & Tuesdays. She likes to put on the blue polka dot scarf on Wednesdays. On Thursdays, she wears her olive colored scarf. On Fridays & Saturdays, she prefers the lovely orange blue scarf. Sundays are no scarf days.
No wonder she is peculiar.Continue »
This is a guest post written by Joel Zaslofsky, author of Experience Curating.
How to Make “Put It in a Spreadsheet” Who You Are (and Not Just What You Do)
It seemed like a crazy question:
Could I use my passion for Excel as motivation to transform my leaky brain from a weakness into a strength?
Sure, I already had a fifteen year love affair going with Excel.
Every other email I sent to my co-workers had an attached Excel spreadsheet. And when I wasn’t using Excel for work purposes, I was using it for grocery list templates or budget tracking.
But I had to discover the answer to my crazy question.
So I told my wife Melinda in January 2012, “Honey, this is the year I put it in a spreadsheet!”Continue »
If you listen carefully, you can hear my screams of joy. I have 2 very happy news to share with you.
- I am speaking at Excelapalooza Excel conference, happening at Dallas (Texas) between September 21 to 24.
- I will be conducting an Advanced Excel, Dashboards & Power Pivot masterclass at Houston (Texas) between September 15 to 18.
To all our readers & friends from USA,
I wish you a happy, fun & safe 4th of July.
For the last 4th of July (2013), we (Jo, kids & I) were in USA. We went to Washington DC to meet up a few friends for that weekend. And we had one of the most memorable evenings of our lives when we went to national mall area in the evening to watch beautifully choreographed fireworks. Kids really loved the amazing display of fire-crackers and enthusiasm.
While we all are back in India this time, it doesn’t mean we cant celebrate 4th of July. So I made some fireworks. In Excel of course.
Here is a little Excel animation I made for all of us.
4th of July Fireworks – Excel animation
First watch this quick demo (<15 secs)Continue »
In the 12th session of Chandoo.org podcast, lets get productive fast.
Announcement: Short format podcasts sessions once a month
Based on listener feedback, I am adding short format sessions (20 mins). This short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel awesomeness.
I hope you like this new format. Do let me know what you think in comments.
And I really appreciate your reviews & comments on iTunes. Please click here and post your review.Continue »