Certificate Authentication

Excel basics

• Excel data types - How Excel treats date and time
• Searching for values in a spreadsheet - Find and mark
• Sheet protection
• Data accuracy
• Create a data series
• Autocorrect
• Instant Fill
• Go To Special
• Paste Special
• Text as columns
• Quick access bar
• Good sheet creation practices
• Keyboard shortcuts
• Cell formatting
• Conditional formatting

Creating formulas

• Inserting functions
• Editing formulas
• Logical functions
• Mathematical functions
• Search Functions
• Text functions
• Date and time functions
• Summing the contents of cells with a button AutoSum
• Adding functions using a dialog box
• Formula evaluation
• Specifying the location of values
• Naming the range
• Modify named ranges
• Use named ranges in formulas

Create a PivotTable

• Basic information about pivot tables
• Overview of pivot table report fields

Creating charts and pivot charts

• Create pivot charts
• Change the chart type