Course Code:
exim
Duration:
7 hours
Prerequisites:
Knowledge of Windows and the basics of Ms Excel
Overview:
Course participants will be able to organize and process data in spreadsheets and information from external data sources. They will be able to create pivot charts and use pivot tables. They will acquire the ability to create and perform advanced operations on formulas.
Course Outline:
Excel Intermediate
- Applying Conditional Formatting and Filtering
- Data manipulation, (sorting data and filtering)
- Using Formulas such as SUM, COUNT, IF, AND, TRIM, CONCATENATE, LOOKUP functions
- Creating and manage PivotTables
- Analyzing data using PivotTables (percentage of total, percentage of aggregated group, etc)
- Visualization data with PivotChart
- Filtering data using Slicers
- Password Protection full sheet or specific cells.