Excel Custom Add-Ins, VBA, Charts, and Graphs
Creating Custom Add-Ins for Excel
Add-ins allow users to package their macros and distribute them across multiple workbooks. Add-ins can be loaded or unloaded as needed, making them versatile for automating tasks across different Excel instances.
Example:
- Create an add-in that automatically sorts data in ascending order.
Steps for Practical:
- Create a macro that sorts data:
Sub SortData()
Range("A1:D10").Sort Key1:=Range("A1"), Order1:=xlAscending
End Sub
- Save this macro as an Excel Add-in (.xlam file)
Power, Influence, and Decision-Making in Organizations
Power vs. Influence
Power (pushes, imposed by authority) vs. Influence (persuades, does not require authority)
Bases of Power
- Personal
- Source of expertise/ability
- Admiration and desire to please
- Positional/Formal
- Fear of negative (punishment)
- Hope for positive (reward)
- Legitimate
- Relational
- Source of resources
- Positions in network
Types of Influence
- Interpersonal
- Influencing individuals and group members
- Procedural
- Managing the rules or procedures used to exchange information and aggregate individual preferences
Cialdini’
Read MoreCost Accounting Standards and Their Impact on Business
Importance of Cost Accounting Standards
Cost Accounting Standards (CAS) play a crucial role in ensuring consistency, transparency, and reliability in cost accounting practices. They serve as a framework for organizations to determine costs systematically and accurately.
Uniformity in Costing
- CAS ensures that all organizations follow a standardized approach to cost accounting, leading to uniformity in cost determination.
- This uniformity facilitates better comparability of cost data across industries
Team Structure Design and Management Principles
New Options for Team Structure Design
Using computers as a central instrument for coordinating the activities of a virtual organization: a small central organization that outsources its major features for most business functions.
Without Borders Organization
An organization that seeks to eliminate the chain of command, have limitless spans of control, and replace departments with empowered teams.
Why Differ from Mechanical Model Structures?
A mechanical model structure is characterized by extensive departmentalization,
Read MoreOrganizational Structure and Management: A Comprehensive Approach
Organizational Structure and Management
Structure: A system outlining how activities are organized and directed to achieve goals. These activities generally include the rules to be followed and the roles and responsibilities of those within the company.
Organizational Design Tools
When designing the structure of any organization, we must be clear about the following:
- The structure of the company has to serve to achieve the real objectives that have been set.
- What is to be done? This refers to the functions
EASA and ICAO Regulations for Aircraft Maintenance
Part 145 Maintenance Organizations
Part 145 organizations are the ‘standard’ maintenance providers for TAC and large aircraft. They must adhere to Regulation (EU) 1321/2014, Annex II. This regulation establishes technical and administrative procedures for ensuring aircraft airworthiness.
Facilities Requirements
Organizations must have:
- Hangars with sufficient dimensions for base maintenance.
- Component workshops large enough for planned maintenance.
- Office space for management and certifying staff.
- A controlled