Month | Date | Duration | Cost | Location | Make a Booking |
---|---|---|---|---|---|
January | 20th -25th | 5 Days | ₦ 341,500 | Port Harcourt | Click to Book |
February | 3rd -8th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
March | 4th- 8th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
April | 15th-19th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
May | 4th -8th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
June | 8th-12th | 5 Days | ₦ 262,500 | Lagos | Click to Book |
July | 13th-17th | 5 Days | ₦ 341,500 | Abuja | Click to Book |
August | 17th-21th | 5 Days | ₦ 341,500 | Port Harcourt | Click to Book |
September | 7th- 11th | 5 Days | ₦ 341,750 | Port Harcourt | Click to Book |
October | 5th-9th | 5 Days | ₦ 341,500 | Port Harcourt | Click to Book |
November | 9th-13th | 5 Days | ₦ 341,750 | Abuja | Click to Book |
Month | Date | Duration | Cost | Location | Make a Booking |
---|---|---|---|---|---|
June | 17th -19th | 3 Days | ₦ 204,750 | Abuja | Click to Book |
July | 8th-10th | 3 Days | ₦ 204,750 | Port Harcourt | Click to Book |
Microsoft Excel is an indispensable tool that has become an integral part of most business organizations across the globe. Excel is used for various purposes by different business establishments, from the micro to the large enterprises. No report is really complete without a few Excel based graphs or charts.
The course is to equip the participants with the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.
- Create pivot tables and charts
- Learn to trace precedents and dependents
- Convert text and validate and consolidate data
- Collaborate with others by protecting worksheets and workbooks
- Create, use, edit, and manage macros
- Import and export data
WORKING WITH FUNCTIONS
- Using the Paste Function tool
- Absolute and relative cell references
- Using range names in functions
- Creating nested functions
- Logical functions (SUMIF, COUNTIF)
- The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
- Financial functions (PMT, NPV)
WORKING WITH DATA
- Using Excel as a database
- Sorting Data
- Custom sorts
- Filtering using AutoFilter
- The Advanced Filter tool
- Database functions
- Using the Data Form to enter data
- Creating subtotals
WORKING WITH EXTERNAL DATA
- Data consolidation
- Linking to another workbook
- Linking to an external database
- Getting data from the web
CHARTING WITH EXCEL
- Selecting the data to chart
- Creating a chart
- Choosing the right chart for the job
- Moving and re-sizing charts
- Customizing charts
- Saving and copying a chart’s design
TABLES
- Creating an Excel table
- Table formatting
- Adding rows and columns
- Automatic calculation in tables
COLLABORATION TOOLS
- Protecting a workbook
- Protecting worksheets and cells
- Adding comments to cells
- Sharing workbooks
- Tracking changes
AUDITING WORKBOOKS
- Viewing formulas
- Tracing precedents and dependents
- Error checking
- Management Trainee
- Specialist Staff
- Managers
- Course Overview
-
Microsoft Excel is an indispensable tool that has become an integral part of most business organizations across the globe. Excel is used for various purposes by different business establishments, from the micro to the large enterprises. No report is really complete without a few Excel based graphs or charts.
The course is to equip the participants with the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.
- Learning Objectives
-
- Create pivot tables and charts
- Learn to trace precedents and dependents
- Convert text and validate and consolidate data
- Collaborate with others by protecting worksheets and workbooks
- Create, use, edit, and manage macros
- Import and export data
- Program Outline
-
WORKING WITH FUNCTIONS
- Using the Paste Function tool
- Absolute and relative cell references
- Using range names in functions
- Creating nested functions
- Logical functions (SUMIF, COUNTIF)
- The IF function and nested Ifs using AND and OR conditions Using VLOOKUP
- Financial functions (PMT, NPV)
WORKING WITH DATA
- Using Excel as a database
- Sorting Data
- Custom sorts
- Filtering using AutoFilter
- The Advanced Filter tool
- Database functions
- Using the Data Form to enter data
- Creating subtotals
WORKING WITH EXTERNAL DATA
- Data consolidation
- Linking to another workbook
- Linking to an external database
- Getting data from the web
CHARTING WITH EXCEL
- Selecting the data to chart
- Creating a chart
- Choosing the right chart for the job
- Moving and re-sizing charts
- Customizing charts
- Saving and copying a chart’s design
TABLES
- Creating an Excel table
- Table formatting
- Adding rows and columns
- Automatic calculation in tables
COLLABORATION TOOLS
- Protecting a workbook
- Protecting worksheets and cells
- Adding comments to cells
- Sharing workbooks
- Tracking changes
AUDITING WORKBOOKS
- Viewing formulas
- Tracing precedents and dependents
- Error checking
- Target Audience
-
- Management Trainee
- Specialist Staff
- Managers