Advanced excel training
from 25th sept to 27th sept 2016. At bagamoyo, Municipal hall.
TOPICS COVERED
- EFFECTIVE SPREAD SHEET DESIGN
- MANAGING CELL RANGE, NAME, DATE AND TIME
- DATA VALIDATION
- LOGIC FUNCTION, IF FUNCTION
- CONDITIONAL FORMAT
- ADVANCE FILTER
- SUBTOTAL
- VLOOKUP
- DATABASE FUNCTION
- AUDITING ERROR CHECKING
- PIVOT TABLE
- FINANCIAL REPORTING: ADVANCE D CHART AND GRAPH
- FORECASTING AND BUDGETING: MOVING AVERAGES AND TREND ANALYSIS
- WHAT IF ANALYSIS (GOAL SEEK, SOLVER, AND SCENARIOS)
- LINKING AND CONSOLIDATING
