Mtc Training Solutions Ltd. Ms Office 2010 Excel Advanced Manual

E-Book Overview

MTC Training Solutions Ltd. – 236 p. (Автор и выходные данные не указаны).Contents: Introduction. How to use this guide. Instructions. Keyboard. Commands. Notes. Grouping worksheets. Activate group mode. Group adjacent sheets. Group non-adjacent sheets. Deactivate group mode. Fill data across worksheets. 3-D formulae. References to other sheets. Multiple worksheets. Moving between the workbook sheets. Worksheet names. Move and copy worksheets. Insert and delete worksheets. Moving worksheets to different workbooks. Consolidating data. Consolidate data from multiple worksheets in a single worksheet. Other ways to consolidate data. Conditional formatting. Other conditional formatting options. More rules. Cell styles. How to select cells, ranges, rows, or columns. Group and ungroup rows and columns. Grouping rows and columns. Ungrouping rows and/or columns. Protect worksheet data. Unlock cells. Worksheet protection. Unprotect sheets. Making your file read only. Data validation rules. Setting validation rules. Track changes. Review and incorporate changes. What-if analysis. Goal seek. Solver. Constraints. Advanced solver features. Solving methods used by solver. Solver options. Solver and scenario manager. Saving solver solutions. Solver reports. Scenario manager. Create a scenario manually. Open the scenario manager. Showing a scenario. Editing a scenario. Deleting a scenario. Scenario summary. Linking data. Linking data between worksheets. Linking data between workbooks. Introduction to charting. Terminology. Creating charts. Separate chart pages. Moving and resizing embedded charts. Data layout. Shortcut menu (right click). Chart types. Available types of chart. Changing the chart type. Default chart type. Formatting charts. Design ribbon. Data source. Switch rows and columns. Add a series manually. The series function. Charting with blocks of data. Changing the chart layout. Chart styles. Moving chart location. Layout ribbon. Formatting chart elements. Resetting custom formats. Adding, removing and formatting labels. Axes. Gridlines. Unattached text. Format dialog. Sparklines. Create sparklines. Axis options. Absolute and relative references. Relative references. Absolute references. Naming cells and ranges. Rules when naming cells. Name box. Defining a name. Selecting names (navigation). Manage names by using the name manager. Bodmas with formulae. Functions. Basic sum function. Autosum. Other common functions. Function library. Insert function. Function box. Type functions. Function argument tool tips. Cell references. Conditional & logical functions. IF statements. Logical test. Value IF true / false. Nested IF. Counting and totalling cells conditionally. Statistical IF statements. SUMIF. COUNTIF. AVERAGEIF. AVERAGEIFS. SUMIFS. COUNTIFS. AND, OR, NOT. AND function. OR function. NOT function. ISERROR function. IFERROR function. LOOKUP functions. Lookup. Vector lookup. HLOOKUP. VLOOKUP. Nested lookups. MATCH(). Two-way lookup. Index function. Combining match and index. Choose. Offset. Financial functions. NPV(). Comparing investment schedules. IRR(). PMT(). Calculating loan repayments. FV(). Date & time calculations. Dates. NETWORKDAYS(). Analysis toolpak. TODAY(). NOW. DAY(), MONTH() AND YEAR(). Time calculations. Subtracting times. Totalling times. Text functions. PROPER, UPPER, LOWER, REPT. Concatenate. String functions (LEFT, MID, RIG