Microsoft Excel Workbooks & Worksheets: Simple Tips & Tricks
3.8 (120 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,479 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Workbooks & Worksheets: Simple Tips & Tricks to your Wishlist.

Add to Wishlist

Microsoft Excel Workbooks & Worksheets: Simple Tips & Tricks

A Quick Guide to 12 Tips for Using Workbooks, Worksheets, and the Microsoft Excel Internal Interface More Efficiently
3.8 (120 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7,479 students enrolled
Last updated 12/2015
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use 12 quick tips when working more efficiently in Microsoft Excel
  • Control the Excel interface by activating the Access Keys
  • Customize the Quick Access Toolbar for one-touch access
  • Customize the Ribbon for better results
  • Get instant access to commands outside of the Ribbon
  • Quickly hide worksheets and scrollbars from view
  • Define a finite scroll area to control access of a worksheet
  • Quickly move between worksheets
  • Alter the default number of worksheets in a workbook
  • Quickly zoom in and out of any worksheet
  • Set a specific print area to avoid including extraneous information
  • Create a custom view for data that you can easily come back to
  • Find and copy the specific file path of your workbook
View Curriculum
Requirements
  • Basic understanding of worksheets, workbooks, and the Microsoft Excel Ribbon
Description

Course Highlights:

  • 12 Individual, Bite-Sized Lessons
  • Downloadable Excel Files
  • Verifiable Certificate of Completion
  • Instant Access to Instructor and the ProductivityMe Community
  • 1080p HD Quality Video
  • Regular Course Updates

In this Course:

Microsoft Excel is a wonderful program. It’s easy to learn, but takes time to master.

In this course, we'll walk you through 12 power user tips in order to get the most out of Excel worksheets, workbooks, and the application’s internal interface.

Give us an hour, and we’ll help you get to the next level of productivity in Microsoft Excel.

In this short, easy-to-follow training course...

We'll Cover:

  • How to Control the Excel Interface
  • How to Customize the Quick Access Toolbar
  • How to Customize the Ribbon
  • How to Access to Commands Outside of the Ribbon
  • How to Hide Worksheets and Scrollbars from View
  • How to Define a Finite Scroll Area
  • How to Move Between Worksheets via the Keyboard Only
  • How to Alter Default Number of Worksheets in a Workbook
  • How to Zoom In And Out Of Any Worksheet
  • How to Set a Specific Print Area
  • How to Create a Custom View of Data
  • How to Find and Copy a Workbook’s Specific File Path

Our Approach:

At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.

You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.

If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.

Final Thoughts:

Alright, that’s it for now.

Look forward to having you in class!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

Who is the target audience?
  • Microsoft Excel 2010, 2013, or 2016 (PC/Windows Users)
  • NOT FOR: Mac Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Getting Started with this Course
2 Lectures 05:21
Introduction to the Course
02:15

DOWNLOAD: Course Excel Files
03:06
+
The Excel Interface & Working More Effectively
7 Lectures 24:38
How to Control the Excel Interface
04:38

How to Customize the Ribbon
04:26

How to Customize the Quick Access Toolbar
04:52

How to Access to Commands Outside of the Ribbon
03:41

How to Hide Worksheets and Scrollbars from View
03:17

How to Define a Finite Scroll Area
03:21

Half-Way Checkpoint
00:23
+
Excel Workbooks & Worksheets: Getting What You Want DONE!
6 Lectures 17:22
How to Move Between Worksheets via the Keyboard Only
02:11

How to Alter the Default Number of Worksheets in a Workbook
02:27

How to Zoom In and Out Of Any Worksheet
03:04

How to Set a Specific Print Area
02:52

How to Create a Custom View of Data
03:59

How to Find And Copy a Workbook’s Specific File Path
02:49
+
Course Wrap-Up
1 Lecture 01:10
Final Thoughts & Next Steps
01:10
About the Instructor
The ProductivityMe Company
4.2 Average rating
1,631 Reviews
35,103 Students
26 Courses
Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

ProductivityMe

Try. Learn. Conquer. Excel.

We create short, engaging videos that help people Master Excel.

We offer simple and easy-to-follow courses, and like our thousands of students, we’re always excited to learn cool new things.

This is ProductivityMe.

Udemy Course Instructors

Tolan Thornton
ProductivityMe Co-founder & Lead Udemy Instructor

Tolan went to the University of Arizona. He graduated summa cuma laude in the top 1% of his class with a Bachelor’s of Science Administration in Finance & Entrepreneurship and a Bachelor’s of Arts in French & East Asian Studies.

Tolan has worked at a top-tier economic consulting firm, specializing in Energy Deals and Financial Litigation.

Fun Facts about Tolan:

Tolan is the oldest of 3 children. He loves to travel.

Tolan has lived in Paris, New York, London, Beijing, Hangzhou, and Casablanca.

Odd fact? Tolan’s left leg is 5mm shorter than his right.

If Tolan had a year off, he’d learn a fourth language- maybe Portuguese, Spanish, or Hindi.

Ryan FitzPatrick
ProductivityMe Co-founder & Udemy Instructor

Ryan graduated summa cuma laude in the top 3% of his class with a Bachelor’s of Science Administration in Management Information Systems & Entrepreneurship.

Ryan has worked in non-profits as well as in Enterprise Management Software. He has worked as a consultant, as a tutor, even a bit in retail!

Fun Facts about Ryan:

Ryan is the younger of 2 children. Though he travels a lot for work, Ryan thinks of Tucson as home.

Ryan loves to write. Short-stories and essays are mostly his passion, but Ryan has even started screenplays, just for kicks!

If Ryan had a year off, he’d probably learn to code. That or start (another) company. Who knows, maybe he’d even do both!