Activity Overview The following activity illustrates how spreadsheets can be used to compute number totals, averages, maximums (highest), and minimums and sort totals. New Skill In this activity, you will practice how to: Add numbers in a spreadsheet using a formula. Use the AutoFill feature to complete formulas. Display formulas in a spreadsheet. Use the […]
Microsoft Excel – Lesson 2 Read More »
Activity Overview The following activity illustrates how spreadsheets can be used to create lists and then alphabetize them. New Skill In this activity, you will practice how to: Change column width and format text. Sort data in ascending order (A-Z). Use AutoComplete and AutoFill features. Change page setup options. Rename and delete sheets. Lesson Open
Microsoft Excel – Lesson 1 Read More »
Step-by-step Training Lesson 1 – Creating lists and alphabetizing. Lesson 2 – Compute number totals, averages, maximums (highest), and minimums and sort totals. Lesson 3 – Compute payrolls (aka Payroll Register). Lesson 4 – Computing sales. Lesson 5 – Calculate purchase discounts and sales tax. Lesson 6 – Tracking employee time sheets. Lesson 7 –
More Excel Resources Read More »