Loading...

Description

This Intermediate Microsoft Excel training workshop is meant for Carlson School students who want to build upon their skill set by learning to work with advanced formulas, formatting and functions. Please note this is a workshop and students will not receive academic credit for completing this course.

Please note this is a workshop and students will not receive academic credit for completing this course.

Outline

  • Work with Subtotals
  • Apply Table formatting
  • Sort and Filter Data
  • Use Conditional Formatting
  • Protecting a Worksheet
  • Working with Duplicate Data
  • Functions
    • Payment
    • IPMT
    • PPMT
    • PV
    • FV
    • Rate
    • NPER
    • SumIF
    • CountIF
    • IF and Nested IF statements
  • Work with Comments
  • Audit Worksheets
  • Create and Modify Charts
  • Use Data Analysis Tools
    • Create a Histogram
    • Create a Statistical Summary Report
  • Learn where to go for help
    • Microsoft
    • Lynda.com
  • Customize Excel’s Default Settings

Cancellation Policy

Cancellation requests submitted 48 hours or more in advance of the start date will receive a full refund of paid registration fees. Cancellation requests submitted less than 48 hours in advance will receive a 50% refund of paid registration fees.

For More Information

If you need help or have questions about this program, please contact Caitlin Dow at cmdow@umn.edu or call 612-625-1216.

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .