Save

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


LinkedIn Learning

Rating Not enough ratings
Length 5h 51m
Starts On Demand (None)
Cost $0
From LinkedIn Learning
Instructor Dennis Taylor
Free Limited Content
Language English
Subjects Business Data Science
Tags Business Excel Spreadsheets

Create an Alert

Not ready to take this course yet? Sign up for a one-time email reminder with a link to this course.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

Entrepreneur Expert $31k

Photography Expert $38k

Tutor Expert $45k

Merchandising Expert $55k

Marketing Expert $58k

ExCEL District Coordinator $65k

Excel Reporting Developer $68k

Investigator Expert $75k

Excel/VBA Developer $75k

Excel Specialist $75k

DBA Expert $132k

Product Support Specialist - Microsoft Excel $136k

Write a review

Your opinion matters. Tell us what you think.

LinkedIn Learning

Rating Not enough ratings
Length 5h 51m
Starts On Demand (None)
Cost $0
From LinkedIn Learning
Instructor Dennis Taylor
Free Limited Content
Language English
Subjects Business Data Science
Tags Business Excel Spreadsheets