The Galaxy Cauldron
Hello! We are a large forum! So here are some things to keep in mind when visiting!

❤️ Not all forums are visible to guests!

❤️ We offer a Dark and Light theme! You can Change it at the very bottom of the forums, on the left hand side

❤️ You can minimize sections that you don't visit/want to see by using the +/- signs location on Category titles.

HomePortalFAQRegisterLog in
Navigation



Navigation

Get Help!
Forum Index
Portal Page
Today's Topics
Watched Stuff
Calendar
Search Forum
Member Roster
Helpful Links
Forum Rules
Avi/Sig Rules
Chat Rules
Guide to RP
Forum Staff
Member Ranks
OSA-P Shop Info
Club Directory

Connect with GC
Tumblr Facebook Twitter Instagram Become a member today for link!
Latest topics
» [Multiverse][Relaxed] Dissidia Multiverse
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Light Today at 10:49 am

» ~LPW #12 (It’s Bo Time!)
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby nm___i3bfc Today at 10:24 am

» Shining Brighter than Any Star, the 8th Anniversary Is Here!
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Diana Today at 9:55 am

» Final Featured Roleplay (Nomination Phase!)
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Sailor Saturn Today at 9:10 am

» Puzzle Contest
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby CrystalBunny Today at 8:39 am

» [RTRP] Professor Tomoe's Tropical Getaway
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Sailor Saturn Today at 6:35 am

» Saban Moon webumentary
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby chrissifniotis Today at 12:12 am

» GC 8th Anniversary GOODIE BAGS!
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Diana Today at 12:11 am

» ★ Stars of the Cauldron Awards 2019 - Voting ★
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby chrissifniotis Yesterday at 11:55 pm

» [Games] Sport's Flash Game Train
Microsoft Excel Tips & Tricks Thread I_icon_minitimeby Cosmos-Hime Yesterday at 6:39 pm

User Control Panel
Your profile
Information Preference Signature Avatar
Social
Friends and Foes Memberlist Groups
Private messages
Inbox PM sent

Share | 
 

 Microsoft Excel Tips & Tricks Thread

View previous topic View next topic Go down 
AuthorMessage
PoetofMercury
Pyramidal Crystal

PoetofMercury

Pyramidal Crystal

Title : GC's Official Loof Merrow
Posts : 1656
Join date : 2011-08-04
Age : 42
Location : Long Island NY


Microsoft Excel Tips & Tricks Thread Empty
PostSubject: Microsoft Excel Tips & Tricks Thread   Microsoft Excel Tips & Tricks Thread I_icon_minitime9th May 2014, 8:13 pm

Hey guys,

I've totally been meaning to create this thread forever. Smile 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. Smile


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. Smile


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? Smile

___________________________

Microsoft Excel Tips & Tricks Thread Mustac10Microsoft Excel Tips & Tricks Thread Siggy2-1
Back to top Go down
http://www.lioddities.com
PoetofMercury
Pyramidal Crystal

PoetofMercury

Pyramidal Crystal

Title : GC's Official Loof Merrow
Posts : 1656
Join date : 2011-08-04
Age : 42
Location : Long Island NY


Microsoft Excel Tips & Tricks Thread Empty
PostSubject: Re: Microsoft Excel Tips & Tricks Thread   Microsoft Excel Tips & Tricks Thread I_icon_minitime15th August 2015, 10:55 pm

Bumping this...since I'm back. Very Happy 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! ^^

___________________________

Microsoft Excel Tips & Tricks Thread Mustac10Microsoft Excel Tips & Tricks Thread Siggy2-1
Back to top Go down
http://www.lioddities.com
Chmia
Lotus Crystal

Chmia

Lotus Crystal

Title : Leg Lamp Power, Make Up!
Posts : 8262
Join date : 2011-10-01
Age : 30
Location : San Antonio, Texas


Microsoft Excel Tips & Tricks Thread Empty
PostSubject: Re: Microsoft Excel Tips & Tricks Thread   Microsoft Excel Tips & Tricks Thread I_icon_minitime30th 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.

___________________________

Microsoft Excel Tips & Tricks Thread DCbBtvOMicrosoft Excel Tips & Tricks Thread Chmia Microsoft Excel Tips & Tricks Thread Yvbpgta
Microsoft Excel Tips & Tricks Thread Sezuti10
Microsoft Excel Tips & Tricks Thread 2508165712 Graphics by Athena, Neo Queen Serenity, Sailor Neptune, Sailor Mercury, Gemma, and Lust Microsoft Excel Tips & Tricks Thread 2508165712
Back to top Go down
PoetofMercury
Pyramidal Crystal

PoetofMercury

Pyramidal Crystal

Title : GC's Official Loof Merrow
Posts : 1656
Join date : 2011-08-04
Age : 42
Location : Long Island NY


Microsoft Excel Tips & Tricks Thread Empty
PostSubject: Re: Microsoft Excel Tips & Tricks Thread   Microsoft Excel Tips & Tricks Thread I_icon_minitime30th October 2015, 8:03 pm

I can show you that! Took me a while to get it too. Smile 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.

___________________________

Microsoft Excel Tips & Tricks Thread Mustac10Microsoft Excel Tips & Tricks Thread Siggy2-1
Back to top Go down
http://www.lioddities.com
Sponsored content




Microsoft Excel Tips & Tricks Thread Empty
PostSubject: Re: Microsoft Excel Tips & Tricks Thread   Microsoft Excel Tips & Tricks Thread I_icon_minitime

Back to top Go down
 

Microsoft Excel Tips & Tricks Thread

View previous topic View next topic Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
The Galaxy Cauldron :: The Star Garden :: Book Lounge-