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

How to Build a Culture that Excites Employees

In today's competitive job market, attracting and retaining a top talent requires more than just…

1 week ago

Modern Business Principles

Although, technology has made things easier for businesses, it has made the competition cruel, and…

1 week ago

Exploring the Dynamics of Manpower Outsourcing

Benefits, Challenges, and Best Practices In today's rapidly evolving business landscape, companies are continually seeking…

2 weeks ago

Advanced Financial Statement Analysis

Are you ready to elevate your financial analysis skills to new heights?Join us for an…

3 weeks ago