| In this 6 hour class you will link worksheets by using 3-D formulas; add a watch window; create and manage links between workbooks; apply special and custom number formats; merge and split cells; change the orientation of data in cells; transpose data. You will also create and outline and consolidate data; create subtotals in a list’ sort lists by columns; filter lists based on complex criteria and copy filtered results to another range; save and publish a worksheet as a Web page; insert and edit hyper links; publish a worksheet as a PDF file; format data points; create combination charts and trendlines and add and format graphic elements; work with Excel templates and create and manage templates. |