Lynda – Excel 2011 for the Mac: Managing and Analyzing Data

Lynda – Excel 2011 for the Mac: Managing and Analyzing Data

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.

Topics include:

* 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

Download uploaded
http://uploaded.net/file/2l6y2ba1/LcExcel2011MacMangAnlzDta.part1.rar
http://uploaded.net/file/sywxtn82/LcExcel2011MacMangAnlzDta.part2.rar
http://uploaded.net/file/j0xvv09z/LcExcel2011MacMangAnlzDta.part3.rar
http://uploaded.net/file/z8jquw0c/LcExcel2011MacMangAnlzDta.part4.rar

Download nitroflare
http://www.nitroflare.com/view/4A6E3B6B8F7EC28/LcExcel2011MacMangAnlzDta.part1.rar
http://www.nitroflare.com/view/6C62CCAD911EA2A/LcExcel2011MacMangAnlzDta.part2.rar
http://www.nitroflare.com/view/04AC02462F2AF8D/LcExcel2011MacMangAnlzDta.part3.rar
http://www.nitroflare.com/view/01070E0FE40F653/LcExcel2011MacMangAnlzDta.part4.rar

Download rapidgator
http://rg.to/file/e3f4783d6568993eb8b6480fc42432c8/LcExcel2011MacMangAnlzDta.part1.rar.html
http://rg.to/file/4177c9645ff6db4ace024fc08c2c740b/LcExcel2011MacMangAnlzDta.part2.rar.html
http://rg.to/file/1d3c5ce7ae2ede7ab85b3f7fdf3598c8/LcExcel2011MacMangAnlzDta.part3.rar.html
http://rg.to/file/38ff120c88046d0a1b40606e8392b77c/LcExcel2011MacMangAnlzDta.part4.rar.html

Download 百度云

你是VIP 1个月(1 month)赞助会员，