Excel Tips & Tricks ITT

Help Support Talkbeer:

MarkIntihar

Moderator
Staff member
Joined
Apr 5, 2013
Messages
9,717
Location
San Jose, CA
spice up your reports
I've been looking for new ideas on how to spice up my reports lately. My manager tells me that my reports are fine and that he really enjoys reading them, but I'm just not feeling it from him. At the end of the day he's not lusting for more, he just closes down his laptop and packs up to head home. I've thought about introducing some "Choose Your Own Adventure" type reports, where he can set the theme of the report and target the specific areas of the report that he wants to focus on. I've even tried staying late after work to show him that I'm putting in the extra effort, and he says he's noticed but I still don't feel like I'm special to him. If anyone has any ideas that might help me stand out a bit more to him, please send me a PM so that we don't clutter up the board with smut. TY.
 
Joined
Apr 10, 2013
Messages
9,049
Location
Squat Rack
Conditional formatting for days! Can't wait for this convo to heat up!




Srs.
This is why I love you.
I've been looking for new ideas on how to spice up my reports lately. My manager tells me that my reports are fine and that he really enjoys reading them, but I'm just not feeling it from him. At the end of the day he's not lusting for more, he just closes down his laptop and packs up to head home. I've thought about introducing some "Choose Your Own Adventure" type reports, where he can set the theme of the report and target the specific areas of the report that he wants to focus on. I've even tried staying late after work to show him that I'm putting in the extra effort, and he says he's noticed but I still don't feel like I'm special to him. If anyone has any ideas that might help me stand out a bit more to him, please send me a PM so that we don't clutter up the board with smut. TY.
What types of reports do you produce? The automated KPI indicators are quite useful and look excellent.
 
Joined
Apr 11, 2013
Messages
36,419
I've been looking for new ideas on how to spice up my reports lately. My manager tells me that my reports are fine and that he really enjoys reading them, but I'm just not feeling it from him. At the end of the day he's not lusting for more, he just closes down his laptop and packs up to head home. I've thought about introducing some "Choose Your Own Adventure" type reports, where he can set the theme of the report and target the specific areas of the report that he wants to focus on. I've even tried staying late after work to show him that I'm putting in the extra effort, and he says he's noticed but I still don't feel like I'm special to him. If anyone has any ideas that might help me stand out a bit more to him, please send me a PM so that we don't clutter up the board with smut. TY.
Two words, man thong.

Or this:
 
Joined
Apr 10, 2013
Messages
9,049
Location
Squat Rack
I hope to god I am not the most experienced Excel person here.
I've found that most people can teach me something new in Excel. It all depends on the type of work you do. For example, I have a coworker who has been teaching me new macro techniques. I am certainly more "experienced" than she is. But I spend more time querying our EDW directly and merging data sources and interpreting for report consumers while she is a pro gamer at making slick reports for our leadership.

Tldr, I'm sure you'll learn something if you want to.
 
Joined
Dec 21, 2013
Messages
9,090
Location
LFK
Anyone have intimate knowledge with conversion to Excel 2010 from older versions? That is the current bane of my existence as my office upgrades from 2003.
EDIT: Access, too, but I will save that for the Access tips and tricks forum.
CTRL + A
CTRL + C
CTRL + V

*shruggy guy ascii*

I actually just save as the most recent file type. But obviously that's not it?
 
Joined
Apr 10, 2013
Messages
9,049
Location
Squat Rack
Anyone have intimate knowledge with conversion to Excel 2010 from older versions? That is the current bane of my existence as my office upgrades from 2003.
EDIT: Access, too, but I will save that for the Access tips and tricks forum.
I don't recall having any issues when we upgraded. Running 2010 now...
 
2

Latest posts

Top