Certificate Authentication

Excel basics

Excel data types
Finding values in a spreadsheet
Naming a range Create label ranges
Modify named ranges
Create your own number formats
Create a named style
Create a user template
Sheet protection

Organizing the data in the spreadsheet

Create a data list
Adding a series of values to the list
Create custom sort lists
Data consolidation
Creating outlines

Data processing in a spreadsheet

Applying conditional formatting
Summarizing data using subtotals
Filtering the list of data
Create a custom filter
Create an advanced filter
Creating scenarios
Data validation

Creating formulas

Summarize cell contents using the AutoSum button
Adding features using a dialog box
Inserting functions
Editing formulas
Estimating the formula
Create a conditional formula
Using a data table to solve formulas
Formula execution error tracking
Search for a value in a specific row or column
Specifying the position of the value
Returning a value from a cell at a specified position in a list of data
Positioning of values in the data list

Processing information from external data sources

Combine data from other Windows programs
Importing a delimited text file
Splitting a column of data into multiple columns
Create a web query
Importing a database table
Using queries to selectively retrieve information from external databases
Calculate the average of the values stored in the scope of the database
Data graphing
Changing the chart type
Create custom chart types
Adding a trendline to a chart
Adding new values and changing data for the chart

Using pivot table reports

Basic information about pivot tables
PivotTable report fields overview
Create a PivotTable report from a list of data
Changing the layout of a PivotTable
Field filtering
Change the calculation type of a data field
Grouping pivot table data items
Entering an additional calculation into the data region
Add a calculated field
Adding a Calculated Item
Retrieving values from a PivotTable report

Create PivotCharts

Making a Pivot Chart from information retrieved from an external database
Changing the layout of a PivotChart
Changing the type of PivotChart
Filtering a PivotChart field
Grouping elements of a PivotChart box
Adding a data table to a PivotChart