This course builds upon the skills and concepts taught in Excel Basic. You will learn how to use multiple worksheets and workbooks; start working with more advanced formatting options including styles, themes, and formatting with text functions; learn how to create outlines and subtotals; create and apply cell names; manipulate tables; save workbooks as webpages; insert and edit hyperlinks; and how to share workbooks. This course also covers advanced chart techniques; use of trend lines and spark lines; worksheet auditing and protection; file sharing and merging; workbook templates; and how to use Pivot Tables and Pivot Charts. All course materials included in price.