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