PoetofMercury Pyramidal Crystal
Title : GC's Official Loof Merrow Posts : 1656 Join date : 2011-08-04 Age : 47 Location : Long Island NY
| Subject: Microsoft Excel Tips & Tricks Thread 9th May 2014, 8:13 pm | |
| Hey guys, I've totally been meaning to create this thread forever. I work in Excel practically 10 hours a day in an accounting context. So I thought maybe I could help people with some excel questions and maybe someone will end up teaching me something new too. SO here's some of the most awesome things I love to do in Excel. If anyone is interested in a tutorial on any of these let me know. Pivot Tables - best way to take a whole spreadsheet of numbers and make a simple summary table to understand it at a glance. Much better than just doing subtotals. Vlookup formulas - Ever have two sheets that you have to compare with each other? This is the way to do it. Macro recording and creating - I'm still an amateur here and there's so much more to learn, but I've tinkered a bit with writing my own and recording them. SumIf - Adds a things together only if certain criteria are met. Ex: Only add up sales made in the year 2013 out of a long list covering multiple years. Anyone have any excel questions or really cool tips? |
|
PoetofMercury Pyramidal Crystal
Title : GC's Official Loof Merrow Posts : 1656 Join date : 2011-08-04 Age : 47 Location : Long Island NY
| Subject: Re: Microsoft Excel Tips & Tricks Thread 15th August 2015, 10:55 pm | |
| Bumping this...since I'm back. I am actually slowly working on developing an excel course as a side job of sorts. (I have too many side jobs, hobbies, and things I need or want to do. LOL I need more than 24 hours in a day...just saying. ^^) But anyway, if anyone needs a hand I'll help if I can! ^^ |
|
Chmia Lotus Crystal
Title : Leg Lamp Power, Make Up! Posts : 8262 Join date : 2011-10-01 Age : 35 Location : San Antonio, Texas
| Subject: Re: Microsoft Excel Tips & Tricks Thread 30th October 2015, 6:30 pm | |
| I love pivot tables! They are the best thing I have learned in Excel so far.
I am beginning to learn Vlookups, but only in the barest of senses. They are complicated for me to put into practice, because I haven't had much experience with them, yet. But, I am starting to understand the concept.
Tell me of this SumIf function. I need this in my life.
I also love the F4 key. If you highlight a section of your function, then press F4, you add $ signs to the cell reference number (B$4$ for example). That makes it so you can make sure that is the specific cell referenced if you start dragging formulas down/to the side. In other words, you use that key to create an absolute reference. If you keep pressing F4, it cycles through the other types of references, but I tend to stick with absolute references. |
|
PoetofMercury Pyramidal Crystal
Title : GC's Official Loof Merrow Posts : 1656 Join date : 2011-08-04 Age : 47 Location : Long Island NY
| Subject: Re: Microsoft Excel Tips & Tricks Thread 30th October 2015, 8:03 pm | |
| I can show you that! Took me a while to get it too. Vlookup is hard for people to explain. I know from when I was being taught. But do it a few times and it starts to make sense. I'll try to throw up a quick Sum If tutorial next week after Halloween crazies are over. |
|
Sponsored content
| Subject: Re: Microsoft Excel Tips & Tricks Thread | |
| |
|