Log In

Your email is not your username

Register

If you were a member of the old Bodybuilding.com forums and would like to reuse your previous username, you can request it below. We use your email only for registration and do not store it. For more information, please see our Privacy Policy.

Confirm your email

A registration code was sent to your email. Enter it here.

Welcome

You have successfully setup your account.

Sign in

Quick Navigation Bottom Misc
Forum
» Just bought Microsoft Excel
  1. Results 1 to 30 of 50
  2. 1
  3. 2
  4. Last
post 1691759723 10-16-2023, 07:19 AM
-
#1
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234

Just bought Microsoft Excel

Any of you brahs use this for work or at all?

What are some nifty things I can do in this bish.

Currently looking at some functions for it.

This software pretty much uses a modified programming language called VBA, but it's all written in singular spreadsheet "cells" (kinda trippy lol).<- correction in post #25



♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691760133 10-16-2023, 07:28 AM
-
#2
  1. TokenV
  2. I ❤ TECHNO
  1. TokenV
  2. I ❤ TECHNO
  3. Join Date: Feb 2012
  4. Location: Belgium
  5. Posts: 41,404
  6. Rep Power: 442514
++
post 1691760173 10-16-2023, 07:29 AM
-
#3
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234
Originally Posted By ScrillaIsBake
pie
now i'm hungry

What kinda data did you used to analyze and why'd ya stop?
Originally Posted By TokenV
oooookkay buddy i physically laughed. good one. srs.
♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691760443 10-16-2023, 07:35 AM
-
#4
  1. donalduck
  2. Registered User
  1. donalduck
  2. Registered User
  3. Join Date: Mar 2012
  4. Posts: 1,543
  5. Rep Power: 11899
Leggo OP.

I work in finance and basically live in excel. It's the GOAT and it's the crutch that corporate america leans on.
post 1691760473 10-16-2023, 07:36 AM
-
#5
  1. theory816
  2. G-Unit
  1. theory816
  2. G-Unit
  3. Join Date: May 2012
  4. Posts: 19,458
  5. Rep Power: 43425
One of the most powerful organizational tools out there.

I used to write in a notebook alot but converted to writing in excel since it's neater. My notebooks are mostly used for writing it down in the moment and then transferred and also used for drawing lol.

I have a cheap laptop used solely for google sheets, which is free.
🤴Supreme Self Esteem Crew
5'5 110lb(MIL Spec) Asian Master Race Crew
Yacht/Boat Crew
post 1691760613 10-16-2023, 07:39 AM
-
#6
  1. WishIWasJawBrah
  2. Misc Enthusiast
  1. WishIWasJawBrah
  2. Misc Enthusiast
  3. Join Date: Sep 2012
  4. Posts: 16,196
  5. Rep Power: 96934
Originally Posted By theory816
One of the most powerful organizational tools out there.

I used to write in a notebook alot but converted to writing in excel since it's neater. My notebooks are mostly used for writing it down in the moment and then transferred and also used for drawing lol.

I have a cheap laptop used solely for google sheets, which is free.
I bet it came in handy during your Community College heydays whilst completing your advanced 2 years Associate Degree
post 1691760703 10-16-2023, 07:40 AM
-
#7
  1. theory816
  2. G-Unit
  1. theory816
  2. G-Unit
  3. Join Date: May 2012
  4. Posts: 19,458
  5. Rep Power: 43425
Originally Posted By WishIWasJawBrah
I bet it came in handy during your Community College heydays whilst completing your advanced 2 years Associate Degree
Lol actually didn't use it at all when I was in CC.
🤴Supreme Self Esteem Crew
5'5 110lb(MIL Spec) Asian Master Race Crew
Yacht/Boat Crew
post 1691761243 10-16-2023, 07:52 AM
-
#8
  1. Goat_187
  2. Registered User
  1. Goat_187
  2. Registered User
  3. Join Date: Nov 2008
  4. Location: Miami, Florida, United States
  5. Age: 40
  6. Posts: 26,316
  7. Rep Power: 93130
You can use it to text your bf and wonder why he aint replying.

post 1691761543 10-16-2023, 07:56 AM
-
#9
  1. Destor
  2. Registered User
  1. Destor
  2. Registered User
  3. Join Date: Apr 2012
  4. Location: Alberta, Canada
  5. Age: 41
  6. Posts: 43,481
  7. Rep Power: 254906
Don't need the mouse to use excel crew
post 1691761663 10-16-2023, 07:58 AM
-
#10
  1. Retoaded
  2. He/Him
  1. Retoaded
  2. He/Him
  3. Join Date: Dec 2011
  4. Posts: 50,517
  5. Rep Power: 650393
No OP, no one uses excel for work.
post 1691761693 10-16-2023, 07:59 AM
-
#11
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234
Originally Posted By ScrillaIsBake
Business school we used it all the time. Random data mostly, but I'd plug in my data. Haven't used it in a while because it reminds me of school work too much now
Years of rows & columns would give me ptsd too brah
Originally Posted By donalduck
Leggo OP.

I work in finance and basically live in excel. It's the GOAT and it's the crutch that corporate america leans on.
omw to ask for a raise. i suppose it is lightyears above pen & paper. i could see it becoming a mess working with large amounts of data and multiple sheets. Like imagine ********s userbase stored in Excel lmfao.
Originally Posted By theory816
One of the most powerful organizational tools out there.

I used to write in a notebook alot but converted to writing in excel since it's neater. My notebooks are mostly used for writing it down in the moment and then transferred and also used for drawing lol.

I have a cheap laptop used solely for google sheets, which is free.
GSheets is neat for accessibility and sharing/working publicly with others. Excel is def faster but it's a nice alternative when the time arises.

Question, why not use a program like One Note or MS Word to write in, unless there's something more you're doing than simply jotting ideas down.
Originally Posted By Destor
Don't need the mouse to use excel crew
mirin
Originally Posted By Goat_187
You can use it to text your bf and wonder why he aint replying.

inspirational
Originally Posted By Retoaded
No OP, no one uses excel for work.
this statement conflicts with others in the thread. you wouldn't lie to me would you
♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691761793 10-16-2023, 08:00 AM
-
#12
  1. jtaylor2010
  1. jtaylor2010
  2. Join Date: Mar 2010
  3. Location: United States
  4. Posts: 33,185
  5. Rep Power: 441422
Hard to believe it’s already 1997.
post 1691761893 10-16-2023, 08:03 AM
-
#13
  1. Retoaded
  2. He/Him
  1. Retoaded
  2. He/Him
  3. Join Date: Dec 2011
  4. Posts: 50,517
  5. Rep Power: 650393
Originally Posted By naaboo
this statement conflicts with others in the thread. you wouldn't lie to me would you
No OP, no one lies on the internet.

I also have not lived in excel for the last 25 years of my life either.
post 1691761913 10-16-2023, 08:03 AM
-
#14
  1. headturner1
  2. User title
  1. headturner1
  2. User title
  3. Join Date: Jan 2012
  4. Location: Washington, United States
  5. Age: 18
  6. Height: 6'5"
  7. Weight: 282 lbs
  8. Posts: 22,831
  9. Subscribers: 9
  10. Rep Power: 318078
Nice OP, very nice
post 1691762063 10-16-2023, 08:07 AM
-
#15
  1. Goat_187
  2. Registered User
  1. Goat_187
  2. Registered User
  3. Join Date: Nov 2008
  4. Location: Miami, Florida, United States
  5. Age: 40
  6. Posts: 26,316
  7. Rep Power: 93130
Excel with ChatGPT prompts = "Look at me, LOOK AT ME!..... I'm CEO now."
post 1691762123 10-16-2023, 08:09 AM
-
#16
  1. theory816
  2. G-Unit
  1. theory816
  2. G-Unit
  3. Join Date: May 2012
  4. Posts: 19,458
  5. Rep Power: 43425
Originally Posted By naaboo
Question, why not use a program like One Note or MS Word to write in, unless there's something more you're doing than simply jotting ideas down.
MS word is for linear writing. My writing style isn't like that at all. There's thoughts, numbers, pictures that all melds together. Google Sheets format is best for containing those things in an organized way.

For example when I need to fix my car and document it to see what is what, I'm not going to write out paragraphs, but rather little bits of information with numbers etc etc.

Parts/Pricing/Importance/Difficulty/Description etc etc stuff like that is better to be done digitally.
🤴Supreme Self Esteem Crew
5'5 110lb(MIL Spec) Asian Master Race Crew
Yacht/Boat Crew
post 1691762203 10-16-2023, 08:11 AM
-
#17
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234
Originally Posted By jtaylor2010
Hard to believe it’s already 1997.
lmao. i'd imagine a good chunk of companies moved over to web-based financial tracking apps, right?
Originally Posted By Retoaded
No OP, no one lies on the internet.

I also have not lived in excel for the last 25 years of my life either.
phew, for a second there i thought i was being taken for a ride. glad to know internet people are an honest bunch.
Originally Posted By headturner1
Nice OP, very nice
it's so fast & snappy i want to lick my screen (and possibly each individual cell)
♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691762553 10-16-2023, 08:19 AM
-
#18
  1. claudio_snchz
  2. 2113
  1. claudio_snchz
  2. 2113
  3. Join Date: Nov 2007
  4. Posts: 826
  5. Rep Power: 23189
LibreOffice Calc Crew checking in (yes I know it's poverty vs. Excel)

Only because I'm a cheap bastard and refuse to give my hard earned dollars to Bill Gates
see multiplemiggs sig

Pureblood Crew
post 1691762933 10-16-2023, 08:25 AM
-
#19
  1. TryingMen
  2. Okie Dokie
  1. TryingMen
  2. Okie Dokie
  3. Join Date: Jan 2023
  4. Posts: 8,457
  5. Rep Power: 38982
Age: 28
post 1691764203 10-16-2023, 08:46 AM
-
#20
  1. niospecv
  2. I mean yeah...
  1. niospecv
  2. I mean yeah...
  3. Join Date: Mar 2006
  4. Posts: 38,152
  5. Rep Power: 214442
Pivot tables and SQL for the win.
**Texas Crew**
**Ultra MAGA Crew**
**Pure Blood Crew**
**Dallas Cowboys Fan Crew**
post 1691764393 10-16-2023, 08:49 AM
-
#21
  1. Maestro
  2. отличнo!
  1. Maestro
  2. отличнo!
  3. Join Date: Oct 2002
  4. Location: New Mexico, United States
  5. Posts: 58,400
  6. Rep Power: 203698
Unless you specifically needed it for work, its not necessary.

and if you wanted some software to make spreadsheets you can just use GoogleSheets which is free if you have a Gmail account and does everything Excel can do.
post 1691764653 10-16-2023, 08:54 AM
-
#22
  1. niospecv
  2. I mean yeah...
  1. niospecv
  2. I mean yeah...
  3. Join Date: Mar 2006
  4. Posts: 38,152
  5. Rep Power: 214442
Originally Posted By Maestro
Unless you specifically needed it for work, its not necessary.

and if you wanted some software to make spreadsheets you can just use GoogleSheets which is free if you have a Gmail account and does everything Excel can do.
You can do the same with excel in the browser via outlook.com or office.com.
**Texas Crew**
**Ultra MAGA Crew**
**Pure Blood Crew**
**Dallas Cowboys Fan Crew**
post 1691764773 10-16-2023, 08:55 AM
-
#23
  1. ChinkWithDink
  2. Banned
  1. ChinkWithDink
  2. Banned
  3. Join Date: May 2023
  4. Age: 56
  5. Posts: 2,072
  6. Rep Power: 0
Imma be that guy. VBA isn't written in the cells, that's only standard Excel functions. To use VBA enable developer tab in settings and then you can add code to the spreadsheet. The code is basically VB6 syntax and has access to an object module that represents the workbook so you can automate or otherwise extend the standard excel functionality. VBA has access to your entire computer basically so is a huge security risk to allow it to execute on your system unless you very much trust the person who wrote it. To counter this excel split the spreadsheet file format into .xlsx and .xlsm with .xlsx not having VBA macros enabled. Be very careful with any .xlsm and or .xls files you didn't create.

I'm not the expert this post makes me out to be but I love excel and vba but it's totally loose what it is enabled to do. Also make sure you tell any programming/database guys you know that an excel spreadsheet is 100% a database and can be used as one and in a lot of cases should be used as one and going to the trouble of using any other form of database is just wanking. They love to hear that.
post 1691764893 10-16-2023, 08:57 AM
-
#24
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234
Originally Posted By theory816
MS word is for linear writing. My writing style isn't like that at all. There's thoughts, numbers, pictures that all melds together. Google Sheets format is best for containing those things in an organized way.

For example when I need to fix my car and document it to see what is what, I'm not going to write out paragraphs, but rather little bits of information with numbers etc etc.

Parts/Pricing/Importance/Difficulty/Description etc etc stuff like that is better to be done digitally.
It makes more sense now that you put it that way.
Originally Posted By claudio_snchz
LibreOffice Calc Crew checking in (yes I know it's poverty vs. Excel)

Only because I'm a cheap bastard andrefuse to give my hard earned dollars to Bill Gates
lmao

that's alright, spreadsheetcels gotta stick together no matter the software
Originally Posted By TryingMen
Age: 28
is that good or bad lol
Originally Posted By niospecv
Pivot tables and SQL for the win.
i heard vlookup & pivot tables were the big bad boys of excel. can you confirm
♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691764933 10-16-2023, 08:58 AM
-
#25
  1. RICHSTRONG
  2. Pa BITCHES
  1. RICHSTRONG
  2. Pa BITCHES
  3. Join Date: Mar 2012
  4. Location: United States
  5. Height: 6'2"
  6. Weight: 350 lbs
  7. Posts: 85,294
  8. Subscribers: 15
  9. Rep Power: 1662183
Originally Posted By TokenV
Fixed
See monster0ultra's sig
post 1691765703 10-16-2023, 09:10 AM
-
#26
  1. naaboo
  1. naaboo
  2. Join Date: Oct 2014
  3. Location: New York, New York, United States
  4. Age: 31
  5. Posts: 4,430
  6. Rep Power: 30234
Originally Posted By ChinkWithDink
Imma be that guy. VBA isn't written in the cells, that's only standard Excel functions. To use VBA enable developer tab in settings and then you can add code to the spreadsheet. The code is basically VB6 syntax and has access to an object module that represents the workbook so you can automate or otherwise extend the standard excel functionality. VBA has access to your entire computer basically so is a huge security risk to allow it to execute on your system unless you very much trust the person who wrote it. To counter this excel split the spreadsheet file format into .xlsx and .xlsm with .xlsx not having VBA macros enabled. Be very careful with any .xlsm and or .xls files you didn't create.

I'm not the expert this post makes me out to be but I love excel and vba but it's totally loose what it is enabled to do. Also make sure you tell any programming/database guys you know that an excel spreadsheet is 100% a database and can be used as one and in a lot of cases should be used as one and going to the trouble of using any other form of database is just wanking. They love to hear that.
interdasting. so writing actual VBA seems good for automation like accessing a csv and uploading it or something (which is prob already a feature in excel). Good to know there's a special file type for VBA enabled otherwise you may as well open up "freebtc.exe" lol

Can I automatically "refresh" a spreadsheet every X amount of seconds, minutes, hours? Ik this is something I could prob Google lol
♥Photography CREW▼NYC CREW▼Mixed CREW▼PCMR CREW▼We all gonna make it CREW♥
♥College CREW▼Raspberry Pi CREW▼Snapple Apple CREW▼Meaningless CREWs CREW♥
♥Seahawks CREW▼Mob Psycho 100 CREW▼if it's on the clock pick up a mop ???? CREW♥
♥MISC COMPUTER SCIENCE CREW♥
MISC Post Remover:
https://forum.obnoxiousbrutes.com/showthread.php?t=182677373
CompSci Discord:
https://discord.gg/8EusJZdvfv
7800X3D+7900XT HHNHNNGGG CREW
post 1691766103 10-16-2023, 09:18 AM
-
#27
  1. N0stradamus
  2. The Blackpill Prophet
  1. N0stradamus
  2. The Blackpill Prophet
  3. Join Date: Oct 2020
  4. Posts: 24,839
  5. Rep Power: 96971
Finance bro.... I practically live in excel.

I know all the functions, all the tips and tricks, all the shortcuts.

When I was a young officecuck, I was responsible for managing the financial side of inventory which required me to analyze around 800K lines of transactions each month. You can't analyze 800K of lines without knowing the all the formulas in excel.
Everything I post is satire.
Tricknology Grand Master.
post 1691766223 10-16-2023, 09:20 AM
-
#28
  1. Unstumpable
  2. Registered User
  1. Unstumpable
  2. Registered User
  3. Join Date: Sep 2016
  4. Age: 34
  5. Posts: 26,131
  6. Rep Power: 219983
I bet the graphics are insane on the latest edition. I just bought a new gaming computer with an RTX 4090. Thinking I'll purchase excel and powerpoint here shortly to see what type of gains I get.
post 1691766263 10-16-2023, 09:21 AM
-
#29
  1. TokenV
  2. I ❤ TECHNO
  1. TokenV
  2. I ❤ TECHNO
  3. Join Date: Feb 2012
  4. Location: Belgium
  5. Posts: 41,404
  6. Rep Power: 442514
Originally Posted By N0stradamus
Finance bro.... I practically live in excel.

I know all the functions, all the tips and tricks, all the shortcuts.

When I was a young officecuck, I was responsible for managing the financial side of inventory which required me to analyze around 800K lines of transactions each month. You can't analyze 800K of lines without knowing the all the formulas in excel.
that were at least 13 worksheets

wild times
++
post 1691767133 10-16-2023, 09:37 AM
-
#30
  1. ChinkWithDink
  2. Banned
  1. ChinkWithDink
  2. Banned
  3. Join Date: May 2023
  4. Age: 56
  5. Posts: 2,072
  6. Rep Power: 0
Originally Posted By naaboo
interdasting. so writing actual VBA seems good for automation like accessing a csv and uploading it or something (which is prob already a feature in excel). Good to know there's a special file type for VBA enabled otherwise you may as well open up "freebtc.exe" lol

Can I automatically "refresh" a spreadsheet every X amount of seconds, minutes, hours? Ik this is something I could prob Google lol
Yes can refresh the spreadsheet, although depending on exactly what you mean by that there is standard excel functionality for that too. But essentially VBA can do anything, it is a complete programming language with full access to the system it is being run on and yes depending on your excel settings opening an .xlsm file is the same as running "freebtc.exe". Enabling the macros is definitely the same.
  1. 1
  2. 2
  3. Last
Quick Navigation Top Misc
Bookmarks
Digg.com
Digg
del.icio.us
del.icio.us
Stumbleupon.com
StumbleUpon
Google.com
Google
Facebook.com
Facebook
Posting Permissions
  1. You may not post new threads
  2. You may not post replies
  3. You may not post attachments
  4. You may not edit your posts