MS. OFFICE FOR SPECIFIC PURPOUSE

Project Based Learning

MANAGE WORKBOOK

Outline Objective :

Save a workbook as a template | Copy macros between workbooks | Reference data in another workbook | Reference data by using structured | references | Enable macros in a workbook | Display hidden ribbon tabs

MANAGE WORKBOOK REVIEW

Create custom number formats | Populate cells by using advanced Fill Series options | Configure data validation

Apply Custom Data Formats and Validation

Restrict editing | Protect a worksheet | Configure formula calculation options | Protect workbook structure | Manage workbook versions | Encrypt a workbook with a password

Apply Advanced Conditional Formatting and Filtering

Create custom conditional formatting rules | Create conditional formatting rules that use formulas | Manage conditional formatting rules

Create and Modify Custom Workbook Elements

Create custom color formats | Create and modify cell styles | Create and modify custom themes | Create and modify simple macros | Insert and configure form controls

Perform Data Analysis and Business Intelligence

Import, transform, combine, display, and connect to data | Consolidate data | Perform what-if analysis by using Goal Seek and Scenario Manager | Use cube functions to get data out of the Excel data model | Calculate data by using financial functions

HCM TRAINING SERVICE

Quality, not quantity

• Approach problems using structured methods of gathering observations, breaking cognitive fixedness, and generating creative ideas for solutions.

• Apply creative solutions and behavior-change analysis to innovation development and internal team processes

• Develop a strategic innovation toolkit and learn when and how to apply design thinking and innovative problem-solving tools and exercise

• Practice empathy in applying a human-centered approach to design techniques, such as user research, user experience, prototyping, and journey mapping

• Assess group dynamics and improve team performance through tools and processes designed to enhance collaboration and iteration in development

• Guide teams to draw from a wide range of professional experiences and backgrounds and create stronger collaboration dynamics to heighten their approach to innovation

INTERNATIONAL CERTIFICATION

The PMP (Project Management Professional) acknowledges candidates skilled at managing the people, processes, and business priorities of professional projects. PMI, the world’s leading authority on project management, created the PMP to recognize project managers who have proven they have project leadership experience and expertise in any way of working.

To obtain PMP certification, a project manager must meet certain requirements and then pass a 180-question exam. The PMP exam was created by project leaders for project leaders, so each test question can be related to real-life project management experiences.

MICROSOFT PROJECT TRAINING

Why is it Important?

Microsoft Project (MS Project) is a project management software developed by Microsoft. This software is designed to assist project managers, teams, and organizations in planning, tracking, and managing projects. MS Project allows you to create different projects, allocate resources, create timelines, track tasks, and report progress.

MS Project offers a range of tools and features that can be used to manage complex projects. These include defining tasks, setting task dependencies, allocating and tracking resources, creating timelines, budget and cost management, progress tracking, and reporting

MS Project provides a flexible platform that can be used for various projects in different industries. It can be applied to a wide range of areas, from large construction projects to software development, event planning, and business processes.

Our principles

Driving technological advancements through continuous innovation and research.

Collaboration

Quality

Innovation

Delivering high-quality solutions and services that exceed customer expectations.

Fostering collaboration and partnerships to achieve mutual growth and success.