Objectives. You will be able to:
- Use productivity tools like Flash Fill, Search and Replace, and Proofing and Researching tools
- Apply advanced Conditional Formatting and Comparative Analysis Formatting to make it easy to read and analyze your data
- Use multiple View features to compare multiple workbooks and compare worksheets
- Sort and filter column data
- Create, modify, and format charts and tables and create a Pivot Table to group and summarize data.
- Use multiple worksheets and workbooks to track, retrieve, and report on data using features Group Mode and 3D Reference formulas.
- Collaborate with others using Comments and Track Changes
- Prepare a workbook for sharing by checking for accessibility and sensitive information
- Use forecasting and data analysis tools like Goal Seek and Sparklines
- Visualize geographic data with Map Charts and 3D Map Tours
- Work with external data, including importing and exporting data and using a Web Query to access data on a website