RE: Excel Fun - Data Grouping and Color Rules
You are viewing a single comment's thread:
I report using Excel and have designed all my own reports but I keep it quite simple. Auto sum and formulas is about as complex as it gets for me but I get by and the Directors don't complain. I also use Excel at home for th budget and holiday planning, costs and schedules. It's a nice little program, but far more powerful than I'll ever use.
0
0
0.000
Yeah there is definitely a lot of Excel components that are insanely advanced. Paula knows a lot of it, being an accountant, and it's way beyond my league but one of the really cool things I learned that helps a lot is Power Query. Depending on what you do with your data, it could be pretty badass and beneficial.
We just recently used it for our taxes, we started our own little business and were tracking expenses. That's where my wife introduced me to subtotal and grouping. Blew my mind! She has a lot of excel tricks up her sleeve! Those accountants, (wife is one as well, Masters degree in Tax lol) they know the stuff in and out!
I only use it as needed and it's a fairly basic level to be honest, nothing like you guys would be doing. I get by and whilst I'd like to know more, there's other things I'd rather learn than excel...Maybe one day, after I've learned the other billion things I want to learn.
Yeah I hear you. Until I needed to use it, I kind of made fun of my wife for being so excited learning something on it. Once you use it for many different things, it becomes pretty awesome. I want to eventually data analytics type of work so that’s another reason I’ve been using it so much and learning whatever I can.
There are so many other things I would like to learn as well lol lots of home improvement stuff at the moment.
Haha, teasing the Excel geek huh? Nice one! Lol.
I have seen you're doing a few DIY projects lately. I like seeing them...Will curate that over almost anything else really, as it shows passion and effort. Me likey.
Thanks! One of the things we realized recently..... don't paint stair treads! With painting them last year, we are now stuck with it. The paint will not come off without spending hours of effort to strip off a single tread. Live and learn, but that's the beauty (or pain?) of home improvement I guess lol
Next place we will definitely be staining them, not painting lol
Are the painted steps slippery or you just don't like the look now?
They thankfully aren’t slippery but a very poor choice of color. Walking on these in the dark is treacherous lol
Oh yeah, dark and looks like a satin, or matt, finish. Not a good combination as they won't reflect much light. Live and learn though.