Excel: Productivity Tips
Offered By: LinkedIn Learning
Course Description
Overview
Add powerful productivity tools to your Excel skill set. Learn shortcuts and hidden tools for supercharging your efficiency in Microsoft Excel.
Syllabus
Introduction
- About the Excel Productivity Tip series
- Introduction to Excel Productivity Tips
- Customizing the Excel footer
- Navigating workbooks with CTRL shortcuts
- Accessing ribbon tools with Alt key tips
- Accessing the Go To Special options
- Removing blank rows
- Creating drop-down menus with Data Validation
- Filling patterns with AutoFill and Flash Fill
- Customizing the Excel ribbon tools
- Splitting text to columns
- Synchronous scrolling across multiple workbooks
- Extracting unique values from a list
- Using named range and table references
- Protecting cells and formulas
- Conclusion: Productivity tips
Taught by
Chris Dutton
Related Courses
Rails with Active Record and Action PackJohns Hopkins University via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn Everyday Excel, Part 1
University of Colorado Boulder via Coursera Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera