This course will teach students how to work with large worksheets in Microsoft Excel and use multiple worksheets and workbooks efficiently. It will show how to link information from different worksheets and workbooks and introduce more advanced formatting techniques, such as creating custom number formats. In addition, students will learn how to create outlines subtotals and how to create and apply cell names. They will sort and filter, consolidate and remove duplicate data, and create and format tables. Finally, they will learn how to audit worksheets for errors, how to protect worksheets and how to share workbooks.