Workbooks Creating & using names Changing application settings Managing names Using multiple workbooks Linking Using built-in templates worksheets with 3-D Creating & managing formulas templates Tables Linking workbooks Sorting & filtering data Managing workbooks PivotTables & PivotCharts Advanced filtering Working with PivotTables Working with tables Rearranging PivotTables Advanced Formatting Formatting PivotTables Using special number formats Advanced Charting Using PivotCharts Using functions to format text Chart formatting options Working with styles Combination charts Working with themes Graphical elements Other advanced formatting Documenting & Auditing Outlining & Subtotals Auditing features Outlining & consolidating data Comments in cells & workbooks Creating subtotals Protection Workgroup collaboration
Workbooks Using multiple workbooks Linking worksheets with 3-D formulas Linking workbooks Managing workbooks Advanced Formatting Using special number formats Using functions to format text Working with styles Working with themes Other advanced formatting Outlining & Subtotals Outlining & consolidating data Creating & using names Managing names Tables Sorting & filtering data Advanced filtering Working with tables Advanced Charting Chart formatting options Combination charts Graphical elements Documenting & Auditing Auditing features Comments in cells & workbooks Changing application settings Using built-in templates Creating & managing templates PivotTables & PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables Using PivotCharts Creating subtotals Protection Workgroup collaboration
Excel%20Intermediate%202010%20Citrus.docx