• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 21:43
CET 03:43
KST 11:43
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Team Liquid Map Contest #233[ASL22] Finals Preview: Sweet Victory!12[ASL22] Ro4 Preview: Mirror Mirror6[ASL22] Ro8 Preview: Within Reach5[ASL22] Ro8 Preview: In A Tizzy11
Community News
Weekly Cups (Nov 9-15): Clem and herO take over1Dark completes military service, returns to SC215[BSL23] RO16 Group Stage20Weekly Cups (Nov 2-8): herO back on top?2Weekly Cups (Oct 26 - Nov 1): MaxPax, herO, Solar win0
StarCraft 2
General
Team Liquid Map Contest #23 Dark completes military service, returns to SC2 Weekly Cups (Nov 9-15): Clem and herO take over StarCraft open world shooter announced at BlizzCon No more SC2 streamers on team liquid?
Tourneys
Sparkling Tuna Cup - Weekly Open Tournament RSL goes to London! 2026 Offline Finals Nov 21-22 Sea Duckling Open (Global, Bronze-Diamond) Dark returns! GSL CK #7 4v4 Team Battle (Nov 19) soO & FanTaSy return! SC2 Kevin Scrim 4v4 (Nov 16)
Strategy
[H] ZvP Mid-Late Game: Stalkers Collossi HT
Custom Maps
[G] How to playtest arcade maps Starcraft 2 Advance [D] the control group Simple Questions/Answers
External Content
Mutation # 552 Secret Storm The PondCast: SC2 News & Results Mutation # 551 Robotic Revival Mutation # 550 Graveyard Shift
Brood War
General
List of top players active on ShieldBattery BW General Discussion NaDa's Body Shield Battery Server New Patch BGH Auto Balance -> http://bghmmr.eu/
Tourneys
SC1 Kevin Scrim hosted by SOOP (Nov 18-19) [IPSL] Winter 26-27 Round of 16! [Megathread] Daily Proleagues 2v2v2v2 Tournament Stage 2: Players
Strategy
Pluto's TvP 5Marine 2Medic Push Simple Questions, Simple Answers Infested Terran strategies in 2026 Nuke strategy worked in K-League 2026-11-09
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Free Space RTS Game, optimised f. Phone/Tablet etc List of Game Threads The PlayStation 5
Dota 2
League of Legends
[TL LoL EUW IHs] Teemo shall perish
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Trading/Investing Thread Artificial Intelligence Thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine
Fan Clubs
Fan Club Resource Thread Reynor Fan Club The Flash Fan Club
Media & Entertainment
Movie Discussion! Anime Discussion Thread [Manga] One Piece
Sports
Football (Soccer) Thread TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
The time I organised my…
AssyrianKing
Why I built Repalyzer (1.1.…
BlueStar
Innovate or Game Over?
TrAiDoS
ShieldBattery on Mac
Kraekkling
Can Bots Beat Pros?? Starcr…
namkraft
StarCraft improvement
iopq
Socialism Anyone?
GreenHorizons
Customize Sidebar...

Website Feedback

Closed Threads



Active: 9545 users

Learning Excel

Blogs > Amnesia
Post a Reply
Amnesia
Profile Blog Joined September 2009
United States3818 Posts
July 09 2010 03:14 GMT
#1
So I was offered a spot at a company for a job through my dad's friend and if I can use Excel then I would start immediately. I was wondering what are good starting points to learn. Any good websites with tutorials? Books? Videos?

Help greatly appreciated! ^^

I don't want to work at the restaurant anymore, it's too tiring and pay isn't as satisfying for the amount of work done.

*****
Sadistx
Profile Blog Joined February 2009
Zimbabwe5568 Posts
July 09 2010 03:18 GMT
#2
Honestly you can figure out 99% of what you need to do in Excel as you go by googling.

"Learning" excel is almost impossible, since there's so many things you can do with it, macros, statistical analysis. It all depends on what you currently need doing.
Amnesia
Profile Blog Joined September 2009
United States3818 Posts
July 09 2010 03:19 GMT
#3
hmm I guess pretty much the basics to get by.
Carnivorous Sheep
Profile Blog Joined November 2008
Baa?21248 Posts
Last Edited: 2010-07-09 03:20:43
July 09 2010 03:20 GMT
#4
Fiddle around with it, learn how to input data, make tables, and make a couple of graphs. All the rest is really just learning as you go along depending on what you need. The basics are fairly straightforward. The bare "basics" can probably take you less than half an hour to learn, and the specifics is really only needed when you know that you need it, and then you an just figure it out then.
TranslatorBaa!
Empyrean
Profile Blog Joined September 2004
17083 Posts
July 09 2010 03:28 GMT
#5
On July 09 2010 12:18 Sadistx wrote:
Honestly you can figure out 99% of what you need to do in Excel as you go by googling.

"Learning" excel is almost impossible, since there's so many things you can do with it, macros, statistical analysis. It all depends on what you currently need doing.


Please never do statistical analysis with excel T_T
Moderator
Cauld
Profile Joined February 2010
United States350 Posts
July 09 2010 03:30 GMT
#6
I always just use the excel help when I think there should be a way to do something in excel, and I don't know how.
Chill
Profile Blog Joined January 2005
Calgary26004 Posts
July 09 2010 03:49 GMT
#7
I consider myself a fairly advanced Excel user. Almost everything I've learned has been:
1. "I wonder how I can do this"
2. Google "excel how to ______"
3. If that doesn't work, try typing what I think the function will be called into Excel help.
4. If that doesn't work, I ask people on IRC and TL PM (seriously, I've done this about 5 times now)

I haven't found any problem that wasn't solved that way.
Moderator
Servius_Fulvius
Profile Joined August 2009
United States947 Posts
July 09 2010 03:53 GMT
#8
As Maddox, master of the Universe says, all you need to know about Microsoft Office is in one place: F1. That's the help key, though, google would probably be more helpful
geometryb
Profile Blog Joined November 2005
United States1249 Posts
July 09 2010 03:56 GMT
#9
there's a handy youtube series by excelisfun you can check out.
YejinYejin
Profile Blog Joined July 2009
United States1053 Posts
July 09 2010 03:57 GMT
#10
Just go to the bottom right corner of cells and click and drag, man.

Click and drag.

If you start getting lost, highlight your workers over and over again to boost APM? :D

Oh, and if you understand the autofill function with click and drag, learn to use the pound sign in your formula. It really helps with keeping certain things constant as you autofill, and allowing others to change.

But, as stated before, do not use Excel for statistical analylsis. ><
안지호
Cauld
Profile Joined February 2010
United States350 Posts
July 09 2010 03:58 GMT
#11
If you want to really impress them learn how to do pivot tables; they're pretty easy after a little practice and are really impressive to people who don't know how to do it and pretty cool overall. (I hope I used that semicolon correctly).
jgad
Profile Blog Joined March 2008
Canada899 Posts
July 09 2010 04:01 GMT
#12
As others have said, Excel isn't so much a thing you can just sit down and learn. It is a loosely connected collection of tools, all of which operate on your fundamental meat and potatoes - -> pages of organised data. What you focus on learning is entirely dependent on what you need to do to your data, or do with it. You could easily spend a month learning a bunch of crap in Excel only to find that the first thing the boss drops on your desk doesn't need any of it, and furthermore that you now need to spend a bunch more time learning the parts of excel that you do need.

Think of Excel like a huge garage filled with toolboxes. You don't really walk in and say :

"What's the best way to learn how to use this garage?"

It's a huge garage with hundreds of tools. The proper way to approach it is to start with a problem - an engine that needs fixing or a car that needs an oil filter changed. Start with simpler tasks, of course, and get to know the surroundings first, but always, always start with a real world problem first. Get a sheet full of data and have a plan of what you want done with it - then start learning how to do it. In this way you grow your skills as you tackle more and more complex problems, gaining experience with a wider and wider range of Excel's tools.

Imagine walking into that garage without any particular piece of equipment to work on - no plan, no problem. How do you even start? Your only option is to start picking up tools at random and trying to figure out what they do...not exactly the best solution.

So, yeah, in short, get your boss to give you some data to play with and a short list of the types of work he typically needs doing. Then you can go through it and see - ah, I need to start by doing "this". You'll also be able to get much more help from others this way as well - you can post a specific question that has a specific answer :

"ok, so I'm trying to do X with this data and I'd like suggestions on the best way to go about doing it"

WAY more likely to get a productive and helpful answer because it's a solvable problem.

Anyway, best of luck - Excel's not that difficult. Count yourself blessed that you'll be learning from the clusterfuck Ribbon version and not having to slash your wrists every afternoon, cursing Microsoft daily for the trainwreck they made of your productivity.

Office 2007 -> Microsoft sneaks into the garage at night, dumps out all the tools, and gets a team of deranged orangutans to "reorganize" them for you. You walk in the next day, take one look around, and FUUUUUUUUUUKKKKK!!

Proceed to get nothing done for the next 18 months while you figure out wtf happened to your slick and streamlined workspace. 0_o
콩까지마
GreEny K
Profile Joined February 2008
Germany7312 Posts
July 09 2010 04:12 GMT
#13
I am definitely an advanced Excel user, I've been trained in office07 and office10 now as well. It is a simple program to use, you need to know what you will be doing in order to learn it better. To know Excel is to hard, there are many different applications for it. Find out what aspect you need to know and then look into that.
Why would you ever choose failure, when success is an option.
Kletus
Profile Blog Joined March 2008
Canada580 Posts
July 09 2010 04:37 GMT
#14
I have been trained in the office suite and there is one key thing to remember when it comes to excel: BOLD THE FORM!!!!
Your resistance only serves to make my carapace harder.
ForSC2
Profile Joined June 2009
United States580 Posts
July 09 2010 04:45 GMT
#15
http://www.baycongroup.com/el0.htm
http://www.smbc-comics.com/index.php?id=2883#comic
xalo
Profile Blog Joined August 2009
Peru80 Posts
July 09 2010 04:52 GMT
#16
Think of Excel like a huge garage filled with toolboxes.


So true

Office 2007 -> Microsoft sneaks into the garage at night, dumps out all the tools, and gets a team of deranged orangutans to "reorganize" them for you. You walk in the next day, take one look around, and FUUUUUUUUUUKKKKK!!

Proceed to get nothing done for the next 18 months while you figure out wtf happened to your slick and streamlined workspace. 0_o


I find 2007 more comfortable than 2003, and the graphs are prettier :$
things you might be using in an office environment:

Pivot tables
VLOOKUP
HLOOKUP
CONCATENATE
ISERROR
IF
NPV (finances)
SUMIF
COUNTIF
etc.
ohh and Macros, you can do pretty things with them

jgad
Profile Blog Joined March 2008
Canada899 Posts
July 09 2010 08:51 GMT
#17
On July 09 2010 13:52 xalo wrote:
Show nested quote +
Think of Excel like a huge garage filled with toolboxes.


So true

Show nested quote +
Office 2007 -> Microsoft sneaks into the garage at night, dumps out all the tools, and gets a team of deranged orangutans to "reorganize" them for you. You walk in the next day, take one look around, and FUUUUUUUUUUKKKKK!!

Proceed to get nothing done for the next 18 months while you figure out wtf happened to your slick and streamlined workspace. 0_o


I find 2007 more comfortable than 2003, and the graphs are prettier :$


It takes like ten times as much clicking get shit done in 2007 and there's almost no way to customize the interface like you could before. Mind you, I'm one of the dinosaurs who had like a decade of honed skills in office pre-'07. The change is far more of a kick in the balls when you've got that much invested in it.
콩까지마
Please log in or register to reply.
Live Events Refresh
PiGosaur Cup
10:00
#108
PiGStarcraft666
CranKy Ducklings70
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
PiGStarcraft666
RuFF_SC2 128
CosmosSc2 72
SpeCial 41
StarCraft: Brood War
Artosis 649
Rush 129
Force[name] 4
Counter-Strike
SPUNJ516
taco 456
Heroes of the Storm
Trikslyr97
Other Games
summit1g15472
Day[9].tv968
shahzam539
JimRising 527
C9.Mang0489
ViBE115
Organizations
Other Games
gamesdonequick1176
BasetradeTV138
[ Show 13 non-featured ]
StarCraft 2
• Hupsaiya 96
• EnkiAlexander 56
• CranKy Ducklings SOOP12
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• Azhi_Dahaki21
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Other Games
• Day9tv968
Upcoming Events
The PondCast
7h 17m
University League
7h 17m
LiuLi Cup
8h 17m
Rogue vs TBD
Maru vs TBD
OSC
13h 17m
Replay Cast
20h 17m
GSL
1d 8h
Maru vs Dark
Patches Events
1d 11h
OSC
1d 13h
Replay Cast
1d 20h
KCM Race Survival
2 days
[ Show More ]
Ultimate Battle
2 days
ZerO vs Bisu
RSL Revival
3 days
BSL
3 days
eOnzErG vs StRyKeR
Cross vs JDConan
RSL Revival
4 days
IPSL
4 days
Ret vs ggnore13
nOmaD vs Aether
BSL
4 days
Bonyth vs Doodle
Kyrie vs Jimin
Replay Cast
4 days
WardiTV Weekly
5 days
Kung Fu Cup
6 days
Solar vs Classic
ByuN vs SHIN
PiGosaur Cup
6 days
Liquipedia Results

Completed

Proleague 2026-11-16
Blizzard Classic Cup 2026
HCC Season 3

Ongoing

Acropolis #5
KCM Race Survival 2026 Season 4
International ShieldBattery League
BSL Season 23
IPSL Winter 2026-27
Calamity Cup Div. A Season 8
Underdog Cup 2026 Div 2-3
Stake Ranked Episode 6
BLAST Rivals Fall 2026
IEM Beijing 2026
PGL Masters Bucharest 2026
Stake Ranked Episode 5
1win Private Club #2
Thunderpick World Champ. '26
ESL Pro League Season 24
Stake Ranked Episode 4
1win Private Club #1
Logitech G Play Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #3
BLAST Open Fall 2026

Upcoming

Sector 591
YSL S4
SC4ALL II: Brood War
NBSL 2026 Xiamen LAN
BSL 23: Non-Korean Championship
HSC XXX
Stellar Fest 2: Lunar Cup
StarCraft2 Weekly Open Tournament 2026 Grand Finals
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
RSL Offline Finals
IEM Kraków 2027
PGL Bucharest 2027
BLAST Bounty Winter 2027
PGL Major Singapore 2026
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2026 TLnet. All Rights Reserved.