Excel

Website:  https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 As a Project Analyst, I used IF statements to check how much credits were generated for a single employee in 2020. The if statements are used to check several things and can produce a result if the condition turns out true or false. When I joined the team, there was already a template that utilized embedded IF statements paired with other functions like vlookup because there were several tabs within one excel file.  Below, I decided to play around with several IF statements and concluded with a SUMIF to calculate the credit generated for a single employee in 2020.  The main idea with my formulas is to find at what quarter does the employee's gross pay goes over 10k. In this case for employee John, it was Q3. Therefore, I calculated 50% of his Q1 and Q2 gross pay to be credit generated. In Q3, he went over. Since I know 5,000 is the maximum generated credit for 2020, then ...

Proper Website:  https://support.microsoft.com/en-us/office/proper-function-61db8dc3-a6ca-456e-ab1b-e93ad47da569#:~:text=Capitalizes%20the%20first%20letter%20and,text%20string%20to%20lowercase%20letters. PROPER(text) Text is text enclosed in quotation marks, a formula that returns text, or a column reference containing the text you want to partially capitalize. Trim Website:  https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9 TRIM(text) The TRIM function syntax has the following arguments: Text Required. The text from which you want spaces removed. As a Project Analyst, I used both the proper and trim functions to clean up payroll excel files of employee names. Not only is this important for making your work look clean, but also trim is essential for making sure your conditional formatting worked. If "John " (with a space) and "John" (no space) are checked for exact match using conditional formatting, it will not hig...