JAS -ANZ accredited An ISO 9001: 2008 & 9001 : 2015 Certified Autonomous Body | A National Programme of Information Technology Education & Development.

Certificate in Advance Excel

Duration:03 Months 
Eligibility: Class X
Contents
1.     Formulas.
2.     VLOOKUP
3.     COUNTIFS
4.     COUNT
5.     IF
6.     COUNTIF
7.     COUNTIFS
8.     Filters
9.     Ribbon Tour
10.                       Quick Filtering
11.                       Filtering by Multiple Criteria
12.                       Saving the Filtered Data
13.                       Performing Calculations on Filtered Data
14.                       PivotTables
15.                       Defined
16.                       Basic PivotTable Data
17.                       Inserting a Pivot Table
18.                       PivotTable Geography
19.                       Building a PivotTable Report – Part One
20.                       Adding row labels, adding column data, changing formulas in columns, changing headers & number formats
21.                       Building a PivotTable Report – Part Two
22.                       Adding multiple row labels, collapsing and expanding, drill down to data, sorting, & refreshing
23.                       Building a PivotTable Report – Part Three
24.                       Grouping by dates, grouping by ranges, show items with no detail, show values in empty cells, grouping across columns
25.                       Building a PivotTable Report – Part Four
26.                       User defined groups, adding/removing subtotals
27.                       Building a PivotTable Report – Part Five
28.                        Using formulas on pivoted data
29) Building a PivotTable Report – Part Six
30) Displaying multiple row labels in columns, or tabular form.
31) Other Cool Things to do with a Pivot Table – Part Seven
33) Report Filters
34) Report Slicers
35) Expanding Filter Results to Individual Tabs
Formatting as a Table - Part Eight