Skills Bank Excel Master - Advanced Level Skills Bank
Price: EGP 850

Course details

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

Updated on 24 June, 2019

Eligibility / Requirements

Anyone Working in Excel in his daily life 

Job roles this course is suitable for:

Finance , Accoutant , HR Assistant

About Skills Bank

" SHAPING THE LEARNING EXPERIENCE "

Skills Bank is a professional training & coaching company with an objective of shaping the learning experience for both individuals & corporates in Egypt and 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

                                                                                                                                  

See all Skills Bank courses

Enquire about this course

You may add more courses here,
your list will be saved.

Rate this page