مصر : ‎‪00201092743310‬​ الإمارات: 00971569110433

قائمة دروس الأوفيس

WORD
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
WHAT IS IT & GOOLS
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE

GETTING STARTED
KEYBOARD
ARABIC-ENGLISH
NAVIGATION
SELECTION
EDITING
TWO MODES
UNDO-REDO
SPEECH

COPY & PASTE
COPY
CUT
HYBERLINK
HYBERLINK-DREAMWEAVER

VIEWS TYPES
INTRO FOR VIEWING
DOC MAP
PRINT LAYOUT
NORMAL
WEB LAYOUT
READING LAYOUT
THUMBNAILS
OUTLINING 1
OUTLINING 2
OUTLINING 3

ZOOMING
ZOOM
FULL SCREEN

FIND & REPLACE
FIND
REPLACE
GO TO

TEXT FORMATING
FONTS
COLOR-UNDERLINE
EFFECTS
EFFECTS PHOTOSHOP
CHAR-SPACING
TEXT EFFECTS
DEFAULT
CLEAR FORMAT – CONTENT

PARAGRAPH FORMATING
GENERAL
GENERAL -ENGLISH
ALIGNMENT
INDE-1
INDE-2-ENGLISH
INDE-3-FIRST+HANGING
SPACING

TAB TYPES
TAB DEFINITION
BASIC SETTING
ACCURATE & DEFAULT TABS
TABS TYPES
TAB LEADER

BULLETS & NUMBERING
BULLUTS DEFNITION
BULLUTS & NUMBERED
COSTOMIZE
COSTOMIZE 2

BORDERS & SHADING
BORDERS
OPTIONS FOR TEXT SPACING
HOR LINE
SHADING

COLOMNS
COLOMN
DELETE COLOMN

DROPING & BACKGROUND
DROP CAP
CHANGE CASE
BACK
FILL EFFECT – GRADIANT
FILL EFFECT -TEXTURE
FILL EFFECT – PATTERN-PIC
WATER 1
WATER 2

WORKING WITH TABLES
SPLIT
SPLIT TABLE
AUTO FORMAT
AUTO FORMAT CATEGORY
DELETE – DEFAULT
HEADING REPEAT
CONVERT TABLE TO TEXT
CONVERT TABLE TO TEXT CONVERT NESTED TABLES
CONVERT TEXT TO TABLES
TABLE DEF.
TABLE CREATION
SORT
FORMULA BASIC
ABS
AVARAGE
COUNT
INT
MIN-MAX
PRODUCT
SIGN
HIDE GRIDLINES
TABLE PROPERTIES – TABLE
TABLE PROPERTIES – TABLE-OPTION
TABLE PROPERTIES – TABLE- BORDERS SHADING
TABLE PROPERTIES – ROW
TABLE PROPERTIES – COL
TABLE PROPERTIES – CELL
TEXT DIRECTION
DRAW TABLES
WRITING – NAVIGATION
DRAW TABLES 2
AUTO FIT
AUTO FIT 2
INSERT
DELETE
SELECT
MERGE

STYLES
STYLE OVERVIEW
STYLE – REVEAL FORMATTING
STYLE – REVEAL FORMATING – COMPARE
STYLE – THEMES
ORGNIZE STYLES
STYLE OVERVIEW-2
STYLE TYPES
STYLE – PARAGRAPH
STYLE – CHARACTER
STYLE – TABLE
STYLE – LIST
STYLE – MODIFY
STYLE – CLEAR FORMATING – DELETE

GRAPHICS & IMAGES
GRAPHIC OVERVIEW
DRAW BASIC SHAPES
NUDGE
ALIGN
DISTRIBUTE
ROTATE – FLIPING
AUTOSHAPE DEFAULTS – CHANGE AUTOSHAPE
ROUTE CONNECTORS
SHADOW STYLE
3D STYLE – 3D MAX
AUTOSHAPES
AUTOSHAPES – FORMAT AUTOSHAPE – ARROWS
AUTOSHAPES – EDIT PICTURES – EDIT POINTS
AUTOSHAPES – EDIT PICTURES – OPEN PATH
AUTOSHAPES – TEXT BOX – LINKS
AUTOSHAPES – TEXT BOX
AUTOSHAPES – WORD ART 1
AUTOSHAPES – WORD ART 2
AUTOSHAPES – WORD ART 3
GROUP
ORDER
GRID
CLIPART
CLIPART SOUNDS-MOVIES
FROM FILE
PICTURE TOOL BAR 1
FROM SCANNER
PICTURE TOOL BAR 2-LINE STYLE COMPRESSING
PICTURE TOOL BAR 3-TEXT WRAPPING
PICTURE TOOL BAR 5-TRANSPERNCY
BACK TO WORD
FORMAT PIC 1
FORMAT PIC 2
PHOTO SHOP START
PS-BRIGHTNESS-CONTRST
PS-FILL
PS-TEXT BLENDING OPTION
PS-TEXT BLENDING OPTION 2
PS-GRADIENT

WORKING WITH CHARTS
ORGNIZATION CHART
ORGNIZATION CHART 2
CYCLE DIAGRAM
RADIAL DIAGRAM
PYRAMID DIAGRAM
VENN – TARGET DIAGRAM
CHARTS OVERVIEW
CHARTS DATA
TYPES
OPTIONS
IMPORT XLS FILES
EXCEL CHART LINK

DRAWINGS & AUTOCAD
WORD & AUTOCAD
POINT-POLAR
POLAR-REL.
POINT-OSNAP
ZOOM REAL TIME
PAN REALTIME
LINE
MULTILINE
POLYLINE
POLYGON-I
POLYGON-C
INTERFACE
RECTANG-USUAL
ARC-3POINT
CIRCLE-RADIUS
DOUNT-FILLED
ELLIPSE-CENTER
ELLIPSE-AXIS
DIVIDE-USUAL
MEASURE-ALL
MIRROR
OFFSET
INTERACTIVE-PROGRAM
ARRAY-RECTANGLE
ARRAY-POLAR
MOVE
SCALE
TRIM
CHAMFER
FILLET
INSERT AUTOCAD DRAWING
COMMAND-OPTIONS
START-STRATIGY
TEXT WINDOW
POINT-DEF.
POINT-ABSOLUTE
POINT-RELATIVE

OBJECT INSERTING
DATE TIME
SYMBOLS – SPECIAL CHARACTERS
SYMBOLS – SYMBOLS
INSERT FILE
INSERT OBJECT 1
INSERT OBJECT 2 EDIT – CONVERT
INSET COMMENT

BREAKS & PRINTING
PAGE BREAK
PRINT PREVIEW
PRINT – RANGES
PRINT – PRINTERS-WHAT-OPTIONS
COL BREAK
TEXT WRABING BREAK
SECTION BREAK – TYPES
PAGE NUMBER 1
PAGE NUMBER 2 FORMATS
HEADER FOOTER 1
HEADER FOOTER 2
HEADER FOOTER FORMAT PAGE NO 3
HEADER FOOTER INSERT GRAPHIC – TABLES
HEADER FOOTER LINK TO PREVIOUS – NEXT
PAGE SETUP-MARGINE
PAGE SETUP-PAPER

HYBERLINKS
BOOKMARK
HYBERLINK 1 CURRENT FOLDER
HYBERLINK 2 BROWSED PAGES
HYBERLINK 3 PLACE IN DOC.
HYBERLINK 4 CREAT NEW
HYBERLINK 5 EMAIL – SCREEN TIP

SPELLING & CORRECTIONS
EDITING TEXT-1-SPEELING AND GRAMMER
EDITING TEXT-2-SPEELINGAND GRAMMER-ADD TO DIC
EDITING TEXT-3-SPEELINGAND GRAMMER-AUTOCORRECT
EDITING TEXT-4-SET LANGUAGE
EDITING TEXT-5-TRANSLATE
EDITING TEXT-6-THERURES
EDITING TEXT-7-RESEARCH
EDITING TEXT-8-AUTOTEXT
EDITING TEXT-9-1-AUTOTEXT NEW
EDITING TEXT-9-2-AUTOTEXT OPTIONS
EDITING TEXT-10-AUTOFORMAT
EDITING TEXT-11-AUTOFORMAT WITH REVIEW CHANGES
EDITING TEXT-12- AUTOCORRECT – REPLACE
EDITING TEXT-13- AUTOCORRECT – CELL CAPITLIZE
EDITING TEXT-14- AUTOCORRECT – CAPS LOCK
EDITING TEXT-15- AUTOFORMAT AS YOU TYPE

REFERENCES & CAPTIONS
FOOTNOOT-BOOTOM OF PAGE
FOOTNOOT-FORMAT
FOOTNOOT-BELOW TEXT
FOOTNOOT-DELETE
END NOOT
VIEW FOOTNOTE
CAPTION 1
CAPTION 2-AUTO CAPTION

WORKING WITH WINDOWS
NEW WINDOW – ARRANGE ALL 1
NEW WINDOW – ARRANGE ALL 2-FILES
SPLIT

TRACK CHANGES
TRACK CHANGES 1
TRACK CHANGES 2-ACCEPT REJECT
TRACK CHANGES 3-ACCEPT REJECT ALL
TRACK CHANGES 4-REVIEWING PANE
TRACK CHANGES 5-COMMENTS, DELETE
TRACK CHANGES 6-VIEW MARKUP

WORKING WITH DOCUMENTS
WORD COUNT
MERGE DOC
COMPARE DOC

WORKING WITH MACROS
MACRO DEF.
MACRO ASSIGNING
MACRO DELETE-EDIT
MACRO EDIT VB
MACRO – CREAT NEW DRAWING

CUSTOMIZATION
CUSTOMIZE-DEF.
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTON IMAGE, STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS
CUSTOMIZE- OPTIONS-KEYBOARD

GETTING HELP
HELP OVERVIEW
HELP -COURSE CONTENT

 

SPECIAL PASTING & LINKS
PASTE SPECIAL
PASTE LINK INSIDE WORD
PASTE LINK 1
PASTE LINK 2-LINKS
CLIPBOARD

ADVANCED SEARCH
ADVANCED FIND-MATCH CASE
GO TO – PAGE-SECTION-LINE
GO TO – COMMENT-BOOKMARK – ETC
FIND- WHOLE WORD
FIND- WILD 1
FIND- WILD ASTRIX
FIND- WILD -END-BIGIN
FIND- FORMAT
FIND- NO FORMAT
FIND- SPECIAL
REPLACE

WORKING WITH FILES
CLOSE-EXIT
SAVE AS
FILE SEARCH EXTENSION
FILE SEARCH -LOOKIN-FILE TYPE
VERSIONS
NEW
NEW -TEMPLATES
FILE DIALOG 1
FILE DIALOG -FOLDERS-FILES 2
FILE DIALOG – TOOLS-READONLY-REPAIR
OPEN
OPEN RECENT FILE
SAVE

WORKING WITH WEB
WEB-LAYOUT
WEB PAGE PREVIEW
SAVE AS WEB

DOCUMENT PROTECTIONS
PROTECT OPEN
PROTECT MODIFY

FORMS & MAIL MERGE
MAIL MERGE INTRODUCTION
DATA TYPES-AUTONUMBER
DATA TYPES-TEXT
DATA TYPES-MEMO-NUMBER-DATE
DATA TYPES-GENERAL -TEXT – CAPTION – DEFAULT VALUE
DATA TYPES – CURRNCY – YES NO
DATA TYPES – LOOKUP MY ENTERING
DATA TYPES – HYBERLINK
DATA TYPES – OLE
DATA TYPES-GENERAL -TEXT-SIZE
DATA TYPES-GENERAL -TEXT – FORMAT
SELECT SOURCE DATA
DATA TYPES-GENERAL -TEXT – INPUTMASK
DATA TYPES-GENERAL -TEXT – INPUTMASK 2
DATABASES IN EXCEL
INTRODUCTION TO DATA
SORT
AUTOFILTER
AUTOFILTER CUSTOM
FORM 2-CRITERIA
AUTOFILTER CUSTOM STRINGS
ADVANCED FILTER
PLACE YOUR DATA
ADVANCED FILTER -MORE CRITERIAS
ADVANCED FILTER -MORE CRITERIAS 2
FORM 1
EXCEL PRACTICE
WORD DATA BASE
SORT DATA
FILTER DATA
ENVELOPS
LABELS
DIRECTORY
PREVIEW DATA
COMPLETE MERGE
CREAT DATA BASES
ACCESS FIELD & RECORDS
CREAT TABLES-DESIGN VIEW
CREAT TABLES-ENTERING DATA

DATABASE INTEGRATION
WORD & DATABASE INTRO
INSERT DATABASE
QUIRY OPTIONS
SORTING
ADD & DELETE RECORDS
MANAGE FIELDS
DATAFORM INTRO
EXCEL DATAFORM
PRACTICE DATAFORM

VISUAL BASIC
VBA-ALL
VBA_OVERVIEW
OBJECTS
PROPERTIES
METHODS
EVENTS
PROCEDURES_FUNCTIONS
VARIABLES
CONSTANT
DECLEAR
VBADE
PROPERTIES WINDOWS
WINDOW CODE
PROJECT EXPLORER
COMBOBOX 1
COMBOBOX 2
COMBOBOX 3
LABEL EVENTS1
LABEL EVENTS2
LABEL PROPERTIES
PICTURE EVENTS1
PICTURE PROPERTIES1
PICTURE PROPERTIES2
TABPAGE CONTROL 1
TABPAGE CONTROL 2
OPTION GROUP
EXAMPLE 01 SHOW MESSAGE
INTRO FOR EXAMPLES
EXAMPLE 01 SHOW MESSAGE
EXAMPLE 02 NEW DOCUMENTS

 

POWER POINT
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

SLIDE DEFINITION
SLIDE DEF.
ZOOM
VIEW WAYS
VIEW WAYS FROM DOWN
RULER
STATUS BAR
SLIDE & OUTLINE PANES
SLIDE & OUTLINE PANES RIGHT – LEFT

GETTING STARTED
START FROM SCRATCH – NEW BLANK
INSERT NEW SLIDE
DUPLICATE SLIDE

DO & UNDO
UNDO & REDO

COPY & CUT
COPY & PASTE
CUT & PASTE

WRITING & FORMATTING
KEYBOARD 1
KEYBOARD 2
KEYBOARD 3
REPLACE
TEXT BOX -WRITING RULES 1
TEXT BOX -WRITING RULES 2
TEXT BOX -WRITING RULES 3
NAVIGATION
SELECTION 1
SELECTION 2
SELECTION 3
FONTS 1
FONTS 2
FONTS 3
TEXT EFFECTS 1
TEXT EFFECTS 2
TEXT EFFECTS 3
REPLACE FONTS
FIND 1-MATCH CASE – WHOLE WORD

BULLETS & PARAGRAPH
BULLETS – NUM 1
BULLETS – NUM 2
BULLETS – NUM 3
CUSTOMIZE – COLOR FOR BULLETS
ALIGNMENT
TAXT DIRECTION
LINE SPACING
CHANGE CASE 1
CHANGE CASE 2
CHANGE CASE 3

SLIDE DESIGN & LAYOUT
SLIDE DESIGN
SLIDE LAYOUT
BACKGROUND 1
BACKGROUND FILL EFFECT 2
BACKGROUND FILL EFFECT 3
BACKGROUND FILL EFFECT 4
BACKGROUND FILL EFFECT 5
PRACTISE
COLOR SCHEME
MAKE NEW COLOR SCHEME

MASTER SLIDE
SLIDE MASTER
SLIDE MASTER 2
NOTES MASTER

GRAPHICS & IMAGES
CLIPART 1
CLIPART 2
CLIPART 3
GROUP 1
GROUP 2
GROUP 3
ORDER 1
ORDER 2
ORDER 3
GRID 1
GRID 2
GRID 3
NUDGE 1
NUDGE 2
NUDGE 3
ALIGN DIST 1
ALIGN DIST 2
ALIGN DIST 3
ROTATE 1
ROTATE 2
ROTATE 3
REROUTE CONNECTORS 1
REROUTE CONNECTORS 2
EDIT POINTS 1
EDIT POINTS 2
EDIT POINTS 3
CHANGE AUTOSHAPE – DEFAULT 1
CHANGE AUTOSHAPE – DEFAULT 2
CHANGE AUTOSHAPE – DEFAULT 3
SHADOW 1
SHADOW 2
SHADOW 3
CLIPART -ANIMATION 1
CLIPART -ANIMATION 2
CLIPART -ANIMATION 3
3D 1
3D 2
3D 3
ORGNIZATION 1
ORGNIZATION 2
ORGNIZATION 3
FORMAT ORGNIZATION 1
FORMAT ORGNIZATION 2
FORMAT ORGNIZATION 3
CYCLE 1
CYCLE 2
CYCLE 3
RADIAL 1
RADIAL 2
RADIAL 3
PYRAMID 1
PYRAMID 2
PYRAMID 3
VENN 1
VENN 2
VENN 3
TARGET 1
TARGET 2
TARGET 3
VIEW COLOR-GRAY -WHITE
DUPLICATE – DELETE SLIDE – CLEAR – SELLECT ALL
FROM FILE 1
FROM FILE 2
FROM FILE 3
NEW PHOTO ALBUM
PHOTO ALBUM LAYOUT 1
PHOTO ALBUM LAYOUT 2
PIC TOOLBAR 1
PIC TOOLBAR 2
PIC TOOLBAR 3
PIC TOOLBAR -LINE STYLE – COMP 1
PIC TOOLBAR -LINE STYLE – COMP 2
PIC TOOLBAR -LINE STYLE – COMP 3
PIC TOOLBAR -TRANSPERANCY 1
PIC TOOLBAR -TRANSPERANCY 2
PIC TOOLBAR -TRANSPERANCY 3
PIC TOOLBAR – RECOLOR PIC OR CLIP ART
FORMAT PIC 1
FORMAT PIC 2
FORMAT PIC 3
FORMAT PIC 1
FORMAT PIC 2
FORMAT PIC 3
FORMAT TEXT BOX
DRAW BASIC SHAPES 1
DRAW BASIC SHAPES 2
DRAW BASIC SHAPES 3
AUTOSHAPES 1
AUTOSHAPES 2
AUTOSHAPES 3
FORMAT AUTOSHAPES (ARROW) 2
FORMAT AUTOSHAPES (ARROW) 3
FORMAT AUTOSHAPES 1
SAVE AS PIC
WORD ART 1
WORD ART 2
WORD ART 3
WORD ART 1
WORD ART 2
WORD ART 3
WORD ART 1
WORD ART 2
WORD ART 3

DRAWINGS & AUTOCAD
POWERPOINT & AUTOCAD
POINT-POLAR
POLAR-REL.
POINT-OSNAP
ZOOM REAL TIME
PAN REALTIME
LINE
MULTILINE
POLYLINE
POLYGON-I
POLYGON-C
INTERFACE
RECTANG-USUAL
ARC-3POINT
CIRCLE-RADIUS
DOUNT-FILLED
ELLIPSE-CENTER
ELLIPSE-AXIS
DIVIDE-USUAL
MEASURE-ALL
MIRROR
OFFSET
INTERACTIVE-PROGRAM
ARRAY-RECTANGLE
ARRAY-POLAR
MOVE
SCALE
TRIM
CHAMFER
FILLET
INSERT NEW AUTOCAD
INSERT AUTOCAD FILE
COMMAND-OPTIONS
START-STRATIGY
TEXT WINDOW
POINT-DEF.
POINT-ABSOLUTE
POINT-RELATIVE

WORKING WITH TABLES
INSERT TABLE -INSERT COL ROW 1
INSERT TABLE -INSERT COL ROW 2
INSERT TABLE -INSERT COL ROW 3
DRAW-ERASER 1
DRAW-ERASER 2
DRAW-ERASER 3
DELETE
MERGE 1
MERGE 2
MERGE 3
SPLIT
BORDER FILL 1
BORDER FILL 2
BORDER FILL 3
TEXT BOX IN TABLES
SELECT
TABLE DIRECTION
DISTRIBUTE

SPELLING & CORRECTIONS
EDITING TEXT-1-SPELLING 1
EDITING TEXT-2-SPELLING 1
EDITING TEXT-3-SPELLING ADD TO DIC 1
EDITING TEXT-4-SPELLING ADD TO DIC 1
EDITING TEXT-5-SPELLING PRACTICE
EDITING TEXT-6-THESARUS
EDITING TEXT-7-THESARUS
EDITING TEXT-8-RESEARCH
EDITING TEXT-9-RESEARCH
EDITING TEXT-10-LANGUAGE
EDITING TEXT-11-LANGUAGE
EDITING TEXT-12- AUTOCORRECT & AUTOFORMAT AS
EDITING TEXT-13- AUTOCORRECT – REPLACE
EDITING TEXT-14- AUTOCORRECT – CELL CAPITLIZE
EDITING TEXT-15- AUTOCORRECT – CAPS LOCK
EDITING TEXT-16- AUTOFORMAT AS YOU TYPE

OBJECT INSERTING
SLIDE NUM
DATE TIME
HEADER FOOTER
PRACTISE
SYMBOLS 1
SYMBOLS 2
SYMBOLS 3
OBJECT 1
OBJECT 2
OBJECT 3
EDIT OBJECT 1
EDIT OBJECT 2
EDIT OBJECT 3
SLIDES FROM FILE
COMMENTS – VIEW MURKUP

CHARTS INSERTING
CHART OVER 1
CHART OVER 2
CHART OVER 3
CHARTS DATA 1
CHARTS DATA 2
CHARTS DATA 3
TYPES 1
TYPES 2
TYPES 3
OPTIONS 1
OPTIONS 2
OPTIONS 3
IMPORT XLS FILES 1
IMPORT XLS FILES 2
EXCEL CHART LINK 1
EXCEL CHART LINK 2
EXCEL CHART LINK 3
PRACTICE EXCEL PASTE LINK

HYBERLINKS
HYBARLINK DEF.
HYBARLINK CURRENT FOLDER 1
HYBARLINK CURRENT FOLDER 2
HYBARLINK CURRENT FOLDER 3
HYBARLINK BROWSED PAGES 1
HYBARLINK BROWSED PAGES 2
HYBARLINK BROWSED PAGES 3
HYBARLINK CREAT NEW 1
HYBARLINK CREAT NEW 2
HYBARLINK CREAT NEW 3
HYBARLINK EMAIL 1
HYBARLINK EMAIL 2
HYBARLINK EMAIL 3
HYBARLINK SCREEN TIP
PASTE AS HYBARLINK
REMOVE HYBARLINK

MULTIMEDIA & FLASH
MOVIES & CLIP ART
FRAME BY FRAME
BASIC TWEENING
MORPH SHAPES
MORPHING
EASE TWEENING
SHAPE HINTS
HIDE HINTS
ANIMATED LIGHT
STROKE ANIMATION
MOTION TWEEN
MOVIES & FILES
EASE & SCALE
PATH MOTION
MOTION ERROR
ALL TOGETHER
DISTRIBUTING OBJECTS
LAYER & ANIMATIONS
ALPHA EFFECT
TINT EFFECT
BRIGHTNESS EFFECT
MASKED ANIMATION
FLASH MOVIES
DYNAMIC ANIMATION
REVERSE
ADVANCED EFFECT
ONION SKINNING
SOUNDS & CLIP ART
SOUNDS & FILES
RECORD SOUNDS
PLAY CD AUDIO
LOOP & HIDING
FLASH ANIMATIONS
ANIMATION OVERVIEW
TWEENS & FRAMES
FRAME RATE

TRANSITION & ANIMATION
VIEW SHOW
HIDE SLIDE
SLIDE TRANSITION
SLIDE TRANSITION (INTERACTION)
ANIMATION SCHEMES
CUSTOM ANIMATION OVER
CUSTOM ANIMATION DETAIL
CUSTOM ANIMATION TIMING
CUSTOM ANIMATION TIMING 2
CUSTOM ANIMATION TIME LINE
CUSTOM ANIMATION MOTION PATHES
CUSTOM SHOWS

ACTION BUTTONS
ACTION BUTTONS – ALL BUTTONS
ACTION BUTTONS – ALL BUTTONS PRACTICE
ACTION BUTTONS – DIALOG -CLICK-OVER
ACTION BUTTONS – DIALOG – RUN-SOUND-HYBER
ACTION BUTTONS – OTHER BUTTONS
ACTION BUTTONS – BIGIN END BUTTONS
ACTION BUTTONS – BACK – NEXT BIGIN END BUTTONS

SLIDE TIMMING
SLIDE TIMING OVER
SLIDE TIMING TRANSETION AUTOMATIC AFTER
SLIDE TIMING REHEARSE TIMING
SLIDE TIMING REHEARSE TIMING 2
SLIDE TIMING RECORD NARRATION

WORKING WITH WINDOWS
SAME FILE
MORE FILES
CASCADE

SHOW SETUP
SHOW SETUP-SHOW SLIDE
SHOW SETUP-SHOW TYPES
SHOW SETUP-ADVANCE SLIDE
SHOW SETUP- LOOPING SHOW
SHOW SETUP- ANIMATION &NARRATION SHOW
SHOW SETUP- RESOLUTION

GETTING HELP
HELP OVER
CONTENTS

SPECIAL PASTING & LINKS
PASTE SPECIAL OVERVIEW
PASTE SPECIAL
PASTE LINK INSIDE WORD
PASTE LINK 1
PASTE LINK 2-LINKS
PRACTICE ON ALL
CLIPBOARD

WORKING WITH FILES
FILE OVERVIEW
SAVE
SAVE AS
SAVE PRACTICE
FILE SEARCH OVER
FILE SEARCH EXTENSION
FILE SEARCH -LOOKIN-FILE TYPE
FILE SEARCH – PRACTICE
COMPARE MERGE
FILE DIALOG 1
FILE DIALOG -FOLDERS-FILES 2
FILE DIALOG – TOOLS-READONLY-REPAIR
CLOSE-EXIT
NEW-AUTO CONTENT
NEW- TEMPLATE
NEW- EXISTING
OPEN
OPEN RECENT FILE
SAVE OVER

WORKING WITH MACROS
MACRO OVER
MACRO DEF.
MACRO ASSIGNING
MACRO DELETE-EDIT
MACRO EDIT VB
MACRO – CREAT NEW DRAWING
MACRO – PRACTICE

CUSTOMIZATION
CUSTOMIZE OVERVIEW – START
CUSTOMIZE- OPTIONS-KEYBOARD
PRACTICE
CUSTOMIZE-DEF.
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTON IMAGE, STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS

WORKING WITH WEB
WEB PAGE
WEB PAGE PREVIEW
PRACTISE PREVIEW
SAVE AS WEB
PRACTISE SAVE

PRINTING
PRINT-PAGE SETUP
PRINT- PRINT PREVIEW
PRINT- PRINT OPTIONS

VISUAL BASIC
VBA-ALL
VBA_OVERVIEW
OBJECTS
PROPERTIES
METHODS
EVENTS
PROCEDURES_FUNCTIONS
VARIABLES
CONSTANT
DECLEAR
VBADE
PROPERTIES WINDOWS
WINDOW CODE
PROJECT EXPLORER
COMBOBOX1
COMBOBOX2
COMBOBOX3
LABEL EVENTS1
LABEL EVENTS2
LABEL PROPERTIES
PICTURE EVENTS1
PICTURE PROPERTIES1
PICTURE PROPERTIES2
TABPAGE CONTROL 1
TABPAGE CONTROL 2
OPTION GROUP

 

EXCEL
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

SHEETS & WORK AREA
SHEET DEF.
WORKSHEET-WORKBOOK
CELL – RIGHT YO LEFT
INSERT -DELETE SHEET
SHEET RENAME
ZOOM
STATUS BAR
FORMULA BAR

GETTING STARTED
FROM SCRATCH – NEW BLANK
DIFFRENCE – NUM – FORMULA
NAMES DEFINE
NAMES CREAT

DO & UNDO
UNDO 1
UNDO 2
UNDO 3

COPY & CUT
COPY 1
COPY 2
COPY 3
CUT 1
CUT 2
CUT 3

WORKING WITH SHEETS
INSERT CELLS
INSERT ROWS
INSERT COL
INSERT WORKSHEET
DELETE WORKSHEET
MOVE OR COPY TO SAME WORKSHEET
MOVE OR COPY TO OTHER WORKSHEET
DELETE
TAB COLOR

FORMAT
FONTS 1
FONTS 2
FONTS 3
ROWS HEIGHT -AUTOFIT
COL HIDE UNHIDE
COL WIDTH -AUTOFIT
SHEET RENAME
SHEET HIDE UNHIDE
SHEET BACKGFROUND
SHEET TAB COLOR
AUTOFORMAT (FROM WORD TABLES) 1
AUTOFORMAT (FROM WORD TABLES) 2
AUTOFORMAT (FROM WORD TABLES) 3
AUTOFORMAT (FROM WORD TABLES) 4
CLEAR (WITHOUT COMMENTS)
STYLE 1
COLORING UNDERLINE 1
COLORING UNDERLINE 2
COLORING UNDERLINE 3
MERGE STYLE
CONDITIONAL FORMATING
EFFECTS & PHOTOSHOP
EFFECTS 1
EFFECTS 2
EFFECTS 3
ALIGNMENT 1
ALIGNMENT 2
ALIGNMENT 3
MERGE CELLS
BORDER 1
BORDER 2
BORDER 3
NUMBERS
PATTERN SHADING 1
PATTERN SHADING 2
PATTERN SHADING 3
ROWS HIDE UNHIDE

GRAPHICS & MULTIMEDIA
CLIP 1
CLIP 2
CLIP 3
CLIP SOUND -VIDEOS
WORD ART 1
WORD ART 2
WORD ART 3
GROUP 1
GROUP 2
GROUP 3
ORDER 1
ORDER 2
ORDER 3
SNAP
NUDGE 1
NUDGE 2
NUDGE 3
ALIGN 1
ALIGN 2
ALIGN 3
ROTATE 1
ROTATE 2
ROTATE 3
CHANGE AUTOSHAPE
FROM FILE 1
FROM FILE 2
FROM FILE 3
DEFAULT 1
DEFAULT 2
DEFAULT 3
SHADOW 1
SHADOW 2
SHADOW 3
3D 1
3D 2
3D 3
ORGNIZATION (FORMATING) 2
ORGNIZATION (FORMATING) 3
ORGNIZATION 1
ORGNIZATION 2
ORGNIZATION 3
CYCLE 1
CYCLE 2
CYCLE 3
RADIAL 1
RADIAL 2
RADIAL 3
PYRAMID 1
PYRAMID 2
PYRAMID 3
VENN 1
VENN 2
VENN 3
TARGET 1
TARGET 2
TARGET 3
SCANNER 1
SCANNER 2
AUTOSHAPE 1
AUTOSHAPE 2
AUTOSHAPE 3
FILL EFFECT (TEXTURE) 1
FILL EFFECT (TEXTURE) 2
FILL EFFECT (TEXTURE) 3
FILL EFFECT (PATTERN) 1
FILL EFFECT (PATTERN-PIC) 2
FILL EFFECT (PATTERN-PIC) 3
FILL EFFECT 1
FILL EFFECT 2
FILL EFFECT 3
PICTURE TOOLBAR 1
PICTURE TOOLBAR 2
PICTURE TOOLBAR 3
PICTURE TOOLBAR -LINE STYLE COMPRESSING 1
PICTURE TOOLBAR -LINE STYLE COMPRESSING 2
PICTURE TOOLBAR -LINE STYLE COMPRESSING 3
PICTURE TOOLBAR -TRANSPERANCY 1
PICTURE TOOLBAR -TRANSPERANCY 2
PICTURE TOOLBAR -TRANSPERANCY 3
FORMAT PICTURE 1
FORMAT PICTURE 2
FORMAT PICTURE 3
BASIC SHAPES 1
BASIC SHAPES 2
BASIC SHAPES 3
AUTOSHAPE -ARROWS FORMATING 1
AUTOSHAPE -ARROWS FORMATING (COLORS-SIZE-WEB)2
AUTOSHAPE -ARROWS FORMATING (COLORS-SIZE-WEB)3
AUTOSHAPE -ARROWS FORMATING (REMAINDER)

HYBERLINKS & MAILS
HYBERLINK 1 CURRENT FOLDER
HYBERLINK 2 CURRENT FOLDER
HYBERLINK 3 CURRENT FOLDER
HYBERLINK 1 BROWSED
HYBERLINK 2 BROWSED
HYBERLINK 3 BROWSED
HYBERLINK RECENT
HYBERLINK – CREAT NEW FILE 1
HYBERLINK – CREAT NEW FILE 2
HYBERLINK – CREAT NEW FILE 3
HYBERLINK – EMAIL 1
HYBERLINK – EMAIL 2
HYBERLINK – EMAIL 3
HYBERLINK – SDREEN TIP (JOIN WITH WORD FILE)
HYBERLINK – PASTE AS HYBERLINK

VIEWS & BREAKS
VIEW NORMAL-PAGE BREAK
INSERT PAGE BREAK

FUNCTIONS
INTRODUCE FUNCTION – DIFF NUM FUNC.-NUM FORMATING
FILL ACROSS WORKSHEET
FILL SERIES
MOST-AVAREGE
CHAR
MOST-SUM
MOST-LARGE
MOST-COUNT
MOST-MAX
MOST-SIN
EXACT
LEFT
CONCATENATE
MATH-ABS
FACT
GCD
INT
LOG-LN
MDETERM
MINVERSE
POWER
SQRT-SUM
ACOS
ACOSH
ASIN-ATAN
COMBINE
COS-COSH
DEGREE
EVEN
EXP
STATICS – SPSS
VARIANCE
STDEV
STANDARIZE
CORRELATION
SPSS END
MEAN
AVEDEV
AVEDEVA
MEDIAN
MODE
COUNT-COUNTA
COUNTBLANK-COUNTIF
QURTILES
TEXT- CHAR
SEARCH
CLEAN
CODE
FIND
LENGTH
LOWER-UPPER
MID
PROPER
REPT-RIGHT
DATE
DAY
TIME
MONTH-HOUR-MINUTE
YEAR-TODAY
NOW
DATE-PRACTICE
LOGICAL-IF
LOGICAL-NESTED IF
AND
OR
NOT-TRUE-FALSE
LOOKUP-COLUMN
AREAS
CHOOSE
COLUMNS
HLOOKUP
INDEX
ROW-ROWS
DATABASE-DAVERAGE
DMAX-DMIN
DCOUNT
DCOUNTA
DPRODUCT
DSTDEV
DSUM
DVAR
INTRODUCE FUNCTION – EQUATION – CELLS TO APPLY
END-1-CREAT FORMULA 4 WAYS
END-2-END FORMULA – FUNCTION
INTRODUCE FUNCTION – NAMES IN FUNC.
FUN ON NEW SHEET BASED ON OTHER SHEETS
FUN ON MORE CELLS BY DRAGGING
INTRODUCE FUNCTION – CELL NAMING IN EQUATION
INTRODUCE FUNCTION – VALUES – VARIBLES
INTRODUCE FUNCTION – HOW TO USE CELLS
INTRODUCE FUNCTION – STARTING WORK
INTRODUCE FUNCTION – MODIFY ARGUMENTS
INSERT FUNCTION DIALOGE BOX-FUNC HELP
INSERT FUNCTION USING OTHER SHEET CELLS
FILL UP-DOWN
FORMULA – FUNCTION
FORMULA-ELEMENTS – PERIORITY
FUNCTION – ARGUMENTS
FUNCTION – NESTED FUNC.

WORKING WITH CHARTS
CHARTSB OVER
CHARTS OPTION – LINKING – UPDATEING
CHARTSB CREAT SIMPLE
CHARTSB DATA RANGE
CHARTSB SERIES
CHARTS OPTION -AXIS-LEGAND
CHARTS OPTION – DATA LABEL – TABLE
CHARTS OPTION – INSERT IN THIS SHEET
CHARTS OPTION – EDITING 1
CHARTS OPTION – EDITING 2

OBJECT INSERTING
INSERT SYMBOLS SPECIAL CHARACTER 1
INSERT SYMBOLS SPECIAL CHARACTER 2
INSERT SYMBOLS SPECIAL CHARACTER 3
INSERT SYMBOLS 1
INSERT SYMBOLS 2
INSERT SYMBOLS 3
INSERT OBJECT 1
INSERT OBJECT 2
INSERT OBJECT 3
INSERT OBJECT (EDITING) 1
INSERT OBJECT (EDITING) 2
INSERT OBJECT (EDITING) 3
INSERT COMMENT
VIEW COMMENT

FORMS & VALIDATIONS
INTRODUCTION TO DATA
SORT 1-BIG MISTAKE
SUBTOTAL
SUBTOTAL – FUNCTIONS
VALIDATION – WHOLE NUM
VALIDATION – DECIMAL – TEXT LENGTH
TABLE INTRO
TABLE PRACTICE
TEXT TO COL-DELIMITED
TEXT TO COL-FIXED
GROUP-OUTLINE-ROWS
GROUP-OUTLINE- COL
AUTO-OUTLINE – CLEAR OUTLINE
CONSOLIDATE SUM
CONSOLIDATE LINK
CONSOLIDATE FUNCTIONS
AUTOFILTER
AUTOFILTER CUSTOM
AUTOFILTER CUSTOM STRINGS
ADVANCED FILTER
ADVANCED FILTER -MORE CRITERIAS
ADVANCED FILTER -MORE CRITERIAS 2
FORM 1
FORM 2-CRITERIA

DATABASE INTEGRATION
EXCEL & DATABASE
DATA TYPES – CURRNCY – YES NO
DATA TYPES – LOOKUP MY ENTERING
DATA TYPES – HYBERLINK
DATA TYPES – OLE
DATA TYPES-GENERAL -TEXT – CAPTION – DEFAULT VALUE
DATA TYPES-GENERAL -TEXT-SIZE
DATA TYPES-GENERAL -TEXT – FORMAT
DATA TYPES-GENERAL -TEXT – INPUTMASK
DATA TYPES-GENERAL -TEXT – INPUTMASK 2
CREAT LIST
IMPORT DATA
RESIZE LIST
TOTAL ROW
CONVERT TO NORMAL RANGE
DATA LINK
FIELD & RECORDS
CREAT TABLES-DESIGN VIEW
CREAT TABLES-ENTERING DATA
DATA TYPES-AUTONUMBER
DATA TYPES-TEXT
DATA TYPES-MEMO-NUMBER-DATE

WORKING WITH MACROS
START MACROS
MACRO DEF.
MACRO ASSIGNING
MACRO DELETE-EDIT
MACRO EDIT VB
MACRO – CREAT NEW DRAWING

CUSTOMIZATION
START COSTOMIZE
CUSTOMIZE-DEF.
CUSTOMIZE- EXCEL PRACTICE
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTTON IMAGE, STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS
CUSTOMIZE- OPTIONS-KEYBOARD

WORKING WITH WINDOWS
SAME FILE
MORE FILES
HIDE & UNHIDE

SPECIAL PASTING & LINKS
PASTE SPECIAL 1
PASTE SPECIAL-WORD
PASTE LINK INSIDE WORD-WORD
PASTE LINK INSIDE
PRACTICE ON SPECIAL-LINK
LINKS
LINK FOR FORMULA
PASTE SPECIAL – OPERATIONS
PASTE SPECIAL – FORMULA-VALUE-COMMENT
PASTE SPECIAL – VALIDATION-BORDERS-REMAIN
CLIPBOARD 1
CLIPBOARD W

WORKING WITH FILES
CLOSE-EXIT W
FILE OVERVIEW
SAVE AS
SAVE
FILE SEARCH EXTENSION
SAVE AS
FILE SEARCH -LOOKIN-FILE TYPE
SAVE PRACTICE
FILE SEARCH OVER
VERSIONS
FILE SEARCH EXTENSION
FILE SEARCH -LOOKIN-FILE TYPE
FILE SEARCH – PRACTICE
FILE DIALOG 1
NEW
FILE DIALOG -FOLDERS-FILES 2
NEW -TEMPLATES
FILE DIALOG – TOOLS-READONLY-REPAIR
CLOSE-EXIT
FILE DIALOG -FOLDERS-FILES 2
NEW BLANK
NEW-EXISTING
NEW-TEMPLATE
FILE DIALOG – TOOLS-READONLY-REPAIR
OPEN
OPEN RECENT FILE
SAVE OVER
SAVE

GETTING HELP
HELP OVER
HELP OVERVIEW
HELP -COURCE CONTENT
HELP CONTENT

FORMULA AUDITING
TOOLS-1-GOOL SEAK
FORMULA AUDITING INTRO
TRACE PRECEDENCE
TRACE DEPENDENCE
REMOVE ARROWS
ERROR CHEKING
RACE ERROR
WATCH WINDOW
EVALUATE FORMULA

SPELLING & CORRECTIONS
EDITING TEXT-1-SPELLING
EDITING TEXT-2-SPELLING ADD TO DIC
EDITING TEXT-3-SPELLING PRACTICE
EDITING TEXT-4-RESEARCH
EDITING TEXT-11- AUTOCORRECT OVER
EDITING TEXT-12- AUTOCORRECT – REPLACE
EDITING TEXT-13- AUTOCORRECT – CELL CAPITLIZE
EDITING TEXT-14- AUTOCORRECT – CAPS LOCK

WHAT IF ANALYSRS
PIVOT TABLE INTRODUCTION
CONSTRAIN SOLVER
SOLVER & SCINARIO
START ANALYSYS
CHANGE FUNCTION
PIVOT CHART
TABLE TO CHART
SCINARIO INTRODUCTION
MULTIBLE CELLS SCINARIO
SCINARIO & PIVOT TABLES
SOLVER INTRO

PRINTING
ORIENTATION & SIZING
PRINT AREA
PRINTER & COPIES
SHEET & WORKBOOK
SCALING & FITTING
MARGINES & CENTERS
BREAKS & PAGES
HEADER & FOOTER
CUSTO HEADER
AREA & ORDERING
PRINT TITLES
PRINT WHAT

VISUAL BASIC
VBA-ALL
VBA_OVERVIEW
OBJECTS
PROPERTIES
METHODS
EVENTS
PROCEDURES_FUNCTIONS
VARIABLES
CONSTANT
DECLEAR
VBADE
PROPERTIES WINDOWS
WINDOW CODE
PROJECT EXPLORER
COMBOBOX1
COMBOBOX2
COMBOBOX3
LABEL EVENTS1
LABEL EVENTS2
LABEL PROPERTIES
PICTURE EVENTS1
PICTURE PROPERTIES1
PICTURE PROPERTIES2
TABPAGE CONTROL 1
TABPAGE CONTROL 2
OPTION GROUP
INTRO TO EXAMPLES
EX 01 VBA EXAMPLES ADD_FUNCTIONS
EX 02 VBA EXAMPLES AVERAGE_FUNCTIONS
EX 03 VBA EXAMPLES NETSALARY A
EX 04 VBA EXAMPLES NETSALARY B

 

OUTLOOK
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

INTERFACE & WORK AREA
INTERFACE – NAVIGATION PANE
CONFIGURE NAVIGATION PANE
STATUS BAR
VIEW NAVIGATION PANE
READING PANE-AUTO PREVIEW
TOOLBAR – GO
FOUR ENVIROMENT WAYS

WORD PROCECCING
WORD PROCECCING
CLIPBOARD
FONTS
CLEAR FORMAT – CONTENT
PARAGRAPH GENERAL
ALIGNMENT
WRITE ARABIC-ENGLISH
UNDO & REDO
COPY
CUT
PASTE SPECIAL
PASTE LINK INSIDE WORD
PASTE LINK 1
PASTE LINK 2-LINKS

FIND & EDITING TEXT
FIND & EDITING TEXT
FIND
EDITING TEXT-1-SPEELING
EDITING TEXT-7-RESEARCH
EDITING TEXT-12- AUTOCORRECT – REPLACE
EDITING TEXT-13- AUTOCORRECT – CELL CAPITLIZE
EDITING TEXT-14- AUTOCORRECT – CAPS LOCK

WORKING WITH MAILS
MAIL OVER
HOW TO CHOICE BG
HOW TO CREATE SIGNTURES PART1
HOW TO CREATE SIGNTURES PART2
CONFIRM MESSAGES
SEND-RECEIVE OPTIONS
SAVE AS PASSWORD
HOW CREATE FOLDER
RULES AND ALERTS
MAIL OVER
MAIL OVER
ADD A NEW E-MAIL ACCOUNT
VIEW OR EXITING E-MAIL ACCOUNT
ARRANGING MESSAGES
CUSTOM ARRANGE
HOW TO SEND
TO-CC-BCC

CALENDERS & APPOINTEMENTS
CALENDER OVER
EVENTS – RECURE
SEARCH
ADD HOLIDAY
TASKPAD
TIME TYPES
CALENDER VIEWS
WORK WEEK
VIEWS & SELECT DAYS
SIMPLE APPOINTEMENT
REMINDER
RECURRENCE
VIEWS

CONTACTS & LISTS
CONTACTS OVER
VCADR EXPORTING
DETAILS – INSERT FILE
INSERT OBJECT
INSERT OBJECT 1
INSERT OBJECT 2 EDIT – CONVERT
SIMPLE CONTACTS
DETAILED CONTACT
PICTURE – MAILS
PHONE LIST
CATEGORY
COMPANY – LOCATION
SEARCH
CHOOSE CONTACT SEARCH

TASKS & PLANNING
OVER & PLANNING
TASK TIMELINE
CUSTOMIZED GROUPING
SORT & FILTER
TASKS ENTRY
TASK REMINDER
OVER DUE
CUSTOMIZED & FIELDS
PROGRESS & COMPLETE
RECURRENCE TASKS
VIEWS 1
CATEGORIES & COMPLETED

NOTES
NOTES OVER
CREAT NOTES
NOTES VIEWS
CATEGORY – COLOR
FIND NOTES

SHORTCUTS
SHORTCUTS OVER
PRACTICE

JOURNAL
OVER VIEW
AUTOMATIC OFFICE RECORD
ITEMS & CONTACTS
AUTOMATIC FROM OTHERS
NEW ENTRY
VIEWS

CUSTOMIZATION
CUSTOMIZE OVER
CUSTOMIZE- OPTIONS-KEYBOARD
CUSTOMIZE- EXAMPLE
CUSTOMIZE-DEF.
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTTON IMAGE,STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS

 

ACCESS
INTRODUCTION & INTERFACE
WELCOME
DATA BASE & ACCESS
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

DO & UNDO
DO & UNDO

COPY & CUT
COPY & PASTE

MODES & WORK AREA
DESIGN – NORMAL MODE

TABLES & DATA TYPES
FIELD & RECORDS
CREAT TABLES-DESIGN VIEW
CREAT TABLES-ENTERING DATA
DATA TYPES-AUTONUMBER
DATA TYPES-TEXT
DATA TYPES-MEMO-NUMBER-DATE
DATA TYPES – CURRNCY – YES NO
DATA TYPES – LOOKUP MY ENTERING
DATA TYPES – HYBERLINK
DATA TYPES – OLE
DATA TYPES-GENERAL -TEXT-SIZE
DATA TYPES-GENERAL -TEXT – FORMAT
DATA TYPES-GENERAL -TEXT – INPUTMASK
DATA TYPES-GENERAL -TEXT – INPUTMASK 2
DATA TYPES-GENERAL -TEXT – CAPTION – DEFAULT VALUE

QUIRIES
QUIRIES-OVER
QUIRIES-CREAT DESIGN VIEW
QUIRIES-SELECT FIELD-ALL
QUIRIES-SORT
QUIRIES-SHOW-UPDATE TABLE
QUIRIES-ADD-DELETE-UPDATE RECORDS
QUIRIES-MAKE NEW FILED
QUIRIES-CRETERIA – AND

FORMS & CONTROLS
FORMS OVER
FORMS FIELDS – AUTOFORMAT
FORMS FIELDS – CONDITIONAL FOR. OVER
CONDITIONAL FORMATING-EXCEL
CONDITIONAL FORMATING – PRACTICE
BOUND CONTROL TO FIELD
PROPERTIES FOR ALL OBJECTS
FORMS WIZARD
FORMS FUNCTION
FORMS CREAT DESIGN VIEW
FORMS FIELDS-CONTROLS
FORMS FIELDS – ALIGN SIZE
FORMS FIELDS – ALIGN SIZE 2
FORMS FIELDS – VER-HOR-SPACING
FORMS FIELDS – GROUP-UNGROUP

REPORTS
REPORTS-OVER
REPORTS – WIZARD
REPORTS – WIZARD – GROUPING
REPORTS – WIZARD – CALCULATION

WEB PAGES
PAGES OVER
CREAT WEB PAGE BY WIZARD
WEB PAGE – NAVIGATE – UPDATE- IN ACCESS
WEB PAGE – CREAT DESIGN VIEW
CREAT BY WEB PAGE EDITING

EXPRESSION BUILDER
EXPRESSION BUILDER OVERVIEW
SIMPLE EXPRESSION
MATH EXAMPLE
MONTH EXAMPLE
STRING EXAMPLE

WORKING WITH MACROS
MACRO OVER
CREAT SIMPLE MACRO
ASSIGN MACROS TO EVENTS
GO NEXT-PREVIOUS MACROS
CLOSE MACRO
MORE MACRO ACTIONS

CUSTOMIZATION
CUSTOMIZE OVER
CUSTOMIZE- OPTIONS-KEYBOARD
CUSTOMIZE- PRACTICE
CUSTOMIZE-DEF.
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTON IMAGE, STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS

WORKING WITH FILES
CLOSE-EXIT
FILE OVERVI
SAVE AS
LINK TABLES
FILE SEARCH EXTENSION
EXPORT
FILE SEARCH -LOOKIN-FILE TYPE
SAVE & SAVE AS
BACK UP DATABASE
VERSIONS
FILE SEARCH OVER
FILE SEARCH EXTENSION
FILE SEARCH -LOOKIN-FILE TYPE
FILE DIALOG
NEW
FILE DIALOG -FOLDERS-FILES
NEW -TEMPLATES
FILE DIALOG – TOOLS-READONLY-REPAIR
CLOSE-EXIT
FILE DIALOG -FOLDERS-FILES
FILE DIALOG – TOOLS-READONLY-REPAIR
NEW BLANK
OPEN
OPEN
OPEN RECENT FILE
OPEN RECENT FILE
SAVE
EXTERNAL DATA

RELATIONSHIPS
RELATIONSHIPS A
RELATIONSHIPS PK FP B
CREATETABLE WITH RELATIONSHIPS
CREATETABLE WITH RELATIONSHIPS C
CREATETABLE WITH RELATIONSHIPS D
CREATETABLE WITH RELATIONSHIPS E
CREATETABLE WITH RELATIONSHIPS F

TEXT CORRECTIONS
EDITING TEXT-11- AUTOCORRECT – OVER
EDITING TEXT-12- AUTOCORRECT – REPLACE
EDITING TEXT-13- AUTOCORRECT – CELL CAPITLIZE
EDITING TEXT-14- AUTOCORRECT – CAPS LOCK

VISUAL BASIC
VBA-ALL
VBA_OVERVIEW
OBJECTS
PROPERTIES
METHODS
EVENTS
PROCEDURES_FUNCTIONS
VARIABLES
CONSTANT
DECLEAR
VBADE
PROPERTIES WINDOWS
WINDOW CODE
PROJECT EXPLORER
COMBOBOX1
COMBOBOX2
COMBOBOX3
LABEL EVENTS1
LABEL EVENTS2
LABEL PROPERTIES
PICTURE EVENTS1
PICTURE PROPERTIES1
PICTURE PROPERTIES2
TABPAGE CONTROL 1
TABPAGE CONTROL 2
OPTION GROUP
EX 1 VBA FOR ACCESS EXAMPLES 1
EX 2 VBA FOR ACCESS EXAMPLES 2 A
EX 3 VBA FOR ACCESS EXAMPLES 2 B
EX 4 VBA FOR ACCESS EXAMPLES 3 A
EX 5 VBA FOR ACCESS EXAMPLES 3 B
EX 5 VBA FOR ACCESS EXAMPLES 4 A
EX 6 VBA FOR ACCESS EXAMPLES 4 B
EX 7 VBA FOR ACCESS EXAMPLES 4 C
EX 8 VBA FOR ACCESS EXAMPLES 5 A
EX 9 VBA FOR ACCESS EXAMPLES 5 B
EX 10 VBA FOR ACCESS EXAMPLES 5 C

 

PUBLISHER
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

ZOOM & WORK AREA
PAGE DEF.
ZOOM
ZOOM 2
STATUS BAR
RULER

GETTING STARTED
FROM SCRATCH
INSERT NEW PAGE
DUPLICATE PAGE
DELETE PAGE
MOVE PAGE
GO TO PAGE
STATUS BAR

DO & UNDO
UNDO & REDO

COPY & CUT
COPY & PASTE
CUT & PASTE

WRITING & FORMATTING
KEYBOARD 1
KEYBOARD 2
KEYBOARD 3
FIND- WHOLE WORD
FONTS 1
FONTS 2
FONTS 3
COLOR UNDER 1
COLOR UNDER 2
COLOR UNDER 3
EFFECTS 1
EFFECTS 2
EFFECTS 3
EFFECTS PHOTOSHOP
CHARACTER SPACING 1
CHARACTER SPACING 2
CHARACTER SPACING 3
INSERT TEXT FILE
TEXT BOX -WRITING RULES 1
TEXT BOX -WRITING RULES 2
TEXT BOX -WRITING RULES 3
NAVIGATION
SELECTION 1
SELECTION 2
SELECTION 3
FIND 1
FIND 2
FIND 3
REPLACE 1
REPLACE 2
REPLACE 3
DELETE TEXT
FIND OPTIONS
ADVANCED FIND-MATCH CASE

PARAGRAPH FORMATING
PARAGRAPH ALIGNMENT
PARAGRAPH INDENTATION – LINE SPACING
SPECIAL CHARACTER

BULLETS & NUMBERING
BULLETS DEF. 1
BULLETS DEF. 2
BULLETS DEF. 3
BULLETS – NUMBERING 1
BULLETS – NUMBERING 2
BULLETS – NUMBERING 3
COSTOMIZE 1
COSTOMIZE 2
COSTOMIZE POSITION
COSTOMIZE PRACTISE
HOR RULES
DROP CAP 1
DROP CAP 2
DROP CAP NON CURRENT
DROP CAP 3
AUTO FIT TEXT 1

WORKING WITH TABLES
INSERT COL ROWS 1
INSERT COL ROWS 2
INSERT COL ROWS 3
GROW TO FIT TEXT
ROTATE TABLES
FORMAT TABLES -1- FILL
FORMAT TABLES -2 LINES
DELETE 1
DELETE 2
DELETE 3
SELECT 1
SELECT 2
SELECT 3
MERGE 1
MERGE 2
MERGE 3
SPLIT 1
SPLIT 2
SPLIT 3
CELL DIAGONALS
AUTO FORMAT 1
AUTO FORMAT 2
AUTO FORMAT 3
AUTO FORMAT 4
FILL DOWN RIGHT
INSERT TABLES 1
INSERT TABLES 2
INSERT TABLES 3

GRAPHICS & IMAGES
CLIP ART 1
CLIP ART 2
CLIP ART 3
PRACTISE
DRAW BASIC SHAPES 1
DRAW BASIC SHAPES 2
DRAW BASIC SHAPES 3
AUTOSHAPES 1
AUTOSHAPES 2
AUTOSHAPES 3
FORMAT AUTOSHAPES
VIEW BOUNDRIES AND GUIDES
INSERT FROM FILE 1
INSERT FROM FILE 2
INSERT FROM FILE 3
INSERT EMPTY FRAME
INSER SCANNER 1
INSER SCANNER 2
INSER SCANNER 3
AUTOSHAPE 1
AUTOSHAPE 2
AUTOSHAPE 3
WORD ART 1
WORD ART 2
WORD ART 3
WORD ART PART 2 1
WORD ART PART 2 2
WORD ART PART 2 3
WORD ART PART 3 1
WORD ART PART 3 2
WORD ART PART 3 3
VIEW PIC
PIC TOOLBAR 1
PIC TOOLBAR 2
PIC TOOLBAR 3
PIC TOOLBAR 1 LINE
PIC TOOLBAR 2 LINE
PIC TOOLBAR 3 LINE
PIC TOOLBAR 1 TEXT WRAPING
PIC TOOLBAR 2 TEXT WRAPING
PIC TOOLBAR 3 TEXT WRAPING
PIC TOOLBAR 1 TRANCPERNCY
PIC TOOLBAR 2 TRANCPERNCY
PIC TOOLBAR 3 TRANCPERNCY
FORMAT PIC1
FORMAT PIC2
FORMAT PIC3

GRAPHICS & FLASH
FLASH DRAWINGS
INK TOOL
OVERLAPING
PENCIL
ERASING
ANCHOR POINTS
LINES TO FILL
COLORS
STROKE AND FILL
INSPECTOR
MIXER SOLID
OVERVIEW
MIXER LINEAR
MIXER IMAGES
BRUSH 1
BRUSH 2
PAINT BUCKET
LOOK FILL
FILL TRANSFORM
IDROPPER TOOL
INSERT FLASH COLORS
VECTOR & RASTER
LINE
OVAL
RECTANGLE
ARROW TOOL
STRAIGHTEN
SUBSELECTION

DRAWINGS & AUTOCAD
PUBLISHERB & AUTOCAD
POINT-POLAR
POLAR-REL.
POINT-OSNAP
ZOOM REAL TIME
PAN REALTIME
LINE
MULTILINE
POLYLINE
POLYGON-I
POLYGON-C
INTERFACE
RECTANG-USUAL
ARC-3POINT
CIRCLE-RADIUS
DOUNT-FILLED
ELLIPSE-CENTER
ELLIPSE-AXIS
DIVIDE-USUAL
MEASURE-ALL
MIRROR
OFFSET
INTERACTIVE-PROGRAM
ARRAY-RECTANGLE
ARRAY-POLAR
MOVE
SCALE
TRIM
CHAMFER
FILLET
INSERT NEW AUTOCAD
INSERT AUTOCAD FILES
COMMAND-OPTIONS
START-STRATIGY
TEXT WINDOW
POINT-DEF.
POINT-ABSOLUTE
POINT-RELATIVE

GROUPING & ORDERING
GROUP 1
GROUP 2
GROUP 3
BASELINE GUIDES
ORDER 1
ORDER 2
ORDER 3
NUDGE 1
NUDGE 2
NUDGE 3
ALIGN 1
ALIGN 2
ALIGN 3
ROTATE FLIP 1
ROTATE FLIP 2
ROTATE FLIP 3
TEXT WRAPING 1
TEXT WRAPING 2
TEXT WRAPING 3
REROUTE CONNECTORS 1
REROUTE CONNECTORS 2
REROUTE CONNECTORS 3
CHANGE AUTOSHAPE 1
CHANGE AUTOSHAPE 2
CHANGE AUTOSHAPE 3

SPECIAL PASTING & LINKS
PASTE-SPECIAL- OVER
PASTE SPECIAL
PASTE LINK INSIDE WORD
PASTE LINK 1
PASTE LINK 2-LINKS
PRACTICE-SPECIAL
PRACTICE-LINK
CLIPBOARD

OBJECT INSERTING
PAGE NUMBERS
HYBERLINK 1 CURRENT FOLDER
HYBERLINK 2 BROWSED PAGES
HYBERLINK 3 PLACE IN DOC.
HYBERLINK 4 CREAT NEW
HYBERLINK 5 EMAIL – SCREEN TIP
HYBERLINK PRACTICE
OBJECT
DATE-TIME
SYMBOLS
GALLARY OBJECTS
ADD GALLARY OBJECTS
WIZARD FOR THIS OBJECT
INSERT PERSONAL INFO
EDIT PERSONAL INFO
HYBERLINK

HEADER & FOOTER
EADER & FOOTER 1
EADER & FOOTER 2

WINDOW MENU
WINDOW MENU

WORKING WITH FILES
FILE OVERVIEW
SAVE
SAVE AS
SAVE PRACTICE
FILE SEARCH OVER
FILE SEARCH EXTENSION
FILE SEARCH -LOOKIN-FILE TYPE
FILE SEARCH – PRACTICE
IMPORT WORD DOC
FILE DIALOG 1
FILE DIALOG -FOLDERS-FILES 2
FILE DIALOG – TOOLS-READONLY-REPAIR
CLOSE-EXIT
NEW-BLANK PRINT
NEW-FROM DESIGN
NEW-WEB PAGE
OPEN
OPEN RECENT FILE
SAVE OVER

BACKGROUND
BACKGROUND 1
FILL EFFECT -GRADIANT
FILL EFFECT -TEXTURE
FILL EFFECT – PATTERN-PIC
VIEW SPECIAL PAPER

CUSTOMIZATION
CUSTOMIZE OVER
CUSTOMIZE- OPTIONS-KEYBOARD
CUSTOMIZE- EXAMPLE
CUSTOMIZE-DEF.
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME, BUTON IMAGE, STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS

GETTING HELP
OVERVIEW
CONTENTS

SPELLING & CORRECTIONS
EDITING TEXT -1- SPELLING 1
EDITING TEXT -1- SPELLING 2
EDITING TEXT -10- AUTOCORRECT – CAPS LOCK
EDITING TEXT -11- AUTOFORMAT AS YOU TYPE
EDITING TEXT -2- SPELLING ADD 1
EDITING TEXT -2- SPELLING ADD 2
EDITING TEXT -3- SPELLING PRACTICE
EDITING TEXT -4- LANGUGE 1
EDITING TEXT -4- LANGUGE 2
EDITING TEXT -5- THERESSS 1
EDITING TEXT -5- THERESSS 2
EDITING TEXT -6- REASEARCH 1
EDITING TEXT -6- REASEARCH 2
EDITING TEXT -7- AUTOCORRECT – AUTOFORMAT
EDITING TEXT -8- AUTOCORRECT – REPLACE
EDITING TEXT -9- AUTOCORRECT – CELL CAPITLIZE

VISUAL BASIC
VBA-ALL
VBA_OVERVIEW
OBJECTS
PROPERTIES
METHODS
EVENTS
PROCEDURES_FUNCTIONS
VARIABLES
CONSTANT
DECLEAR
VBADE
PROPERTIES WINDOWS
WINDOW CODE
PROJECT EXPLORER
COMBOBOX1
COMBOBOX2
COMBOBOX3
LABEL EVENTS1
LABEL EVENTS2
LABEL PROPERTIES
PICTURE EVENTS1
PICTURE PROPERTIES1
PICTURE PROPERTIES2
TABPAGE CONTROL 1
TABPAGE CONTROL 2
OPTION GROUP

 

INFOPATH
INTRODUCTION & INTERFACE
WELCOME
OPENING & FIRST LOOK
PREREQUISITES
SCREEN SIZE
MAIL SUPPORT
LESSON SPEED
TASK PANE
LET US START

WORK AREA & WRITING
PROG-PAPER
KEY 1
KEY 2 W
KEY 3
WRITING RULES1
WRITING RULES2
WRITING RULES3
NAVIGATION 1
NAVIGATION 2
NAVIGATION 3
SELECTION 1
SELECTION 2
SELECTION 3
MODES

GETTING STARTED
SCRATCH
ITEMS CONTROLS

DO & UNDO
UNDO & REDO

COPY & CUT
CUT & PASTE
COPY & PASTE

FORMATTING & STYLES
FONT
STYLE
BULLETS NUMBERING
BORDERS SHADING
COLOR SCHEMES

WORKING WITH TABLES
CREAT TABLES 1
CREAT TABLES 2 LAYOUTS
CREAT TABLES 3 LAYOUTS
CREAT TABLES REPEATING
INSERT 1
INSERT 2
INSERT 3
DELETE
SELECT1
SELECT2
SELECT3
MERGE 1
MERGE 2
MERGE 3
SPLIT 1
SPLIT 2
SPLIT 3
BORDERS 1
BORDERS 2
BORDERS 3
GRIDLINES

GRAPHICS & IMAGES
CLIP ART 1
CLIP ART 2
CLIP ART 3
FROM FILE 1
FROM FILE 2
FROM FILE 3
HOR LINE
FORMAT PIC – SIZE-TEXT
FORMAT PIC- TEXT WRAPING

FORMS DESIGN
FORM OVERVIEW-FILL-DESIGN
TEXT BOX – DISPLAY -PLACE HOLDER – SPELLING
TEXT BOX – DISPLAY – WRAPTEXT – ALIGNMENT
TEXT BOX – DISPLAY – CONDITIONAL
TEXT BOX – DATA TYPES-TEXT-NUMBER
TEXT BOX – DATA TYPES-TEXT-DECIMAL
TEXT BOX – DATA TYPES-TEXT-BOOLEAN-HYBER
TEXT BOX – DATA TYPES-TEXT-DATE-TIME
TEXT BOX – SIZE
TEXT BOX – ADVANCED-ACCESSKEY-TAB
RICH TEXT BOX
RICH TEXT BOX – PROPERTIES
DROP DOWN LIST BOX-PROPERTIES
DROP DOWN LIST BOX- LIST MANUALLY
LIST BOX- ALL
LIST BOX- DATABASE
DATE PICKER
CHECK BOX
OPTION BUTTON
BULLET LIST
NUMBERED LIST
PLAIN LIST
HYBERLINK-LINK TO
HYBERLINK- DATA SOURCE
DESIGN FORM-3 WAY
PICTURE CONTROL
INK PICTURE CONTROL
DESIGN FORM-LAYOUT
DESIGN FORM-FIELD-CONTROL-DATA SOURCE
TEXT BOX – PROPERTIES DATA
TEXT BOX – VALIDATION 1
TEXT BOX – VALIDATION 2
TEXT BOX – VALIDATION 3

ADVANCED CONTROLS
ADVANCED CONTROLS OVERVIEW
SECTION
SECTION-PROPERTIES-INSERT-REMOVE
OPTIONAL SECTION
REPEATING SECTION 1
REPEATING SECTION – CHANGE BINDING
REPEATING TABLE 1

DATA SOURCE
DATA SOURCE OVER
CREAT DATA SOURCE
DATA SOURCE TYPES
DATA SOURCE DATA TYPES
REPEATING – CANT BLANK
RIGHT CONTROL FOR RIGHT DATA TYPE
DATA SOURCE RIGHT MENU
DATA SOURCE ERRORS
DATA SOURCE DRAGGING

DATA SOURCE DESIGN
DESIGN FROM DATA SOURCE OVER
CREAT TABLES-ENTERING DATA
DATA TYPES-AUTONUMBER
DATA TYPES-TEXT
DATA TYPES-MEMO-NUMBER-DATE
DATA TYPES – CURRNCY – YES NO
DATA TYPES – LOOKUP MY ENTERING
DATA TYPES – HYBERLINK
DATA TYPES – OLE
DATA TYPES-GENERAL -TEXT-SIZE
DATA TYPES-GENERAL -TEXT – FORMAT
DATABASE LINK – ACCESS
DATA TYPES-GENERAL -TEXT – INPUTMASK
DATA TYPES-GENERAL -TEXT – INPUTMASK 2
DATA TYPES-GENERAL -TEXT – CAPTION – DEFAULT VALUE
QUIRIES-OVER
QUIRIES-CREAT DESIGN VIEW
QUIRIES-SELECT FIELD-ALL
QUIRIES-SORT
QUIRIES-SHOW-UPDATE TABLE
QUIRIES-ADD-DELETE-UPDATE RECORDS
QUIRIES-MAKE NEW FILED
FINAL CREAT FORM FROM ACCESS
QUIRIES-CRETERIA – AND
XML DATA OVER
XML FILE
CUSTOMIZE A SAMPLE
DATABASE OVER & DYNAMIC EFFECTS
DIFFERENT VIEWS
ACCESS TABLE CREATION
FORMS FROM QUIREIES
DESIGN – NORMAL MODE
FIELD & RECORDS
CREAT TABLES-DESIGN VIEW

FIND & REPLACE
FIND-REPLACE OVER
FIND
REPLACE
ADVANCED FIND-MATCH CASE
FIND- WHOLE WORD
FIND- WILD
FIND- WILD ASTRIX
FIND- WILD -END-BIGIN
PRACTICE

CUSTOMIZATION
START CUSTOMIZE
CUSTOMIZE-DEF.
SMALL EXAMPLE
CUSTOMIZE- MAKE TOOLBAR FROM MENUES
CUSTOMIZE- MENU REARRANGE
CUSTOMIZE- MENU NAME,BUTON IMAGE,STYLE
CUSTOMIZE- MENU CHANGE FUNCTION – RESET
CUSTOMIZE- MENU MAKER – ASSIGN MACRO – COMMAND
CUSTOMIZE- OPTIONS
CUSTOMIZE- OPTIONS-SCREEN TIPS
CUSTOMIZE- OPTIONS-KEYBOARD

GETTING HELP
OVERVIEW
HELP OVER
HELP CONTENT
TOUR

SPELLING
EDITING-1-SPELLING-1
EDITING TEXT-1-SPEELING AND GRAMMER-2
EDITING-2-SPELLING ADD-1
EDITING TEXT-2-SPEELINGAND GRAMMER-ADD TO DIC-2
EDITING-3-SPELLING PRACTICE
EDITING-4-SPELLING LANGUAGE-1
EDITING TEXT-4-SET LANGUAGE-2.

اترك تعليقاً

Close Menu