COURSE INFORMATION

Scheduled Dates: 03 – 07 Feb 2025 | 05 – 09 May 2025 | 04 – 08 Aug 2025 | 03 – 07 Nov 2025

Duration: 1 Week

Customized dates and one-on-one sessions can be organized.

Preamble

In this Introduction to Microsoft Excel training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets.

Learning outcomes

• Create, modify and format a spreadsheet for beginners
• Use basic formulas and functions
• Create a calculation across multiple worksheets
• Sort a list
• Create a Microsoft Excel chart
• Print a spreadsheet using Headers and Footers and Page Breaks

Course Outline

Chapter 1: Office Workspace Basics

• Basic Window Elements
• Exploring Microsoft Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with Key Tips
• Using the Status Bar
• Getting Help

Chapter 2: Introduction to Excel

• What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook

Chapter 3: Entering and Editing Data

• Entering Text, Numbers, and Data
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data

Chapter 4: Introduction to Formulas and Functions

• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas

Chapter 5: Working with Functions

• Using Statistical Functions
• Using Financial Functions
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations

Chapter 6: Formatting Data

• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

Chapter 7: Formatting Worksheets

• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

Chapter 8: Adding Charts and Graphics

• Creating a Chart
• Enhancing a Chart
• Modifying Chart Data
• Changing Chart Types
• Drawing Shapes
• Inserting Pictures
• Creating SmartArt

Chapter 9: Viewing and Printing Workbooks

• Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data Info about Slicers
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet
• Printing Selected Data

Chapter 10: Managing Workbooks

• Arranging Multiple Workbooks
• Adding Hyperlinks
• Working with Comments
• Saving Workbooks in Different Formats
• Saving a Workbook as a Web Pages
• Creating Folders
• E-Mailing a Workbook

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:
Email: This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancellation of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.

COURSE INFORMATION

Scheduled Dates:  06 – 17 Jan 2025 | 07 – 18 Apr 2025 | 07 – 18 Jul 2025 | 06 – 17 Oct 2025

Duration: 2 weeks

Customized dates and one-on-one sessions can be organized.

Preamble

Introduction to Computer Applications is designed to familiarize students with computers and their applications. Students will learn fundamental concepts of computer hardware and software and become familiar with a variety of computer applications, including word-processing, spreadsheets, databases, and multimedia presentations. Students will also investigate Internet-based applications, working with email and learning how to browse the web. Coursework also includes activities that explore social and ethical issues related to computers.

Course outline

•    General introductions
•    Introduction to the computer
•    Introduction to Windows
•    Introduction to typing
•    Review Windows and Typing
•    Windows Navigation
•    Word Introduction
•    Review Windows and Word
•    Word Formatting Commands
•    Review Word Formatting
•    Windows File Management
•    Review Formatting and File Management
•    Internet Navigation
•    Internet Search
•    Internet Safe Practices
•    Word Editing
•    Word Formatting, cont.
•    Review Word Editing and Formatting
•    Final Review and Project

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:
Email:This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancellation of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.

COURSE INFORMATION

Scheduled Dates: 22 – 26 Jan '2024 | 22 – 26 Apr '2024 | 22 – 26 Jul '2024 | 21 – 25 Oct '2024

Duration: 1 Week

Customized dates and one-on-one sessions can be organized.

Preamble

This Training will enable participants to create a project, add activities and relationships, assign resources, adjust the project plan to account for schedule delays and over allocated resources, and analyze portfolios. Participants will also learn how to customize the personal workspace and the project workspace to monitor project progress and communicate with team members. Oracle BI and BPM are not covered in this course. The course uses P6, Primavera Web-based project management tool. It is divided into four sections: Overview and Creating a Project; Scheduling the Project and Managing Data; Assigning Resources and Baselining; and Project Execution and Control.

Target Group

Existing user, Business Analyst, Functional Implementer, Project Manager

PREREQUISITE: Knowledge of project management principles

Course Objectives:
• Create a project
• Create a Work Breakdown Structure
• Add Activities
• Customize activity views
• Create Relationships
• Schedule the project
• Assign constraints
• View the Enterprise Project Structure
• Optimize the project schedule
• Assign roles and resources
• Analyze resources and cost
• Baseline the project plan
• Execute the project
• Customize dashboards
• Manage risk
• View reports

Course Outline
• Project Management Life Cycle
• Understanding Data in P6
• Overview and Navigation
• Creating a Project
• Creating a Work Breakdown Structure
• Adding Activities
• Calendars
• Creating Relationships
• Scheduling
• Assigning Constraints
• Customizing Activity Views
• Understanding Roles and Resources
• Assigning Roles and Resources
• Project Workspace
• Optimizing the Project Plan
• Baselining the Project Plan
• Methods of Applying Progress
• Executing the Project Plan
• Analyzing the Updated Project
• Portfolios and Dashboards
• App A – Updating the Project Using Timesheets
• App B – Reporting
• CS – Three Case Studies

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:

Email: This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancellation of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.

COURSE INFORMATION

Scheduled Dates: 03 – 14 Mar 2025 | 02 – 13 Jun 2025 | 1 – 12 Sep '2025 | 01 – 12 Dec 2025

Duration: 2 Weeks

Customized dates and one on one sessions can be organized.

PREAMBLE

Today’s researchers are under pressure to ‘publish or perish’. Consequently, researchers. World-wide are increasingly finding it worth their while to use SPSS to facilitate their data analysis.

Additionally, the workshop will benefit corporate executives who have to prepare business reports. As most executives have to prepare business reports, this workshop will be of value to any executive interested in updating his/her data analysis skills.

TARGET GROUP

Middle level managers and team members who have basic computer skills and a statistical background

COURSE OUTLINE

• Introduction
• Overview of SPSS
• Data input
• File important from other applications life Ms-Excel
• Output to SPSS and to Ms-Word
• Data Manipulation
• Sorting cases
• Selecting cases
• Data transformation
• Data sampling
• Scatter plots and other graphs
• Frequency tables
• Cross tabs & Contingency tables
• Simple linear Regression Analysis
• Covariance Analysis
• SPSS as a database
• Interpretation & representation of SPSS Analysis
• Testing of hypothesis
• Measures of central tendency
• Measures of dispersion

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:
Email:This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancellation of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.