This list of Excel help topics will assist you in completing your Excel projects. This list of help topics includes:
If you are stuck and need additional help, we do offer support. A support call is $50 for a one hour Zoom meeting. We can help troubleshoot formulas and offer recommendations. For larger projects book a project with us to discuss your needs. For large projects we will provide you with a quote and estimated time of completion.
These tips have been useful for past clients as well as ourselves, and will help you plan your Excel projects.
This is list of Excel functions separated by category. To learn more about each topic, click on the first column.
AND | Test multiple conditions at one time. All conditions must evaluate to TRUE |
OR | Test multiple conditions at one time. At least one condition must evaluate to TRUE. |
SUMPRODUCT | Multiply, then sum arrays. Commonly used to do SUMIFS or counts with both rows AND columns. |
This is list of Excel formulas that can be used to solve common problems. This list is also separated by category. To learn more about each topic, click on the first column.
Count birthdays by year |
Count months by short name (MMM) |
Sum by short month (MMM) for any year |