برنامج إكسل – المستوى المتقدم

المدرب: مفيد سمارة

Program Introduction

Microsoft Excel is one of the most essential tools used across industries for data analysis, reporting, and decision-making. This advanced-level training program is designed to empower participants with comprehensive skills in using Excel’s advanced features, enabling them to create dynamic reports, analyze complex data sets, and automate tasks efficiently and professionally.

Target Audience

This program is intended for:

Employees  who use Excel in their daily tasks.

Data analysts, finance, and administrative staff.

Individuals with a basic knowledge of Excel looking to advance to expert-level capabilities.

 

Program Goal

To enhance participants’ proficiency in utilizing advanced Excel features for professional data management, analysis, and reporting.

General Objectives

By the end of this program, participants will be able to:

Apply conditional formatting and data validation rules.

Use advanced logical, financial, and date functions.

Create and manipulate PivotTables, PivotCharts, and interactive dashboards with Slicers.

Analyze data using data tables and advanced charting techniques.

Import and export data from external sources.

Record and edit macros to automate repetitive tasks.

Secure workbooks and manage user permissions effectively.

 

Program Content :

Day 1: Advanced Data Management and Functions

Quick Review: Excel interface and essentials

Data formatting and cell styles

Conditional formatting and rules manager

Data validation and dropdown lists

Named ranges and referencing

Logical functions: IF, AND, OR

Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH

Date and time functions: TODAY, NOW, NETWORKDAYS, WORKDAYS, etc.

Financial functions: PMT, PV, FV, NPER, IPMT, PPMT

 

Day 2: Data Analysis and Advanced Reporting

Creating PivotTables and using the PivotTable Fields pane

Summarizing data and using “Show Values As”

Interactive dashboards with Slicers

Creating and customizing PivotCharts

Data tables for scenario analysis (one- and two-variable data tables)

Advanced charting:

Custom chart creation

Combination charts (line + column)

Secondary axis usage

Scatter and mixed graphs

 

Day 3: Integration, Automation, and Data Protection

Importing and exporting data:

Delimited text files

External data sources

Creating web queries to pull data from the internet

Macros and VBA:

Recording macros

Macro security settings

Copying between workbooks

Workbook and worksheet protection:

Protecting sheets and workbooks

Encrypting files with passwords

Sharing workbooks and defining editable ranges

 

Training Methodology

Hands-on exercises using Excel

Live demonstrations and walkthroughs

Real-world examples and case-based discussions

Training files and advanced practice scenarios

 

عدد ساعات : 21ساعة

مكان الانعقاد : المعهد المصرفي الفلسطيني – رام الله