Managing and Analyzing Data in Excel 2010 - Lynda Tutorials - [GameSlim]

seeders: 4
leechers: 12
Added on November 21, 2015 by GameSlimin Other > Tutorials
Torrent verified.



Managing and Analyzing Data in Excel 2010 - Lynda Tutorials - [GameSlim] (Size: 397.24 MB)
 Ex_Files_Man_Data_Excel.zip2.1 MB
 How to Manage & Analyze Data in Excel #01 Welcome.mp49.67 MB
 How to Manage & Analyze Data in Excel #02 Exercise Files.mp42.01 MB
 How to Manage & Analyze Data in Excel #03 Menu.mp419.26 MB
 How to Manage & Analyze Data in Excel #04 Toolbar.mp421.23 MB
 How to Manage & Analyze Data in Excel #05 Multiple.mp412.68 MB
 How to Manage & Analyze Data in Excel #06 Custom.mp425.46 MB
 How to Manage & Analyze Data in Excel #07 Color.mp417.93 MB
 How to Manage & Analyze Data in Excel #08 Column.mp48.26 MB
 How to Manage & Analyze Data in Excel #09 Random.mp410.67 MB
 How to Manage & Analyze Data in Excel #10 Column.mp422.6 MB
 How to Manage & Analyze Data in Excel #11 Numeric.mp47.86 MB
 How to Manage & Analyze Data in Excel #12 Date.mp49.81 MB
 How to Manage & Analyze Data in Excel #13 Topten.mp413.09 MB
 How to Manage & Analyze Data in Excel #14 Custom.mp46.49 MB
 How to Manage & Analyze Data in Excel #15 Copy.mp413.79 MB
 How to Manage & Analyze Data in Excel #16 Limits.mp47.99 MB
 How to Manage & Analyze Data in Excel #17 Set Subtotals.mp416.81 MB
 How to Manage & Analyze Data in Excel #18 Multiple.mp429.85 MB
 How to Manage & Analyze Data in Excel #19 OR.mp416.28 MB
 How to Manage & Analyze Data in Excel #20 Complex.mp421.17 MB
 How to Manage & Analyze Data in Excel #21 Unique.mp415.76 MB
 How to Manage & Analyze Data in Excel #22 Remove Dup.mp411.92 MB
 How to Manage & Analyze Data in Excel #23 Identify Dup.mp427.86 MB
 How to Manage & Analyze Data in Excel #24 Count If.mp411.93 MB
 How to Manage & Analyze Data in Excel #25 Sum If.mp420.08 MB
 How to Manage & Analyze Data in Excel #26 Database Functions.mp412.88 MB
 How to Manage & Analyze Data in Excel #27 Next Steps.mp41.77 MB
 Managing and Analyzing Data in Excel 2010.txt820 bytes

Description

image
Managing and Analyzing Data in Excel 2010
1h 32m
Appropriate for all
Oct 27, 2011

In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.

Topics include:
Multiple key sorting
Single and multiple column numeric filters
Creating a top-ten list with values or percentages
Setting up subtotals
Creating multiple-field criteria filters
Creating unique lists from repeating field data
Using the Remove Duplicates command
Finding duplicate data with specialized arrays
Counting the number of unique items in a list
Using SUMIF and COUNTIF functions
Working with the database functions such as DSUM and DMAX

Sharing Widget


Download torrent
397.24 MB
seeders:4
leechers:12
Managing and Analyzing Data in Excel 2010 - Lynda Tutorials - [GameSlim]