Lock your Ad to the Top of this Site - Readers always see it! - Advertise Here
 


« Image Processing with LabVIEW and IMAQ Vision
HTTP Essentials: Protocols for Secure, Scaleable Web Sites »

Total Training for Microsoft® Excel® 2007: Advanced

  • 9,828 views
  • In: Total Training, Video Training
  • Author : nostriker
    • 3 votes, average: 4.67 out of 53 votes, average: 4.67 out of 53 votes, average: 4.67 out of 53 votes, average: 4.67 out of 53 votes, average: 4.67 out of 5

    Total Training for Microsoft® Excel® 2007: AdvancedNow that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft 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

    http://rapidshare.com/files/57708195/_M1XL07_P01_C01_L00.mov
    http://rapidshare.com/files/57711904/_M1XL07_P01_C01_L01.mov
    http://rapidshare.com/files/57711925/_M1XL07_P01_C01_L02.mov
    http://rapidshare.com/files/57711636/_M1XL07_P01_C01_L03.mov
    http://rapidshare.com/files/57710370/_M1XL07_P01_C01_L04.mov
    http://rapidshare.com/files/57711434/_M1XL07_P01_C01_L05.mov
    http://rapidshare.com/files/57711772/_M1XL07_P01_C01_L06.mov
    http://rapidshare.com/files/57711263/_M1XL07_P01_C01_L07.mov
    http://rapidshare.com/files/57711759/_M1XL07_P01_C01_L08.mov
    http://rapidshare.com/files/57711482/_M1XL07_P01_C01_L09.mov
    http://rapidshare.com/files/57706513/_M1XL07_P01_C02_L00.mov
    http://rapidshare.com/files/57709323/_M1XL07_P01_C02_L01.mov
    http://rapidshare.com/files/57708563/_M1XL07_P01_C02_L02.mov
    http://rapidshare.com/files/57710467/_M1XL07_P01_C02_L03.mov
    http://rapidshare.com/files/57711673/_M1XL07_P01_C02_L04.mov
    http://rapidshare.com/files/57710307/_M1XL07_P01_C02_L05.mov
    http://rapidshare.com/files/57710303/_M1XL07_P01_C02_L06.mov
    http://rapidshare.com/files/57708818/_M1XL07_P01_C02_L07.mov
    http://rapidshare.com/files/57709391/_M1XL07_P01_C02_L08.mov
    http://rapidshare.com/files/57710239/_M1XL07_P01_C02_L09.mov
    http://rapidshare.com/files/57708951/_M1XL07_P01_C02_L10.mov
    http://rapidshare.com/files/57711580/_M1XL07_P01_C02_L11.mov
    http://rapidshare.com/files/57711181/_M1XL07_P01_C02_L12.mov
    http://rapidshare.com/files/57708371/_M1XL07_P01_C02_L13.mov
    http://rapidshare.com/files/57707895/_M1XL07_P01_C02_L14.mov
    http://rapidshare.com/files/57708347/_M1XL07_P01_C02_L15.mov
    http://rapidshare.com/files/57708825/_M1XL07_P01_C02_L16.mov
    http://rapidshare.com/files/57705936/_M1XL07_P01_C03_L00.mov
    http://rapidshare.com/files/57711013/_M1XL07_P01_C03_L01.mov
    http://rapidshare.com/files/57708346/_M1XL07_P01_C03_L02.mov
    http://rapidshare.com/files/57711721/_M1XL07_P01_C03_L03.mov
    http://rapidshare.com/files/57709112/_M1XL07_P01_C03_L04.mov
    http://rapidshare.com/files/57711184/_M1XL07_P01_C03_L05.mov
    http://rapidshare.com/files/57709304/_M1XL07_P01_C03_L06.mov
    http://rapidshare.com/files/57712206/_M1XL07_P01_C03_L07.mov
    http://rapidshare.com/files/57711871/_M1XL07_P01_C03_L08.mov
    http://rapidshare.com/files/57709388/_M1XL07_P01_C03_L09.mov
    http://rapidshare.com/files/57710296/_M1XL07_P01_C03_L10.mov
    http://rapidshare.com/files/57712067/_M1XL07_P01_C03_L11.mov
    http://rapidshare.com/files/57711917/_M1XL07_P01_C03_L12.mov
    http://rapidshare.com/files/57712003/_M1XL07_P01_C03_L13.mov
    http://rapidshare.com/files/57711675/_M1XL07_P01_C03_L14.mov
    http://rapidshare.com/files/57708627/_M1XL07_P01_C03_L15.mov
    http://rapidshare.com/files/57713221/_M1XL07_P01_C04_L00.mov
    http://rapidshare.com/files/57717198/_M1XL07_P01_C04_L01.mov
    http://rapidshare.com/files/57716913/_M1XL07_P01_C04_L02.mov
    http://rapidshare.com/files/57717568/_M1XL07_P01_C04_L03.mov
    http://rapidshare.com/files/57717392/_M1XL07_P01_C04_L04.mov
    http://rapidshare.com/files/57717784/_M1XL07_P01_C04_L05.mov
    http://rapidshare.com/files/57715892/_M1XL07_P01_C04_L06.mov
    http://rapidshare.com/files/57713218/_M1XL07_P01_C05_L00.mov
    http://rapidshare.com/files/57717596/_M1XL07_P01_C05_L01.mov
    http://rapidshare.com/files/57717902/_M1XL07_P01_C05_L02.mov
    http://rapidshare.com/files/57714247/_M1XL07_P01_C05_L03.mov
    http://rapidshare.com/files/57717344/_M1XL07_P01_C05_L04.mov
    http://rapidshare.com/files/57716785/_M1XL07_P01_C05_L05.mov
    http://rapidshare.com/files/57714362/_M1XL07_P01_C05_L06.mov
    http://rapidshare.com/files/57716382/_M1XL07_P01_C05_L07.mov
    http://rapidshare.com/files/57714543/_M1XL07_P01_C05_L08.mov
    http://rapidshare.com/files/57716839/_M1XL07_P01_C05_L09.mov
    http://rapidshare.com/files/57716311/_M1XL07_P01_C05_L10.mov
    http://rapidshare.com/files/57717411/_M1XL07_P01_C05_L11.mov
    http://rapidshare.com/files/57717634/_M1XL07_P01_C05_L12.mov
    http://rapidshare.com/files/57714889/_M1XL07_P01_C05_L13.mov
    http://rapidshare.com/files/57717801/_M1XL07_P01_C05_L14.mov
    http://rapidshare.com/files/57715769/_M1XL07_P01_C05_L15.mov
    http://rapidshare.com/files/57715678/_M1XL07_P01_C05_L16.mov
    http://rapidshare.com/files/57715912/_M1XL07_P01_C05_L17.mov
    http://rapidshare.com/files/57717397/_M1XL07_P01_C05_L18.mov
    http://rapidshare.com/files/57716998/_M1XL07_P01_C05_L19.mov
    http://rapidshare.com/files/57717679/_M1XL07_P01_C05_L20.mov
    http://rapidshare.com/files/57716372/_M1XL07_P01_C05_L21.mov
    http://rapidshare.com/files/57713789/_M1XL07_P01_C06_L00.mov
    http://rapidshare.com/files/57716424/_M1XL07_P01_C06_L01.mov
    http://rapidshare.com/files/57717307/_M1XL07_P01_C06_L02.mov
    http://rapidshare.com/files/57716204/_M1XL07_P01_C06_L03.mov
    http://rapidshare.com/files/57717956/_M1XL07_P01_C06_L04.mov
    http://rapidshare.com/files/57713691/_M1XL07_P01_C07_L00.mov
    http://rapidshare.com/files/57716403/_M1XL07_P01_C07_L01.mov
    http://rapidshare.com/files/57715904/_M1XL07_P01_C07_L02.mov
    http://rapidshare.com/files/57715782/_M1XL07_P01_C07_L03.mov
    http://rapidshare.com/files/57717110/_M1XL07_P01_C07_L04.mov
    http://rapidshare.com/files/57717442/_M1XL07_P01_C07_L05.mov
    http://rapidshare.com/files/57716678/_M1XL07_P01_C07_L06.mov
    http://rapidshare.com/files/57717489/_M1XL07_P01_C07_L07.mov
    http://rapidshare.com/files/57717302/_M1XL07_P01_C07_L08.mov  
    del.icio.us:Total Training for Microsoft® Excel® 2007: Advanceddigg:Total Training for Microsoft® Excel® 2007: Advancedblinklist:Total Training for Microsoft® Excel® 2007: Advancedreddit:Total Training for Microsoft® Excel® 2007: AdvancedY!:Total Training for Microsoft® Excel® 2007: Advanced

    Random Posts

    You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

    9 Responses to “Total Training for Microsoft® Excel® 2007: Advanced”

    • amrnijad
      September 24th, 2007 20:52
      1

      Thanks nostriker for your upload!!! I was wondering do you have "Total Training for Microsoft® Excel® 2007: Essentials"  ? Can u upload it for us? with best regards!

    • ganelon
      September 24th, 2007 23:28
      2

      Thanks for sharing nostriker. You have some good tutorials in your collection.

    • nhashem
      September 24th, 2007 23:58
      3

      hey Thanks nostriker for this good upload, but do you have The excersise files , you know the small execell files that came with the dvd. thank again.

    • ctc531
      September 25th, 2007 09:07
      4

      Hello Guys… What software do you use to download all these files? If I go one by one it might take me forever!. And of course a premium account with my friends at rapidshare is out of the question 

    • dumshi
      October 3rd, 2007 06:13
      5

      Pls. also upload Excersise files.,. Tx.. 

    • datpin
      November 2nd, 2007 09:55
      6

      pls reupload

    • fret
      June 22nd, 2008 16:31
      7

      Link has been deleted. Can you pls reupload or direct to another link. Txs

    • YeNaingWin
      September 8th, 2008 01:49
      8

      thxs for sharing knowledge, could u give us a link for execise file?

    • Man Inaboat
      November 20th, 2008 18:42
      9

      What kind of idiot loads up individual movie files.
      Hey moron, learn the art of sharing, zip up the files into archives so that the download process is easier!!!!! Buffoon!!

    Leave a Reply

    You must be logged in to post a comment.