Excel Expert Certificate

In 8 practical, exercise packed lessons, you'll learn the following:
Lesson One:                   Using AutoFill, carrying out date calculations, adding a worksheet                   background, showing/hiding gridlines and headings, creating and working with tables, converting text to columns, removing duplicates, consolidating data, hiding/unhiding worksheets, using paste special, creating a custom format. 
Lesson Two:                   Defining, using and managing named ranges, using named ranges in formulas, inserting, modifying and removing hyperlinks, formatting elements of a column chart, using functions: ROUND; SUMIF; IF; IFERROR; AND, using the IF function nested with OR.
Lesson Three:                    Using conditional formatting, editing a conditional formatting rule, using the Rules Manager, formatting cells meeting a specific condition, applying more than one conditional formatting rule, sorting data using cell attributes, filtering data using cell attributes, using advanced filter options. 
Lesson Four:                   Recording and running macros, editing a macro, running a macros from the Quick Access Toolbar, deleting macros, using data validation, tracing precedent/dependent cells in a worksheet, evaluating formulas, tracing errors. 
Lesson Five:                   Summarising data using subtotals, using database functions, grouping and ungrouping data, creating a pivot table, refreshing pivot table data, filtering information in a pivot table, formatting pivot table data. 
Lesson Six:                   Inserting headers and footers, copying and pasting data between worksheets, grouping and ungrouping worksheets, creating a new workbook, switching between workbooks, viewing multiple workbooks, hiding and unhiding a workbook, saving as a template, creating a workbook from a template using existing templates and online resources. 
Lesson Seven:                   Protecting worksheet cells, applying and removing passwords, setting file properties, sharing workbooks, merging workbooks, tracking changes, accepting or rejecting changes, using the Document Inspector, marking a workbook as final, removing a password, adding a digital signature. 
Lesson Eight:                   Using statistical function: COUNTA, COUNTBLANK, COUNTIF, using text functions: PROPER, UPPER; LOWER; CONCATENATE, using financial functions: PV; NPV; RATE, using nested functions.