Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments. Learn how to use functions in your formula's. You'll explore specific types of formulas that can help you on multiple levels, such as financial and array formulas.
You'll learn how to apply formulas to charts and pivot tables, troubleshoot your formulas, develop custom functions, and much more.
After completing this course, you will understand and be able to apply Excel formulas and functions to solve a variety of data analysis problems.
Anyone who is familiar with the basics of Excel, but would like to expand their knowledge.
Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:
• Clerical, Office professionals
• Help desk personnel
• Program/Project Managers
• Other members of the general population
• Create analytical, financial, etc. reports
• Data entry
• Family budget
• Format numerical (financial, statistical, etc.) reports
• Process data
• Technical support
Familiarity with Excel basics.
Before coming to the class, attendees should have an understanding of Excel fundamentals including formatting, navigation, and basic formulas.
*Course cost listed does not include the cost of courseware. Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course is subject to a minimum enrollment to run. This course may run as a virtual instructor led course if the minimum enrollment has not been met.