Details
In today’s modern businesses, there is hardly anything as luck. What is more realistic is the ability to make accurate financial and business decisions at the right time.
Excel is the most widely used spreadsheet application by professionals in accounting, audit, IT, engineering and other fields for analysis and manipulation using various tools relative to their areas of specialization . Hence, we present some tools in Microsoft Excel that could enhance business decision
Date : April 6, 13 (two Saturdays only)
Training Course Duration: 9:00 am – 4 : 30 pm
Venue: Phiret Training Hall
No 1 Adegbeyemi Street, Off Allen Avenue, Alade Bus-Stop Ikeja
Fess: 25,000
Early bird Registration:
20,000 for payment made on or before 1st April 2019
TRAINING OBJECTIVE
This course advances the user,s knowledge of function, demonstrate how to manage data with Excel and explores how Excel is used to present data using tables and charts
Training 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 COUNTIFS,AVERAGEIF)
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
Linking to another workbook
Linking to an external database
Data consolidation
- 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
- 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