What's new in Excel 2007?

		Quickly find the Excel training topic of your interest. Example: Just type VLOOKUP or IF in the search box on the left.
Training in Excel 2007		More Free Excel Training Videos Introduction Formatting text and numbers Basic Calculations Page layout and print preview Autocomplete data entry feature Automatic data entry in many worksheets Absolute and relative cell reference How to use comments in an Excel worksheet How to remove duplicates from worksheet data Create a new workbook based on a template Using themes and smartart diagrams Inbuilt Functions Convert function Working with Factorials Using worksheets effectively in Excel 2007 Using 3-D references Using consolidate feature Condtional Formatting Sumifs - sum based on multiple criteria Countif - a powerful function Nested functions Using 'IF' & 'AND' functions together Text to columns RANK - a useful statistical function Sort Function More on sort data Autofilter Advanced filter DSUM function in Excel DAVERAGE function Formatting data as tables Vlookup Vlookup and calculations Vlookup and Data Analysis Hlookup and Data Analysis Lookup functions using nested functions The MATCH function and Data Analysis The MATCH function and Data Analysis Data analysis using subtotals Data analysis using combination of Max, Match, Vlookup and LARGE functions Graphs inside Excel cells Formatting the in-cell graphs Charts Pivot Tables Goal Seek Solver Solver and Financial Planning Named ranges Data validation Custom Data validation Trim function Text functions Linking an Excel worksheet with a Word 2007 document Saving Excel 2007 files for use with older Excel versions Record a macro How to write your first macro Using range property Using Cells property Calculations macro Do while loop For... next loop Import data from text files Import data from databases Using a command button Navigating large worksheets and keyboard shortcuts Use the keyboard to work with the Ribbon programs Quiz Teaching kids through Excel Inventory Management Gantt Charts in Excel 2007 Accessing data from other workbooks Collaboration: send Excel document in e-mail message Sensitivity Analysis with data tables Sensitivity Analysis using Spin Button Checkbox form control - an interesting use Updating calculations automatically using dynamic ranges Finding your latest sales data Business solution - how long did the product stay in the store? Sensitivity analysis before starting a business Sensitivity analysis using the scenario manager Twitter Web Client in Excel Len function in Twitter web client 'IF' function in Twitter web client Random Function RAND() Simulations using Random Function RAND() Monte Carlo Simulation Step by step macros... See more Free Excel Training Videos