Make a Spreadsheet in Excel

cleaning up excessive internal links

←Older revision		Revision as of 00:24, 11 December 2019
Line 4:		Line 4:
	=== Creating a Basic Spreadsheet ===		=== Creating a Basic Spreadsheet ===
	#Open Microsoft Excel. You'll find it in the Start menu (Windows) or in the Applications folder (macOS). The app will open to a screen that allows you to create or select a document. [[Image:Make a Spreadsheet in Excel Step 1 Version 5.jpg|center]]		#Open Microsoft Excel. You'll find it in the Start menu (Windows) or in the Applications folder (macOS). The app will open to a screen that allows you to create or select a document. [[Image:Make a Spreadsheet in Excel Step 1 Version 5.jpg|center]]
−	#* If you don't have a paid version of Microsoft Office, you can use the free online version at https://www.office.com to create a basic spreadsheet. You'll just need to [[Create a Microsoft Account|sign in with your Microsoft account]] and click '''Excel''' in the row of icons.	+	#* If you don't have a paid version of Microsoft Office, you can use the free online version at https://www.office.com to create a basic spreadsheet. You'll just need to sign in with your Microsoft account and click '''Excel''' in the row of icons.
	# Click to create a new workbook. A workbook is the name of the document that contains your spreadsheet(s). This creates a blank spreadsheet called '''Sheet1''', which you'll see on the tab at the bottom of the sheet.[[Image:Make a Spreadsheet in Excel Step 2 Version 5.jpg|center]]		# Click to create a new workbook. A workbook is the name of the document that contains your spreadsheet(s). This creates a blank spreadsheet called '''Sheet1''', which you'll see on the tab at the bottom of the sheet.[[Image:Make a Spreadsheet in Excel Step 2 Version 5.jpg|center]]
	#* When you make more complex spreadsheets, you can add another sheet by clicking '''+''' next to the first sheet. Use the bottom tabs to switch between spreadsheets.		#* When you make more complex spreadsheets, you can add another sheet by clicking '''+''' next to the first sheet. Use the bottom tabs to switch between spreadsheets.
Line 23:		Line 23:
	#* Click '''Cancel''' when you're done browsing.		#* Click '''Cancel''' when you're done browsing.
	#* To learn more about entering formulas, see [[Type Formulas in Microsoft Excel|How to Type Formulas in Microsoft Excel]].		#* To learn more about entering formulas, see [[Type Formulas in Microsoft Excel|How to Type Formulas in Microsoft Excel]].
−	#* For tips on common functions, check out [[Use the Lookup Function in Excel|How to Use the Lookup Function in Excel]], and [[Use the Sum Function in Microsoft Excel|How to Use the Sum Function in Microsoft Excel]].	+	#Save your file when you're finished editing. To save the file, click the '''File''' menu at the top-left corner, and then select '''Save As'''. Depending on your version of Excel, you'll usually have the option to save the file to your computer or OneDrive.[[Image:Make a Spreadsheet in Excel Step 6 Version 6.jpg|center]]
−	#Save your file when you're finished editing. To save the file, click the '''File''' menu at the top-left corner, and then select '''Save As'''. Depending on your version of Excel, you'll usually have the option to save the file to your computer [[Use OneDrive|or OneDrive]].[[Image:Make a Spreadsheet in Excel Step 6 Version 6.jpg|center]]
	#* Now that you've gotten the hang of the basics, check out the "Creating a Home Inventory from Scratch" method to see this information put into practice.		#* Now that you've gotten the hang of the basics, check out the "Creating a Home Inventory from Scratch" method to see this information put into practice.
	=== Creating a Home Inventory from Scratch ===		=== Creating a Home Inventory from Scratch ===
Line 49:		Line 48:
	#* Click the '''Fonts''' menu to browse for and select a font.		#* Click the '''Fonts''' menu to browse for and select a font.
	#Save your document. When you've reached a good stopping point, you can save the spreadsheet by clicking the '''File''' menu at the top-left corner and selecting '''Save As'''.[[Image:Make a Spreadsheet in Excel Step 7 Version 5.jpg|center]]		#Save your document. When you've reached a good stopping point, you can save the spreadsheet by clicking the '''File''' menu at the top-left corner and selecting '''Save As'''.[[Image:Make a Spreadsheet in Excel Step 7 Version 5.jpg|center]]
−	#* Now that you've created your first spreadsheet, see [[Use Excel|How to Use Excel]] for a more in-depth look at what else you can do with Excel.	+
	=== Creating a Monthly Budget from a Template ===		=== Creating a Monthly Budget from a Template ===
	#Open Microsoft Excel. You'll find it in the Start menu (Windows) or in the Applications folder (macOS). The app will open to a screen that allows you to create or open a workbook.[[Image:Make a Spreadsheet in Excel Step 8 Version 5.jpg|center]]		#Open Microsoft Excel. You'll find it in the Start menu (Windows) or in the Applications folder (macOS). The app will open to a screen that allows you to create or open a workbook.[[Image:Make a Spreadsheet in Excel Step 8 Version 5.jpg|center]]
Line 72:		Line 71:
	#* Any changes you make to the Monthly Income and Monthly Expenses tabs will affect what you see in your Summary.		#* Any changes you make to the Monthly Income and Monthly Expenses tabs will affect what you see in your Summary.
	#Save your document. When you've reached a good stopping point, you can save the spreadsheet by clicking the '''File''' menu at the top-left corner and selecting '''Save As'''.[[Image:Make a Spreadsheet in Excel Step 14 Version 5.jpg|center]]		#Save your document. When you've reached a good stopping point, you can save the spreadsheet by clicking the '''File''' menu at the top-left corner and selecting '''Save As'''.[[Image:Make a Spreadsheet in Excel Step 14 Version 5.jpg|center]]
−	#* Now that you've created your first spreadsheet, see [[Use Excel|How to Use Excel]] for a more in-depth look at what else you can do with Excel.	+
	== Related wikiHows ==		== Related wikiHows ==
	*[[Create an Image from a Excel Spreadsheet]]		*[[Create an Image from a Excel Spreadsheet]]

from wikiHow - Recent Changes [en] https://ift.tt/357P61G
via IFTTT