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

22 - 26 Apr, 2024  5 days

Follow Event

  

NGN 285,000

Venue: Alexis Hotel and Conference Centre. Plot 693 ObafemiAwolowo Way Jabi- Abuja

Other Dates

Venue Date Fee  
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 29 Jul - 01 Aug, 2024 NGN285000
LAP NEW WORLD HOTEL JABI ABUJA, State, 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
Alexis Hotel and Conference Centre. Plot 693 ObafemiAwolowo Way Jabi- Abuja Apr 22 - 26 Apr, 2024
LAP NEW WORLD HOTEL JABI ABUJA, State, Nigeria 29 Jul - 01 Aug, 2024
LAP NEW WORLD HOTEL JABI ABUJA, State, 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

Related Courses

Demystify the Complex Products of Credit Derivatives Course Demystify the Complex Products of Credit Derivatives Course

4 days, 27 - 30 May, 2024 

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

Fontini Consulting Ltd

This course gives you the wide range of uses of credit derivatives, pricing and hedging of credit derivatives products and insights into the latest credit derivatives products and applications ...

Forensic Accounting and Audit Certification Course Forensic Accounting and Audit Certification Course

4 days, 13 - 16 May, 2024 

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

Fontini Consulting Ltd

Corporates frauds have the inherent power to bring large organizations to their knees, cause huge monetary loss, prompt lawsuits followed by significant legal expenses, lead to the imprisonment of ...

Management Skill Improvement for Managers Workshop Management Skill Improvement for Managers Workshop

4 days, 23 - 26 Apr, 2024 

2024-04-23 12:04:00 2024-04-23 12:04:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

The workshop, which will be a practical one, will teach the participants the preparation, analysis, and interpretation of accounts from the rudimentary stages. The workshop will also dwell on basic ...

Operational Risk Management: Basel Compliance Training Operational Risk Management: Basel Compliance Training

4 days, 13 - 16 May, 2024 

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

Fontini Consulting Ltd

This training course gives you the knowledge and skills needed to review, benchmark, and refine operational risk policies within your financial institution. How to be Compliant for Basel II/III This ...