MENU & TOOLS IN EXCEL
- Title bar & Menu Bar
- Standard Toolbar
- Formatting toolbar
- Status Toolbar
- Workbook and worksheets, Columns and rows
- Name box
- Formula Bar
TABLES & CHARTS
- Creating tables (Basic)
- Creating charts (Column, Bar, Pie & Line)
BASIC FORMULAS
- SUM/SUMIF
- COUNT/COUNTA/COUNTIF
- AVERAGE/AVERAGEIF
- IF/IFERROR
- MIN & MAX
- TRIM & PROPER
- CONCATENATE
- RIGHT & LEFT
- DATE & DAYS
- AND & OR
DURATION: 1 Hour (40minutes theory & 20 minutes practice)
Remarks:
- Booking is required 1 week before the preferred date
- Weekends Only
- At the end of the session, you will receive 2 excel workbooks (the training notes and exercises for your practice).