Workshop: Microsoft Office - Excel Module 6
Workshop Code: MSW E6
Logical and statistical functions are presented, but don’t let the name scare you! You will learn how to create an IF statement, Nested If statements, SUMIF, SUMIFS (new to 2010), AVERAGEIF and AVERAGEIFs along with other math functions. Find out the fastest way to sum a column, and how to use VLookup, MATCH and INDEX. Do you know the answer, but don’t know how to get there? Use Excel’s analytical tools of Goal Seek and Solver to work your formulas in reverse. Finally, to become a true Excel 2010 Expert, you will learn how to create Macros for your everyday tasks.
*Potential Job Enrichment Credit: 3 points
Skills To Be Attained:
Click Session Code or Date and Time to View Sessions Details and Register
No sessions are currently offered for this workshop.