META LAB and the DLC are collaborating once again to provide a series of Excel workshops during the first half of the Spring 2015 term to support the MIIS community. Learning sessions will take advantage of the Lynda.com Excel 2013 Essential Training online video tutorial series progressing from introductory topics to more intermediate skills and functions.
Spring 2015 sessions will be held in CF442, Pac Lab. Your facilitator will be META Lab graduate assistant and Data Analysis Teaching Assistant: Jeff Zeitz.
There are four sessions currently scheduled. Session #1 will cover the basics, and we want to be clear, it will be the very basics, while subsequent sessions will move toward more advanced skills. But please feel free, if you are already familiar with Excel, and don’t think you need a basic class, to sign up for any of the classes in the series that might interest you.
We will be using a Flipped Classroom format for these classes. Participants are responsible for watching the videos associated with the class(es) they will be attending, so we can work with the skills you have learned and answer any questions you might have.
A list of the videos associated with the various sessions and who might most benefit from watching them is linked in the “Video List” link associated with each session. The videos are labeled based upon the skill level they would most likely help. There are currently four groups on the lists, “Beginner” – if you have very little experience with Excel, this is you, “Middle” – if you have some experience with Excel but not a lot, this is you, “Everyone” – this is information everyone should know, take a look at the description provide with the video and determine for yourself if you need to watch it, and lastly, “ALL” – this is a video that I think everyone should watch, even if you have been using Excel for a while.
The bullet points listed below each class session is associated with the Lynda.com videos we will cover in that class.
SIGN UP BELOW
Excel Learning Series: Dates, Times, and Locations
Session #1: Friday, February 20, 12:15-1:30pm | Location: CF442 – PAC Lab | Video List
- Getting Started with Excel
- Entering Data
- Creating Formulas and Functions
Session #2: Friday, February 27, 12:15-1:30pm | Location: CF442 – PAC Lab | Video List
- Formatting
- Adjusting Worksheet Layout
- Printing
Session #3: Friday, March 6, 12:15-1:30pm | Location: CF442 – PAC Lab | Video List
- Introduction to Charting
- Adjusting Worksheet Views
Session #4: Friday, March 13, 12:15-1:30pm | Location: CF442 – PAC Lab | Video List
- Multiple Worksheets and Workbooks
- This last one is still being decided on and will either be
- IF, VLOOKUP, and Power Functions, or
- Pivot Tables
Session #4 Make-Up Session: Friday, March 27, 1:00-2:30pm | Location: CF442 – PAC Lab | Video List
- Multiple Worksheets and Workbooks
- This last one is still being decided on and will either be
- IF, VLOOKUP, and Power Functions, or
- Pivot Tables
[sign_up_sheet category_id=”1″]
Lynda.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”