Excel Training - Intermediate v2007 / 2010
Microsoft Excel course content: Using multiple excel worksheets and workbooks Using multiple excel workbooks Linking worksheets with 3-D formulas Linking excel workbooks Managing excel workbooks Advanced formatting Using special number formats Using functions to format text Working with styles Working with themes Other advanced formatting Outlining and subtotals Outlining and consolidating data Creating subtotals Cell and range names Creating and using names Managing names Lists and tables Examining lists Sorting and filtering lists Advanced filtering Working with tables Web and Internet features Saving workbooks as Web pages Using hyperlinks Distributing workbooks Advanced charting Chart formatting options Combination charts Graphic elements Documenting and auditing Auditing features Comments in excel cells and workbooks Protection Workgroup collaboration Templates and settings Application settings Built-in templates Creating and managing excel templates