Excel for Mac 2016: Shortcuts
Excel for Mac 2016: Shortcuts
MP4 | Video: 720p | Duration: 2:41:45 | English | Subtitles: VTT | 369.5 MB
MP4 | Video: 720p | Duration: 2:41:45 | English | Subtitles: VTT | 369.5 MB
Become a more productive, efficient Excel user with this collection of tips and tricks—just for Mac. Curt Frye kicks off with his top 10 power shortcuts, and introduces techniques for controlling and customizing the user interface, managing workbooks and worksheets, and organizing, entering, and formatting data. He offers shortcuts for working with dates and times, creating and managing useful formulas, and summarizing data using charts and pivot tables. Find the solution you need to fix a specific problem or speed up a certain task, or watch all 60+ tips to become an Excel power user.
Topics include:
- Entering a data series using the fill handle
- Creating hyperlinks
- Controlling the Ribbon
- Moving between worksheets quickly
- Setting a print area
- Selecting noncontiguous cells
- Applying a table style
- Creating substitute data sets using scenarios
- Wrapping and shrinking cell text
- Entering data quickly
- Removing duplicate values
- Inserting the current date or time
- Generating a list of unique random numbers
- Calculating running totals
- Summarizing data
- Dealing with formula errors