Skill Sets
Creating Data and Content
• Enter and edit cell content • Locate specific cell content • Locate, select, and insert supporting information • Insert, position, and size graphics Analyzing Data • Filter lists using the AutoFilter feature • Sort lists • Insert and modify formulas • Use statistical, date and time, financial, and logical functions • Create, modify, and position diagrams and charts based on worksheet data Formatting Data and Content
• Apply and modify cell formats • Apply and modify cell styles • Modify row and column formats • Format worksheets Collaborating
• Insert, view, and edit comments Managing Workbooks
• Create new workbooks from templates • Insert, delete, and move cells • Create and modify hyperlinks • Organize worksheets • Preview data in other views • Customize window layout • Setup pages for printing • Print data • Organize workbooks using file folders • Save data in appropriate formats for different uses |