Blog

DATA MANAGEMENT AND ANALYSIS USING EXCEL

This course is designed to provide participants with an understanding of how Information Systems are used in organizations for meeting strategic and operational goals. To this end, participants will acquire skills using current end-user software for communication, data transformation, collaboration, and problem-solving. The course also covers software and hardware components, information structures, basic business organization and processes, information system security, and networks.

 

KEY LEARNING OUTCOMES

At the end of this training, participants will be able to:

Describe how data is captured, organized and managed using a data management system and design a simple database using data modeling techniques. Discuss the strategic considerations in information system development and their impacts on the organization. Design effective user interfaces and explain the importance of internal controls for information systems. Describe the different technologies, techniques and infrastructure of transaction processing systems associated with various transaction cycles. Identify and analyze risk factors, discuss measures to mitigate risks and the importance of business continuity planning

 

TARGET PARTICIPANTS:

  • Product Managers
  • Marketing Staff
  • Staff of Management & Information Science department
  • Finance department

COURSE CONTENT

  • Introduction to Information Systems in Organizations
  • Financial Reporting using excel
  • Optimizing BPA usage for reporting
  • Financial and Business Communication
  • Consolidating data from separate files and sheets
  • Advanced data validation using lists, dates and custom validation
  • Cell management tools: left, right, mid, concatenate, value
  • Naming, editing, and managing cells and ranges
  • Looking-up data, texts, and values using Vlookup
  • The incredible table-tools technique
  • Slicing dates into day names, weeks, week numbers, month names, years and quarters
  • Text to columns and dynamic trimming using Trim, Len
  • Managing texts and numbers using replace, find, and substitute
  • Text change functions

COURSE DURATION: 2 Days

COURSE DATE: July 26th-27th 2023

COURSE FEE: N 85,000.00 per Participant

For further enquires and registration, please call: 09013234481, 08062549540

You can also visit us at CREM: 1 Adebayo Oyelana Street, beside Ejigbo Mini Stadium, Ejigbo Isolo, Lagos

OTHER UPCOMING COURSES TREASURY RISK MANAGEMENT DEFENSIVE DRIVING SKILLS TRAINING INVENTORY AND STORE MANAGEMENT
CREM Nigeria

Recent Posts

Outsourcing

A Strategic Way Out of Nigeria’s 2024 New Minimum Wage In 2024, Nigeria faces yet…

1 month ago

Best Practices in Customer Relationship Management

In today's competitive business environment, exceptional customer relationship management (CRM) is crucial for building loyalty,…

2 months ago

References for Get Your Dream Job

i) Drucker, P. F. (1999). Management challenges for the 21st century. Harper Business. ii) Kolb,…

3 months ago