Manipulating Data/Named Ranges

• Paste Special
• Transposing Data
• Importing Text and Delimiting by Space, Comma or Tab
• Naming Cell Ranges
• Naming Ranges within Formulas
• Navigating Through Workbooks Using Named Ranges
• Creating Named Ranges Automatically Based on Cell Values
• Deleting Named Cells/Ranges
• Creating Subtotals
• Removing Subtotals

Templates

• Using Templates
• Creating Templates
• Opening and Editing Templates

Formatting and Display Techniques

• Formatting Tables
• Formatting Tables Using Table Styles
• Formatting Cell Ranges Using Conditional Formatting
• Creating Custom Number Formats
• Freezing the Top Row
• Freezing the First Column
• Freezing the Top Row and the First Column Simultaneously
• Hiding and Un-Hiding Rows
• Hiding and Un-Hiding Columns
• Hiding and Un-Hiding Worksheets

Sorting and Querying Data

• Sorting Internal Excel Databases
• Custom Sort Options
• Using AutoFilter to Query Data
• Multiple Queries
• Removing Queries
• Top 10 AutoFilter
• Filtering Unique Records
• Advanced Filter

Linking and Consolidation

• Linking Individual Cells within a Worksheet
• Linking Charts to Data within a Worksheet
• Linking a Cell Range on One Worksheet to Another Worksheet
• Linking Data From One Workbook to Another
• Linking Data on One Worksheet to a Chart in Another Worksheet
• Linking a Chart From one Workbook to Another
• Copying Data from Excel into a Word Document
• Linking a Chart from Excel into a Word Document
• Consolidating Data Over Several Worksheets or Worksheet Pages

Chart Formatting Techniques

• Changing the Angle of a Pie Chart Slice
• Formatting the Chart Axis Fonts
• Formatting the Chart Axis Scales
• Formatting the Chart Axis Txt Orientation
• Creating and Positioning a Chart Title
• Re-Positioning a Chart legend
• Re-Positioning Chart data labels
• Exploding the Segments within a Pie Chart
• Deleting a Data Series within a Chart
• Adding a Data Series to a Chart
• Modifying the Chart Type for a Defined Data Series
• Widening the Gap Between Columns/Bars within a 2D Chart
• Inserting an Image into a 2D Chart (As a Background)
• Inserting an Image into a 2D Chart (To Format a Column or Bar of Data)

Protection and Security

• Specifying a Password for Opening a Workbook
• Using the 'Read Only Recommended' Option