Unit 1: Getting To Know Excel
* Starting Excel
* The Excel Screen
* Using The Ribbon
* Using The KeyTip Badges
* Minimising The Ribbon
* Using Shortcut Menus
* Launching Dialog Boxes
* Customising The Quick Access Toolbar
* The Office Button
* Using The Office Button
* The Status Bar
* Customising The Staus Bar
* Exiting Safely From Excel
Unit 2: Creating A New Workbook
* Understanding Workbooks
* Using The Blank Workbook Template
* Typing Text Into A Worksheet
* The Save As Dialog Box
* Saving A New Workbook
* Typing Numbers Into A Worksheet
* Typing Simple Formulas In A Worksheet
* Easy Formulas
* Typing Dates In A Worksheet
* Easy Formatting
* Checking Spelling In A Worksheet
* Making And Saving Changes
* Printing A Worksheet
* Safely Closing A Worksheet
Unit 3: Working With Workbooks
* Opening An Existing Workbook
* Moving About A Worksheet
* Moving About A Workbook
* Going To A Specific Location
* The Open Dialog Box
Unit 4: Editing In A Workbook
* Understanding Data Editing
* Overwriting Cells Contents
* Editing Longer Cell Entries
* Editing Formulas
* Editing Functions
* Clearing A Cell
* Deleting A Worksheet
* Undoing And Redoing Operations
Unit 5: Formulas And Functions
* Understanding Formulas
* Creating Formulas That Add
* Creating Formulas That Subtract
* Formulas That Multiply And Divide
* Understanding Functions
* Using The SUM Function To Add
* Summing Non-Contiguous Ranges
* Calculating An Average
* Finding A Maximum Value
* Finding A Minimum Value
* More complex Formulas
* What If Formulas
Unit 6: Formula Referencing
* Absolute Versus Relative Referencing
* Relative Formulas
* Problems With Relative Formulas
* Creating Absolute References
* Creating Mixed References
Unit 7: Selecting Ranges
* Understanding Ranges
* Selecting Ranges
* Selecting Non-Contiguous Ranges
* Using Special Selection Techniques
* Selecting Larger Ranges
* Selecting Rows
* Selecting Columns
* Viewing Range Calculations
* Creating An Input Range
Unit 8: Copying Excel Data
* Understanding Copying In Excel
* Using Fill For Quick Copying
* Copying From One Cell To Another
* Copying From One Cell To A Range
* Copying From One Range To Another
* Copying Relative Formulas
* Copying To A Non-Contiguous Range
* Copying To Another Worksheet
* Copying To Another Workbook
Unit 9: Font Formatting
* Understanding Font Formatting
* Working With Live Preview
* Changing Fonts
* Changing Font Size
* Growing And Shrinking Fonts
* Making Cells Bold
* Italicising Text
* Underling Text
* Changing Font Colours
* Changing Background Colours
* Using The Format Painter
* Applying Strikethrough
* Subscripting Text
* Superscripting Text
Unit 10: Cell Alignment
* Understanding Cell Alignment
* Aligning Right
* Aligning To The Centre
* Aligning Left
* Aligning Top
* Aligning Bottom
* Aligning To The Middle
* Rotating Text
* Indenting Cells
* Wrapping And Merging Text
* Merging And Centring
* Merging Cells
* Unmerging Cells
Unit 11: Row And Column Formatting
* Approximating Column Widths
* Setting Precise Column Widths
* Setting The Default Column Width
* Approximating Row Height
* Setting Precise Row Height
* Hiding Rows And Columns
* Unhiding Rows And Columns
Unit 12: Number Formatting
* Understanding Number Formatting
* Applying General Formatting
* Formatting As Currency
* Formatting Percentages
* Formatting As Fractions
* Formatting As Dates
* Using The Thousands Separator
* Increasing And Decreasing Decimals
Unit 13: Printing
* Understanding Printing
* Previewing Before You Print
* Performing A Quick Print
* Selecting A Printer
* Printing A Range
* Printing An Entire Workbook
* Specifying The NUmber Of Copies
* The Print Dialog Box
Unit 14: Creating Charts
* Understanding The Charting Process
* Choosing The Chart Type
* Creating A New Chart
* Working With An Embedded Chart
* Resizing A Chart
* Dragging A Chart
* Printing An Embedded Chart
* Creating A Chart Sheet
* Changing The Chart Type
* Changing The Chart Layout
* Changing THe Chart Style
* Printing A Chart Sheet
* Embedding A Chart Into A Worksheet
* Deleting A Chart
|
