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

29 Jul - 01 Aug, 2024  4 days

Follow Event

  

NGN 285,000

Venue: LAP NEW WORLD HOTEL JABI ABUJA

Other Dates

Venue Date Fee  
LAP NEW WORLD HOTEL JABI ABUJA, Abuja FCT, Nigeria 21 - 24 Oct, 2024 NGN285000

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
LAP NEW WORLD HOTEL JABI ABUJA Jul 29 - 01 Aug, 2024
LAP NEW WORLD HOTEL JABI ABUJA, Abuja FCT, Nigeria 21 - 24 Oct, 2024
NGN 285,000.00
(Convert Currency)

Dr. Francis okereke 08035062583

A distinguished team of Facilitators who are eminently qualified professionals
NST PPC Advert

Related Courses

Project Management, Monitoring and Evaluation Course Project Management, Monitoring and Evaluation Course

4 days, 13 - 16 May, 2024 

2024-05-13 12:05:00 2024-05-13 12:05:00
State, Nigeria

Fontini Consulting Ltd

The Project Management, Monitoring and Evaluation course is designed to help participants to: Understand key aspects of project design, planning, implementation, administration, and Monitoring and ...

Treasury Management Course Treasury Management Course

5 days, 20 - 24 May, 2024 

2024-05-20 12:05:00 2024-05-20 12:05:00
Ghana

Fontini Consulting Ltd

Eliminating the Challenges of Treasury Management; This Course will entails Day 1 Current challenges of corporate treasury management Corporate value creation Cash flow and liquidity management ...

Security and Safety in the Oil and Gas Industry Security and Safety in the Oil and Gas Industry

4 days, 20 - 23 May, 2024 

2024-05-20 12:05:00 2024-05-20 12:05:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

This all important security and safety in the oil and gas industry seminar will  address the nitty gritty of Security and Safety in the Oil and Gas Industry. Details on request. ...

Business Analysis for Legal and Non Finance Professionals Business Analysis for Legal and Non Finance Professionals

4 days, 10 - 13 Sep, 2024 

2024-09-10 12:09:00 2024-09-10 12:09:00
State, Nigeria

Fontini Consulting Ltd

This course gives Legal Advisers and managers as well as executives with no prior background in finance and or accounting the foundation to understanding financial accounting, business analysis, ...