Objectives. You will be able to:
- Use Flash Fill, Text to Columns, and Group Mode to work with your data
- Use editing features such as Find and Replace, proofing options, and research tools to refine your workbook
- Modify workbook views
- Apply conditional formatting to text, numbers, and dates
- Apply custom number formatting
- Use nested, logical, and statistical functions
- Modify and format charts
- Add sparklines, pictures, and SmartArt
- Modify Tables, PivotTables, and web queries
- Share workbooks
- Use tools to enhance sharing such as hyperlinks, track changes, and comments
- Analyze data with Goal Seek and Data Tables