|
1. Filling Data
1. Filling A Series
2. Filling A Growth Series
3. Filling A Series Backwards
4. Filling Using Options
5. Creating A Custom Fill List
6. Modifying A Custom Fill List
7. Deleting A Custom Fill List
2. Moving Data
1. Understanding Moving In Excel
2. Moving Cells And Ranges
3. Moving Data To Other Worksheets
4. Moving Data To Other Workbooks
3. Formula Techniques
1. Scoping A Formula
2. Developing A Nested Function
3. Creating Nested Functions
4. Editing Nested Functions
5. Copying Nested Functions
6. Using Concatenation
7. Switching To Manual Recalculation
8. Forcing A Recalculation
9. Pasting Values From Formulas
10. Pasting Formulas As Pictures
4. Logical Functions
1. Using IF To Display Text
2. Using IF To Calculate Values
3. Nesting IF Functions
4. Using IFERROR
5. Using TRUE And FALSE
6. Using AND
7. Using OR
8. Using NOT
5. Number Formatting Techniques
1. Using Alternate Currencies
2. Formatting Dates
3. Formatting Time
4. Creating Custom Formats
6. Conditional Formatting
1. Formatting Cells Containing Values
2. Clearing Conditional Formatting
3. More Cell Formatting Options
4. Top Ten Items
5. More Top And Bottom Formatting Options
6. Working With Data Bars
7. Working With Colour Scales
8. Working With Icon Sets
|
7. Applying Borders
1. Applying A Border To A Cell
2. Applying A Border To A Range
3. Applying A Bottom Border
4. Applying Top And Bottom Borders
5. Removing Borders
6. The More Borders Option
7. Using The More Borders Option
8. Working With A Worksheet
1. Changing Worksheet Views
2. Worksheet Zooming
3. Viewing The Formula Bar
4. Viewing The Gridlines
5. Viewing The Ruler
6. Inserting Cells
7. Deleting Cells
8. Inserting Columns
9. Inserting Rows
10. Deleting Rows And Columns
11. Switching Between Worksheets
9. Worksheet Techniques
1. Inserting And Deleting Worksheets
2. Copying A Worksheet
3. Renaming A Worksheet
4. Moving A Worksheet
5. Hiding A Worksheet
6. Unhiding A Worksheet
7. Copying A Worksheet To Another Workbook
8. Moving A Worksheet To Another Workbook
9. Changing Worksheet Tab Colours
10. Grouping Worksheets
11. Hiding Rows And Columns
12. Unhiding Rows And Columns
13. Freezing Rows And Columns
14. Splitting Windows
10. Finding And Replacing
1. Finding Text
2. Finding Cell References In Formulas
3. Replacing Values
4. Using Replace To Change Formulas
5. Replacing Within A Range
6. Finding Formats
7. Finding Constants Using Go To Special
8. Finding Formulas Using Go To Special
9. Finding The Current Region
10. Finding The Last Cell
11. Page Setup
1. Using Built In Margins
2. Setting Custom Margins
3. Changing Margins By Dragging
|
4. Centring On A Page
5. Changing Orientation
6. Specifying The Paper Size
7. Setting The Print Area
8. Clearing The Print Area
9. Inserting Page Breaks
10. Using Page Break Preview
11. Removing Page Breaks
12. Setting A Background
13. Clearing The Background
14. Settings Rows As Repeating Print Titles
15. Clearing Print Titles
16. Printing Gridlines
17. Printing Headings
18. Scaling To A Percentage
19. Fit To A Specific Number Of Pages
20. Strategies For Printing Larger Worksheets
12. Sorting Data
1. Performing An Alphabetical Sort
2. Sorting On More Than One Column
3. Sorting By Rows
4. Sorting Numbered Lists
13. Filtering Data
1. Performing An Alphabetical Sort
2. Sorting On More Than One Column
3. Sorting By Rows
4. Sorting Numbered Lists
14. Charting Techniques
1. Adding A Chart Title
2. Adding Axes Titles
3. Positioning The Legend
4. Showing Data Labels
5. Showing A Data Table
6. Modifying The Axes
7. Showing Gridlines
8. Formatting The Plot Area
9. Showing The Plot Area
10. Adding A Trendline
11. Adding Error Bars
12. Adding A Text Box To A Chart
13. Drawing Shapes In A Chart
15. Chart Text Formatting
1. Using Font Formatting And Alignment
2. Using WordArt Styles
3. Changing Text Fill
4. Changing Text Outline
5. Changing Text Effects
Concluding Remarks
|
