Kalmarjan
New member
- Joined
- Nov 25, 2021
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Good morning, I'll try to keep it brief.
I've been using Excel on and off for a little over 20 years. I mostly used it for keeping track of recipes in a kitchen (I used to be a chef) and for entering/tracking inventory data. I knew a bit of conditional formatting, how to roughly lookup items with a VLookup table, etc.
I am an avid Photoshop user, so as such I am a person that LOVES keyboard shortcuts, and Excel is amazing for that.
Fast forward to today. I no longer work in kitchens, and I now work at a corporation in the planning department. There are a LOT of uses for Excel here, and my day-to-day job entails working with data from SAP, and manipulating that data with Excel to make reports. I sometimes need to rely on National to make reports before I can continue in my workflow, which is something I know I can't change.
What I would like to do is further my knowledge in Excel, but there so much information out there. I have NO idea where to start.
I work with Pivot tables all day, there are slicers everywhere, and sometimes I feel like there are things that I am doing (like hitting buttons on slicers to get values to enter into another table) that I could automate, but where does a chap start? I can't upload an example because of privacy and corporate concerns, but the gist is something like this:
There are 40 installations that all provide service, and take X numbers of hours to do so. I have an excel sheet that has a pivot table that I press each slicer to filter down the installation, and that pops out a number that I have to enter into another excel file to give me a graph. I have a feeling I could just somehow link the two and save some time? (Hopefully not make me obsolete lol)
This is an example, there are many things I would like to learn, and I am a person that is pretty hands on in learning...
Thank you for reading my ramble, I'm lost and need some direction LOL
I've been using Excel on and off for a little over 20 years. I mostly used it for keeping track of recipes in a kitchen (I used to be a chef) and for entering/tracking inventory data. I knew a bit of conditional formatting, how to roughly lookup items with a VLookup table, etc.
I am an avid Photoshop user, so as such I am a person that LOVES keyboard shortcuts, and Excel is amazing for that.
Fast forward to today. I no longer work in kitchens, and I now work at a corporation in the planning department. There are a LOT of uses for Excel here, and my day-to-day job entails working with data from SAP, and manipulating that data with Excel to make reports. I sometimes need to rely on National to make reports before I can continue in my workflow, which is something I know I can't change.
What I would like to do is further my knowledge in Excel, but there so much information out there. I have NO idea where to start.
I work with Pivot tables all day, there are slicers everywhere, and sometimes I feel like there are things that I am doing (like hitting buttons on slicers to get values to enter into another table) that I could automate, but where does a chap start? I can't upload an example because of privacy and corporate concerns, but the gist is something like this:
There are 40 installations that all provide service, and take X numbers of hours to do so. I have an excel sheet that has a pivot table that I press each slicer to filter down the installation, and that pops out a number that I have to enter into another excel file to give me a graph. I have a feeling I could just somehow link the two and save some time? (Hopefully not make me obsolete lol)
This is an example, there are many things I would like to learn, and I am a person that is pretty hands on in learning...
Thank you for reading my ramble, I'm lost and need some direction LOL