Users Online

· Guests Online: 18

· Members Online: 0

· Total Members: 188
· Newest Member: meenachowdary055

Forum Threads

Newest Threads
No Threads created
Hottest Threads
No Threads created

Latest Articles

· Leccture 8
· Udemy – Intro Robo...
· Dropshipping
· Udemy – The Comple...
· Udemy – Course 4: ...

Articles Hierarchy

Articles Home » Data Science » Become a Data Scientist

Become a Data Scientist

Excel 2016: Managing and Analyzing Data with Dennis Taylor

3h • COURSE
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating duplicate data, and using Excel's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time.
Topics include:
  • Prepping data for analysis
  • Multiple-key sorting
  • Sorting by rows or by columns
  • Setting single- and multi-level subtotals
  • Using text, numeric, and date filters
  • Creating custom filters
  • Filtering tables using slicers
  • Using Advanced Filter
  • Eliminating duplicate data
  • Using SUMIF and COUNTIF functions for quick data analysis
  • Working with the database functions such as DSUM and DMAX

· Posted by Superadmin on January 22 2019 · 0 Comments · 1036 Reads · Print
Page 56 of 66: 1...53545556575859...66

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.

Ratings

Rating is available to Members only.

Please login or register to vote.
No Ratings have been Posted.
Render time: 1.07 seconds
15,119,972 unique visits