Are you currently saving every Excel spreadsheet in a separate file? Did you know you can have multiple pages in a one Excel file called a "workbook?" Did you know you could create formulas that span multiple worksheets? Did you know you could share workbooks with other users?
Attend this course if you want to:
Learn how to keep related spreadsheets in one workbook file. Name worksheet pages for easy retrieval. Change the color of worksheet tabs. Insert, delete, and move worksheets to where you want them. Change the default number of worksheets in new workbooks. Copy or move a worksheet within a workbook or to another workbook (to use as a template for new data). Copy or move a range of cells within a workbook or to another workbook. Group worksheets and simultaneously edit or format the data on all the worksheets. Create formulas that span multiple worksheets. Hide worksheets to reduce the number of worksheet tabs and prevent undesired viewing. Print workbooks or selected sheets within the workbook. Save a workbook or worksheet as a template, and then edit or delete that template. Protect workbooks, worksheets, and cells from change. Hide formulas from others using the workbook. Share workbooks with other users for simultaneous updates
