Shelly Cashman Excel 2019 | Module 1: Textbook Project 1

Subject:MS ExcelPrice:19.99 Bought3

Share With

Shelly Cashman Excel 2019 | Module 1: Textbook Project

1.	Non-graded - Project: Real Estate Budget Worksheet and Chart
2.	Non-graded - Starting and Using Excel
3.	Non-graded - Selecting a Cell
4.	Entering Text
		To Enter the Worksheet Titles
		To Enter Column Titles
		To Enter Row Titles
5.	Entering Numbers
		To Enter Numbers
6.	Calculating Sums and Using Formulas
		To Sum a Column of Numbers
7.	Using the Fill Handle to Copy a Cell to Adjacent Cells
		To Copy a Cell to Adjacent Cells in a Row
		To Calculate Multiple Totals at the Same Time
8.	Calculating Average, Maximum, and Minimum Values
		To Enter a Formula Using the Keyboard
		To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle
9.	Non-graded - Saving the Project
10.	Formatting the Worksheet
		To Change a Cell Style
		To Change the Font
		To Apply Bold Style to a Cell
		In the Monthly Finances worksheet, the range A1:A2 should be formatted using the Bold font style.
		To Increase the Font Size of a Cell Entry
		To Change the Font Color of a Cell Entry
		To Center Cell Entries across Columns by Merging Cells
		To Format Rows Using Cell Styles
		In the Monthly Finances worksheet, cell A4 should be formatted using the 20% - Accent6 cell style.
		To Format Numbers in the Worksheet
		To Adjust the Column Width
11.	Adding a Pie Chart to the Worksheet
		To Apply a Style to a Chart
12.	Changing the Sheet Tab Names and Colors
		To Move a Chart to a New Sheet
		To Change the Sheet Tab Name and Color
13.	Non-graded - Document Properties
14.	Printing a Worksheet
		To Preview and Print a Worksheet in Landscape Orientation
		The Monthly Finances worksheet should be formatted using Landscape orientation.
15.	Non-graded - Viewing Automatic Calculations
16.	Non-graded - Correcting Errors