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

seeders: 4

leechers: 12

Download torrent

Added on November 21, 2015 by GameSlimin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Managing and Analyzing Data in Excel 2010 - Lynda Tutorials - [GameSlim] (Size: 397.24 MB)

		Ex_Files_Man_Data_Excel.zip	2.1 MB
		How to Manage & Analyze Data in Excel #01 Welcome.mp4	9.67 MB
		How to Manage & Analyze Data in Excel #02 Exercise Files.mp4	2.01 MB
		How to Manage & Analyze Data in Excel #03 Menu.mp4	19.26 MB
		How to Manage & Analyze Data in Excel #04 Toolbar.mp4	21.23 MB
		How to Manage & Analyze Data in Excel #05 Multiple.mp4	12.68 MB
		How to Manage & Analyze Data in Excel #06 Custom.mp4	25.46 MB
		How to Manage & Analyze Data in Excel #07 Color.mp4	17.93 MB
		How to Manage & Analyze Data in Excel #08 Column.mp4	8.26 MB
		How to Manage & Analyze Data in Excel #09 Random.mp4	10.67 MB
		How to Manage & Analyze Data in Excel #10 Column.mp4	22.6 MB
		How to Manage & Analyze Data in Excel #11 Numeric.mp4	7.86 MB
		How to Manage & Analyze Data in Excel #12 Date.mp4	9.81 MB
		How to Manage & Analyze Data in Excel #13 Topten.mp4	13.09 MB
		How to Manage & Analyze Data in Excel #14 Custom.mp4	6.49 MB
		How to Manage & Analyze Data in Excel #15 Copy.mp4	13.79 MB
		How to Manage & Analyze Data in Excel #16 Limits.mp4	7.99 MB
		How to Manage & Analyze Data in Excel #17 Set Subtotals.mp4	16.81 MB
		How to Manage & Analyze Data in Excel #18 Multiple.mp4	29.85 MB
		How to Manage & Analyze Data in Excel #19 OR.mp4	16.28 MB
		How to Manage & Analyze Data in Excel #20 Complex.mp4	21.17 MB
		How to Manage & Analyze Data in Excel #21 Unique.mp4	15.76 MB
		How to Manage & Analyze Data in Excel #22 Remove Dup.mp4	11.92 MB
		How to Manage & Analyze Data in Excel #23 Identify Dup.mp4	27.86 MB
		How to Manage & Analyze Data in Excel #24 Count If.mp4	11.93 MB
		How to Manage & Analyze Data in Excel #25 Sum If.mp4	20.08 MB
		How to Manage & Analyze Data in Excel #26 Database Functions.mp4	12.88 MB
		How to Manage & Analyze Data in Excel #27 Next Steps.mp4	1.77 MB
		Managing and Analyzing Data in Excel 2010.txt	820 bytes

Description

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]