Microsoft Excel(Basic & Advanced)

Microsoft Excel has grown to become arguably the most important computer program in the workplaces around the world. Whether you are budgeting, organizing client sales lists, or need to plan an office social gathering, Excel is a powerful tool that has become entrenched in business processes worldwide.

In Finance and Accounting

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions.

This is the area of business with the biggest reliance and benefit from Excel spreadsheets. Advanced formulas in Excel can turn manual processes that took weeks to complete in the 1980s into something that takes only a few minutes today.

Most users know that Excel can add, subtract, multiply, and divide, but it can do much more with advanced IF functions when coupled with VLOOKUP, INDEX-MATCH-MATCH, and pivot tables.

In Human Resource

While database systems like Oracle (ORCL), SAP (SAP), and Quickbooks (INTU) can be used to manage payroll and employee information, exporting that data into Excel allows users to discover trends, summarize expenses and hours by pay period, month, or year, and better understand how your workforce is spread out by function or pay level.

HR professionals can use Excel to take a giant spreadsheet full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future.

Who Should Attend?

This course is suitable for all industries professionals of both Public and Private Sector who are:

  • Accountants
  • Secretaries
  • Project documentation and support staff
  • Bankers
  • Trainers
  • Public Speakers
  • NYSC members

Course Outline

  • Entering and editing data
  • Principles of Data layout/Tables
  • Excel Table formats
  • Formatting Data
  • Working with Data Tools
  • Excel Functions and Formulas
  • Excel Functions and Formulas
  • Working with Pivot Tables
  • Working with Excel Macros

Training Duration: 3 days

WEEK DAYS CLASSES

Time: 9am-4pm (Weekdays)

WEEKEND CLASSES

9am – 4pm (Saturday)

 1pm – 5pm (Sundays)

Training Fee: N70,000 (Seventy thousand naira only)

The above amount covers training materials, lunch break, light refreshments,

Note: Installment payments available (Half payment can be made before the class and half at the end of the class)

Training Venue:  Ikeja, Festac, Lekki and VGC Specific venue in these areas will be communicated to you 1 week before the training.

All Payments should be made into:

Bank – Guaranty Trust Bank, Account Name – Betaconnect Professional Consulting
Account Number –  0221146836
All Cheque payments, should be in favour of “Betaconnect Professional Consulting”

For further information, send us a mail on info@betaconnectng.com

Share this information to other interested colleagues.