Learn to Master Microsoft Excel: Week 16 Excel Hacks!

Welcome to the final 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 16.

Rookie: How can Excel make my life easier?

Week 16: Modifying Cell Styles http://www.skillsx.com/topic/x101-119/

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

Week 16: MID Function http://www.skillsx.com/topic/x111-113/

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 15 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 15.

Rookie: How can Excel make my life easier?

Week 15: Copying and Pasting http://www.skillsx.com/topic/x101-112/

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

Week 15: ERROR Filtering http://www.skillsx.com/topic/x111-110/

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 14 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 14.

Rookie: How can Excel make my life easier?

Week 14: Freeze Panes http://www.skillsx.com/topic/x101-109/

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

Week 14: Data Validation List http://www.skillsx.com/topic/x111-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 13 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 13.

Rookie: How can Excel make my life easier?

Week 13: What is a Function http://www.skillsx.com/topic/x111-106/

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


Week 12: MATCH Function 
http://www.skillsx.com/topic/x111-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 12 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 12.

Rookie: How can Excel make my life easier?

Week 12: The Context Menu http://www.skillsx.com/topic/x101-106/

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

Week 12: INDEX Function http://www.skillsx.com/topic/x111-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 11 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 11.

Rookie: How can Excel make my life easier?

Week 11: The Context Menu http://www.skillsx.com/topic/x101-105/

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

Week 11: Amending Chart Data http://www.skillsx.com/topic/x121-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 10 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 10.

Rookie: How can Excel make my life easier?

Week 10: Semi-Anchored Referencing http://www.skillsx.com/topic/x101-123/

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

Week 10: Copy Across Sequence http://www.skillsx.com/topic/x102-108/

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 9 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 9.

Rookie: How can Excel make my life easier?

Week 9: Absolute Addressing http://www.skillsx.com/topic/x101-122/

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

Week 9: Auto-SUM with Alt + = http://www.skillsx.com/topic/x102-113/

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 Excel: Week 8 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 8.

Rookie: How can Excel make my life easier?

Week 8: Relative Addressing http://www.skillsx.com/topic/x101-121/

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

Week 8: Use Timing Flags http://www.skillsx.com/topic/x201-27/
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 7 Hack

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 7.

Rookie: How can Excel make my life easier?

Week 7: Formatting Numbers http://www.skillsx.com/topic/x101-117/

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

Week 7: Insert Copied Cells http://www.skillsx.com/topic/x102-112/

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/*