Learners will learn to use some of excel's advanced functions and incredible database features including impressive subtotals and pivottable reports, and vlookup and hlookup. Learners also will learn how to create basic charts, parse data, insert cell comments, track changes, and use various graphics tools.
Course Topics:
- Define an alternative data set
- Define multiple alternative data sets
- Vary your data to get a desired result by using Goal Seek
- Analyze data by using descriptive statistics
- Analyze data dynamically by using PivotTables
- Filter, show, and hide PivotTable data
- Edit and format PivotTables
- Create PivotTables from external data
- Customize the appearance of charts
- Find trends in your data
- Summarize your data by using sparklines
- Create dynamic charts by using PivotCharts
- Create diagrams by using SmartArt
- Create shapes and mathematical equations
- Enable and examine macros
- Create, modify, and run macros
- Include Office documents in workbooks
- Store workbooks as parts of other Office documents
- Paste charts into other documents
- Track and manage colleagues’ changes
- Protect workbooks and worksheets
- Authenticate workbooks
- Save workbooks for the Web
|