Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Basic Excel Training for Managers

By: Fontini Consulting Ltd

Abuja FCT, Nigeria

24 - 28 Mar, 2025  5 days

Follow Event

  

NGN 545,000

Venue: LAP NEW WORLD HOTEL JABI ABUJA

Other Dates

Venue Date Fee  
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 23 - 27 Jun, 2025 NGN545000
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 22 - 26 Sep, 2025 NGN545000

Microsoft Excel is the most used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. This course aims to teach individuals how to easily monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists. In addition, hands-on practical would be carried out to solidify participants’ training.

Course Objectives

By the end of this course, participants should be able to:

  • Work with data
  • Use collaboration tools effectively.
  • Work with outlines
  • Analyze data with pivot tables.

Target Audience

Managers, Senior Supervisors and Professionals who want to learn the basic to intermediate excel skills.

Target Competencies

  • Managing performance
  • Multi-tasking skill
  • Analytical skill
  • Coaching skill

Course Outline

  • Working with Functions
  • Using the paste function tool
  • Absolute and relative cell references
  • Using range name in functions
  • Crested nested functions.
  • Logical functions (SUMIF, COUNTIF)
  • Working with Data
  • Using Excel as a database
  • Sorting Data
  • Custom sorts
  • Filtering using AutoFilter.
  • The Advanced Filter tools.
  • Working with External Data
  • Writing formulas in cells
  • Using the formula bar
  • AutoSum and other basic functions
  • Working with External Data
  • Data consolidation
  • Linking to another workbook
  • Linking to an external database
  • Getting data from the web
  • Collaboration tools
  • Protecting a workbook
  • Protecting worksheets and cells
  • Adding comments to cells
  • Sharing workbooks
  • What-if Analysis
  • Using the scenario manager
  • Creating and editing scenarios
  • Creating a scenario report
  • Using Goal Seek
  • Working with Outlines
  • Applying an outline
  • Automatic outlining
  • Displaying and collapsing levels
  • Modifying outline settings
  • Creating subtotals
  • Analyzing Data with Pivot Tables
  • Creating a pivot table
  • Defining the source range
  • Inserting, moving, and deleting fields
  • Showing and hiding fields
  • Grouping and ungrouping fields
  • Excel Macros
  • About macros and VBA
  • Macro security
  • Recording macros
  • Running a Macro
  • Absolute and relative references
  • Saving and distributing macros
  • Assigning a macro to a button
  • Editing macro code
  • Automatic macros

Course Booking:

Please use the “book now” or “inquire” buttons on this page to either book your space or make further enquiries.

LAP NEW WORLD HOTEL JABI ABUJA Mar 24 - 28 Mar, 2025
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 23 - 27 Jun, 2025
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 22 - 26 Sep, 2025
NGN 545,000.00
(Convert Currency)

Dr. Francis okereke 08035062583

Basic Excel Training for Managers
A distinguished team of Facilitators who are eminently qualified professionals

Related Courses

Certified Procurement Professional Certified Procurement Professional
On going

5 days, 10 - 14 Feb, 2025 

2025-02-10 12:02:00 2025-02-10 12:02:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

Procurement is at the heart of the supply chain function as the purchasing department can spend up to 70% of a company's money. In this course, we will explore the strategic role of the ...

Corporate Finance Master Class Training Course Corporate Finance Master Class Training Course

5 days, 10 - 14 Mar, 2025 

2025-03-10 12:03:00 2025-03-10 12:03:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

Corporate Finance Master Class, this training course gives you an overview of the main theories and tools used in corporate finance, all centered on an examination of shareholder value. What you will ...

Excellence in Corporate Internal Auditing and Fraud Control Workshop Excellence in Corporate Internal Auditing and Fraud Control Workshop

4 days, 24 - 27 Feb, 2025 

2025-02-24 12:02:00 2025-02-24 12:02:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

The workshop will highlight current trends and practices in corporate in internal auditing. Issues to be discussed include: The wider scope of roles and responsibilities of a modern internal ...

Asset and Liability Management for Banks Asset and Liability Management for Banks

5 days, 21 - 25 Apr, 2025 

2025-04-21 12:04:00 2025-04-21 12:04:00
Ghana

Fontini Consulting Ltd

This financial management course designed by experts  helps you get the right balance when confronting asset and liability management processes with banks and financial institutions. This ...