Fall 2015 Excel Learning Series – Session 3

Amy Slay Data Analysis, Events, Excel October 5, 2015

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

To get access to the learning series materials and receive information on future sessions, click the sign up button!

Resources

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”

Fall 2015 Excel Learning Series – Session 2

Amy Slay Data Analysis, Events, Excel, TW@M, Workshops September 16, 2015

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.

Sign Up

To 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

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 September 4, 2015

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.

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

To get access to the learning series materials and receive information on future sessions, click the sign up button!

Resources

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

Excel Learning Series

Amy Slay Data Analysis, Events, Excel, MIIS Update, TW@M, Workshops September 9, 2014September 20, 2014

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:

If 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 March 6, 2014

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.

Effective Data Presentation Techniques Wrap Up

Molly Sterns Data Analysis, Presentations, Workshops November 26, 2013

For those of you who attended Profs. Ruehsen and Murphy’s workshop last week on Effective Data Presentation Techniques, here are their slides for your records. For those who were unable to attend, feel free to have a look through and try to identify the most effective and ineffective approaches. If you’re not sure, come by the Digital Learning Commons to get the recap!

Data Presentation Techniques 2013

Thanks again to Profs. Ruehsen and Murphy for a very helpful presentation.

Upcoming Event: Effective Data Presentation Techniques

Molly Sterns Blog, Data Analysis, Events, MIIS Update, Presentations, Workshops November 8, 2013

A workshop @ The Commons with Profs. Moyara Ruehsen and Phil Murphy

Monday, November 18, 6:00 pm in the Design Space

Wondering how best to present your data for all of those course assignments and reports? Well, now is your chance to learn from the experts. Tell your story in a coherent and effective manner with a graph that your audience can interpret in two seconds. Should you use a pie chart for that data? Is there an optimal number of slices? What about an area diagram? When is it best to use a horizontal bar chart instead of a vertical column chart? When do stacked columns make sense? (Almost never.) How can 3-D deceive? Are there effective ways to combine lines and columns in the same diagram? (Yes.) And will it ever make sense to use a stacked area diagram (yes) or a donut or half-donut (yes)? Or should you abandon the chart idea altogether and just go with a table? (Sometimes.) Hear more nuanced answers to these questions and more!