Now 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.
|Frequency Band||Project Files: Included Format: DVD-ROM and Online Platform: Windows License Quantity: 5-24U LICS|
|Target Audience||Intermediate to Advanced.|
|Course Duration||6 Hour|
|Front Camera||Total Training|
|Course Curriculum||Chapter 1: SUMMARIZING DATA (58 min) Advanced Subtotals Formatting the Subtotal Rows Adding and Copying with Subtotals Consolidating Data Introducing the SUMIF Command Working with the SUMIF Command Using Array Formulas Looking at AutoSum Tricks Utilizing Fill Handle Tricks Chapter 2: WORKING WITH PIVOT TABLES (52 min) Creating a Pivot Table Rearranging Fields in a Pivot Table Explaining the Report Layout Options Using the Report Filters Feature Using Top 10 & Date Filters Handling Blank Cells Drilling Down in the Pivot Table Sorting a Pivot Table Formatting a Pivot Table Creating Custom Formats Explaining the Grouping Options Adding Formulas to a Pivot Table Changing a Calculation in a Pivot Table Replicating a Pivot Table Counting with a Pivot Table Using Pivot Charts Chapter 3: CHARTING IN EXCEL (75 min) Charts Refresher Moving, Sizing & Copying Charts Formatting Charts Formatting a Series Exploring the Home & Format Ribbons Deciding What Chart Format to Use Show a Time Series with Column or Line Charts Using Combination Charts Using Line Chart Accessories Using Bar Charts to Show Comparisons Using Component Charts Using Correlation Charts Exploring Other Charts Chart Lies Revealed & Advanced Chart Types Creating a Custom Layout Chapter 4: GETTING VISUAL (28 min) Using Conditional Formatting Using Advanced Conditional Formatting Highlighting, Sorting & Filtering Columns Using SmartArt Functions Using Different SmartArt Graphics Embedding a Formula into a Shape Chapter 5: CREATING POWERFUL FORMULAS (85 min) Using Goal Seek to Find an Answer Auditing Formulas Shrinking the Formula Bar Understanding Errors Joining Text Columns Using Custom Formatting Codes Pasting Values Using Paste Special Breaking Apart Text Converting Text to Numbers Using Date Functions Using Bizarre Date Functions Using Exponents Using the VLOOKUP Function Using Index Match Using the Offset Function Using the Convert Function Looking at Interesting but Obscure Functions Using the Rand Function Working with Regression Ranking & Sorting Formulas Chapter 6: RECORDING MACROS (18 min) Displaying the Developer Tab Recording a Simple Macro Simplifying the Macro Recording Using Relative References Chapter 7: TIPS & TRICKS (28 min) Showing Off New Tips in Excel 2007 Tips for Handling Worksheets Using Excel as a Word Processor Miscellaneous Tips Validating Data Changing Text Entry Direction Using Speak Cells Final Comments & Credits|
|Brand Name||Total Training|
|Training Method||Self Training|
|Training Subject||For Microsoft Excel 2007: Advanced|
Related Business/Personal Management
Communicate more effectively by connecting efficiently with others...
Microsoft Outlook 2013 License through the Microsoft Open Business...
Microsoft Project Standard 2010 delivers powerful, visually enhanced ways...
Microsoft Outlook 2010 offers premium business and personal e-mail...
Microsoft Project Professional 2010 delivers powerful, visually enhanced...