Learn to Master Microsoft Excel: Week 5 Excel Hacks

Welcome to the Excel Hack of the Week!

Microsoft Excel is the most widely used program for data and numerical analysis. It is used in every industry and all areas of academic study. Learn to master this powerful tool with online instruction brought to you by skillsX and the Dartmouth Center for Professional Development.

The Excel Hacks of the Week are select clips from the skillsX video library* demonstrating Excel’s most useful and powerful capabilities. Each week the CPD will send out two videos, one geared toward beginners and one geared toward more experienced users. Here are the videos for week 5.

Rookie: How can Excel make my life easier?

Week 5: Basic Formulas. http://www.skillsx.com/topic/x101-114/

Experienced: How can I do more, faster and more efficiently with Excel?

Week 5: Use the Alt Key. http://www.skillsx.com/topic/x102-104/

The full array of videos can be found at www.skillsX.com, where you are welcome to register free of charge. Don’t see a tutorial on a task you are trying to do? Just leave a comment on the Speak Up! page (see top menu) and we’ll add it. New videos every week!

*skillsX Video Library http://www.skillsx.com/reference/video-library/*

 

Learn to Master Microsoft Excel: Week 4 Hacks!

Welcome to the Excel Hack of the Week!

Microsoft Excel is the most widely used program for data and numerical analysis. It is used in every industry and all areas of academic study. Learn to master this powerful tool with online instruction brought to you by skillsX and the Dartmouth Center for Professional Development.

The Excel Hacks of the Week are select clips from the skillsX video library* demonstrating Excel’s most useful and powerful capabilities. Each week the CPD will send out two videos, one geared toward beginners and one geared toward more experienced users. Here are the videos for week 4.

Rookie: How can Excel make my life easier?

Week 4: Add a Pie Chart. http://www.skillsx.com/topic/x101-129/

Experienced: How can I do more, faster and more efficiently with Excel?

Week 4: Selecting Rows and Columns. http://www.skillsx.com/topic/x102-103/

The full array of videos can be found at www.skillsX.com, where you are welcome to register free of charge. Don’t see a tutorial on a task you are trying to do? Just leave a comment on the Speak Up! page (see top menu) and we’ll add it. New videos every week!

*skillsX Video Library http://www.skillsx.com/reference/video-library/*

Learn to Master Microsoft Excel: Week 3 Excel Hacks!

Welcome to the Excel Hack of the Week!

Microsoft Excel is the most widely used program for data and numerical analysis. It is used in every industry and all areas of academic study. Learn to master this powerful tool with online instruction brought to you by skillsX and the Dartmouth Center for Professional Development.

The Excel Hacks of the Week are select clips from the skillsX video library* demonstrating Excel’s most useful and powerful capabilities. Each week the CPD will send out two videos, one geared toward beginners and one geared toward more experienced users. Here are the videos for week 3.

Rookie: How can Excel make my life easier?

Week 3: X-Y Scatter Plot. http://www.skillsx.com/topic/x121-112/

Experienced: How can I do more, faster and more efficiently with Excel?

Week 3: Toggle the Ribbon with Ctrl+F1. http://www.skillsx.com/topic/x102-105/

The full array of videos can be found at www.skillsX.com, where you are welcome to register free of charge. Don’t see a tutorial on a task you are trying to do? Just leave a comment on the Speak Up! page (see top menu) and we’ll add it. New videos every week!

*skillsX Video Library http://www.skillsx.com/reference/video-library/) *

Learn to Master Microsoft Excel: Week 2 Excel Hacks!

Welcome to the Excel Hack of the Week!

Microsoft Excel is the most widely used program for data and numerical analysis. It is used in every industry and all areas of academic study. Learn to master this powerful tool with online instruction brought to you by skillsX and the Dartmouth Center for Professional Development.

The Excel Hacks of the Week are select clips from the skillsX video library* demonstrating Excel’s most useful and powerful capabilities. Each week the CPD will send out two videos, one geared toward beginners and one geared toward more experienced users. Here are the videos for week 2.

Rookie: How can Excel make my life easier?

Week 2: Excel Chart Types. http://www.skillsx.com/topic/x121-109/

Experienced: How can I do more, faster and more efficiently with Excel?

Week 2: Using Format Macros. http://www.skillsx.com/topic/x102-117/

The full array of videos can be found at www.skillsX.com, where you are welcome to register free of charge. Don’t see a tutorial on a task you are trying to do? Just leave a comment on the Speak Up! page (see top menu) and we’ll add it. New videos every week!

*skillsX Video Library http://www.skillsx.com/reference/video-library/) *

Welcome to the Excel Hack of the Week!

Welcome to the Excel Hack of the Week!

Microsoft Excel is the most widely used program for data and numerical analysis. It is used in every industry and all areas of academic study. Learn to master this powerful tool with online instruction brought to you by skillsX and the Dartmouth Center for Professional Development.

Are you opening Excel for the first time? Do you consider yourself proficient but are looking for some new tips? Or are you experienced and looking to take Excel to the next level?

SkillsX is founded by one of the foremost practitioners in applying Excel toward solving problems. It is now providing free video tutorials to all Dartmouth students, from basic elements to complex financial modeling and high level data analysis and visualization.

The Excel Hacks of the Week are select clips from the skillsX video library* demonstrating Excel’s most useful and powerful capabilities. Each week the CPD will send out two videos, one geared toward beginners and one geared toward more experienced users. Here are the videos for week 1.

Rookie: How can Excel make my life easier?

Week 1: Basic math functions.  http://www.skillsx.com/topic/x111-107/

Experienced: How can I do more, faster and more efficiently with Excel?

Week 1: The fastest way to visualize data – the F11 key.  http://www.skillsx.com/topic/x101-067/

The full array of videos can be found at www.skillsX.com, where you are welcome to register free of charge. Don’t see a tutorial on a task you are trying to do? Just leave a comment on the Speak Up! page (see top menu) and we’ll add it. New videos every week!

*skillsX Video Library http://www.skillsx.com/reference/video-library/)

Ready. Set. Go! Sweet Sixteen Challenge

Sweet 16 Summer Challenge

sweet_16

The Center for Professional Development (CPD) wants to challenge the ’16s on campus to develop life-long job-seeking skills and information this summer.  In order to do so, a student will:

  • Accept the Challenge under your DartBoard Profile
  • Complete 3 eligible programs offered through the CPD (Look for S16S beside the program title)
  • Network with parents & alumni; learn valuable skills; work towards an internship.
  • Show off your accomplishment with a Digital Badge once all is completed.

To participate:

  • Log into DartBoard to sign up for programs designated with (S16S)
  • Attend at least 3 of the programs offered; feel free to sign up for more!

Programs include:

  • Internship Ramp Bootcamp
  • Speed Networking
  • Recruiting Tutorial
  • The Many Face of Law
  • 6 Tips for 16s: Become an Expert Networker
  • Cracking the Case Interview
  • Crush Your Interviews

For more information, log into DartBoard.  Dare to Be Different!

Where’s the Resume Guide? What is Networking? How Do I Prepare for an Interview?

Have a suggestion for the CPD? Post a new idea or vote for one on our page.Check out what other feedback students have given us!

The Center for Professional Development is dedicated to being as accessible as possible to the student population at Dartmouth. UserVoice is a tool we have implemented for students to ask questions and get responses quickly, no matter the time of day or night.

UserVoice_logo

Where’s the Resume Guide? What is Networking? How Do I Prepare for an Interview?

The Center for Professional Development is dedicated to being as accessible as possible to the student population at Dartmouth. UserVoice is a tool we have implemented for students to ask questions and get responses quickly, no matter the time of day or night.

Have a suggestion for the CPD? Post a new idea or vote for one on our page.Check out what other feedback students have given us!

UserVoice_logo

5 Ways to Build Relationships with Faculty

Even if graduate school is not in your plans, it’s important to create great relationships with your professors. Get to know a faculty member well and they can help answer questions on course material, advise you on opportunities to apply what you study in a job or profession, and — when the time comes — write you a recommendation for a new opportunity.

Here are five tips for relationship building — courtesy of the Undergraduate Dean’s office:

  1. Go to office hours when you don’t need to.
    Show them your level of interest in what you are studying.
    cropped-cropped-logo-webwork42-150x150
  2. Give notice that you’ll be missing class in advance.
    If you are going to be out of town or have the flu, let your professor know that you’ll be missing class ahead of time. In some cases, you may be able to get notes from others.
  3. Ask about a final grade.
    Not sure why or how you ended up with the course grade you did on a transcript. Contact your faculty and ask to have a face-to-face conversation. If you did better than expected, find out what you did well. If your grade was lower than expected, it’s okay to ask why — just be careful not to play defense. Understand what happened.
  4. Pick up your final exam
    Aren’t you curious about how you did?
  5. Send a note to the professor thanking them.
    Whether you enjoyed a class, discovered a new discipline you never thought of before, changed your idea on what to major in or simply looked forward to your class everyday, say so. Who doesn’t love genuine positive feedback?Follow two or more of these steps and you’ll be well on your way to building strong relationships with your faculty!

 

Jump Into Spring Term

Given the snow, ice and salt on the ground, it’s hard to believe that Spring term is here.dartmouth_library
We’ve got a full slate of panels, interactive workshops and events, log into Dartboard and check out our Events Calendar to see what’s been scheduled so far. We’re always adding new programs, don’t forget to look for updates whenever you log in.

dartboard