┌█ SkillSoft.Analyzing.Data.in.Excel.2007-LiB █┐
│└─────────────────────────────────────────────────────────────────────────┘│
│ │
│ │
│ │
└════════╦═══════════════════════════════════════════════════════╦══════════┘
│ ▄▀▀▀▀▀▀▀▄ ▄▀▄ █▀▀▀▀▀▀▀▀▄(C) │
│ ▀▄▀███▀▄▀ ▄▀▄█▄▀▄ █ ▀▀▀▀▀██▄▀▄▄ │
│ █ █░█ █ ▀▄▀███▀▄▀█ ███ ░ ██▄ █ │
│ █ █▒█ █ TEAM █▀ ▀ ▀█ █ ███ ▒ ███ █ │
│ █ █▓█ █ LiB █ ███ █ █ ███ ▓ ██▀▄▀ │
│ █ █■█ █ █ █░█ █ █ ███ ▀▀██▄▀▄ │
│ █ █▓█ █ ▄ █ █▒█ █ █ ███ ▓ ███ █ │
│ █ █▒█ █▀▀▄▀▀█ █ █▓█ █ █ ███ ▒ ███ █ │
│ █ █░█ ▀ ███ █ █ ███ █ █ ███ ░ ███ █ │
│ █ █████████ █▀▄▄███▄▄▀█ ███ ▄██▀▄▀ │
│ █▄▄▄▄▄▄▄▄▄▄▄█▄▄▄▄▄▄▄▄▄█▄▄▄▄▄▄▄▄▀ │
│ │
│ ╔═════════════════════════════════╗ │
╚══════════╣ .::: LiBrary is Here !! :::. ╠══════════╝
╚═════════════════════════════════╝
┌──────────────────────┐ ▓▒░ Release Information ░▒▓ ┌──────────────────────┐
│ ██▓▓▒▒░░░░▒▒▓▓██ └─────────────────────────────┘ ██▓▓▒▒░░░░▒▒▓▓██ │
├───────────────────────────────────────────────────────────────────────────┤
│ TITLE : Analyzing Data in Excel 2007 │
├───────────────────────────────────────────────────────────────────────────┤
│ AUTHOR : SkillSoft │
├───────────────────────────────────────────────────────────────────────────┤
│ PUBLISHER : SkillSoft │
├───────────────────────────────────┬───────────────────────────────────────┤
│ ISBN : 0000000 │ MAKER : TEAM LiB │
├───────────────────────────────────┼───────────────────────────────────────┤
│ PAGES : N/A Pages │ PACKAGER : TEAM LiB │
├───────────────────────────────────┼───────────────────────────────────────┤
│ EDITION : N/A │ SUPPLIER : TEAM LiB │
├───────────────────────────────────┼───────────────────────────────────────┤
│ LANGUAGE : ENGLISH │ FORMAT : ZIP │
├───────────────────────────────────┼───────────────────────────────────────┤
│ RELEASE : 03-03-09 │ SIZE : 22.67 MB │
└═══════════════════════════════════╧═══════════════════════════════════════┘
┌────────────────────────┐ ▓▒░ Release Notes ░▒▓ ┌──────────────────────────┐
│ └───────────────────────┘ │
│ │
│ [Product Information] │
│ │
│ Overview/Description │
│ Excel 2007 provides powerful data analysis tools that enable you to │
│ explore large amounts of data and to make educated business decisions │
│ based on that data. With PivotTable reports you can interactively │
│ summarize data, making it easier to analyze and present the results. │
│ PivotChart reports provide a graphical view of PivotTable report │
│ data. Using Goal Seek and Solver enables you to retrieve required │
│ results from formulas by determining the data the formula requires. │
│ You can also use additional what-if analysis components, data tables │
│ and scenarios, to view how value changes in formulas affect the │
│ formula results and to forecast worksheet outcome models │
│ respectively. This course covers advanced data analysis features, │
│ such as PivotTable and PivotChart reports, Goal Seek, Solver, │
│ scenarios, data tables, and OLAP. │
│ │
│ Target Audience │
│ End users seeking proficiency in the use of Microsoft Excel 2007 at a │
│ power user level or seeking to obtain Microsoft Office Specialist │
│ (MOS) certification in Microsoft Excel 2007 at an Expert level or an │
│ equivalent. │
│ │
│ Prerequisites │
│ Some knowledge of word processing, computing, and spreadsheets; │
│ familiarity with the Microsoft Office work environment; an │
│ understanding of the Internet and web-page functionality │
│ │
│ Expected Duration (hours) │
│ 3.5 │
│ │
│ Lesson Objectives │
│ │
│ Analyzing Data in Excel 2007 │
│ # create a PivotTable report │
│ # rearrange PivotTable data │
│ # customize PivotTable reports │
│ # modify the look and feel of a PivotTable report │
│ # create a PivotChart report │
│ # modify a PivotChart report │
│ # perform calculations in PivotTables reports │
│ # recognize when to use each calculation type │
│ # create a PivotTable report │
│ # customize a PivotTable report │
│ # change the summary calculation in a PivotTable report │
│ # create a calculation with a formula │
│ # create a PivotChart │
│ # use Goal Seek to perform data analysis │
│ # use Solver to perform data analysis │
│ # create scenarios for what-if analysis │
│ # use the Scenario Manager to modify scenarios │
│ # create a one-variable data table for data analysis │
│ # create a two-variable data table for data analysis │
│ # project values in a series │
│ # perform advanced functions │
│ # match advanced functions with examples of when you would use them │
│ # consolidate data from different workbooks using a Summary function │
│ # use Goal Seek │
│ # use Solver to perform what-if analysis │
│ # create a data table to perform what-if analysis │
│ # use advanced functions and consolidate data │
│ │
│ [Install Information] │
│ │
│ Unpack it ! │
│ Enjoy this fine release from TEAM LiB ~_* │
│ │
│ [For more information] │
│ │
│ http://www.skillsoft.com/Catalog/detail.asp? │
│ CourseCode=mo_expu_a01_dt_enus │
│ │
└═══════════════════════════════════════════════════════════════════════════┘
┌─────────────────────┐ ▓▒░ TEAM LiB AGREEMENTS ░▒▓ ┌───────────────────────┐
│ └─────────────────────────────┘ │
│ │
│ Attention: Please read these terms carefully before using our │
│ release. Using our release indicates that you have read and accepted │
│ these agreements. If you do not agree to accept these terms, do not │
│ use our release or infomation from it. We may change the terms of │
│ this Agreement at any time. │
│ │
│ YOU MAY USE OUR RELEASE FOR EVALUATION PRUPOSES ONLY. WE WILL NOT BE │
│ HELD RESPONSIBLE FOR OUR RELEASE. IF YOU LIKE THIS BOOKWARE, YOU'RE │
│ STRONGLY ADVISED TO BUY IT. BOOKWARE PUBLISHER AND AUTHOR NEED │
│ QUALITY PRODUCTS. YOU MAY NOT USE OUR RELEASE TO MAKE MONEY OR USE IT │
│ SUPPORT FOR COMMERCIAL PURPOSE. │
│ │
└═══════════════════════════════════════════════════════════════════════════┘
┌────────────────────────┐ ▓▒░ TEAM LiB NEWS ░▒▓ ┌──────────────────────────┐
│ └───────────────────────┘ │
│ │
│ - Looking for EU affil site │
│ │
│ Do You Wanna Join? Getting In Touch With Us If... │
│ - You can access Online library │
│ - People who works in publishing company │
│ - You can provide fast speed servers as team │
│ dump │
│ such as 100+mbit/200+g │
│ - You are good cracker │
│ │
└═══════════════════════════════════════════════════════════════════════════┘
┌───────────────────────┐ ▓▒░ TEAM LiB Greets ░▒▓ ┌──────────── ▄▄ ─────────┐
│ └─────────────────────────┘ ▄████▄ │
│ ▄█████████▄ │
│ TEAM LiB send GREETS to: ▄████████ ██ │
│ All groups who bring releases of high ▀██▀▀████▄▄███▄███▄
│ quality to the scene. ▄██████████████
│ Thanks to all our hardworking members. ▄▄▄█████████▀ ███ ▀▀█▀
│ █████████▀███▄▄██ │
└═══════════════════════════════════════════════════ ███████ ▄███████ ═════┘
██▀▀ ▄██████▀
██████ ▄▄
┌─────────────────────┐ ▓▒░ Contact Information ░▒▓ ┌───────── ███████ ─────┐
│ └─────────────────────────────┘ ███████▀ │
│ ██████ ▄▄▄██▄ │
│ Email: TeamLiB[at]msn[dot]com ██████████ │
│ Any request for technical support ▄████████████▀ │
│ or missing files will be ignored ████████▀▀ │
│ so don't waste your/our time! ▀▀▀▀ ▄█████▄ │
│ ▄▄██████████ │
└═════════════════════════════════════════════════════════ █████▀ ████ ═══┘
███ ▄▄▄▄████
███ █████████
TEAM LiB (Since 2003) ███ ██▀ ████
.nfo layout by D1BT ███ ▀▄▄█▄███▀
▀██████████▀
▀██▀ ███▀
█─────────────────────────────────────────────────────────────────────────█