Skills Bank Excel Master - Advanced Level Skills Bank
السعر: 850 جنيه مصري

تفاصيل الدورة

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

تحديث بتاريخ 24 June, 2019

المتطلبات

Anyone Working in Excel in his daily life 

وظائف مناسبة لهذه الدورة

المالية , Accoutant , HR Assistant

نبذة عن معهد 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

What we do?
Provide practical learning and solutions that address actual needs of individuals who seek to develop and thrive in their careers. Our training courses, workshops & Public sessions are customized according to the needs of employees and corporates according to their work environment, corporate culture and position levels so as to get the best result of training targets.

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

استفسر عن هذه الدورة

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

قيِم هذه الصفحة