Excel 2007 (Microsoft) - Tutorials & Training Collection

MS Excel 2007 Tutorials & Training Collection






1) Lynda.com Excel 2007 Essential Training

English | .mov | 490Mb
Genre: eLearning

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.


If you like my post, please show your appreciation a simple "Thanks" is enough for me..
And THANKS for Download my upload





2) Lynda.com Excel 2007 Introduction To Formulas And Functions

English | .mov | 165Mb
Genre: eLearning

Using the exercise files
1.Introducing Excel 2007 Functions and Formulas
2.Creating Basic Summary Formulas
3.Sorting and Filtering PivotTable Data
4.Preparing Data for Analysis in Excel
5.Auditing Worksheet Formulas
6.Performing What-If Analysis


If you like my post, please show your appreciation a simple "Thanks" is enough for me..
And THANKS for Download my upload





3) Lynda.com Excel 2007 Creating Charts with Dynamic Data

English | .bin | 65.1Mb
Genre: eLearning

Excel 2007: Creating Charts with Dynamic Data shows how simple data in Excel can be used to build exciting and updatable charts. Microsoft Most Valuable Professional Curt Frye explains how to use both named ranges and Excel tables to create charts that adjust as the data changes. Curt demonstrates how to specify the number of points in a chart and how to use a drop-down list to select which data series is displayed. Finally, he shows how to use PivotChart reports to reorganize and visualize data on the fly. Exercise files accompany the course


If you like my post, please show your appreciation a simple "Thanks" is enough for me..
And THANKS for Download my upload





4) Lynda.com Excel 2007 Creating and Managing Invoices

English | .bin | 66.7Mb
Genre: eLearning

In Excel 2007: Creating and Managing Invoices, Microsoft Most Valuable Professional Curt Frye shows how to set up an efficient and flexible invoice management system. As part of the instruction on how to design a custom invoice in Excel, Curt explains how to use a PivotTable to put each customer's information on its own worksheet. If Word is the preferred method for creating an invoice, Curt covers how to use Word 2007's Mail Merge function to work with an Excel sheet. He also outlines some advanced tips, including calculating interest on unpaid items and tracking invoices. Exercise files accompany the course.


If you like my post, please show your appreciation a simple "Thanks" is enough for me..
And THANKS for Download my upload





5) Lynda.com Excel.2007 Advanced Formulas And Functions

English | .mov | 373Mb
Genre: eLearning

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.


Note: For .Bin file type please unrar and burn it into CD/DVD

If you like my post, please show your appreciation a simple "Thanks" is enough for me..
And THANKS for Download my upload