MS Office Excel Training - The top 100 essential functions

 1,711 total views,  2 views today

MS Office Excel Training - The top 100 essential functions in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.


375.-/d
ID : 248

Goal : Learn to use and combine the 100 most common MS Excel functions in statistics, logic, database, time management, text modification and finance.

Audience : Users needing to improve their knowledge of MS Excel functions for more professional efficiency and accuracy.

Prerequisites : Daily hands on experience of MS Excel with basic tables and formulas.

Goals :
  • Introduction
  • Reminder of SUM, MAX, MIN, COUNT, AVERAGE
  • Relative and absolute references
  • Naming cells vs absolute references
  • Logical functions IF, AND, OR
  • Functions INDEX, LOOKUP, VLOOKUP, XLOOKUP, MATCH
  • Error management using the functions ISERR, ISNA
  • Formatting number functions ROUND, ROUND.UP, ROUND.DOWN, FLOOR, CEILING
  • Basic text functions CONCATENATE, RIGHT, LEFT, UPPERCASE, LOWERCASE, PROPER
  • Dates and time functions YEAR, TODAY, NOW, DAY, DATE, WEEKDAY, MONTH, EOMONTH, etc.
  • Functions SUMIF, COUNTIF, COUNTA, COUNTBLANK,Matrix function SOMMEPRODUCT, MMULT
  • Basic descriptive statistics functions FREQUENCY, MODE, LARGE, MEDIANE, STDEV, STDEVP, VAR, VARP, PERCENTILE, AVERAGE, etc.
  • Audit toolbar for evaluations and functions' tracing
  • Training Conclusion

Pedagogical method : A certificate will be awarded to each participant who has attended at least 80% of the training.

Suggested duration (days) : 3

Daily price : 375 CHF
Price per day per trainee without course material, without certificate, without evaluation, without training room or computer

Book
  • Title : Formulas and Functions With MS Office Excel 2007
  • Author(s) : Paul McFedries
  • Pages : 552
  • ISBN : 0789736683

Tags : excel, functions, statistics, average, sum, matrix, logical, finance, dates, time, text.