Programm
- Further Formulas and Functions
- Nested functions
- Working with a lookup function
- Protecting cells
- Unprotecting documents
- Custom number formats
- Conditional formatting
- Working with Data Lists
- General information for creating a list
- Complex sorting using a dialog box
- Working with Data Validation
- Setting data validation criteria
- Checking data validation
- Applying data validation to other cells
- Goal Seek
- Consolidate
- Scenario Manager
- Working with estimates
- Opening the Scenario Manager
- Creating a scenario report
- Deleting a scenario
- Solver
- PivotTable
- What is a PivotTable?
- Creating a data list
- PivotTable Tools
- Creating the PivotTable report
- Advanced PivotTable features
- Changing the PivotTable
- Rearranging rows and columns
- Hiding contents
- Displaying extreme values
- Outlining Excel Data
- Sample spreadsheet
- Showing and hiding cell ranges
- Removing the outline
- Customizing levels and ranges
- Subtotals
- Charts
- Breakeven analysis
- Sparklines
- Macros Task Automation
- Recording a macro
- Running a macro
- Creating a Custom Function
- Procedures
- Custom function features
- Using the custom function
- Data Import and Export
- Using the clipboard to exchange data
- Importing graphics
- Editing imported graphics
- Picture Tools
- Preparing a document for sharing
- Templates
- The benefits of a template
- Creating a template
- Saving the template
- Using the template for a new workbook
- Forms
- Validation and cell protection
- Controls
- Other controls (calendar)
- Format
- Performing Settings in Excel
- Options
- Customizing the Quick Access Toolbar
Ziele
After the course, you will be able to: Use Lookup & Informational Functions Create Pivot Tables Use What-If Tools Sharing and Tracking Workbooks Record Basic MacrosVoraussetzungen
You must have sound Excel skills and understand key concepts of spreadsheets, or equivalent to our Intermediate course level.