👇👇👇👇👇👇 دوره آموزش جامع اکسل 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

👇👇👇👇👇👇
دوره آموزش جامع اکسل 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