تدريب اخصائي التطوير المستوى الاول :
Microsoft Excel 2007
Customize the excel environment
|
Excel popular options
|
Color scheme
|
Customize an excel worksheet
|
Header & footer tools design contextual tab
|
Watermarks in excel
|
Enhance worksheets using themes
|
Types of themes
|
Create new theme colors dialog box
|
Create new theme fonts dialog box
|
Work with comments
|
Comments
|
Access external resources using hyperlinks
|
Hyperlinks
|
Creatingworkbooksusing templates
|
Create aworkbook from a template
|
Templates
|
Types of templates
|
Create a custom template
|
Custom template
|
Organizing datausing tables
|
Create tables
|
Tables
|
Table components
|
Create table dialog box
|
Quick styles
|
Table tools design contextual tab
|
Modify tables
|
Summary function
|
Summary function in excel
|
The insert function dialog box
|
The resize table option
|
Format tables
|
Presenting datausing charts
|
Create a chart
|
Chart
|
Types of charts
|
Insert chart dialog box
|
Modify charts
|
Chart elements
|
Format charts
|
The enhanced chart tools
|
Chart styles
|
Chart layout
|
Create a chart template
|
Chart templates
|
Share excel charts
|
Chart sharing
|
ENHANCING VISUAL APPEALUSINGGRAPHICOBJECTS
|
Insert Graphics
|
Graphic Objects
|
Types of Graphic Objects
|
Modify Graphic Objects
|
Picture Tools Format Contextual Tab
|
Emphasize an Area of a Worksheet
|
Shapes
|
Types of Shapes
|
The Shapes Gallery
|
Illustrate Workflow Using SmartArt Graphics
|
SmartArt Graphics
|
The SmartArt Gallery
|
Format Graphic Objects
|
Graphic Formatting Methods
|
Change the Order of Layered Graphic Objects
|
Layering
|
Group Graphic Objects
|
Grouping
|
Organize Graphic Objects
|
Calculating data with advanced formulas
|
Refer to a Range of Cells
|
Range Name
|
Calculate Data across Worksheets
|
Three-Dimensional Cell Reference
|
Perform Date and Time Calculations
|
Function Categories
|
Date and Time Functions
|
Format Text Using Formulas
|
Text Functions
|
Perform Numeric Calculations
|
Financial Functions
|
Statistical Functions
|
Math and Trigonometry Functions
|
Calculate Data with Lookup & Reference Functions
|
Lookup & Reference Functions
|
Perform Logical Analysis
|
Logical Functions
|
Print Formulas
|
SORTING AND FILTERING DATA
|
Sort Data in a Spreadsheet
|
Sort
|
Filter Data in a Spreadsheet
|
Filter
|
Filter Options
|
Microsoft Access 2007
Create a Junction Table
|
Many-to-Many Relationships
|
Junction Tables
|
Improve Table Structure
|
Writing advanced queries
|
Create Sub queries
|
Sub queries
|
Create Unmatched and Duplicate Queries
|
Find Unmatched Query Wizard
|
Find Duplicates Query Wizard
|
Group and Summarize Records Using Criteria
|
Summarize Data Using a Crosstab Query
|
Crosstab Query
|
Crosstab Query Wizard
|
Simplifying tasks with macros
|
Create a Macro
|
Macros
|
The Macro Builder Window
|
Macro Action
|
Types of Macro Actions
|
Action Arguments
|
Attach a Macro
|
Object Events
|
Restrict Records Using a Condition
|
Macro Conditions
|
The Where Condition
|
Validate Data Using a Macro
|
Event Properties for Data Validation
|
Macro Actions for Data Validation
|
Automate Data Entry Using a Macro
|
Event Properties for Automating Data Entry
|
Macro Actions for Automating Data Entry
|
Making effective use of forms
|
Display a Calendar on a Form
|
ActiveX Controls
|
Form Format Properties
|
Organize Information with Tab Pages
|
Tab Control
|
Display a Summary of Data in a Form
|
Sub form Wizard
|
Microsoft PowerPoint 2007
Customizing the PowerPoint environment
|
Personalize the PowerPoint Interface
|
ScreenTip Styles
|
Color Schemes
|
The Popular Option
|
Customize Save Options
|
Customizable Save Options
|
Apply Advanced Customization Options
|
Customizable Advanced Options
|
CUSTOMIZING A DESIGN TEMPLATE
|
Set Up a Slide Master
|
Custom Template
|
Slide Master
|
The Reuse Slides Pane
|
Customize Slide Layouts
|
Custom Slide Layout
|
Create Custom Themes
|
Custom Themes
|
The Create New Theme Fonts Dialog Box
|
Customize Bullets
|
Custom Bullets
|
The Bullets And Numbering Dialog Box
|
Add Common Slide Information
|
Common Slide Information
|
The Header And Footer Dialog Box
|
Modify the Notes Master
|
The Notes Master
|
Modify the Handout Master
|
The Handout Master
|
Delivery Methods
|
Adding diagrams to a presentation
|
Create a Diagram
|
SmartArt Graphics
|
The Choose A SmartArt Graphic Dialog Box
|
SmartArt Graphic Categories
|
Advanced Graphical Techniques
|
ADDING SPECIAL EFFECTS TO PRESENTATIONS
|
Add Multimedia Elements
|
The Media Clips Group
|
The Movie Options Group
|
The Clip Art Task Pane
|
Customize Slide Component Animation
|
The Custom Animation Task Pane
|
Entrance Custom Animation Effects
|
Types of Entrance Custom Animation Effects
|
Emphasis Custom Animation Effects
|
Types of Emphasis Custom Animation Effects
|
Motion Path Custom Animation Effects
|
Types of Motion Path Custom Animation Effects
|
Exit Custom Animation Effects
|
Types of Exit Animation Effects
|
Ordering
|
CUSTOMIZING A SLIDE SHOW PRESENTATION
|
Set up a Custom Show
|
Custom Slide Shows
|
Slide Show Options
|
Hyperlinks
|
The Action Settings Dialog Box
|
Action Buttons
|
Set up a Slide Show to Repeat Automatically
|
Information Kiosks
|
ليست هناك تعليقات:
إرسال تعليق