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
4.2 (62 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.
5,622 students enrolled
Free
Start Learning Now
  • Lectures 16
  • Length 1 hour
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course 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

What are the requirements?

  • Basic understanding of worksheets, workbooks, and the Microsoft Excel Ribbon

What am I going to get from this course?

  • 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

What is the target audience?

  • Microsoft Excel 2010, 2013, or 2016 (PC/Windows Users)
  • NOT FOR: Mac Users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started with this Course
Introduction to the Course
02:15
DOWNLOAD: Course Excel Files
03:06
Section 2: The Excel Interface & Working More Effectively
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
Section 3: Excel Workbooks & Worksheets: Getting What You Want DONE!
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
Section 4: Course Wrap-Up
Final Thoughts & Next Steps
01:10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The ProductivityMe Company, 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!

Ready to start learning?
Start Learning Now