[share_ebook] Lynda - Excel 2007 Essential Training

Description

 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.


Table of contents

Introduction
     Welcome     0:36     0.7 MB
1. Getting Started
     Why use a spreadsheet?     1:44     2.9 MB
     What's changed in Excel 2007?     5:37     11.2 MB
     The Ribbon     2:09     3.5 MB
     The Microsoft Office Button     1:27     2.7 MB
2. Setting Up Excel 2007
     What's on the Ribbon?     1:56     2.4 MB
     Making your way around the Ribbon     2:12     3.0 MB
     Customizing the Ribbon     3:08     4.6 MB
     Customizing the Microsoft Office Button     4:54     7.9 MB
3. Modifying Worksheets
     Opening old worksheets     2:24     3.8 MB
     Adding and deleting worksheets     3:18     4.2 MB
     Inserting and deleting cells     6:53     12.6 MB
     Freezing areas of a worksheet     3:40     6.9 MB
4. Basic Formatting
     Width and height     7:25     11.5 MB
     Numeric formats     2:21     3.9 MB
     Alignment of data     3:19     5.0 MB
     Playing with fonts     2:58     4.5 MB
     AutoFilter     2:21     3.9 MB
     Formatting as a table     2:27     4.8 MB
5. Advanced Formatting
     Removing duplicates     6:01     9.4 MB
     What is Conditional Formatting?     2:21     3.7 MB
     Working with Conditional Formatting     2:14     4.3 MB
     Managing Conditional Formatting rule preferences     2:39     4.0 MB
     Converting text to columns     4:35     6.9 MB
     Data validation     3:41     5.0 MB
6. Using Templates, Styles, and AutoFormat
     Templates     3:45     6.1 MB
     Styles     3:35     6.4 MB
     AutoFormat     3:36     4.8 MB
7. Managing Lists in Excel
     Excel lists have now become tables     2:34     4.7 MB
     Converting text to columns     3:11     5.1 MB
     Sorting and Grouping     5:09     9.0 MB
     Creating a summary report     1:22     2.5 MB
8. Reviewing Worksheets
     Proofing your work     3:31     5.6 MB
     Providing comments on worksheets     3:13     5.3 MB
9. Sharing Worksheets
     Protecting and sharing a worksheet     3:57     6.5 MB
     Allowing others to edit ranges     4:03     6.1 MB
     Track Changes     3:43     6.4 MB
10. Printing Workbooks
     Preparing to print     2:31     4.5 MB
     Print Preview     3:33     5.1 MB
     The Page Layout Tab     3:56     6.8 MB
     Page Breaks     4:36     7.6 MB
     The Page Layout View     3:54     5.1 MB
     Headers and Footers     4:13     4.8 MB
11. Enhancing Worksheets
     Adding themes to your worksheet     2:53     5.7 MB
     Page setup options     8:00     14.6 MB
     Scale to Fit     2:26     4.4 MB
     Worksheet options     5:29     10.0 MB
     Inserting images     3:46     6.5 MB
12. Using Templates
     Using templates     3:50     6.1 MB
13. Manipulating the Screen Display
     Workbook Views     2:53     4.5 MB
     Hiding and Zooming     3:44     7.4 MB
     Window Panes     5:31     10.1 MB
     More screen options     5:40     9.7 MB
14. Importing Data
     Importing from Access     2:24     3.4 MB
     Using the Import Wizard for text files     5:52     7.6 MB
15. Finding and Replacing Data
     The Find and Select button     4:34     7.7 MB
     Find and Replace     2:48     4.3 MB
     Removing duplicates     4:01     6.9 MB
16. Working with Formulas
     What are formulas?     3:20     3.6 MB
     Order of Operations     2:50     3.0 MB
     Relative and absolute referencing     4:54     7.5 MB
     The new Formula Tab     5:59     9.4 MB
17. Working with Basic Functions
     What are Functions?     2:57     4.3 MB
     AutoSum     2:47     4.9 MB
     Minimum     3:55     7.3 MB
     Trim     5:02     9.2 MB
     Left     2:48     5.1 MB
18. Working with Advanced Functions
     Concatenation     4:10     7.5 MB
     SumIf     5:18     8.2 MB
     Lookup     7:25     10.8 MB
     What-If Analysis     3:53     4.8 MB
19. Charts
     Why create a chart?     2:12     3.3 MB
     Creating your chart     3:37     5.5 MB
     Modifying your chart     6:46     10.0 MB
     Laying out your chart     4:09     5.4 MB
20. Pivot Tables
     What are PivotTable reports and PivotChart reports?     2:32     3.9 MB
     Creating a PivotTable     4:47     7.5 MB
     Laying out your PivotTable     2:30     3.8 MB
     Designing your PivotTable     4:09     6.3 MB
     Creating a PivotChart     3:25     6.1 MB
21. Working with Macros
     Why use macros?     2:14     4.4 MB
     Creating a macro     4:31     7.2 MB
     Macro security     2:12     2.5 MB
22. Workflow in Excel 2007
     Reviewing a workflow in Excel     5:36     10.1 MB
Conclusion
     Conclusion     0:22     0.5 MB


Download :

http://www.easy-share.com/1904295872/Lynda.com.Excel.2007.Essential.Training.rar.001
http://www.easy-share.com/1904296404/Lynda.com.Excel.2007.Essential.Training.rar.002
http://www.easy-share.com/1904310418/Lynda.com.Excel.2007.Essential.Training.rar.003
http://www.easy-share.com/1904310837/Lynda.com.Excel.2007.Essential.Training.rar.004
http://www.easy-share.com/1904311430/Lynda.com.Excel.2007.Essential.Training.rar.005
http://www.easy-share.com/1904311657/Lynda.com.Excel.2007.Essential.Training.rar.006
http://www.easy-share.com/1904311753/Lynda.com.Excel.2007.Essential.Training.rar.007
http://www.easy-share.com/1904311880/Lynda.com.Excel.2007.Essential.Training.rar.008
http://www.easy-share.com/1904312002/Lynda.com.Excel.2007.Essential.Training.rar.009
http://www.easy-share.com/1904312095/Lynda.com.Excel.2007.Essential.Training.rar.010

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Download links for "[share_ebook] Lynda - Excel 2007 Essential Training":


How to Download
You may need eMule or Bittorrent to download ebook torrents or emule links.

Report Dead Link
Please leave a comment to report dead links, so that someone else may update new links.

1. Ebooks list page : 2595
2. Lynda Excel 2007 Essential Training
3. LYNDA Excel 2007 Essential Training
4. Lynda.com Outlook 2007 Essential Training
5. LYNDA Word 2007 Essential Training
6. lynda.com.sharepoint.2007.essential.training.dvd
7. [request_ebook] lynda.com 3d's max 9 essential training part 2
8. [share_ebook] Lynda.com: 3DS Max 2009 Essential Training
9. [share_ebook] Lynda.com Painter 11 Essential Training DVD
10. [share_ebook] Lynda.com Dreamweaver CS4 with CSS Essential Training
11. [share_ebook] Lynda.com FileMaker Pro 10 Essential Training Win/Mac
12. [share_ebook] Lynda.com - CorelDRAW X4 Essential Training
13. [share_ebook] Lynda.com FileMaker Pro 10 Essential Training Win/Mac
14. [share_ebook] [Lynda] Audition 3 Essential Training
15. [share_ebook] Lynda.com: Poser 7 Essential Training
16. [share_ebook] Lynda - Flash CS4 Professional Essential Training