ARCHITECTING SOFTWARE WITH OBJECT ORIENTED ANALYSIS AND DESIGN

ARCHITECTING SOFTWARE WITH OBJECT ORIENTED ANALYSIS AND DESIGN

Summary

Location

Location

Malaysia

Duration

Duration

3 Days
Format

Format

Public Class

Public Class

Understanding Object Oriented Analysis and Design

Object Oriented Analysis and Design is at the heart of modern software engineering. In this comprehensive course, we delve deep into the art of architecting software using the principles of Object Oriented Analysis and Design (OOAD).

Mastering the Art

Our course takes you on a journey through the intricate world of object oriented analysis and design. Whether you’re a seasoned developer or just starting out, we’ve got you covered. You’ll learn to dissect complex problems, break them down into manageable components, and create elegant solutions using the power of objects and classes.

Elevate Your Skills

By the end of this course, you’ll be equipped with the knowledge and skills needed to tackle real-world software challenges with confidence. You’ll be fluent in object-oriented thinking, be able to create robust software architectures, and write clean, maintainable code. So, if you’re ready to take your software engineering skills to the next level, join us on this exciting journey into the world of Object Oriented Analysis and Design.

Course Details

Course Code: EX21A-2; Instructor-led

Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Prerequisites

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

  • Have attended Microsoft Excel – Foundation & Intermediate Level; OR
  • Able to create simple to complex formulas and functions
  • Able to validate data in a Worksheet
  • Able to apply Filter data using Auto & Advanced Filters
  • Able to clean Duplicate Records

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Create Subtotal Using the Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use XLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Summarizing & Analyzing with Pivot Table and Pivot Charts

Outlines

Topic A: Outlining and Grouping Data

  • Using Automatic Outlining
  • Displaying and Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals

Topic A: Using Data Analysis Tools

  • Using a One or Two Input Data Table
  • Using Goal Seek

Topic B: Exploring Scenarios

  • Creating a Scenario
  • Editing Scenarios
  • Creating Scenario Summary Report

Topic C: Using Solver

  • Generating Reports with Solver
  • Changing Solver Values
  • Managing Solver Constraints
  • Using Solver as a Goal Seek Tool

Topic A: Using the XOOKUP Function

  • Using XLOOKUP to Find Data
  • Find Exact Match with XLOOKUP
  • Find Closest Match with XLOOKUP

Topic B: Alternative LOOKUP Function

  • Using the INDEX Function
  • Using the MATCH Function
  • Combining the MATCH and INDEX functions

Topic C: Linking, Consolidating, and Combining Data

  • Linking Workbooks
  • Consolidating Workbooks
  • Combining Worksheets

Topic A: Create Combo Chart

  • Comparing 2 Types of Values with high Variance
  • Creating Combo Chart
  • Editing Combo Chart

Topic A: Create a PivotTable

  • Create PivotTable Dialog Box
  • PivotTable Fields Pane
  • Summarize Data in a PivotTable
  • Show Values as Functionality of a PivotTable
  • Personalize the default PivotTable layout

Topic B: Filter Data by Using Slicer & Timeline

  • Insert Slicers Dialog Box
  • Insert Timeline

Topic C: Analyzing Data with PivotChart

  • Creating PivotChart
  • Editing a PivotChart

Topic A: Linking Workbooks

  • Inserting Hyperlinks
  • Editing Hyperlinks
  • Formatting Hyperlinks
  • Using Hyperlinks in Excel

Topic A: Protecting Worksheet and Workbook

  • Lock & Unlock Cells
  • Protecting the Current Sheet
  • Allow users to edit range
  • Protecting an Entire Workbook
  • File Protection

Trainers

Reviews

Interested In

ARCHITECTING SOFTWARE WITH OBJECT ORIENTED ANALYSIS AND DESIGN

Starting From
RM4500
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: ARCHITECTING SOFTWARE WITH OBJECT ORIENTED ANALYSIS AND DESIGN
Duration: 3 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *