Excel

Fall 2015 Excel Learning Series – Session 3

Amy Slay Data Analysis, Events, Excel

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 during the first half of the Fall 2015 term to support the MIIS community. The third of four sessions will take place on October 9th at noon in CF442, Pac Lab. All you need to bring is yourself! Your facilitator will be META Lab graduate assistant 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.

Session 3 Topics

  • Charts and Adjusting Worksheet View
  • How to create a charts (All Types)
  • Other chart types, mixed Use income as line, expenses and
  • Savings as stacked column
  • Altering parts of a chart
  • SPARKLINES
  • Freeze panes
  • Splits
  • Outlining

Sign Up

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

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”

Fall 2015 Excel Learning Series – Session 2

Amy Slay Data Analysis, Events, Excel, TW@M, Workshops

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 during the first half of the Fall 2015 term to support the MIIS community.  The second of four sessions will take place on September 25th 11am – noon in MG100 (McGowan 100).  All you need to bring is yourself and your laptop! Your facilitator will be META Lab graduate assistant 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.

Sign Up

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

Session 2 Topics

  • Control 1 important and easy way to get to the format cell box
  • Formatting Cells
  • Tabs (part 2)
  • Row Height and Columns functions
  • 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

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”

Fall 2015 Excel Learning Series

Amy Slay Data Analysis, Events, Excel, MIIS Update, TW@M, Workshops

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 during the first half of the Fall 2015 term to support the MIIS community. The first of four sessions will take place on September 11th at noon in CF442, Pac Lab. All you need to bring is yourself! Your facilitator will be META Lab graduate assistant 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.

Session 1 Topics

– cursor
– cells
– formula bar
– tabs
– worksheets
– templates
– fonts
– copy and paste
– wrap text
– mini toolbar
– quick access tool bar
– status bar
– entering data
– autofill
– undo/redo
– comments
– save
– writing + copying formulas
– $$$$$$

Sign Up

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

 

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”

You helped us help you

George Payne About Us, Curricular Technology, Digital Storytelling, Excel, Projects, Services, Workshops

This past Tuesday from 12-2 the DLC had a table set up on Samson Patio, accompanied by a mobile white board. We were staging an event to assess the needs of the student body in the final weeks of the Spring Semester. We wrote on the board:

Come have your needs assessed!

How can the DLC help you succeed in the last 4 weeks of the semester?

I need to be able to:

Use   |    Make   |   Manage

And at least 25 of you all gave us your detailed opinions about how we could help you to succeed in the last 4 weeks of class. This is what we learned:

  1. Some students demanded that we offer training on Customer Relationship Management (CRM) and Staff Management software, like Salesforce, Asana, and Basecamp.
  2. Some students are tired of playing the role of technical support to teachers who struggle to use the iLearn platform, and GA positions are springing up to address those needs, but the DLC is assumed to be at fault for that.
  3. Excel training in workshop format will remain in high demand every semester.
  4. Making websites (in e-portfolio/blog format especially), infographics, and digital storytelling methods are coming in increasingly high demand.
  5. Some students love being supported by the DLC in full-class format because they want to be able to learn beside their classmates in DLC workshops.
  6. TLM students continue to request that we teach them how to build apps.
  7. Many of you don’t feel comfortable navigating Apple computers
  8. Some students are under the impression that we in the DLC assume going to Lynda solves problems, but many of you find it intimidating to teach yourselves in that way.

So what are we going to do about it? Some of you will receive a direct email in response to our assessment. Some of you will be best addressed in group format, so keep a look out for a group email. And other needs may take a few more days of prep to be addressed appropriately. We may organize a workshop or two, but we need to have another team meeting on Wednesday first.

More updates coming soon

Excel Learning Series

Amy Slay Data Analysis, Events, Excel, MIIS Update, TW@M, Workshops

META LAB and the DLC are collaborating to provide a series of Excel workshops throughout the Fall 2014 semester to support the MIIS community.  Learning sessions will progress from introductory topics to more advanced tools and functions. Your facilitator will be META Lab graduate assistant and Data Analysis Teaching Assistant: Amer Shurrab.

Excel Learning Series: Weekly Topics to be Covered

  • Session #1: Friday, September 19, Location: CF 434
  • Session #2: Friday, September 26, Location: CF 434
  • Session #3: Friday, October 3, Location CF 452

*PLEASE REGISTER BELOW TO JOINT THE EXCEL LEARNING SERIES MAILING LIST
To help us plan for the series, REGISTER by filling out the survey below:

Lynda.com logoIf you’re interested in learning more about Excel, there are numerous web resources available. 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”

Intro to Excel Workshop!

Molly Sterns 2014 Services, Data Analysis, Events, Excel, MIIS Update, Workshops

Working with data this semester? Want to brush up on your foundational Excel skills? Come to the DLC Thursday, March 13 from 12:30-1:30 to go through a basic training on how to format and summarize a data set. We’ll go over how to sort your columns and rows, hide what you don’t need (and unhide it if you decide you do), freeze panes to make scrolling easier, calculate summary statistics like mean and standard deviation, and anything else you want to know. This is a beginner class and we will move as slowly as needed.  In future weeks we will offer more advanced classes depending on demand.

Bring your computer and any specific projects or questions you have.

Weekly Excel Workshop: Catch-Up Week!

Molly Sterns Excel, Workshops

Have you been attending the DLC’s weekly Excel trainings, but have questions about some of the material that’s been covered? Or maybe you haven’t made it to any sessions yet, but have been meaning to come by with specific questions.  Either way, this drop-in catch up session is for you.  DLC Staff will be available to review topics and troubleshoot – a great chance for 1:1 attention on all your Excel questions!

We’ll plan to meet in the upstairs of the DLC.

See you there!