- الموقع: Cairo Governorate - القاهرة
- مدة الدورة التدريبية: 2 يوم
- تاريخ البدء: استفسر
- مواعيد الدورة: استفسار
تفاصيل الدورة
Learning Outcome:
- Mastering Excel most important functions
- Analyzing Data and Alternative data sets
- Apply the key Excel functions to prepare data for analysis
- Apply advanced calculations
- Create and customize pivot tables to reconcile and analyze accounts efficiently
- Utilize pivot tables functions and calculations to generate a set of management and business analysis reports
- Creating Advanced charts and graphics
- Changing workbook Appearance
Workshop Content:
Advanced Calculations on Data
- Creating Formulas to calculate value with functions (CountIf, SumIf, HLookup, VLookup, Aggregate, Concatenate)
- Performing Advanced Date & Time Calculations.
Advanced Format Tools
- Creating workbook from Template
- Add Header, Footer, and Setup Pages
- Naming group of data
- Advanced formatting cells
- Advanced page setup
- Conditional Formatting
- Linking to office documents from a workbook
- Creating Advanced Chart and Sparkline’s
- Protect workbook and worksheet with Password
Analysis Tools
- Conditional Formatting
- Using Data Validation to create a drop-down list
- Filtering and sorting in table with Slicers
- Finding and correcting an error
- Using watch window tool
Reporting Tools
- Analyze data by Pivot table and Pivot chart
- Using function (Getpivotdata)
- Using Consolidate tool
- Key functions to prepare data for pivot table reporting
- Creating and customising pivot tables
- Performing calculations within pivot tables
المتطلبات
Anyone Working in Excel in his daily life
نبذة عن معهد Skills Bank
Skills Bank is a Training sessions and career coaching provider with an objective to shape the learning experience for people in Egypt & Middle East
Through our career Coaching & Planning programs we will help you determine your career dream, and how to reach it and the skills needs to achieve it..
Our services:
- Soft Skills Workshops
- Business Workshops
- Human Resources Workshops
- Tailored Workshops
- Career Coaching
- Public events
عرض الجميع دورات Skills Bank
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.