Free Microsoft Office Training and Tutorial Resources




    



April 3, 2006

Excel Training Tutorials in Flash format

Here are execellent, well written, and free video t raining tutorials for Microsoft Excel. These training tutorials many features and functionality of Excel, including basic concepts, pivot tables, charts, advanced functions, building Excel applications, and VBA. These are in Flash format.

Excel Training Tutorials in Flash format


Basic ExcelConcepts

- Using “Paste Special”
Using Text to Columns
Tips on Filtering with “AutoFilter”
Using Goal Seek
Data Validation in Excel
About Conditional Formatting
Basics of Protecting a Worksheet
Basics of Using Subtotals
Basics of Print Setup Options
- Formatting Tricks

  Grouping Tabs to Save Time
  Conditional Format with Four Conditions
-

All About Pivot Tables

- Create a Basic Pivot Table
- Sorting in a Pivot Table
- Create a Drill Down Effect with a Pivot Table
- Adding a Calculated Field in a Pivot Table
- Grouping in a Pivot Table
- Creating Pivot Charts
- Using Pivot Table Advanced Options
Convert Pivot Tables Into Hard Data
Table Structures: Good and Not So Good
- Synchronize 2 Pivot Tables with a Combo Box
Tie a Chart to a Pivot Table

  All About Multiple Consolidation Ranges
  Pivot Table Based Conditional Chart
  Add Dynamic Icons to Pivot Table Reports

  Pivot Tables and Spreadsheet Bloat  Sample Add-in
 

All About Charts

- Formatting Charts
Combo Charts and Formatting Data Points
- Create Dynamic Chart Labels
- Create a Histogram Chart
Create a Basic Water Fall Chart
Using the Bar to Pie Chart
Add Average Line to a Chart
Invert Negatives in a Chart
Get Graphical without Charts?
Create a Scrolling Chart (Offset Function)

- Create a Basic Speedometer Chart
- Create a Thermometer Effect in you Column Charts
  Quick and Easy Organizational Chart
  Creating a Delta Chart
  Creating a Benchmark Chart
  Use Excel Charts in PowerPoint Without Bloat
 

Advanced Excel Functions

- Alternate Shading with Conditional Formatting
VLOOKUP formulas made easy
Matrix Lookup Formula (Index and Match)
Cell Information Functions
Text and String Functions
Formula to Convert Trailing Minus Signs
- Using IF(AND()) & IF(OR())
- Increase Available Undo Actions
- Using the SumProduct() Function
Using the COUNTIF() to Find Duplicates
Set Duplicates Warning with Data Validation
Basics of Nested Formulas
Conditional Sums and Array Formulas
- Formula to convert your dates to quarters
  Using the SUBTOTALS Function
  Sort by Color without an Add-in
  Turn a Row Oriented Dataset into a Column Oriented Dataset
  Dynamic Ranges Finally Explained
  Sort by Capitalization

Building Excel Applications

- All About Recording Macros
- Cleaning up your Macro generated VBA
- Using Spreadsheet Form Controls
- Using Macros to create a user interface

- Send Emails with SENDEMAIL method
- Create your First User Form (Create a Splash Screen)
- Calling up Excel Dialog Boxes
  Fun Spreadsheet that does Magic Tricks
  Force Users to Enable Macros
 

Getting Started with VBA

- Quick overview of VBA
- Understanding Reference Libraries
  Declaring Variables

- Using If Statements
- Using Select Case Statements
- The Basics of the Do Loops
- Using For Next Loops
- Looping with For Each Statements

Popularity: 26% [?]




Related Posts:
  • Free Flash Ebook
  • 12 Free Ebooks for Flash, Dreamweaver, Fireworks, Macromedia CF MX 7
  • Free Microsoft Excel Video Training
  • 21 Page Flash Training Tutorial
  • Microsoft Excel Workshop Training Handouts

  • Tags for this post>>

    1 Comment »

    1. [...] Excel Flash Training Video’s: This is a great site offering free Excel training video’s. [...]

      Pingback by myexcelfiles.com » Links — February 1, 2009 @ 2:22 pm

    RSS feed for comments on this post.

    Leave a comment

    You must be logged in to post a comment.