Mac

DVD Converter

Audio

Personal Info Managers

Excel Level 3 & Excel VBA & Excel UserForm Courses
We are not just Excel teachers, but also Excel developers!
Download Now

Classic Menu for Excel
Show the menus and toolbars in Excel 2007
Download Now

AnalyzerXL Package
Stock trading in MS Excell!
Download Now

Complete Excel Course
Excel Levels 1, 2, 3 VBA and UserForms Courses.
Download Now

Excel VBA Level 1 and Excel UserForms
Excel VBA Training Level 1 and Excel UserForms and Controls.
Download Now

Excel Training - Video Series

Publisher : an01digitalservices
Date added : 01-Jun-2009
Rating :

File size : Unknown
Language : English
License : Shareware - Time Limit
Price : $ 67.00
OS : Windows 98/NT/2000/ME/XP/VISTA
UpdateDate : 03-Jun-2009
Requirements : No special requirements

shareware-order, Excel Training - Video Series downloads

Excel Training - Video Series's Information

See How Easy it is to Learn Excel!!!
* Are you struggling to Learn Excel?
* Are you busy enough to not spend your time reading Excel books?
* Do you want to learn Excel to better contribute your existing job/work?
* Do you want to show your Excel skills like a pro in the next interview?
* Would you want to Learn Excel in a weekend?
If the answer to all/any of the question above is 'Yes' then this course is for you.

A series of 12 Lessons covering the most used Excel topics to make learning Excel very easy for you. These Video tutorials are a result of a 20 years of collective experience and covers all the topics here which should help you move on with Excel and become an intermediate level user of Excel.

Video Contents Index

(Those in Blue are sample Videos)

Part 1. Basic Introduction

1. What's new in 20072. The Ribbon Menu3. The Office Button 5. Keyboard Shortcuts

Part 2: First Excel File

1. Creating Excel Files2. Cells, Rows and Columns3. Entering Data4. Saving Files

Part 3: Working with Worksheets

1. Add, Delete and Rename2. Tab Colors3. Split Windows/Freeze Panes4. Hide and Unhide5. Protect and Un-Protect6. Working with Shapes

Part 4: Cell Formats and Options

1. Height and Width of Rows & Columns2. Types of data3. Align and Indent4. Font Options5. Hyperlinks6. Context Menu7. Insert, Delete and move columns, rows & Cells8. Cut, Copy and Paste9. Paste Special10. Clipboard11. Cell Borders12. Merge Cells13. Wrap Text

Part 5: More on Formatting

1. Conditional Formatting2. Data Validation3. Naming Ranges4. Special Characters5. Format Painter

Part 6: Formulas and Functions

1. Relative and Absolute Cell References2. Other Sheets references3. Functions4. Function Examples

Part 7: Dealing with Data

1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data

Part 8: Finalizing the Workbook

1. Check Spellings2. Cell Comments3. Hide Worksheets4. Find and Replace5. Lock and Unlock Cells

Part 9: Printing Your Workbook

1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks

Part 10: Charts and Labels

Part 11: Pivot Tables

1. Build2. Options

Excel Training - Video Series's Screenshot

Excel Training - Video Series's Related Search

Web	www.sharewareorder.com
www.globalshareware.com	www.downloadrating.com

Excel Training - Video Series's Reviews

No opinions. Be the first!

More Products from Excel Training - Video Series's Company

1.Excel Training - Video Series 01/Jun/2009

Rating :

See How Easy it is to Learn Excel!!! * Are you struggling to Learn Excel? * Are you busy enough to not spend your time reading Excel books? * Do you want to learn Excel to better contribute your existing job/work? * Do you want to show your Excel skills like a pro in the next interview? * Would you want to Learn Excel in a weekend? If the answer to all/any of the question above is 'Yes' then this course is for you. A series of 12 Lessons covering the most used Excel topics to make learning Excel very easy for you. These Video tutorials are a result of a 20 years of collective experience and covers all the topics here which should help you move on with Excel and become an intermediate level user of Excel. Video Contents Index (Those in Blue are sample Videos) Part 1. Basic Introduction 1. What's new in 20072. The Ribbon Menu3. The Office Button 5. Keyboard Shortcuts Part 2: First Excel File 1. Creating Excel Files2. Cells, Rows and Columns3. Entering Data4. Saving Files Part 3: Working with Worksheets 1. Add, Delete and Rename2. Tab Colors3. Split Windows/Freeze Panes4. Hide and Unhide5. Protect and Un-Protect6. Working with Shapes Part 4: Cell Formats and Options 1. Height and Width of Rows & Columns2. Types of data3. Align and Indent4. Font Options5. Hyperlinks6. Context Menu7. Insert, Delete and move columns, rows & Cells8. Cut, Copy and Paste9. Paste Special10. Clipboard11. Cell Borders12. Merge Cells13. Wrap Text Part 5: More on Formatting 1. Conditional Formatting2. Data Validation3. Naming Ranges4. Special Characters5. Format Painter Part 6: Formulas and Functions 1. Relative and Absolute Cell References2. Other Sheets references3. Functions4. Function Examples Part 7: Dealing with Data 1. Importing Data2. Text to Columns3. Duplicate Data4. Sort & Filter Data Part 8: Finalizing the Workbook 1. Check Spellings2. Cell Comments3. Hide Worksheets4. Find and Replace5. Lock and Unlock Cells Part 9: Printing Your Workbook 1. Print Ranges2. Margins3. Shrink to Fit4. Header/Footer5. Page Breaks Part 10: Charts and Labels Part 11: Pivot Tables 1. Build2. Options

2.NPV Caculator 14/Jun/2009

Rating :

This, one sheet Excel workbook will let you understand and help you make an NPV model in Excel. It takes "Equipment" as an example to demonstrate NPV model, however this can be changed as per your needs. This Template is accompanied by a PDF document which will help you undertand and implement NPV and IRR calculations in Excel. After studying the document you will be able to * Explain the concept of Time Value of Money * Calculate the present value and future value of a stream of cash flows using excel * Explain the types of cash flows encountered in financial analysis, and how to adjust for each type in making time value calculations in Excel. * Differentiate between the alternative compounding periods, and use Excel to compare present and future values under different compounding schemes. The template is unprotected, to make sure you can make appropriate changes. The workbook and the document comes with a nominal cost of $15 and will work with Microsoft Excel Version 2002 onwards and any PDF reader.

3.Price Elasticity of Demand Calculator 14/Jun/2009

Rating :

The Price Elasticity of Demand (commonly known as just price elasticity) measures the rate of response of quantity demanded due to a price change. The formula for the Price Elasticity of Demand (PEoD) is: PEoD = (% Change in Quantity Demanded)/(% Change in Price)

4.Google Translate(TM) for Excel® 18/Feb/2011

Rating :

This Add-in adds a Custom Function in your Excel® along with other built in functions which will help you easily translate text of strings from one language to other. The function is very easy to use, and is used as any other Excel® function. There is a help file also available with this addin which details the various Languages that ca be converted using this add-in and the respective language codes. This Add-in uses the Google Translate(TM) translation service API for translation. This add-n is available to be downloaded for free. Give it a try and translate your workbook text into the language of your choice with ease. Use this function as any other default function in MS Excel.

5.Easy Excel® to PDF 20/Mar/2011

Rating :

Are you tired of complicated and expensive software that have too many settings to configure before you can produce a nice looking PDF from your Excel® files? Easy Excel to PDF lets you convert Microsoft® Excel® Workbooks, individual Excel® Sheets and the selected ranges to PDF documents with a few simple clicks. This Add-in for Excel® gets embedded into your Excel® so do not need to launch any other windows based software. The Add-in works with the Active Workbook of you Excel® Application and all you need to do is to browse to the location where you like the PDF files to be generated. The software automatically works out the PDF files names, the margins of the PDF files, the alignments, the orientation etc as per the content of your Excel® Workbook. This add-in comes with a 15 day free trial for the functionality so so can try before you buy the software. Also, because the objective of things here is to make things easy, this addin is very reasonably priced so its easy on your pocket as well. Also, you can check for regular updates through the software itself and all new updates will be automatically updated. Please note that this application works with all versions of Excel® including Excel® 2010. The conversion happens only with .XLS files, however the software assists you to save your files to .XLS extensions before producing PDFs. Features: * Full font and text formatting: colors, face, size, bold, italic, underline, strike, superscript, subscript * Export of spreadsheets with borders to PDF table preserving colors, line type and background * Hyperlinks and ancors * Special characters * Multiple worksheets * Various cell types: strings, numbers, dates, floating point * Merged cells, row and cell width and height * Formulas * XLS files protected by password * Export Excels files and streams to PDF files and streams

Excel Training - Video Series Download