Translate

        
        
        

Popular News
Featured Torrents
Archive
Tags Cloud
•   Win7dl.com Downloads » E-Books » Online MS Excel 2007 Advanced 
Online MS Excel 2007 Advanced
  • 0
 (Votes #: 0)
Online MS Excel 2007 Advanced


Total Training – Online MS Excel 2007 Advanced | 768 MB



Now that you got your feet wet learning the new features in MS Excel 2007 in the first video series, Total Training for MS Excel 2007: Essentials, you’re ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you’ll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.

Lesson 1: SUMMARIZING DATA (58 min)

1. Advanced Subtotals

2. Formatting the Subtotal Rows

3. Adding and Copying with Subtotals

4. Consolidating Data

5. Introducing the SUMIF Command

6. Working with the SUMIF Command

7. Using Array Formulas

8. Looking at AutoSum Tricks

9. Utilizing Fill Handle Tricks



Lesson 2: WORKING WITH PIVOT TABLES (52 min)

1. Creating a Pivot Table

2. Rearranging Fields in a Pivot Table

3. Explaining the Report Layout Options

4. Using the Report Filters Feature

5. Using Top 10 & Date Filters

6. Handling Blank Cells

7. Drilling Down in the Pivot Table

8. Sorting a Pivot Table

9. Formatting a Pivot Table

10. Creating Custom Formats

11. Explaining the Grouping Options

12. Adding Formulas to a Pivot Table

13. Changing a Calculation in a Pivot Table

14. Replicating a Pivot Table

15. Counting with a Pivot Table

16. Using Pivot Charts



Lesson 3: CHARTING IN EXCEL (75 min)

1. Charts Refresher

2. Moving, Sizing & Copying Charts

3. Formatting Charts

4. Formatting a Series

5. Exploring the Home & Format Ribbons

6. Deciding What Chart Format to Use

7. Show a Time Series with Column or Line Charts

8. Using Combination Charts

9. Using Line Chart Accessories

10. Using Bar Charts to Show Comparisons

11. Using Component Charts

12. Using Correlation Charts

13. Exploring Other Charts

14. Chart Lies Revealed & Advanced Chart Types

15. Creating a Custom Layout



Lesson 4: GETTING VISUAL (28 min)

1. Using Conditional Formatting

2. Using Advanced Conditional Formatting

3. Highlighting, Sorting & Filtering Columns

4. Using SmartArt Functions

5. Using Different SmartArt Graphics

6. Embedding a Formula into a Shape



Lesson 5: CREATING POWERFUL FORMULAS (85 min)

1. Using Goal Seek to Find an Answer

2. Auditing Formulas

3. Shrinking the Formula Bar

4. Understanding Errors

5. Joining Text Columns

6. Using Custom Formatting Codes

7. Pasting Values

8. Using Paste Special

9. Breaking Apart Text

10. Converting Text to Numbers

11. Using Date Functions

12. Using Bizarre Date Functions

13. Using Exponents

14. Using the VLOOKUP Function

15. Using Index Match

16. Using the Offset Function

17. Using the Convert Function

18. Looking at Interesting but Obscure Functions

19. Using the Rand Function

20. Working with Regression

21. Ranking & Sorting Formulas



Lesson 6: RECORDING MACROS (18 min)

1. Displaying the Developer Tab

2. Recording a Simple Macro

3. Simplifying the Macro

4. Recording Using Relative References



Lesson 7: TIPS & TRICKS (28 min)

1. Showing Off New Tips in Excel 2007

2. Tips for Handling Worksheets

3. Using Excel as a Word Processor

4. Miscellaneous Tips

5. Validating Data

6. Changing Text Entry Direction

7. Using Speak Cells

8. Final Comments & Credits


Download Links


Hotfile

http://hotfile.com/dl/19004258/7ba8102/Total_Training_for_Microsoft_Excel.part01.rar.html


http://hotfile.com/dl/19004289/8678d36/Total_Training_for_Microsoft_Excel.part02.rar.html


http://hotfile.com/dl/19004296/6263a09/Total_Training_for_Microsoft_Excel.part03.rar.html


http://hotfile.com/dl/19004317/aa07679/Total_Training_for_Microsoft_Excel.part04.rar.html


http://hotfile.com/dl/19004334/22f4b68/Total_Training_for_Microsoft_Excel.part05.rar.html


http://hotfile.com/dl/19004361/6543e3b/Total_Training_for_Microsoft_Excel.part06.rar.html


http://hotfile.com/dl/19004370/29bcff4/Total_Training_for_Microsoft_Excel.part07.rar.html


http://hotfile.com/dl/19004383/410945c/Total_Training_for_Microsoft_Excel.part08.rar.html


http://hotfile.com/dl/19004410/ee2fb3d/Total_Training_for_Microsoft_Excel.part09.rar.html



Uploading

http://uploading.com/files/3ae87cb7/Total_Training_for_Microsoft_Excel.part01.rar


http://uploading.com/files/59a5a4d7/Total_Training_for_Microsoft_Excel.part02.rar


http://uploading.com/files/53cm934c/Total_Training_for_Microsoft_Excel.part03.rar


http://uploading.com/files/3c784f6a/Total_Training_for_Microsoft_Excel.part04.rar


http://uploading.com/files/e83ma146/Total_Training_for_Microsoft_Excel.part05.rar


http://uploading.com/files/2f95bd1f/Total_Training_for_Microsoft_Excel.part06.rar


http://uploading.com/files/d5245517/Total_Training_for_Microsoft_Excel.part07.rar


http://uploading.com/files/212m6e7e/Total_Training_for_Microsoft_Excel.part08.rar


http://uploading.com/files/dd25f31d/Total_Training_for_Microsoft_Excel.part09.rar


http://uploading.com/files/3c784f6a/Total_Training_for_Microsoft_Excel.part04.rar



All links are interchangable. It mean you can download any part of archive from any server and can extract it without problem! PM me if links are dead, I will try to re-upload the file if I can!


Category: E-Books | Date: 30-11-2009, 08:16 | Author: creativelivenew | Comments (0)
Information
Comment on the news site is possible only within 365 days from the date of publication.
OnWeb
Win7 on Twitter Win7 on FriendFeed
Vote
Favorite Download Engine
Mediafire.com
Rapidshare.com
Hotfile.com
Extabit.com
Shragle.com
Rapidgator.net
Netload.in
Letitbit.net
Shareflare.net
Other
Partners
Latest News
Absinthe 2.0.1 Mac OSX & Win7dl.com Downloads
Absinthe 2.0.1 Mac OSX | 7.47 MB Absinthe 2.0 is finally here to provide your iOS 5.1.1 device with an untethered jailbreak. This release has been a large collaborative effort between Chronic-Dev Team and iPhone Dev Teams ...

GraphicRiver Truck Mock-up Photoshop & Win7dl.com Downloads
GraphicRiver Truck Mock-up Photoshop Photoshop PSD | 262 MB

VA - Running Hits [2CD] (2012) & Win7dl.com Downloads
VA - Running Hits [2CD] (2012) 2CD | Release: 2012 | Runtime : 131:59 min | Bitrate : 249kbps average | Size : 235.95 MB Genre : Pop | Label : Sony Music

GraphicRiver Paper Weight 3D Glass Displayer Photoshop & Win7dl.com Downloads
GraphicRiver Paper Weight 3D Glass Displayer Photoshop Photoshop ATN | 1 Mb

Alan Wake's American Nightmare v1.01.16.9062 + Extras - THETA (2012/MULTi6) & Win7dl.com Downloads
Alan Wake's American Nightmare v1.01.16.9062 + Extras - THETA (2012/MULTi6) Year: 2012 | PC | Eng/Ger/Fre/Ita/Spa/Jap | Developer: Remedy Entertainment | Published by: Remedy Entertainment | 2.57 GB Genre: Action ...

GraphicRiver Multi-utility Flyer For Different Business - 4 Photoshop & Win7dl.com Downloads
GraphicRiver Multi-utility Flyer For Different Business - 4 Photoshop Photoshop PSD, JPG Image | 46 Mb

share