Excel file for projects and reports

Bag code: COMSO37525024 Days: 5 days Today’s training: 5 hours Time: 25 training hours Targeted participants: Anyone interested in learning about Excel and its features Program overview: This program revolves around an Excel file for projects and reports (definition – types – features – objectives – advantages – disadvantages .. etc.) and will be presented through the following units: First training unit: Excel basics for project management Second training unit: Task tracking and progress Third training unit: Resource and cost management Fourth training unit: Creating periodic reports Fifth training unit: Improving and customizing Excel file Program objectives: To enable the trainee to create a simple project schedule. To understand methods of adding columns to track task status. To discuss protecting the Excel file with a password to ensure data security. Program topics: First unit: (Excel basics for project management) Creating a simple project schedule (Gantt Chart). Entering tasks and start and end dates. Second unit: (Task tracking and progress) Adding columns to track task status (completed, in progress, not started yet). Inserting a progress bar for each task. Third unit: (Resource and cost management) Creating a table to track resources (people, equipment, materials). Calculating project costs using functions like SUM. Fourth unit: (Creating periodic reports) Using Pivot Tables to analyze data. Creating charts to display progress and budget. Fifth unit: (Improving and customizing Excel file) Protecting the Excel file with a password to ensure data security. Customizing templates to meet different project needs. Contents of the bag: PowerPoint 122 Trainer’s guide 129 Trainee’s guide 113 Activities 10 Introductory guide 4 References 4 Evaluation and data forms 6 Pre- and post-test 6 Videos 10 Images 10 Mind maps 1 Brochure 1 Bag contents: 12 Training bag model Please click here to view the training bag model