The Entrepreneur Forum | Financial Freedom | Starting a Business | Motivation | Money | Success

Welcome to the only entrepreneur forum dedicated to building life-changing wealth.

Build a Fastlane business. Earn real financial freedom. Join free.

Join over 80,000 entrepreneurs who have rejected the paradigm of mediocrity and said "NO!" to underpaid jobs, ascetic frugality, and suffocating savings rituals— learn how to build a Fastlane business that pays both freedom and lifestyle affluence.

Free registration at the forum removes this block.

Analysing data in Excel using simple text manipulation & pivot-tables

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,690
Ireland

Charnell

Block me if you're a quack
FASTLANE INSIDER
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
276%
Oct 12, 2014
1,091
3,009
Kansas City
As an over the shoulder it's fascinating because I genuinely enjoy working in Excel.

But the first 5 or so minutes was formating the date to be easier to read which is a fantastic video in and of itself, however, if I click over wanting to learn about pivot tables and have to wait through that I'm out.
 

BizyDad

Keep going. Keep growing.
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Read Unscripted!
Summit Attendee
Speedway Pass
User Power
Value/Post Ratio
416%
Oct 7, 2019
2,885
11,989
Phoenix AZ
I don't know which blew my mind more, the video or @Charnell having a new pic. :rofl:

Jokes aside, great video. Need to jump in and play to see what I can gleen from pivot tables. Thanks for giving me a starting point.
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,690
Ireland
Yeah, it’s not quite the right title for the video @Charnell. I didn’t know what title to give it so the thumbnail was readable.

Or maybe I should have explained that your reports are only going to be as good as the base data they read. Hmmm... maybe I record an intro section explaining what I’m going to do and why?

I even decided not to create an intro slide with a title on (like I did for the first video on this channel) - because I want to be able to change the title and thumbnail as I see fit.

Curious what you guys would name the video?
 
Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

Charnell

Block me if you're a quack
FASTLANE INSIDER
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
276%
Oct 12, 2014
1,091
3,009
Kansas City
Curious what you guys would name the video?
"Excel Expert Quickly Formats Google Ads Data Into Something Readable" and include timestamps as to what you're doing at each section of the video. It seemed to me there were 3 sections: the date formating, creating the pivot table, then manipulating it.
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,690
Ireland
"Excel Expert Quickly Formats Google Ads Data Into Something Readable" and include timestamps as to what you're doing at each section of the video. It seemed to me there were 3 sections: the date formating, creating the pivot table, then manipulating it.
Cool.

I changed the thread and video title from:
  • Excel Pivot-Table Example (using Google Ads data)
to
  • Analysing data in Excel using simple text manipulation & pivot-tables

The Google Ads part is irrelevant I think.
 

jdm667

Silver Contributor
FASTLANE INSIDER
Read Rat-Race Escape!
Read Fastlane!
Read Unscripted!
Speedway Pass
User Power
Value/Post Ratio
216%
Jan 27, 2020
357
770
Boston, MA
Years ago, I used PivotTables all the time at work - awesome refresher, thanks Andy!

I think a lot of people struggle with Vlookups when they get started with Excel, so a link to another video on how they work could be helpful for newbies.
 
Dislike ads? Remove them and support the forum: Subscribe to Fastlane Insiders.

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
User Power
Value/Post Ratio
370%
May 20, 2014
18,563
68,690
Ireland

Post New Topic

Please SEARCH before posting.
Please select the BEST category.

Post new topic

Guest post submissions offered HERE.

Latest Posts

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Ideas needing execution, more!

Join Fastlane Insiders.

Top