ADVANCED EXCEL TRAINING
ADVANCED EXCEL TRAININGToday 10.07.2021, CSI conducts 5 days of training of Advanced Excel Training model for the Admin & Finance Departments, and Data analyses Team from Somaliland MDAs.
This model sets out advanced skills that can be used to produce sophisticated reports, perform complex mathematical and statistical calculations, and improve productivity using spreadsheet applications.
The overall training aim is
• To apply advanced formatting options such as conditional formatting and customized number formatting and handle worksheet.
• Use functions such as those associated with logical statistics financial and mathematical operations
• Create charts and apply advanced charts formatting. Work with labels and lists to analyze, filter, and sort data, create and use scenarios.
• Validate and audit spreadsheet data and enhance productivity by working with named cell ranges and macros.
• Use linking, embedding, and importing features to integrate data, and compare and merge spreadsheets, and apply spreadsheet security features.
