[su_tabs]
[su_tab title = “Description”]
The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
[/su_tab]
[su_tab title = “Program Structure”]
Topics:
- 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
Fees: – INR 15, 00 (assuming $ = INR 60)
Duration:
1 Hour 32 Minutes
[/su_tab]
[su_tab title =”Tools”]
- Excel
[/su_tab]
[su_tab title = “Contact”]
[/su_tab]
[/su_tabs]