INTRODUCTION
A spreadsheet is the computer equivalent of a paper ledger sheet, consisting of a grid made from columns and rows. It is an environment that can make number manipulation easy and somewhat painless. Here then lies the critical significance of MS Excel in managing finance, personnel, stores and all related activities in the organization that involve the generation of spreadsheets. It’s easy-to-use attribute, malleability, analytical and other characteristics make Excel the most powerful manager of spreadsheets. Currently, most users of this package are oblivious of the advance features, a gap that this course is designed to bridge
OBJECTIVES
At the end of the training, participants will be able to:
- Highlight rich resources available in advanced MS Excel applications
- Teach participants how to produce reliable Excel workbooks, including how to display, format, and edit existing worksheets and develop new ones and how to make the most of Excel by creating formulas to analyse data quickly
- Provide the techniques needed for mastering Excel’s
charting capabilities and working with multiple workbooks
to illustrate data, relationships and trends
CONTENTS
Beyond the Basics
- Enter and edit labels, values and formulas in a
worksheet - Use Auto fill to quickly fill in predefined labels and
to copy text, numbers and formulas
Working with Charts and Multiple Worksheets
- Create a structured list to maximize current and
future data productivity - Sort a list using several techniques
- Add subtotals to worksheets without writing any
formulas
Sorting, Filtering, Subtotals and Pivot Tables
Use mathematical functions (sum, round, trunk,
ceiling)
Use logical functions (if, and, or, not, nested if
Format and Calculate date and time, etc.
Functions and Data Analysis
TARGET
Accountants, Financial Controllers, Auditors, Bankers, Insurers and others from the financial sector
FEE:
1 week: N100,000 2 weeks N150,000
DATE:
1 week : Feb 6-10, Mar. 6-10, Apr 3-7 May 8-12, June
5-9, Ju13-7, Aug 7-11, Sept 4-8, Oct 9-13, Nov. 6-10,
Dec 4-8, 2023.
1 Week Feb 5-9, 12 – 23, Mar. 4-8, 11-22, Apr. 1-5, 8-
19, May 6-10, 13-24 June 3-7, 10-21, July 1-5, 8-19
August 9-9, 12-23 Sept. 2-6, 9-20 Oct. 7-11, 14-25
Nov. 4-8, 11-22, Dec. 2-6,9-20, 2024
2 weeks Feb 12-23 March 11-22 April 8-19 May 13-24
June 10-21 July 8-19 August 12-23 Sept 9-20 Oct 14-
25 Nov 11-22 Dee 9-20.
2 week : Feb 13-24, Mar13-24, Apr.l0-21, May 15-26,
June 12-23, Jull0-21, Aug 14-25, Sept. 11-22, Oct 9-
20, Nov. 13-24, Dec 11-22, 2023.