General audience working for services and manufacture companies.

DEVELOPING COMPETENCIES

Goals Orientation, Continuous Improvement, Critical Capability.

By the end of the course the participant will be able to apply the Excel tools properly.

I. PERSONALIZED FORMA

II. CELLS FILL UP

III. CHARTS

IV. CONDITIONAL FORMAT

V. DATA ENTRY VALIDATION

A. Creating Validation

B. Adding Informative Notes for the Entry

C. Adding Personalized Notes for Entry Errors

VI. FORMULA AND FUNCTIONS

A. Difference between Formula and Function

B. Functions Application

C. Logical (IF) Functions

D. Nested IF

E. Search Functions

F. Search v

G. Search h

H. Data Base

VII. CONVERTING A TEXT INTO COLUMNS

VIII. ORDERING INFORMATION

A. Ordering Information Ascendingly or Downwardly:

B. Alphabetically

C. Numerically

D. Chronologically

IX. FILTERING INFORMATION

A. Auto Filter

B. Advanced Filter

X. CREATING AND REMOVING SUB TOTALS

XI. GRAPHICS

A. Most Common Graphics

B. Bar Graphics

C. Countershaft

D. Menu and Graphics Tools

XII. APPLYING: ENTRIES, REMOVALS, CHANGES AND COLUMNS THROUGH THE APPLICATION FORM IN A DATA LIST (CHART)

XIII. SECURITY

A. Workbooks and Files Protection

B. Hiding and Showing Workbooks

C. Protecting and Unprotecting Worksheets

D. Hiding and Showing Worksheets

E. Blocking and Unblocking Graphics’ Objects

F. Security for Worksheets

G. Blocking and Unblocking Worksheets

H. Hiding and Showing Formulas

XIV. LISTS

A. Creating a Lists

B. Removing a List

C. Linking a Function Lists

D. Applying Totals to a List

XVI. HYPERLINKS

A. Creating a Hyperlink

B. Creating Hyperlinks from Texts

C. Creating Hyperlinks from Pictures

D. Removing Hyperlinks

E. Using Hyperlinks

XVII. CONSOLIDATING INFORMATION

A. Working with multiple Workbooks

XVIII. OBTAINING EXTERNAL DATA

A. From Text

B. From the Net

C. Access

D. ODBC

XIX. ANALYSIS AND IF

A. Objective Searching

B. Scenarios

C. Solving

XX. DYNAMICS CHARTS AND GRAPHICS

A. Design Area, Row, Column, Page and Data

B. Creating a Dynamic Chart

C. Format

D. Filters

E. Computed Fields

F. Creating Dynamic Graphics

G. Computed Elements Fields

H. Segmentation

I. Moving a Dynamic Chart

XXI. MACROS

A. What a MACRO is?

B. Macros Recorder

C. Ways to Executing Macro

D. Creating a Personalized Function

E. Automating a Report

F. Creating an App with Macros

• A diagnosis test will be applied to measure the audience knowledge.
• A guide will be given
• The course includes practices for each subject.
• A test will be applied at the end of the course.