From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Welcome - Microsoft Excel for Mac Tutorial
From the course: Excel 2016 for the Mac: Managing and Analyzing Data
Welcome
- [Dennis] Hi, I'm Dennis Taylor and welcome to this course on managing and analyzing data in Excel. When you work with large lists, you need tools to manage your data and get the most information out of them. Excel has a variety of features specifically designed for these purposes and I'll cover them in detail in this course. I'll start by showing you a variety of ways to use the most important data management tool, sorting, and then show you how you can see just the data you need using filtering. I'll also show you how to automatically insert subtitles into sorted lists, how to identify and delete duplicate data, and how to convert a list into a table. Also, how to gather valuable statistical information via the COUNTIF SUMIF family of functions and that database statistical functions. This course is designed to further your knowledge of Excel. If you have little or no knowledge of this software, we recommend viewing the Excel Essentials course first. If you already feel comfortable using Excel, let's get started.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.