Excel Learning Series – Spring 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 11-12. All you need to bring is yourself! Your facilitator will be META Lab GA and Data Analysis Teaching Assistant: Mentru Nagbe. 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.

Schedule

  • Session 1: February 19, 11-12
  • Session 2: February 26, 11-12
  • Session 3: March 11, 11-12
  • Session 4: March 18, 11-12
  • Session 5: April 1, 11-12 

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 5

  • Linking functions, equations, and graphs
  • Creating custom budgets from scratch
  • Series review

Session 4

  • More pivot tables
  • Working in multiple workbooks
  • Linking workbooks and formulas
  • Uploading untidy data
  • In-depth V-lookup
  • Financial functions

Session 3

  • How to create a charts (All Types)
  • Other chart types, mixed income as line, expenses and
  • savings as stacked column
  • Altering parts of a chart
  • SPARKLINES
  • Freeze panes
  • Splits
  • Outlining
  • Some more useful functions
  • Pivot Table (time permitting)

Session 2

  • Formatting Cells
  • Tabs (part 2)
  • Row Height and Columns Width
  • Alignments
  • Text Wrap
  • Borders
  • Numerical Formatting
    • Dates
    • Time
  • Format
  • Conditional Formatting
  • Tables
  • Hidden Function
  • Print Preview tab
  • Previewing Page Breaks
  • Page Set up and printing screen

Session 1

  • Cursor
  • Cells
  • Formula bar
  • Tabs
  • Worksheets
  • Templates
  • Fonts
  • Copy and paste
  • Wrap text
  • Minitoolbar
  • Quick Access Tool Bar-
  • Status Bar
  • Entering data
    • Autofill
    • Undo/redo
    • Comments
    • Save
  • Formulas
    • Writing formulas
    • Copying formulas
    • $$$$$$

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”