Excel Learning Series – Fall 2016

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 from 12 – 1:30 PM. All you need to bring is yourself! Your facilitator will be META Lab GA and Data Analysis Teaching Assistant: Flynn Pollard. When used properly, Microsoft Excel can be an extremely powerful tool to display, organize, and analyze large data sets. The series will contain hidden tips and tricks in addition to exercises that will make you an Excel champion in no time. Questions? Reach out to Flynn at fpollard@miis.edu.

Please note that seating in the Pac Lab is limited – the computers are available on a first-come, first-served basis. If you prefer, you are welcome to bring your own laptops!

Schedule

  • Session 1: Friday, October 14, 12 – 1:30
  • Session 2: Friday, October 28, 12 – 1:30
  • Session 3: Friday, November 18, 12 – 1:30

Sign Up

excel-signup-buttonTo get access to the learning series materials and receive information on future sessions, click the sign up button!

 

Curriculum

Session 1: Intro to Excel

  • 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

Session 2: Making and Using Tables

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

Session 3: Charts and Other Basic Visualization Tools

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

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”