Page 1
Page 1
Started By
Message

Microsoft Excel Forums

Posted on 11/28/18 at 2:35 pm
Posted by BugAC
St. George
Member since Oct 2007
52765 posts
Posted on 11/28/18 at 2:35 pm
What are the better/most relevant excel forums out there. I have some pretty advanced stuff i want to do that i can't do by googling how to. Anyone know of some good forums that are current and helpful? Or do we have some excel guru's here?
Posted by VermilionTiger
Member since Dec 2012
37573 posts
Posted on 11/28/18 at 2:55 pm to
Reddit's excel subreddit
Posted by Chinese Bandit
Edmond, Ok
Member since Jan 2004
1543 posts
Posted on 11/28/18 at 3:20 pm to
Mr Excel has helped me with some serious macros...try them out
Posted by BugAC
St. George
Member since Oct 2007
52765 posts
Posted on 11/28/18 at 3:22 pm to
quote:

Mr Excel has helped me with some serious macros...try them out



work filters blocked that one. I'm on excel subredit
Posted by foshizzle
Washington DC metro
Member since Mar 2008
40599 posts
Posted on 11/28/18 at 7:16 pm to
Honestly, if you're really pushing Excel you will probably be better off putting your data into a real database and learning to work with it instead.

Excel is a fantastic ad-hoc tool but for repeatable processes you'll waste lots of time forcing it to do what Oracle was born to handle.
Posted by LSUtigerME
Walker, LA
Member since Oct 2012
3789 posts
Posted on 11/28/18 at 7:53 pm to
Mr Excel or Ozgrid always tends to pop up on my searches.

I find it hard to believe it can’t be solved by some google searches though. What are you trying to do?
Posted by philabuck
NE Ohio
Member since Sep 2008
10378 posts
Posted on 11/28/18 at 11:19 pm to
quote:

work filters blocked that one. I'm on excel subredit


Well... that's an interesting approach to web filtering.
Posted by GetCocky11
Calgary, AB
Member since Oct 2012
51247 posts
Posted on 11/30/18 at 6:55 am to
quote:

Honestly, if you're really pushing Excel you will probably be better off putting your data into a real database and learning to work with it instead.

Excel is a fantastic ad-hoc tool but for repeatable processes you'll waste lots of time forcing it to do what Oracle was born to handle.


If the data is something like 50,000 rows or less, Excel is a lot easier to deal with.

Hell, I do some occasional work with a 200,000 row dataset and just use Excel. It is less about Excel and more about the machine you're using.
This post was edited on 11/30/18 at 6:56 am
Posted by messyjesse
Member since Nov 2015
2028 posts
Posted on 11/30/18 at 9:27 am to
What are you trying to do exactly? "Advanced" Excel frequently involves peripheral technologies (VBA, DAX, PowerQuery, PowerPivot). There are plenty of resources out there for those beyond just an Excel forum.
Posted by VermilionTiger
Member since Dec 2012
37573 posts
Posted on 11/30/18 at 10:13 am to
if you're ever looking to do anything in VBA, the best method to do is 1st run a macro on what you want to do. That is a great starting point for sure.
Posted by Mingo Was His NameO
Brooklyn
Member since Mar 2016
25455 posts
Posted on 11/30/18 at 3:37 pm to
quote:


If the data is something like 50,000 rows or less, Excel is a lot easier to deal with.



Disagree. Depends on what you're doing and your alternatives.
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram