کانال آموزش اکسل

01 April 2016 16:57

👇👇👇👇👇👇
دوره آموزش جامع اکسل 2003 توسط Mark Swift
شامل سرفصلهای :
Introduction
Welcome
Getting Started
Spreadsheet uses
Toolbars and menus
Moving around
Getting help
Creating Workbooks
Opening new workbooks
Entering data
Commenting and saving
Modifying Worksheets
Opening worksheets
Add and delete worksheets
Insert and delete cells
Worksheet data
Formatting Worksheets
Width and height
Numeric formats
Alignment of data
Naming cells and ranges
Naming constants
Creating lists
Autofilter
Designated lists
Printing Workbooks
Print options
Printing and hiding data
Headers and footers
Working with Formulas
Creating formulas
Relative and absolute
External references
Named constants
Working with Basic Functions
Functions
Enhancing Worksheets
Fonts and merging
Rotate and indent
Borders
Shading and format painter
Rename and color worksheet tabs
Working with pictures
Using Templates, Styles and Autoformats
Templates
Styles
Autoformat
Smart documents
Charts
Chart terminology
Chart wizard
Formatting charts
Inserting images
Printing charts
Finding and Replacing Data
File search
Find and replace
Importing and Exporting Data
Import from Word
Delimited data
Import from the web
Exporting data
Using Multiple Worksheets
Consolidation
3D formulas
Manipulating the Screen Display
Multiple panes
More screen options
Working with Advanced Functions
If
Time
Date and time
Lookup
Formulas and Text
Compare text
Concatenation
Special characters
Pivot Tables
Pivot tables
Macros
Recording a macro
Macro menus
Global macros
Conclusion
Goodbye