EXCEL TECHNIQUES
Held in cooperation with Intuition, this course will provide you with the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.
Content
- Excel Menus & Shortcuts
- Excel Formulas & Calculation Functions
- Naming Cells & Referencing Names
- Editing Cell Names
- Formatting Cells & Worksheets
- Pivot Tables
- Lookup Functions
- Conditional Statements
- Conditional Formatting
- Conditional Statements in Excel & Exercises
- Data Validation
- Data Table
- Combo Box Controls for Dashboards
- Goal Seek & Scenario Manager
Who is the course for?
All bankers who seek to enhance their knowledge in Excel.
Duration
2 hours
*The e-learning program is non-refundable once an account is created.
One Month License
EGP 550
Three Month License
EGP 650
Six Month License
EGP 850