Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Won't You Be My Neighbor? The Table is Set Click Here to Get Started Sample Files Intermediate Excel Lesson Objectives: Learn how to create lists in Excel. This lesson shows how to present data visually, format data as a Table and set the print options. In this lesson you will: Review how to create, format and sort a list page 4 Learn how to use single and multilevel sorts page 6 Explain the steps needed to create a Table page 8 Identify the Header Row with the Table Tools page 10 Locate the Quick Style Formats page 15 Use the Table Tools to add a Total Row page 17 Review the Print Preview options page 20 Locate and use Page Break Preview page 22 Explain the steps needed to Set Print Area page 23 Identify options to scale the spreadsheet to fit page 24
Click Here to Get Started
Sample Files
Intermediate Excel
Lesson Objectives: Learn how to create lists in Excel. This lesson shows how to present data visually, format data as a Table and set the print options. In this lesson you will:
Review how to create, format and sort a list page 4
Learn how to use single and multilevel sorts page 6
Explain the steps needed to create a Table page 8
Identify the Header Row with the Table Tools page 10
Locate the Quick Style Formats page 15
Use the Table Tools to add a Total Row page 17
Review the Print Preview options page 20
Locate and use Page Break Preview page 22
Explain the steps needed to Set Print Area page 23
Identify options to scale the spreadsheet to fit page 24