Advanced Excel / R 17 / Nasr City
Schedule
Fri May 10 2024 at 03:00 pm to 08:00 pm
Location
HR Passport | Cairo, QH
Advertisement
Workshop outline:Course basic .advanced and data analysis.
- Introduction and basic definition
- How to use cells
- How to create password or mark as final
- Speared sheet design and documentation
- Basic formulas and function ( sum – max – min – average – count – count a – count blank …..)
- Relative and absolute reference
- How to use to quick access ( add or remove)
- Serial concept explanation
- Insert or delete cells , rows and columns
- How to print ( print titles , print area , orientation ….)
- Create table and design
- Conditional formatting
- How to use flash fill
- How to use text to column
- Protect sheet
- Protect work book
- Freeze row or column
- Sort and filter
- Find and replace
- Wrap text and merge
- Data validation
- Simple if
- Remove duplicate
- Nested if
- And , OR function
- IF And , IF OR function
- Text function ( Mid , LEFT , RIGHT , UPPER , LOWER ,PROPER ,……)
- hyper link
- Round function ( M round , Round ,Round up ,Round Down )
- V look up Function
- H look up Function
- Match Function
- Index Function
- If error Function
- Concatenate function
- Date Function
- Time function
- Is even function
- Is odd function
- Abs function
- Sum if , sum ifs , count if , count ifs
- Create pivot table
- Pivot table calculate
- Format number
- Format charts
- Using slicer
- Type charts
- How to make simple Dashboard
Targeted audiences:
Payroll, Personnel, Accountant, Recruitment specialist, Supervisor, Section head, Manager
HR Supervisor, Section head, Manager, Director
Total Duration: ( 20 Hours )
Event schedule:
Each Friday as of 10/5/2024 for 4 times
From 03:00 PM till 08:00 PM
Payment :
__________
Vodafone Cash: 01008811056
Bank transfer: CIB Bank 100043505895 - Ahly Bank 0203011024929401010
Address:
العنوان:- ٧ شارع محمد حسن الجمل اول عباس العقاد ناصية البنك الاهلي - الدور الخامس
Location?
https://maps.app.goo.gl/VoCBLXuM5ZLgbPxx8
For more information please call : 01555089963
Regards,
HRP
Advertisement
Where is it happening?
HR Passport, 7 شارع محمد حسن الجمل, القاهرة, القاهرة, مصر,Cairo, EgyptEvent Location & Nearby Stays:
