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

LinkedIn Learning

Excel 2016 for the Mac: Managing and Analyzing Data

via LinkedIn Learning

Overview

Learn easy-to-use data management commands and techniques to manage and analyze large lists of data.

Syllabus

Introduction
  • Welcome
1. Sorting Data
  • Sort concepts and Sort menu options
  • Multiple-key sorting
  • Sort from AZ and ZA menu icons
  • Sort based on data order in custom lists
  • Sort by background color or font color
  • Sort left-to-right columns
  • Sort data in random order
2. Filtering Data
  • Filter single- and multiple-column text
  • Numeric filters
  • Date filters
  • Text filters
  • Top 10 (value or percent) option
  • Create custom filters
  • Copy and sort filtered lists
  • Recognize standard filtering limitations
3. Advanced Filter
  • Advanced Filter for complex OR criteria
  • Advanced Filter for specialized filters
  • Advanced Filter to create unique lists
4. Creating Automatic Subtotals in Sorted Lists
  • Single- and multiple-level subtotals
  • Expand and collapse displays with symbols
5. Eliminating Duplicate Data
  • Remove Duplicates command
  • Identify duplicate data
  • Count unique items using an array formula
6. Data Analysis Tools
  • SUMIF and COUNTIF and related functions
  • Database functions
  • Use tables for formatting and data-handling features
Conclusion
  • Next steps

Taught by

Dennis Taylor

Reviews

4.9 rating at LinkedIn Learning based on 36 ratings

Start your review of Excel 2016 for the Mac: Managing and Analyzing Data

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.