Certificate Authentication

Knowledge of Windows and MS Excel basics

• Excel Data Types
• Look up values ​​in a spreadsheet
• Naming the range, create a range of labels
• Modifying named ranges
• Create custom number formats
• Use AutoFormat options in a spreadsheet
• Create a named style
• Creating a user template
• Protection sheets

Organizing data in a worksheet

• Create a list of data
• Adding to the list of series
• Creating a custom sort lists
• Consolidate data
• Create conspect

Processing of data in a spreadsheet

• Apply conditional formatting
• Summarizing data with subtotals
• Filter the list of data
• Create a custom filter
• Create an advanced filter
• Create scenarios
• Data Validation

Creating formulas

• Aggregation of cell contents using the AutoSum
• Adding in the dialog window
• Insert Function
• Editing formulas
• Evaluate Formula
• Using Solver tool to obtain specific values ​​of the arguments
• Create a conditional formula
• Using the data table to solve the formulas
• Tracking error performance formulas
• Look up values ​​in a particular row or column
• Determine the value location 
• Returning values ​​from a cell in a specific location in the data list
• Positioning of the data list
• Create a table of credit

The processing of information from external data sources

• Combining data from other Windows programs
• Importing a delimited text file
• Dividing a column of data into multiple columns
• Create a Web Query
• Importing database table
• Using queries to selectively retrieve information from external databases
• Calculate the average of the values ​​stored in the database

Produce data charts

• Changing the chart type
• Creating a custom chart types
• Adding a trendline to a chart
• Adding new values ​​and change data for the chart
• Create a combination chart

Using Pivot Table reports

• Basic information about PivotTables
• Overview of PivotTable fields.
• Create a PivotTable report with a list of data
• Change the layout of a PivotTable
• Filtering fields
• Changing the type of calculation data fields
• Grouping PivotTable data elements
• Entering additional calculations to the data area
• Add a calculated field
• Adding a calculated
• Get values ​​from a PivotTable report

Creating a PivotChart

• Performing the pivot of information from external database
• Change the layout of a PivotChart
• Changing a PivotChart
• Filtering fields PivotChart
• Grouping elements PivotChart field
• Add a table of data to the PivotChart