mata podi support ekak denna

ange88 · 11:25 AM

mata microsoft exel igena ganna kawruhari e-book ekak hari ,video tutorial ekak denawada?? please

cj4ever · 09-28-2009, 10:34 PM

Teach Yourself Visually - Excel 2007

Description:

Quote:

Are you a visual learner?

Do you prefer instructions that show you how to do something - and skip the long-winded explanations?
If so, then this book is for you.
Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks.

Each task-based spread includes easy, visual directions for performing necessary operations, including:

* Using the Ribbon and galleries

* Entering data and resizing columns

* Applying formulas and functions

* Formatting worksheets

* Adding clip art and 3D effects

* Interpreting data with charts

* Helpful sidebars offer practical tips and tricks

* Succinct explanations walk you through step by step

* Full-color screen shots demonstrate each task

* Two-page lessons break big topics into bite-sized modules

Size: 52MB

Download Links:

Code:

http://hotfile.com/dl/12971397/c109a37/Teach_Yourself_Visually_-_Excel_2007.rar.html

All my files are scanned with Kaspersky Internet Security 2010 before uploaded.

Malinga · 09-28-2009, 10:36 PM

http://www.ebookee.com/

oya site eke search karanna. godak ebooks ai. ehema naththum oyaata Video Tutorial download karagena balannath puluvan.

ange88 · 09-29-2009, 11:25 AM

thanx friends,but i need a video tutorial

kasun1986 · 09-29-2009, 11:31 AM

Book Description

Author: Curtis D. Frye
Publisher: Microsoft Press
ISBN: 073562304X
Size: 30.6 MB

Excel provides an easy-to-use, powerful spreadsheet environment that helps you handle calculations and data more effectively. With Microsoft Office Excel 2007 Step by Step, youll learn all the ins and outs of working with Excel features, including the exciting new interface for this latest version of Office. This information-packed guide provides numbered steps and hands-on examples that show you how to get the most out of Excel. With this book, youll learn how to work with tools to make worksheet entry faster, make your Excel documents more attractive, present information visually with charts, sorting and filtering data, publish documents on the Web, and lots more. The companion CD provides all exercise source files so that you get hands-on with Excel right away.

Download

Code:

http://rapidshare.com/files/81990207/sbs_excel_2007.rar

kasun1986 · 09-29-2009, 11:32 AM

Microsoft Office Excel 2007 Bible

PDF | 914 Pages | 23 MB

Code:

http://rapidshare.com/files/206961856/Microsoft_Office_Excel_2007_Bible.rar

kasun1986 · 09-29-2009, 11:33 AM

VTC Microsoft Excel 2007 - CFE - Video Tutorial

Code:

http://rapidshare.com/files/183085398/VTC.Microsoft.Excel.2007-CFE.part1.rar
http://rapidshare.com/files/183093956/VTC.Microsoft.Excel.2007-CFE.part2.rar
http://rapidshare.com/files/183097556/VTC.Microsoft.Excel.2007-CFE.part3.rar
http://rapidshare.com/files/183101313/VTC.Microsoft.Excel.2007-CFE.part4.rar
http://rapidshare.com/files/183105494/VTC.Microsoft.Excel.2007-CFE.part5.rar
http://rapidshare.com/files/183105961/VTC.Microsoft.Excel.2007-CFE.part6.rar

kasun1986 · 09-29-2009, 11:34 AM

Total Training for Microsoft Excel 2007 Advanced

Title: Microsoft Excel 2007 Advanced
Category: Communication & Office Tools
Presenter: Bill Jelen
Platform: Windows
Format: DVD-ROM
Running Time: 6 Hrs, 1 DVD
Level: Intermediate to Advanced
Project Files: Included

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.

Lesson 1: SUMMARIZING DATA (58 min)
1. Advanced Subtotals
2. Formatting the Subtotal Rows
3. Adding and Copying with Subtotals
4. Consolidating Data
5. Introducing the SUMIF Command
6. Working with the SUMIF Command
7. Using Array Formulas
8. Looking at AutoSum Tricks
9. Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES (52 min)
1. Creating a Pivot Table
2. Rearranging Fields in a Pivot Table
3. Explaining the Report Layout Options
4. Using the Report Filters Feature
5. Using Top 10 & Date Filters
6. Handling Blank Cells
7. Drilling Down in the Pivot Table
8. Sorting a Pivot Table
9. Formatting a Pivot Table
10. Creating Custom Formats
11. Explaining the Grouping Options
12. Adding Formulas to a Pivot Table
13. Changing a Calculation in a Pivot Table
14. Replicating a Pivot Table
15. Counting with a Pivot Table
16. Using Pivot Charts

Lesson 3: CHARTING IN EXCEL (75 min)
1. Charts Refresher
2. Moving, Sizing & Copying Charts
3. Formatting Charts
4. Formatting a Series
5. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
7. Show a Time Series with Column or Line Charts
8. Using Combination Charts
9. Using Line Chart Accessories
10. Using Bar Charts to Show Comparisons
11. Using Component Charts
12. Using Correlation Charts
13. Exploring Other Charts
14. Chart Lies Revealed & Advanced Chart Types
15. Creating a Custom Layout

Lesson 4: GETTING VISUAL (28 min)
1. Using Conditional Formatting
2. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
4. Using SmartArt Functions
5. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS (85 min)
1. Using Goal Seek to Find an Answer
2. Auditing Formulas
3. Shrinking the Formula Bar
4. Understanding Errors
5. Joining Text Columns
6. Using Custom Formatting Codes
7. Pasting Values
8. Using Paste Special
9. Breaking Apart Text
10. Converting Text to Numbers
11. Using Date Functions
12. Using Bizarre Date Functions
13. Using Exponents
14. Using the VLOOKUP Function
15. Using Index Match
16. Using the Offset Function
17. Using the Convert Function
18. Looking at Interesting but Obscure Functions
19. Using the Rand Function
20. Working with Regression
21. Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS (18 min)
1. Displaying the Developer Tab
2. Recording a Simple Macro
3. Simplifying the Macro
4. Recording Using Relative References

Lesson 7: TIPS & TRICKS (28 min)
1. Showing Off New Tips in Excel 2007
2. Tips for Handling Worksheets
3. Using Excel as a Word Processor
4. Miscellaneous Tips
5. Validating Data
6. Changing Text Entry Direction
7. Using Speak Cells
8. Final Comments & Credits

Download:

Code:

http://rapidshare.com/files/165883412/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part01.rar
http://rapidshare.com/files/165883406/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part02.rar
http://rapidshare.com/files/165883386/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part03.rar
http://rapidshare.com/files/165883541/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part04.rar
http://rapidshare.com/files/165883326/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part05.rar
http://rapidshare.com/files/165883434/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part06.rar
http://rapidshare.com/files/165883349/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part07.rar
http://rapidshare.com/files/165883490/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part08.rar
http://rapidshare.com/files/165882665/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part09.rar

Pass:

Code:

www.oxava.com

ange88 · 09-29-2009, 05:26 PM

tanx kasun