Download Now

Excel 2007 Introduction To Formulas And Functions
Excel 2007: Introduction to Formulas and Functions
MP4 | Video: 540p | Duration: 2:26:33 | English | Subtitles: VTT | 221.8 MB


Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and WeiRuan-->WeiRuan Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions. Exercise files accompany this course.

Topics include:
Copying and pasting the value results of a formulaCreating formulas to count cells that meet certain conditionsConnecting Excel to an external data sourceBuilding a two-input data tableSummarizing data using an Excel table

Download link

Direct Download

Tags: Introduction, Formulas, Functions

Add Comments:
Enter Code: *