Managing and Analyzing Data in Excel
- Type product
Managing and Analyzing Data in Excel
Beschrijving
Shares easy-to-use database commands and methods for maintaining an Excel database.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…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Shares easy-to-use database commands and methods for maintaining an Excel database.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
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.