osama_youssef
01-03-2008, 05:28 AM
بسم الله الرحمن الرحيم
TOTAL.TRAINING.ONLINE.MICROSOFT.EXCEL.2007.ADVANCE D
أفضل و أقوى سلسلة شرح لميكروسوفت إكسل 2007 ووظائفه المتقدمه
http://www.totaltraining.com/img/prod/150x150/excel2007_adv.jpg
الكورس عباره عن DVD يحتوي على 6 ساعات كامله شرح فيديو
مقسمه إلى سبعة أقسام
http://www.mrexcel.com/ttibill.jpg
لغة الشرح: الإنجليزيه
تاريخ الإصدار : 3 ديسمبر 2007
ومرفق أيضاً رابط للأمثله و النماذج المستخدمه في الشرح
و طبعاً نظراً لكبر المساحه أنصحكم بتحميل جزء و مشاهدته ثم تحميل التالي و هكذا حتى تنتهي السلسله
راجياً من الله أن ينفعكم به
فقد تعبت كثيراً في إحضاره و الله شهيد على ذلك وكل ما أطلبه منكم هو الدعاء لي بالهدايه
Language......: English
Company.......: Artbeats
Scene Release-Date..: Dec-03-2007
Title..: TOTAL.TRAINING.ONLINE.MICROSOFT.EXCEL.2007.ADVANCE D-ABORTIONSAREFORBABIES
Platform..: Windows
Format..: DVD-ROM & Online
Level...: Intermediate to Advanced
De******ion: Now that you got your feet wet learning the new features in Microsoft Excel 2007
in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to
dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll
be at ease learning some new techniques that will streamline your next data analysis project.
Sit back and discover how to unleash the power of Excel with this in-depth video series.
Running Time: 6 Hrs, 1 DVD
Project Files: Included
Here is the course outline:
Lesson 1: SUMMARIZING DATA (58 min)
* Advanced Subtotals
* Formatting the Subtotal Rows
* Adding and Copying with Subtotals
* Consolidating Data
* Introducing the SUMIF Command
* Working with the SUMIF Command
* Using Array Formulas
* Looking at AutoSum Tricks
* Utilizing Fill Handle Tricks
Lesson 2: WORKING WITH PIVOT TABLES (52 min)
* Creating a Pivot Table
* Rearranging Fields in a Pivot Table
* Explaining the Report Layout Options
* Using the Report Filters Feature
* Using Top 10 & Date Filters
* Handling Blank Cells
* Drilling Down in the Pivot Table
* Sorting a Pivot Table
* Formatting a Pivot Table
* Creating Custom Formats
* Explaining the Grouping Options
* Adding Formulas to a Pivot Table
* Changing a Calculation in a Pivot Table
* Replicating a Pivot Table
* Counting with a Pivot Table
* Using Pivot Charts
Lesson 3: CHARTING IN EXCEL (75 min)
* Charts Refresher
* Moving, Sizing & Copying Charts
* Formatting Charts
* Formatting a Series
* Exploring the Home & Format Ribbons
* Deciding What Chart Format to Use
* Show a Time Series with Column or Line Charts
* Using Combination Charts
* Using Line Chart Accessories
* Using Bar Charts to Show Comparisons
* Using Component Charts
* Using Correlation Charts
* Exploring Other Charts
* Chart Lies Revealed & Advanced Chart Types
* Creating a Custom Layout
Lesson 4: GETTING VISUAL (28 min)
* Using Conditional Formatting
* Using Advanced Conditional Formatting
* Highlighting, Sorting & Filtering Columns
* Using SmartArt Functions
* Using Different SmartArt Graphics
* Embedding a Formula into a Shape
Lesson 5: CREATING POWERFUL FORMULAS (85 min)
* Using Goal Seek to Find an Answer
* Auditing Formulas
* Shrinking the Formula Bar
* Understanding Errors
* Joining Text Columns
* Using Custom Formatting Codes
* Pasting Values
* Using Paste Special
* Breaking Apart Text
* Converting Text to Numbers
* Using Date Functions
* Using Bizarre Date Functions
* Using Exponents
* Using the VLOOKUP Function
* Using Index Match
* Using the Offset Function
* Using the Convert Function
* Looking at Interesting but Obscure Functions
* Using the Rand Function
* Working with Regression
* Ranking & Sorting Formulas
Lesson 6: RECORDING MACROS (18 min)
* Displaying the Developer Tab
* Recording a Simple Macro
* Simplifying the Macro
* Recording Using Relative References
Lesson 7: TIPS & TRICKS (28 min)
*
* Showing Off New Tips in Excel 2007
* Tips for Handling Worksheets
* Using Excel as a Word Processor
* Miscellaneous Tips
* Validating Data
* Changing Text Entry Direction
* Using Speak Cells
* Final Comments & Credits
معلومات أكثر
http://www.totaltraining.com/prod/mi...el2007_adv.asp
الأمثله التطبيقيه المستخدمه في الشرح
http://rapidshare.com/files/52705919/TT_Advanced_Excel2007_PF.zip
روابط التحميل على الرابيدشير
http://rapidshare.com/files/52704739/M1XL07_P01_C01_L00.mov
http://rapidshare.com/files/52704854/M1XL07_P01_C01_L01.mov
http://rapidshare.com/files/52704790/M1XL07_P01_C01_L02.mov
http://rapidshare.com/files/52704772/M1XL07_P01_C01_L03.mov
http://rapidshare.com/files/52704759/M1XL07_P01_C01_L04.mov
http://rapidshare.com/files/52704762/M1XL07_P01_C01_L05.mov
http://rapidshare.com/files/52704760/M1XL07_P01_C01_L06.mov
http://rapidshare.com/files/52704848/M1XL07_P01_C01_L07.mov
http://rapidshare.com/files/52704771/M1XL07_P01_C01_L08.mov
http://rapidshare.com/files/52704768/M1XL07_P01_C01_L09.mov
http://rapidshare.com/files/52704726/M1XL07_P01_C02_L00.mov
http://rapidshare.com/files/52704745/M1XL07_P01_C02_L01.mov
http://rapidshare.com/files/52704747/M1XL07_P01_C02_L02.mov
http://rapidshare.com/files/52704794/M1XL07_P01_C02_L03.mov
http://rapidshare.com/files/52704843/M1XL07_P01_C02_L04.mov
http://rapidshare.com/files/52704799/M1XL07_P01_C02_L05.mov
http://rapidshare.com/files/52704812/M1XL07_P01_C02_L06.mov
http://rapidshare.com/files/52704752/M1XL07_P01_C02_L07.mov
http://rapidshare.com/files/52704764/M1XL07_P01_C02_L08.mov
http://rapidshare.com/files/52704792/M1XL07_P01_C02_L09.mov
http://rapidshare.com/files/52704738/M1XL07_P01_C02_L10.mov
http://rapidshare.com/files/52704775/M1XL07_P01_C02_L11.mov
http://rapidshare.com/files/52704783/M1XL07_P01_C02_L12.mov
http://rapidshare.com/files/52704744/M1XL07_P01_C02_L13.mov
http://rapidshare.com/files/52704751/M1XL07_P01_C02_L14.mov
http://rapidshare.com/files/52704780/M1XL07_P01_C02_L15.mov
http://rapidshare.com/files/52704773/M1XL07_P01_C02_L16.mov
http://rapidshare.com/files/52705040/M1XL07_P01_C03_L00.mov
http://rapidshare.com/files/52705133/M1XL07_P01_C03_L01.mov
http://rapidshare.com/files/52705065/M1XL07_P01_C03_L02.mov
http://rapidshare.com/files/52705107/M1XL07_P01_C03_L03.mov
http://rapidshare.com/files/52705077/M1XL07_P01_C03_L04.mov
http://rapidshare.com/files/52705092/M1XL07_P01_C03_L05.mov
http://rapidshare.com/files/52705067/M1XL07_P01_C03_L06.mov
http://rapidshare.com/files/52705263/M1XL07_P01_C03_L07.mov
http://rapidshare.com/files/52705117/M1XL07_P01_C03_L08.mov
http://rapidshare.com/files/52705071/M1XL07_P01_C03_L09.mov
http://rapidshare.com/files/52705128/M1XL07_P01_C03_L10.mov
http://rapidshare.com/files/52705147/M1XL07_P01_C03_L11.mov
http://rapidshare.com/files/52705202/M1XL07_P01_C03_L12.mov
http://rapidshare.com/files/52705150/M1XL07_P01_C03_L13.mov
http://rapidshare.com/files/52705104/M1XL07_P01_C03_L14.mov
http://rapidshare.com/files/52705085/M1XL07_P01_C03_L15.mov
http://rapidshare.com/files/52705066/M1XL07_P01_C04_L00.mov
http://rapidshare.com/files/52705111/M1XL07_P01_C04_L01.mov
http://rapidshare.com/files/52705108/M1XL07_P01_C04_L02.mov
http://rapidshare.com/files/52705140/M1XL07_P01_C04_L03.mov
http://rapidshare.com/files/52705214/M1XL07_P01_C04_L04.mov
http://rapidshare.com/files/52705139/M1XL07_P01_C04_L05.mov
http://rapidshare.com/files/52705098/M1XL07_P01_C04_L06.mov
http://rapidshare.com/files/52705075/M1XL07_P01_C05_L00.mov
http://rapidshare.com/files/52705166/M1XL07_P01_C05_L01.mov
http://rapidshare.com/files/52705308/M1XL07_P01_C05_L02.mov
http://rapidshare.com/files/52705084/M1XL07_P01_C05_L03.mov
http://rapidshare.com/files/52705283/M1XL07_P01_C05_L04.mov
http://rapidshare.com/files/52705134/M1XL07_P01_C05_L05.mov
http://rapidshare.com/files/52705109/M1XL07_P01_C05_L06.mov
http://rapidshare.com/files/52705151/M1XL07_P01_C05_L07.mov
http://rapidshare.com/files/52705137/M1XL07_P01_C05_L08.mov
http://rapidshare.com/files/52705199/M1XL07_P01_C05_L09.mov
http://rapidshare.com/files/52705174/M1XL07_P01_C05_L10.mov
http://rapidshare.com/files/52705183/M1XL07_P01_C05_L11.mov
http://rapidshare.com/files/52705194/M1XL07_P01_C05_L12.mov
http://rapidshare.com/files/52705125/M1XL07_P01_C05_L13.mov
http://rapidshare.com/files/52705203/M1XL07_P01_C05_L14.mov
http://rapidshare.com/files/52705120/M1XL07_P01_C05_L15.mov
http://rapidshare.com/files/52705178/M1XL07_P01_C05_L16.mov
http://rapidshare.com/files/52705158/M1XL07_P01_C05_L17.mov
http://rapidshare.com/files/52705173/M1XL07_P01_C05_L18.mov
http://rapidshare.com/files/52705123/M1XL07_P01_C05_L19.mov
http://rapidshare.com/files/52705195/M1XL07_P01_C05_L20.mov
http://rapidshare.com/files/52705132/M1XL07_P01_C05_L21.mov
http://rapidshare.com/files/52705113/M1XL07_P01_C06_L00.mov
http://rapidshare.com/files/52705135/M1XL07_P01_C06_L01.mov
http://rapidshare.com/files/52705180/M1XL07_P01_C06_L02.mov
http://rapidshare.com/files/52705130/M1XL07_P01_C06_L03.mov
http://rapidshare.com/files/52705219/M1XL07_P01_C06_L04.mov
http://rapidshare.com/files/52705114/M1XL07_P01_C07_L00.mov
http://rapidshare.com/files/52705129/M1XL07_P01_C07_L01.mov
http://rapidshare.com/files/52705171/M1XL07_P01_C07_L02.mov
http://rapidshare.com/files/52705154/M1XL07_P01_C07_L03.mov
http://rapidshare.com/files/52705205/M1XL07_P01_C07_L04.mov
http://rapidshare.com/files/52705201/M1XL07_P01_C07_L05.mov
http://rapidshare.com/files/52705185/M1XL07_P01_C07_L06.mov
http://rapidshare.com/files/52705229/M1XL07_P01_C07_L07.mov
http://rapidshare.com/files/52705212/M1XL07_P01_C07_L08.mov
تحياتي
أسامه يوسف
TOTAL.TRAINING.ONLINE.MICROSOFT.EXCEL.2007.ADVANCE D
أفضل و أقوى سلسلة شرح لميكروسوفت إكسل 2007 ووظائفه المتقدمه
http://www.totaltraining.com/img/prod/150x150/excel2007_adv.jpg
الكورس عباره عن DVD يحتوي على 6 ساعات كامله شرح فيديو
مقسمه إلى سبعة أقسام
http://www.mrexcel.com/ttibill.jpg
لغة الشرح: الإنجليزيه
تاريخ الإصدار : 3 ديسمبر 2007
ومرفق أيضاً رابط للأمثله و النماذج المستخدمه في الشرح
و طبعاً نظراً لكبر المساحه أنصحكم بتحميل جزء و مشاهدته ثم تحميل التالي و هكذا حتى تنتهي السلسله
راجياً من الله أن ينفعكم به
فقد تعبت كثيراً في إحضاره و الله شهيد على ذلك وكل ما أطلبه منكم هو الدعاء لي بالهدايه
Language......: English
Company.......: Artbeats
Scene Release-Date..: Dec-03-2007
Title..: TOTAL.TRAINING.ONLINE.MICROSOFT.EXCEL.2007.ADVANCE D-ABORTIONSAREFORBABIES
Platform..: Windows
Format..: DVD-ROM & Online
Level...: Intermediate to Advanced
De******ion: Now that you got your feet wet learning the new features in Microsoft Excel 2007
in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to
dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll
be at ease learning some new techniques that will streamline your next data analysis project.
Sit back and discover how to unleash the power of Excel with this in-depth video series.
Running Time: 6 Hrs, 1 DVD
Project Files: Included
Here is the course outline:
Lesson 1: SUMMARIZING DATA (58 min)
* Advanced Subtotals
* Formatting the Subtotal Rows
* Adding and Copying with Subtotals
* Consolidating Data
* Introducing the SUMIF Command
* Working with the SUMIF Command
* Using Array Formulas
* Looking at AutoSum Tricks
* Utilizing Fill Handle Tricks
Lesson 2: WORKING WITH PIVOT TABLES (52 min)
* Creating a Pivot Table
* Rearranging Fields in a Pivot Table
* Explaining the Report Layout Options
* Using the Report Filters Feature
* Using Top 10 & Date Filters
* Handling Blank Cells
* Drilling Down in the Pivot Table
* Sorting a Pivot Table
* Formatting a Pivot Table
* Creating Custom Formats
* Explaining the Grouping Options
* Adding Formulas to a Pivot Table
* Changing a Calculation in a Pivot Table
* Replicating a Pivot Table
* Counting with a Pivot Table
* Using Pivot Charts
Lesson 3: CHARTING IN EXCEL (75 min)
* Charts Refresher
* Moving, Sizing & Copying Charts
* Formatting Charts
* Formatting a Series
* Exploring the Home & Format Ribbons
* Deciding What Chart Format to Use
* Show a Time Series with Column or Line Charts
* Using Combination Charts
* Using Line Chart Accessories
* Using Bar Charts to Show Comparisons
* Using Component Charts
* Using Correlation Charts
* Exploring Other Charts
* Chart Lies Revealed & Advanced Chart Types
* Creating a Custom Layout
Lesson 4: GETTING VISUAL (28 min)
* Using Conditional Formatting
* Using Advanced Conditional Formatting
* Highlighting, Sorting & Filtering Columns
* Using SmartArt Functions
* Using Different SmartArt Graphics
* Embedding a Formula into a Shape
Lesson 5: CREATING POWERFUL FORMULAS (85 min)
* Using Goal Seek to Find an Answer
* Auditing Formulas
* Shrinking the Formula Bar
* Understanding Errors
* Joining Text Columns
* Using Custom Formatting Codes
* Pasting Values
* Using Paste Special
* Breaking Apart Text
* Converting Text to Numbers
* Using Date Functions
* Using Bizarre Date Functions
* Using Exponents
* Using the VLOOKUP Function
* Using Index Match
* Using the Offset Function
* Using the Convert Function
* Looking at Interesting but Obscure Functions
* Using the Rand Function
* Working with Regression
* Ranking & Sorting Formulas
Lesson 6: RECORDING MACROS (18 min)
* Displaying the Developer Tab
* Recording a Simple Macro
* Simplifying the Macro
* Recording Using Relative References
Lesson 7: TIPS & TRICKS (28 min)
*
* Showing Off New Tips in Excel 2007
* Tips for Handling Worksheets
* Using Excel as a Word Processor
* Miscellaneous Tips
* Validating Data
* Changing Text Entry Direction
* Using Speak Cells
* Final Comments & Credits
معلومات أكثر
http://www.totaltraining.com/prod/mi...el2007_adv.asp
الأمثله التطبيقيه المستخدمه في الشرح
http://rapidshare.com/files/52705919/TT_Advanced_Excel2007_PF.zip
روابط التحميل على الرابيدشير
http://rapidshare.com/files/52704739/M1XL07_P01_C01_L00.mov
http://rapidshare.com/files/52704854/M1XL07_P01_C01_L01.mov
http://rapidshare.com/files/52704790/M1XL07_P01_C01_L02.mov
http://rapidshare.com/files/52704772/M1XL07_P01_C01_L03.mov
http://rapidshare.com/files/52704759/M1XL07_P01_C01_L04.mov
http://rapidshare.com/files/52704762/M1XL07_P01_C01_L05.mov
http://rapidshare.com/files/52704760/M1XL07_P01_C01_L06.mov
http://rapidshare.com/files/52704848/M1XL07_P01_C01_L07.mov
http://rapidshare.com/files/52704771/M1XL07_P01_C01_L08.mov
http://rapidshare.com/files/52704768/M1XL07_P01_C01_L09.mov
http://rapidshare.com/files/52704726/M1XL07_P01_C02_L00.mov
http://rapidshare.com/files/52704745/M1XL07_P01_C02_L01.mov
http://rapidshare.com/files/52704747/M1XL07_P01_C02_L02.mov
http://rapidshare.com/files/52704794/M1XL07_P01_C02_L03.mov
http://rapidshare.com/files/52704843/M1XL07_P01_C02_L04.mov
http://rapidshare.com/files/52704799/M1XL07_P01_C02_L05.mov
http://rapidshare.com/files/52704812/M1XL07_P01_C02_L06.mov
http://rapidshare.com/files/52704752/M1XL07_P01_C02_L07.mov
http://rapidshare.com/files/52704764/M1XL07_P01_C02_L08.mov
http://rapidshare.com/files/52704792/M1XL07_P01_C02_L09.mov
http://rapidshare.com/files/52704738/M1XL07_P01_C02_L10.mov
http://rapidshare.com/files/52704775/M1XL07_P01_C02_L11.mov
http://rapidshare.com/files/52704783/M1XL07_P01_C02_L12.mov
http://rapidshare.com/files/52704744/M1XL07_P01_C02_L13.mov
http://rapidshare.com/files/52704751/M1XL07_P01_C02_L14.mov
http://rapidshare.com/files/52704780/M1XL07_P01_C02_L15.mov
http://rapidshare.com/files/52704773/M1XL07_P01_C02_L16.mov
http://rapidshare.com/files/52705040/M1XL07_P01_C03_L00.mov
http://rapidshare.com/files/52705133/M1XL07_P01_C03_L01.mov
http://rapidshare.com/files/52705065/M1XL07_P01_C03_L02.mov
http://rapidshare.com/files/52705107/M1XL07_P01_C03_L03.mov
http://rapidshare.com/files/52705077/M1XL07_P01_C03_L04.mov
http://rapidshare.com/files/52705092/M1XL07_P01_C03_L05.mov
http://rapidshare.com/files/52705067/M1XL07_P01_C03_L06.mov
http://rapidshare.com/files/52705263/M1XL07_P01_C03_L07.mov
http://rapidshare.com/files/52705117/M1XL07_P01_C03_L08.mov
http://rapidshare.com/files/52705071/M1XL07_P01_C03_L09.mov
http://rapidshare.com/files/52705128/M1XL07_P01_C03_L10.mov
http://rapidshare.com/files/52705147/M1XL07_P01_C03_L11.mov
http://rapidshare.com/files/52705202/M1XL07_P01_C03_L12.mov
http://rapidshare.com/files/52705150/M1XL07_P01_C03_L13.mov
http://rapidshare.com/files/52705104/M1XL07_P01_C03_L14.mov
http://rapidshare.com/files/52705085/M1XL07_P01_C03_L15.mov
http://rapidshare.com/files/52705066/M1XL07_P01_C04_L00.mov
http://rapidshare.com/files/52705111/M1XL07_P01_C04_L01.mov
http://rapidshare.com/files/52705108/M1XL07_P01_C04_L02.mov
http://rapidshare.com/files/52705140/M1XL07_P01_C04_L03.mov
http://rapidshare.com/files/52705214/M1XL07_P01_C04_L04.mov
http://rapidshare.com/files/52705139/M1XL07_P01_C04_L05.mov
http://rapidshare.com/files/52705098/M1XL07_P01_C04_L06.mov
http://rapidshare.com/files/52705075/M1XL07_P01_C05_L00.mov
http://rapidshare.com/files/52705166/M1XL07_P01_C05_L01.mov
http://rapidshare.com/files/52705308/M1XL07_P01_C05_L02.mov
http://rapidshare.com/files/52705084/M1XL07_P01_C05_L03.mov
http://rapidshare.com/files/52705283/M1XL07_P01_C05_L04.mov
http://rapidshare.com/files/52705134/M1XL07_P01_C05_L05.mov
http://rapidshare.com/files/52705109/M1XL07_P01_C05_L06.mov
http://rapidshare.com/files/52705151/M1XL07_P01_C05_L07.mov
http://rapidshare.com/files/52705137/M1XL07_P01_C05_L08.mov
http://rapidshare.com/files/52705199/M1XL07_P01_C05_L09.mov
http://rapidshare.com/files/52705174/M1XL07_P01_C05_L10.mov
http://rapidshare.com/files/52705183/M1XL07_P01_C05_L11.mov
http://rapidshare.com/files/52705194/M1XL07_P01_C05_L12.mov
http://rapidshare.com/files/52705125/M1XL07_P01_C05_L13.mov
http://rapidshare.com/files/52705203/M1XL07_P01_C05_L14.mov
http://rapidshare.com/files/52705120/M1XL07_P01_C05_L15.mov
http://rapidshare.com/files/52705178/M1XL07_P01_C05_L16.mov
http://rapidshare.com/files/52705158/M1XL07_P01_C05_L17.mov
http://rapidshare.com/files/52705173/M1XL07_P01_C05_L18.mov
http://rapidshare.com/files/52705123/M1XL07_P01_C05_L19.mov
http://rapidshare.com/files/52705195/M1XL07_P01_C05_L20.mov
http://rapidshare.com/files/52705132/M1XL07_P01_C05_L21.mov
http://rapidshare.com/files/52705113/M1XL07_P01_C06_L00.mov
http://rapidshare.com/files/52705135/M1XL07_P01_C06_L01.mov
http://rapidshare.com/files/52705180/M1XL07_P01_C06_L02.mov
http://rapidshare.com/files/52705130/M1XL07_P01_C06_L03.mov
http://rapidshare.com/files/52705219/M1XL07_P01_C06_L04.mov
http://rapidshare.com/files/52705114/M1XL07_P01_C07_L00.mov
http://rapidshare.com/files/52705129/M1XL07_P01_C07_L01.mov
http://rapidshare.com/files/52705171/M1XL07_P01_C07_L02.mov
http://rapidshare.com/files/52705154/M1XL07_P01_C07_L03.mov
http://rapidshare.com/files/52705205/M1XL07_P01_C07_L04.mov
http://rapidshare.com/files/52705201/M1XL07_P01_C07_L05.mov
http://rapidshare.com/files/52705185/M1XL07_P01_C07_L06.mov
http://rapidshare.com/files/52705229/M1XL07_P01_C07_L07.mov
http://rapidshare.com/files/52705212/M1XL07_P01_C07_L08.mov
تحياتي
أسامه يوسف