1,321 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.
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.
- 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.