Set Reminder Save for later

Excel 2016

Tips and Tricks

Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly.

The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost. Topics include:
  • Entering today's date or time instantly
  • Converting formulas to values with a simple drag
  • Undoing and redoing with keyboard commands
  • Accessing the Ribbon from the keyboard
  • Creating split screens fast
  • Navigating in workbooks quickly
  • Selecting noncontiguous ranges
  • Entering data more efficiently
  • Dragging and dropping data
  • Performing calculations without formulas
  • Applying formatting with keyboard shortcuts
  • Using database techniques to work with Excel data
  • Working with charts, shapes, and linked images

Get Details and Enroll Now

OpenCourser is an affiliate partner of LinkedIn Learning.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

LinkedIn Learning

Rating Not enough ratings
Length 5h 51m
Starts On Demand (Start anytime)
Cost $0/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Dennis Taylor
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Business Data Science
Tags Business Excel Spreadsheets

Get a Reminder

Get an email reminder about this course

Send to:

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Colorist Expert $34k

Negotiator Expert $38k

English Language Development, AVID & AVID Excel Teacher $53k

Transportation Expert $54k

Hairstylist Expert $59k

Excel Reporting Developer $68k

F/A Expert $70k

Excel/Access DTS Developers $78k

Excel VBA Developer $82k

Excel/Access DTS Developer $83k

Tutor - Accounting/ Excel /ESL $87k

MBB Expert $109k

Write a review

Your opinion matters. Tell us what you think.

LinkedIn Learning

Rating Not enough ratings
Length 5h 51m
Starts On Demand (Start anytime)
Cost $0/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Dennis Taylor
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Business Data Science
Tags Business Excel Spreadsheets

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now