Excel: Productivity Tips

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Productivity Courses Data Manipulation Courses Data Validation Courses Flash Fill Courses

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

1. 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

Conclusion: Productivity tips

Taught by

Chris Dutton

Related Courses

أفضل الممارسات لبرمجة وتطوير الهواتف المحمولة باستخدام جافا
Coursera Project Network via Coursera Build a automated CRM for Lead Management with Google Sheets
Coursera Project Network via Coursera Exploratory Data Analysis in Python
Codecademy Create a Value versus Complexity Matrix in Google Sheets
Coursera Project Network via Coursera Creating a Budget in Libre Calc for a Small Business
Coursera Project Network via Coursera