شروحات فديو لأهم خصائص الاكسل لشركة "Lynda"

Making important information presentable is what sets successful business reports and presentations apart from staid, unintelligible data. In Excel 2007: Formatting Data, author Dennis Taylor shares simple and powerful tips for making information readable and understandable, including automation techniques that take the drudgery out of formatting even the largest amounts of data. This course covers techniques for accentuating and emphasizing specific cells and adding style and readability to worksheets. Exercise files accompany this course.

Course Contents

Introduction

Welcome

Using the exercise files

1.Numeric Formatting Tools: Adjusting Numeric Formats Quickly

Working with the Numeric Formatting options

Learning the important formatting keystroke shortcuts

Setting special formats for dates, times, phone numbers, fractions, etc.

Building custom numeric formats

Building custom date formats

2.Fonts, Borders, and Cell Colors: Controlling Display Features

Applying and adjusting fonts and font colors

Adding custom formats with font color variations

Applying underline, strikethrough, subscript, and superscript formatting

Applying border styles and adjusting gridlines

Using fill color and patterns for cell backgrounds

3.Alignment Tools

Adjusting horizontal and vertical cell alignment

Creating angled text variations for greater variety and readability

Indenting data and dollar signs 02:27 3.1 MB

Simplifying title adjustments with the versatile Merge and Center commands

Controlling titles and headings with the Wrap Text and Shrink to Fit options

4.Other Valuable Formatting Tools

Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar

Applying different formatting styles within the same cell

Copying formats quickly with dragging techniques and the Format Painter

Formatting text from Word or the web with the Justify feature

Adding a background image to a worksheet

5.Row, Column, and Sheet Adjustments

Adjusting single and multiple row heights and column widths without commands

Working with rows, columns, and sheets

Working with the Hide/Unhide options

6.Displaying Data as an Outline

Setting up data for outlining

Using outlining symbols and levels

7.Essential Data Visualization Tools: Tables, Themes, Styles, and More

Converting data into a table and reformatting

Applying combinations of formats for selected cells

Setting themes for workbook-wide adjustments of colors, fonts, and effects

Understanding the options in Shape formatting

Fine-tuning shape effects

Learning the WordArt essentials for titles and headings

8.Adding Stunning Visual Effects to Pictures

Converting a chart to a picture and adding new images

Applying picture styles in a flash for added flair

Applying picture shapes and borders

9.Conditional Formatting: A Dynamic and Powerful Way to Accentuate Data

Creating value-based formatting using logical operators

Creating value-based formatting using data bars and color scales

Creating formats based on formulas

10.Specialized Power Formatting Techniques

Hiding repeating titles in a column to clarify printed output

Restoring missing title data in a column

Displaying large values without using formulas

Creating Elbow formatting to show row/column headings in the same cell

Removing the hyperlink attribute from multiple cells

Formatting a list for double-spaced printing

والروابط كتالي

http://hotfile.com/dl/33737593/9b2b051/LDCEXCL2007FMDRONiSO.part1.rar.html

http://hotfile.com/dl/33737107/b4ff36d/LDCEXCL2007FMDRONiSO.part2.rar.html

http://hotfile.com/dl/33737152/b1eb5c0/LDCEXCL2007FMDRONiSO.part3.rar.html

http://hotfile.com/dl/33737657/75aa839/LDCEXCL2007FMDRONiSO.part4.rar.html

او

http://rapidshare.com/files/365921985/LDCEXCL2007FMDRONiSO.part1.rar

http://rapidshare.com/files/365919801/LDCEXCL2007FMDRONiSO.part2.rar

http://rapidshare.com/files/365921937/LDCEXCL2007FMDRONiSO.part3.rar

http://rapidshare.com/files/365919607/LDCEXCL2007FMDRONiSO.part4.rar

3- Excel.2007.Pivot.Tables.For.Data.Analysis.Training-iRONiSO

والروابط كتالي

http://rapidshare.com/files/303350927/Lynda.com.Excel.2007.Pivot.Tables.For.Data.Analysis.Training-iRONiSO.rar

او

http://hotfile.com/dl/16832278/1b563c5/Lynda.com.Excel.2007.Pivot.Tables.For.Data.Analysis.Training-iRONiSO.rar.html

4- Using Microsoft Excel For Data Analysis (استخدام الاكسل لتحليل البيانات)

محتوى السيدي

This CD-ROM covers the essential elements of Excel for the analysis of business problems, with narrated live action screen videos, and supplementary exercises for the students to complete to cement the ideas. Its 9 modules each cover a different aspect of the use of Excel, starting from the ground up. Topics include using the Excel menus, data tables, using the solver, graphing, using spreadsheets for basic statistics, regression, and using pivot tables for complex data sets.

والروابط كتالي

http://hotfile.com/dl/24550711/be8c50e/h-eeufadm.part1.rar.html

http://hotfile.com/dl/24550770/1a666f4/h-eeufadm.part2.rar.html

http://hotfile.com/dl/24550801/f288730/h-eeufadm.part3.rar.html

http://hotfile.com/dl/24550914/53e30cd/h-eeufadm.part4.rar.html

http://hotfile.com/dl/24551085/25edf60/h-eeufadm.part5.rar.html

http://hotfile.com/dl/24551127/9d67c89/h-eeufadm.part6.rar.html

http://hotfile.com/dl/24551136/51f3c2a/h-eeufadm.part7.rar.html

او

http://rapidshare.com/files/336625757/h-eeufadm.part1.rar

http://rapidshare.com/files/336625913/h-eeufadm.part2.rar

http://rapidshare.com/files/336625943/h-eeufadm.part3.rar

http://rapidshare.com/files/336625715/h-eeufadm.part4.rar

http://rapidshare.com/files/336625724/h-eeufadm.part5.rar

http://rapidshare.com/files/336626046/h-eeufadm.part6.rar

http://rapidshare.com/files/336623782/h-eeufadm.part7.rar

او

http://uploading.com/files/433de913/h-eeufadm.part1.rar/

http://uploading.com/files/d6b26cm5/h-eeufadm.part2.rar/

http://uploading.com/files/c5748626/h-eeufadm.part3.rar/

http://uploading.com/files/dbadecfe/h-eeufadm.part4.rar/

http://uploading.com/files/497167fa/h-eeufadm.part5.rar/

http://uploading.com/files/a91b1c5f/h-eeufadm.part6.rar/

http://uploading.com/files/96a65c6m/h-eeufadm.part7.rar/

5- Excel 2007 Essential Training أكسل 2007 التدريبات الاساسية

وصف الدروس

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data.

Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

الروابط

http://hotfile.com/dl/21792039/be8e5e8/LcE2007ET.3613761.part1.rar

http://hotfile.com/dl/21792118/2b09f60/LcE2007ET.3613761.part2.rar

http://hotfile.com/dl/21792233/61d11a5/LcE2007ET.3613761.part3.rar

http://hotfile.com/dl/21792329/0fd21b2/LcE2007ET.3613761.part4.rar

او

http://rapidshare.com/files/325658940/LcE2007ET.3613761.part1.rar

http://rapidshare.com/files/325659006/LcE2007ET.3613761.part2.rar

http://rapidshare.com/files/325659045/LcE2007ET.3613761.part3.rar

http://rapidshare.com/files/325658945/LcE2007ET.3613761.part4.rar

6- Microsoft Excel 2007 Financial Analysis

وصف الدروس

Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.

الروابط

http://www.filefactory.com/file/ah3335g/n/Lynda_com_Microsoft_Excel_2007_Financial_Analysis-iNKiSO_part1_rar

http://www.filefactory.com/file/ah33340/n/Lynda_com_Microsoft_Excel_2007_Financial_Analysis-iNKiSO_part2_rar

او

http://hotfile.com/dl/10867119/525469c/Lynda.com.Microsoft.Excel.2007.Financial.Analysis-iNKiSO.part1.rar.html

http://hotfile.com/dl/10867118/20aab61/Lynda.com.Microsoft.Excel.2007.Financial.Analysis-iNKiSO.part2.rar.html

او

http://rapidshare.com/files/271533744/Lynda.com.Microsoft.Excel.2007.Financial.Analysis-iNKiSO.part1.rar

http://rapidshare.com/files/271533566/Lynda.com.Microsoft.Excel.2007.Financial.Analysis-iNKiSO.part2.rar

7- VTC Microsoft Excel 2007 Tutorials

وصف الدرس

Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to create, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included. To get started learning Microsoft Excel 2007, click on one of the movie links below.

الروابط

http://rapidshare.com/files/311431918/turkovtc_ME2007T.part1.rar

http://rapidshare.com/files/311435776/turkovtc_ME2007T.part2.rar

http://rapidshare.com/files/311437180/turkovtc_ME2007T.part3.rar

http://rapidshare.com/files/311446250/turkovtc_ME2007T.part4.rar

http://rapidshare.com/files/311451294/turkovtc_ME2007T.part5.rar

8- Microsoft Excel 2007 Power Shortcut

الروابط

http://rapidshare.com/files/308603404/i-lynmexc7pws.part1.rar

http://rapidshare.com/files/308601507/i-lynmexc7pws.part2.rar

او

http://kewlshare.com/dl/85fb958d0808/i-lynmexc7pws.part1.rar.html

http://kewlshare.com/dl/8f430766be1d/i-lynmexc7pws.part2.rar.html

9- Microsoft Excel 2007 Advanced Formulas And Functions

شرح المحتوى

In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course.

الروابط

http://rapidshare.com/files/312897132/KiemCun.ME7.part1.rar.html

http://rapidshare.com/files/312900163/KiemCun.ME7.part2.rar.html

http://rapidshare.com/files/312897991/KiemCun.ME7.part3.rar.html

http://rapidshare.com/files/312897870/KiemCun.ME7.sfv.html

10 - Train Signal Microsoft Excel 2007 DVD

شرح المحتوى

Learn All of the Simple Tools & Techniques Used By Professionals to Increase Productivity, Enhance Efficiency and Improve Business Analysis and Reporting! Whether you're tracking expenses, budgeting goals or creating massive keyword lists with one million rows, the new Microsoft Excel 2007 will streamline your workflow like never before. And thanks to Train Signal's newest Excel 2007 course, you'll master all of those time saving features, and business building tools in no time. No stone is left unturned as we break down common to advanced concepts into easy, hands on lessons! We are so convinced that this course is the most comprehensive Excel 2007 training on the market, that we guarantee your satisfaction for 90 days! And if certification is your goal, rest assured that this course will help you pass the 77-602 MCAS Exam!

الروابط

http://www.filefactory.com/file/a0fg9ca/n/TSME2007D_part01_rar

http://www.filefactory.com/file/a0fg9b9/n/TSME2007D_part02_rar

http://www.filefactory.com/file/a0fg9cf/n/TSME2007D_part03_rar

http://www.filefactory.com/file/a0fg9b8/n/TSME2007D_part04_rar

http://www.filefactory.com/file/a0fg972/n/TSME2007D_part05_rar

http://www.filefactory.com/file/a0fg9dh/n/TSME2007D_part06_rar

http://www.filefactory.com/file/a0fg9c6/n/TSME2007D_part07_rar

http://www.filefactory.com/file/a0fg9ef/n/TSME2007D_part08_rar

http://www.filefactory.com/file/a0fg9fg/n/TSME2007D_part09_rar

http://www.filefactory.com/file/a0fg9ff/n/TSME2007D_part10_rar

http://www.filefactory.com/file/a0fg9fh/n/TSME2007D_part11_rar