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
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera