Excel Level 2

Description

Excel Level 2 will teach you how to work with large worksheets in Microsoft Excel 2013 and use multiple worksheets and workbooks effi ciently. It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, you will learn how to create outlines and subtotals and create and apply cell names with Wendy Barker. You will sort and fi lter data and create and format tables. Learn how to save workbooks as web pages, insert and edit hyperlinks, and share workbooks via email. Audit worksheets for errors, protect worksheets, share and merge workbooks, and track changes in a workbook. Finally, you will customize the Excel environment and create and modify custom templates.

Prerequisite: Microsoft Excel Level 1 or equivalent knowledge.