Details
This course is fundamentally designed to improve participants’ skills and knowledge in Microsoft excel. The course will equip participants with the essential skills to boost their productivity, improve data accuracy, and make informed decisions using Excel’s advanced features and functionalities.
The participants will gain a comprehensive understanding of intermediate-level Excel functions and techniques. They will learn how to efficiently manage and manipulate data, perform complex calculations, and create professional-looking spreadsheets.
This course is designed for individuals who have a basic understanding of Excel and want to enhance their proficiency in data analysis, formula building, and data visualization.
Outline
Course Outline
Day 1: Advanced Formulas and Functions
- Review of basic Excel functions and formulas
- Working with logical functions (IF, AND, OR)
- Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Applying text functions (LEFT, RIGHT, MID, CONCATENATE)
- Introduction to array formulas
Day 2: Data Analysis and Manipulation
- Sorting and filtering data
- Using advanced data validation techniques
- Applying conditional formatting
- Working with data tables and what-if analysis
- Introduction to PivotTables and PivotCharts
Day 3: Working with Advanced Functions
- Working with date and time functions
- Utilizing statistical functions (AVERAGE, COUNT, MAX, MIN)
- Performing mathematical calculations (SUMPRODUCT, ROUND, ABS)
- Using financial functions (NPV, IRR, PMT)
- Customizing and creating user-defined functions (UDFs)
Day 4: Data Visualization and Reporting
- Creating dynamic charts and graphs
- Customizing chart elements and formatting options
- Building interactive dashboards
- Utilizing slicers and timelines
- Generating reports with data visualization techniques
Day 5: Advanced Data Management Techniques
- Working with tables and structured references
- Using data validation and conditional logic
- Advanced filtering techniques
- Data consolidation and linking
- Automating tasks with macros
Special Offer
Schedules
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
No. of Days: | 5 |
Total Hours: | 40 |
Perk Group Africa is a capacity development, and consultancy center, a leading destination for organizations, groups, and individuals seeking to advance their skills in the many domains within our scope.
Our expertise includes Socio-economic Research, training, and consultancies on Spatial technologies, Climate change (Environmental Sustainability), Gender Inclusivity, Data Management and Statistics, Project Cycle Management, Enterprise Development, Governance, Organizational Development, and Personal Productivity.
PGA has a tradition of work excellence, we are privileged to have a pool of highly experienced and motivated consultants, all of whom are recognized as industry leaders in their respective fields.
Our aim is to ensure that our services contribute to the public good through sharing knowledge for the benefit of society.