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

Microsoft Excel Workbooks & Worksheets: Simple Tips & Tricks

Course Description

Course Highlights: 12 Individual, Bite-Sized LessonsDownloadable Excel FilesVerifiable Certificate of CompletionInstant Access to Instructor and the ProductivityMe Community1080p HD Quality VideoRegular 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 ToolbarHow to Customize the Ribbon How to Access to Commands Outside of the RibbonHow to Hide Worksheets and Sc... Read More »

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

Read Less
Course Outcomes:
  • 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
Course Details:

Target Audience

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

Access Timeframe

Full Lifetime Access
Certificate Info:

Type of Certification

Certificate of Completion

Format of Certification

Digital

Professional Association/Affiliation

Udemy is not an accredited institution, but we offer skills-based courses taught by experts in their field.

Method of Obtaining Certification

When all lectures have been completed, a gold or green trophy will appear on the course dashboard, signifying that the certificate of completion is ready for download. Click on the trophy to view the certificate.

Additional Details

Certificates of completion can be accessed at Udemy.com and the mobile site, but not through the mobile apps or Apple TV. If you've completed a course on the mobile app or Apple TV, please log into Udemy.com through a browser to access your certificate.
About Instructor:

The ProductivityMe Company - Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

Technical Requirements

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

DON'T HAVE TIME?

We can send you everything you need to know about this course through email.
We respect your privacy. Your information is safe and will never be shared.