Learn to work more efficiently and impressively in Excel by mastering features such as 3-D references, absolute and relative cell addressing, data tables, named ranges, sorting and filtering, restrict data entry, group worksheets, subtotal reports, and work with conditional formatting.
Course Topics:
- Create a manual nested array formula
- Compare data using Vlookup with 3-D reference and conditional formatting
- Use the Go To feature to find unmatched records
- Create a Subtotals Report
- Work with basic macros
- Create and edit a PivotTable
- Use Group and Outline feature
- Use Text to Columns feature
- Use Scenario Manager Analysis Tool and Solver Analysis Tool
- Use Goal Seek and the Data Tables feature
- Use Formula Auditing features
- Discuss Document Inspector, Digital Signatures, Shared Workbooks
- Set access permissions
- Discuss Track Changes, IRM, Marking a Document as Final
- Consolidate Worksheets
- Discuss E-mailing options
- Use some basic Data Manage features such as basic autofilter, group objects, reset graphics
|