Excel 2007 training videos

For Corporate Excel 2007 training contact Dr. Dinesh Takyar on +91-9810081867
Sample video: Database functions in Excel like DSUM, DAVERAGE, etc Introduction Microsoft Office Button Formatting text and numbers Basic Calculations Library functions use Circular Reference 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 Database functions in Excel DSUM function in Excel DAVERAGE function Formatting data as tables Vlookup Vlookup and calculations Vlookup and Data Analysis Vlookup using lists Hlookup and Data Analysis Lookup functions using nested functions 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 Another Interesting use of 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 Import data into Excel from another Excel file 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() Bank reconciliation using a for loop Bank reconciliation using a 'do while' loop Excel and mail merge in Microsoft Word Export data from Outlook to Excel Excel and mail merge in Microsoft Word Breakeven analysis in Excel using Goalseek Calendar in Excel Budget in Excel Track changes in an Excel worksheet Descriptive Statistics An interesting use of date functions - birthdays in Excel Excel Array Formulas to summarize data Excel tips for beginners and advanced users Interest calculations on delayed payments in Excel Extracting numbers from alphanumeric text strings How to recover excel graph data from powerpoint slide or graph What happened to the data form in Excel 2007? Highlighting duplicates in Excel data Converting Excel fies to PDF Financial statements- Balance sheet, Income statement, Cash flow statement Excel like calculations in Word Step by step macros...	Excel 2007 Videos Excel 2003 Videos Macros Excel 2007 Macros Excel 2003 About Us Free Ebook Offline Training Twitter What's new?
Quickly find the topic of your interest from hundreds of Excel videos:

For Corporate Excel 2007 training contact Dr. Dinesh Takyar on +91-9810081867

For Corporate Excel 2007 training
contact Dr. Dinesh Takyar on +91-9810081867