Black Friday 2024: 25+ Ways to Save on Online Learning

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel for Mac 2016: Shortcuts

via LinkedIn Learning

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
Become a more productive, efficient Excel user with this collection of tips and tricks—just for Mac.

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.

Syllabus

Introduction
  • Welcome
  • What you should know before watching this course
  • Using the exercise files
1. Top 10 Shortcuts
  • Entering numbers with leading zeros
  • Entering data series using the fill handle
  • Adding text to a number format
  • Printing a sheet on a set number of pages
  • Using an Excel table column as a named range
  • Numbering rows in a range or table
  • Creating hyperlinks to other resources
  • Summarizing data using SUMPRODUCT
  • Hiding worksheets
  • Creating recommended PivotTables
2. Controlling the Excel Program and Interface
  • Controlling the Ribbon
  • Customizing the Quick Access Toolbar
  • Showing Excel in full-screen mode
  • Displaying the templates page while Excel is running
  • Closing or quitting Excel quickly
3. Managing Workbooks and Worksheets
  • Moving among worksheets quickly
  • Displaying a workbook’s full path
  • Setting the number of worksheets in a workbook
  • Displaying the Save As dialog box quickly
  • Setting a print area
4. Organizing Data
  • Selecting noncontiguous cell ranges
  • Extending a selection using the keyboard
  • Creating a linked picture of a range
  • Creating a custom view
  • Creating a table using Ctrl+T
  • Applying a table style and replacing existing formatting
  • Finding a target value
  • Creating substitute data sets using scenarios
5. Entering and Formatting Data
  • Entering a line break into a cell
  • Wrapping and shrinking cell text
  • Entering data into every cell in a range
  • Picking data from a list
  • Entering data into cells across multiple sheets
  • Entering data using an AutoCorrect value
  • Changing the font size using the keyboard
  • Displaying the Format Cells dialog box
  • Finding a specific color using RGB values
  • Basing conditional formats on a formula
6. Managing a Data Series
  • Extending a date series
  • Using a custom list with the fill handle
  • Entering a data series quickly
  • Removing duplicate values
7. Working with Dates and Times
  • Inserting the current date or time
  • Displaying times that exceed 24 hours
  • Calculating days between dates
  • Calculating workdays between dates
  • Calculating time to reach an investment goal
  • Displaying thousandths of a second
8. Creating Useful Formulas
  • Generating a list of unique random numbers
  • Using INDEX and MATCH to look up data without using the leftmost column
  • Summarizing data on the status bar
  • Rounding values
  • Summarizing data using AutoSum formulas
  • Creating custom error messages using IFERROR
9. Managing Formulas
  • Calculating running totals
  • Creating and selecting named ranges quickly
  • Commenting within a formula
  • Displaying a cell formula using FORMULATEXT
  • Exiting a cell without saving changes
  • Dealing with errors
Conclusion
  • Next steps

Taught by

Curt Frye

Reviews

Start your review of Excel for Mac 2016: Shortcuts

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.