- Home /
- Excel 2007: Power User Student Manual
Excel
2007:
Power
User
Topic-Level Outline
Days: 1
Prerequisites: Excel 2007: Advanced or
equivalent experience
Unit 1 : Advanced formulas, functions, and arrays
Topic A:0 Text functions
A-1: Using LEFT, MID, and CONCATENATE
Topic B:0 Date and time functions
B-1: Using date and time formats
B-2: Using the NOW and DATE functions
B-3: Performing calculations on dates
B-4: Using the WORKDAY function
Topic C:0 Information functions
C-1: Using IS functions
C-2: Using the CELL function
Topic D:0 Array formulas
D-1: Using an array formula to multiply two ranges
D-2: Creating a multi-cell array formula
D-3: Summing cells based on logical tests in an array formula
D-4: Performing a logical OR test by using an array function
Unit 2 : Advanced editing and formatting
Topic A:0 The Paste Special command
A-1: Copying formulas and values
A-2: Copying a validation
A-3: Applying a mathematical operation to copied data
A-4: Linking data
Topic B:0 The Go To Special dialog box
B-1: Finding formulas that result in errors
B-2: Finding precedent and dependent cells
Topic C:0 Merging styles
C-1: Copying styles between workbooks
Topic D:0 Additional chart formatting options
D-1: Inserting a picture as a chart background
D-2: Creating a chart template
Unit 3 : Analyzing and sharing information
Topic A:0 Wizard add-ins
A-1: Installing Add-ins
A-2: Using the Conditional Sum Wizard
A-3: Using the Lookup Wizard
Topic B:0 Solver models and reports
B-1: Saving a problem model
B-2: Loading a problem model
B-3: Creating an Answer report
Topic C:0 Statistical analysis tools
C-1: Measuring correlation of data
C-2: Calculating a moving average
Topic D:0 Embedding and linking
D-1: Inserting an embedded object
D-2: Inserting a linked object
Unit 4 : Advanced customization
Topic A:0 Popular and Save options
A-1: Setting a default font
A-2: Changing the default file format and location
A-3: Specifying Autorecover options
Topic B:0 Formulas options
B-1: Limiting iterations
B-2: Changing error checking rules
Topic C:0 Automating Excel
C-1: Using the AutoCorrect feature
C-2: Applying smart tags to cells
Topic D:0 Advanced options
D-1: Entering a decimal point automatically as you type
D-2: Displaying formulas instead of results
SKU | AX1423951042 |
---|---|
Weight | 0.7570 |
Coming Soon | N/A |
Days of Training | 1 |
Audience | Student |
Product Family | Axzo |
Product Type | Print Courseware |
Electronic | No |
ISBN | 1423951042 |
Language | English |
Page Count | 130 |
Curriculum Library | Excel |
Year | 2007 |
Manufacturer's Product Code | N/A |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2014-03-22 00:00:00 |
datafile | 1423951042.gif |
---|---|
datafile | 1423951042mini.gif |
datafile | 1423951042.jpg |
outline | Excel 2007 Power User.html |