Productivity Secrets – Freeze, Pane, Quick Access, Keyboard Shortcuts

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
Unfortunately, once people know how to use a few basic functions in Excel, the learning usually stops. Instead, what people should be asking themselves, is “how can I do, what I’m doing, faster?” You’ll be surprised at how many times I see people performing tasks 10 times or even sometimes 20 times longer than they should. Don’t be one of these people. Instead, learn a few more shortcuts and you’ll not only make your work life easier, but you’ll free up more time to talk with your buddies at the water fountain!

TARGET AUDIENCE
I don’t encourage beginners to learn shortcuts just yet. Therefore this is designed for intermediates and expert users looking to enhance they’re performance. 

STRUCTURE
I’ve tried to cover as many of the main shortcuts I use. This is by no means all of them but should be enough to get you going. This course contains over 20 videos and just under 50 minutes of content. 

DIFFICULTY
Intermediates to experts

COURSE OUTCOMES

  • Freeze panes
  • Slider divider
  • Quick access toolbar (basics only. See my full course for more on this subject)
  • Quick ribbon control
  • Instance navigation
  • Section highlighting
  • Workbook switching
  • Zooming

Course Structure

  • The Opening Act
  • Getting Started
    • Case Study Explained
      00:00:00
      • DOWNLOADABLE FILE!!
    • Freeze Panes Explained
      00:00:00
    • Using the Slider Divider
      00:00:00
    • Slider Divider To Freeze Panes
      00:00:00
  • Advanced Freeze Pane Techniques
    • Freezing The First Column
      00:00:00
    • Instant Freeze Pane Explanation
      00:00:00
    • Instant Freeze Pane - Horizontal
      00:00:00
    • Instant Freeze Pane - Vertical
      00:00:00
    • Instant Freeze Pane - Horizontal and Vertical
      00:00:00
  • Quick Access Toolbar
    • Quick Access Toolbar Explained
      00:00:00
    • Adding and Removing Icons
      00:00:00
    • Reordering the Toolbar
      00:00:00
    • Control the Toolbar with the Keyboard
      00:00:00
  • Navigation and Selection Techniques

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.