Excel Learning Series – Fall 2017

Are you looking to improve your Excel skills? Does the phrase Microsoft Excel make you nervous? Fear not friends, META LAB and the DLC are collaborating once again to provide a series of Excel workshops to support the MIIS community. The sessions will take place in CF442, Pac Lab. Your instructors will be META Lab GRA Elizabeth Fisher, and MBA-IEP alumnus Kevin Morenzi. The Series is made up of two different offerings. Elizabeth’s sessions take place on Fridays and will offer a cumulative overview of Excel functionality. Kevin’s sessions take place on Thursdays and are for more advanced participants looking to get beyond the basics into advanced formulas. There is one single-sign up form for the Series (see below); we will send out reminders before each session. 

Questions? Reach out to us at dlc@miis.edu.

Please note that the maximum capacity of the Pac Lab is 30 people. Seating/computers will be available on a first-come, first-served basis.  

Schedule

Elizabeth’s sessions take place on Fridays and offer a cumulative overview of Excel functionality. Kevin’s sessions are for more advanced participants looking to get beyond the basics into advanced formulas. 

Upcoming Sessions 

Excel Overview w/ Elizabeth  Advanced Excel Formulas w/ Kevin
  • Friday, Dec 1, 12 – 2 pm, Pac Lab 

NO MORE SESSIONS 

   

 

Sign Up

excel-signup-buttonClick the sign-up button to get access to series learning materials! You only need to sign up once — we’ll keep you posted on future sessions.  Note that the maximum capacity of the Pac Lab is 30 people. Seating/computers will be available on a first-come, first-served basis. Signing up does not guarantee you a seat. 

 

Self-paced Resources

Lynda LogoLynda.com is an incredible online resource offering guided video tutorials and step by step instructions for all sorts of digital tools. As a member of the Middlebury community you have premium access. Here’s how it works:

  • Visit go.miis.edu/lynda
  • Input your MIIS login credentials
  • Search “Excel Essential Learning”

 

Previously Covered Topics 

Sign up above to receive updates. 

Excel Overview w/ Elizabeth  Advanced Excel Formulas w/ Kevin
11/3: Advanced Formulas (passed) 

  • VLOOKUP and INDEX MATCH
  • If, then type formulas
  • Formulas within formulas
  • Overview of the essentials when to use advanced formulas

10/20: Pivot Tables (passed)

  • How to create Pivot Tables
  • How to create Pivot Charts
  • Editing for different analytics
  • Brief intro to dashboards

10/6: Working with Charts (passed) 

  • How to create charts
  • Bar, column, line, pie, lines, stacked columns, sparklines
  • Editing charts
  • Application
  • Making visualizations for budgets, grade sheets, and indexes

9/22: Making and Using Tables (passed) 

  • Table creation
  • Basic data cleaning
  • Find & Select
  • Freezing panes
  • Application
    • Cleaning a table 

9/8: Intro to Excel (passed)

  • Basics
    • Cursor, cells, formula bar, tabs, worksheets, templates, fonts, copy and paste, wrapping text, and the minitoolbar
  • Entering data
    • Autofill, undo/redo, comments
  • Formulas
    • Writing basic formulas, copying formulas, stabilizing formulas
  • Application
    • Grade sheets, budgets
11/2: Power Tools (passed) 

  • Workbook Protection
  • Formula tracing, tracking, and trouble shooting
  • Data enhancements: Sparklines
  • Forecasting Tools: Forecast Sheet, Data Analysis add-ins
  • Power Tools: Power Pivot, 3D Maps 

10/12: Pivot Tables (passed) 

  • What is a Pivot Table?
  • Setting up Pivot Table data
  • Creating a Pivot Table
  • Formatting
  • Manipulation of Pivot Table Reports
  • Calculated Fields
  • Using Slicers
  • PivotCharts

9/28: Advanced Formulas (passed)

  • Understanding absolute and relative reference
  • Using specific formulas such as VLOOKUP, INDEX + MATCH
  • Embed formulas within formulas
  • Mathematical Functions
  • Logical & Reference Functions
  • Financial Functions

9/14: Intro to Excel (passed)

  • Basics
    • Cursor, cells, formula bar, tabs, worksheets, templates, fonts, copy and paste, wrapping text, and the minitoolbar
  • Entering data
    • Autofill, undo/redo, comments
  • Formulas
    • Writing basic formulas, copying formulas, stabilizing formulas
  • Application
    • Grade sheets, budgets