Not currently logged in.
login
Welcome > Learning Opportunities > Workshop Details Help Help

Workshop: Microsoft Office - Excel Module 6

Workshop Code: MSW E6

Objective:

Description:
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.



Information Technology Services
Miami University
Comments, questions? click here