Leadership
Titlu curs: Excel 2007 Formulas and Functions
- Description: Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.
- Target audience: Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.
- Estimated Duration: 2.0 h
- Lesson Objectives: Basics of Formulas and References in Excel 2007
•identify the elements of a formula
•identify the default order in which calculations occur
•match absolute, relative, mixed, and 3-D references with examples
Insert Formulas in Excel 2007
•insert an Excel 2007 formula
•use names to clarify formulas
•edit formulas
Entering a Formula with References in Excel 2007
Perform AutoCalculate Functions in Excel 2007
•use the AutoCalculate feature to perform basic functions
Logical, Financial, and Date Functions in Excel 2007
•use a logical function
•use a financial function
•use a date function
Inserting Functions in Excel 2007
Using Formulas and Functions in Excel 2007
Compatibilitatea sistemului meu
Asigura-te ca poti parcurge cursurile SkillSoft pe acest calculator.
Reprezint o companie
Pentru a-ti oferi cea mai potrivita solutie pentru compania ta, lasa-ne datele de contact si un expert in e-learning te va cauta, fara nici o obligatie, in urmatoarele 2 zile lucratoare.
Lista serviciilor oferite companiilor →
Garantia ZF: cu Ziarul Financiar economisesti minim 10% la cursurile si serviciile de e-learning. Conditiile garantiei →
Pentru clientii noi
Atat crearea unui cont nou cat si parcurgerea oricaror cursuri demonstrative sunt gratuite.
