1) Lynda.com Excel 2007 Essential TrainingEnglish | .mov | 490Mb
Genre: eLearningLike 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.
Download:-
Filesonic 1 Filesonic 2 Filesonic 3Filesonic 4Filesonic 52) Lynda.com Excel 2007 Introduction To Formulas And FunctionsEnglish | .mov | 165Mb
Genre: eLearningUsing the exercise files1.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
Download:-
Filesonic 1 Filesonic 23) Lynda.com Excel 2007 Creating Charts with Dynamic DataEnglish | .bin | 65.1Mb
Genre: eLearningExcel 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.
Download:-
Filesonic4) Lynda.com Excel 2007 Creating and Managing InvoicesEnglish | .bin | 66.7Mb
Genre: eLearningIn 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.
Download:-
Filesonic5) Lynda.com Excel.2007 Advanced Formulas And FunctionsEnglish | .mov | 373Mb
Genre: eLearningIn 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.
Download:-
Filesonic 1 Filesonic 2 Filesonic 3Filesonic 4
*Note: For .Bin file type please unrar and burn it into CD/DVD
