Excel 2010 Intermediate Course Date: 11/23/13 Course Time: 9am - 5pm Registration: Call 647-4287 or 777-3685 for more information. Course Details: Link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace. Apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark. Create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings. Define and apply cell and range names; use names in formulas; and define and apply 3-D names. Sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and use structured references. Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment. Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images. Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final. Change Excel’s default application settings and customize the Ribbon; work with Excel templates; and create and manage templates. Create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotChart to graphically display data from a PivotTable.
Posted on: Tue, 19 Nov 2013 04:00:06 +0000
Trending Topics
Recently Viewed Topics
© 2015