Excel 2016 for the Mac: Managing and Analyzing Data
Offered By: LinkedIn Learning
Course Description
Overview
Learn easy-to-use data management commands and techniques to manage and analyze large lists of data.
Syllabus
Introduction
- Welcome
- 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
- 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
- Advanced Filter for complex OR criteria
- Advanced Filter for specialized filters
- Advanced Filter to create unique lists
- Single- and multiple-level subtotals
- Expand and collapse displays with symbols
- Remove Duplicates command
- Identify duplicate data
- Count unique items using an array formula
- SUMIF and COUNTIF and related functions
- Database functions
- Use tables for formatting and data-handling features
- Next steps
Taught by
Dennis Taylor
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX