Loading...

Description

This advanced Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with what-if analysis, data tables, basic macros, data validation and basic macros. 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

  • What-if Analysis
    • Goal Seek
    • Data Tables
    • Scenarios
  • Named cell ranges
  • Basic macros using the Microsoft macro recorder
    • Edit macros
    • Create macro button
  • Pivot Tables and Pivot Charts
    • Modifying Pivot Tables
    • Drill-down
    • Filters, Slicers, Timelines
  • Text and Lookup Functions
    • Trim
    • Proper
    • Concatenate
    • Flash Fill
    • VLookup
  • Data validation

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 .