MS Excel 2007 Tutorials & Training Collection
Results 1 to 1 of 1
  1. #1
    Admin
    ~IronMan~'s Avatar
    Member InfoShowcaseActivity StatusThanks / Tagging Info
    join date|Join Date
    Nov 2006
    location|Location
    At Home
    post count|Posts
    21,314
    reputation|Rep Power
    100
    flag|Country: Users Flag!

    MS Excel 2007 Tutorials & Training Collection

    MS Excel 2007 Tutorials & Training Collection

    MS Excel 2007 Tutorials & Training CollectionMS 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.

    MS Excel 2007 Tutorials & Training Collection
    Code:
    http://www.filesonic.com/file/15766855/Lynda.com.-.Excel.2007.Essential.Training.part1.rar.html
    http://www.filesonic.com/file/15766867/Lynda.com.-.Excel.2007.Essential.Training.part2.rar.html
    http://www.filesonic.com/file/15766881/Lynda.com.-.Excel.2007.Essential.Training.part3.rar.html
    http://www.filesonic.com/file/15766891/Lynda.com.-.Excel.2007.Essential.Training.part4.rar.html
    http://www.filesonic.com/file/15766903/Lynda.com.-.Excel.2007.Essential.Training.part5.rar.html
    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

    MS Excel 2007 Tutorials & Training Collection
    Code:
    http://www.filesonic.com/file/15769511/Excel._2007.Introduction.to.Formulas.n.Functions.part1.rar.html
    http://www.filesonic.com/file/15769513/Excel._2007.Introduction.to.Formulas.n.Functions.part2.rar.html
    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

    MS Excel 2007 Tutorials & Training Collection
    Code:
    http://www.filesonic.com/file/15769503/L.c.Excel.2007.Creating.Charts.with.Dynamic.Data.rar.html
    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.

    MS Excel 2007 Tutorials & Training Collection
    Code:
    http://www.filesonic.com/file/15769541/L.c.Excel.2007.Creating.and.Managing.Invoices.rar.html
    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.

    MS Excel 2007 Tutorials & Training Collection
    Code:
    http://www.filesonic.com/file/15769515/L.c.Excel.2007.Advanced.Formulas.n.Functions.part1.rar.html
    http://www.filesonic.com/file/15769521/L.c.Excel.2007.Advanced.Formulas.n.Functions.part2.rar.html
    http://www.filesonic.com/file/15769531/L.c.Excel.2007.Advanced.Formulas.n.Functions.part3.rar.html
    http://www.filesonic.com/file/15769539/L.c.Excel.2007.Advanced.Formulas.n.Functions.part4.rar.html
    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

  2. # 1a
    India
    MS Excel 2007 Tutorials & Training Collection

    Join Date
    Jan 2009
    Location
    Advertising world
    Posts
    192
     

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adobe CS5 Tutorials and Training Collection
    By ~IronMan~ in forum Guides/Tutorials
    Replies: 0
    Last Post: 16th November 2010, 16:14
  2. Total Training for Microsoft Excel 2007 Advanced
    By ~IronMan~ in forum Guides/Tutorials
    Replies: 0
    Last Post: 16th November 2010, 16:13
  3. Lynda.com Excel 2007 Macros in Depth
    By ~IronMan~ in forum Guides/Tutorials
    Replies: 0
    Last Post: 16th November 2010, 16:09
  4. Lynda.com Excel 2007 Macros in Depth
    By ~IronMan~ in forum Guides/Tutorials
    Replies: 0
    Last Post: 16th November 2010, 16:09
  5. Lynda Excel 2007 Macros in depth
    By ~IronMan~ in forum Guides/Tutorials
    Replies: 0
    Last Post: 16th November 2010, 15:53

User Tag List

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •