MS Office Excel Training - Planning creation

 1,229 total views,  2 views today

MS Office Excel Training - Planning creation 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.


475.-/d
ID : 660

Goal : Create an MS Excel table with functionalities close to MS Project for micro-projects management, for personal tasks management or team planning.

Audience : Ths training is intended for users willing to use MS Excel as planning tool.

Prerequisites : Good knowledge of MS Excel, particularly complex nested functions.

Goals :
  • Introduction
  • Review on limits of MS Excel
  • Review logical, search and date functions
  • Use date formatting
  • Status bar statistics
  • Use conditional formatiing
  • Use validation tool for scrolling lists
  • Create personal layouts with filters and columns/rows hiding
  • Record automation macros
  • Freeze panes
  • Compare spreadsheets and workbooks side by side,Multi-open same file
  • Colouring spreadshheets tabs
  • Insert and print comments
  • Print table headers and hide gridline
  • Use cells naming for fastrer moves
  • Protect workbooks
  • Share workbooks
  • Training Conclusion

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

Suggested duration (days) : 2

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


Tags : planning, gantt, planning, timesheet, excel, training, MS office, ms excel.