#FREE Excel 2011 for the Mac: Managing and Analyzing Data #Business #Excel

When you work with large amounts of data, you need tools to manage the sheer volume of information and get the most value from it. In this course, Dennis Taylor shares easy-to-use commands and methods for managing and analyzing data with Excel 2011 for Mac. The course covers sorting, inserting subtotals, filtering, identifying and deleting duplicate data, using the Excel Advanced Filter feature, and gathering valuable statistical information with specialized database functions.

LEVEL –  Intermediate

COURSE TOPICS:

Multiple-key sorting
Sorting columns left-to-right
Filtering columns
Creating a top-ten list with values or percentages
Using Advanced Filter for complex filters
Setting up subtotals
Using the Remove Duplicates command
Using SUMIF, COUNTIF, and related functions
Working with the database functions, such as DSUM and DMAX

READ MORE

LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Excel 2011 for the Mac: Managing and Analyzing Data”

Instructor’s Welcome Note:

(bright music) – Hi, I’m Dennis Taylor and welcome to Excel 2011 for the Mac: Managing and Analyzing Data. 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 gather valuable statistical information via the SUMIF family of functions and the database statistical functions. So, let’s get started with Excel 2011 for the Mac: Managing and Analyzing Data.

 

 

Get 10 days of FREE unlimited access to Lynda.com.

Excel 2011 for the Mac: Managing and Analyzing Data
Business Intelligence T
Dennis Taylor tutorials
Lynda review

from Course reviews, freebies, coupons http://www.coursetag.com/free-excel-2011-for-the-mac-managing-and-analyzing-data-business-excel/