YoVDO

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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard