Manufacturer’s Description
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.
The Specs
| General | |
|---|---|
| URL | http://www.totaltraining.com |
| Additional Specifications | |
| Training Type | Course |
| Frequency Band | Project Files: IncludedFormat: DVD-ROM and OnlinePlatform: WindowsLicense Quantity: 5-24U LICS |
| Target Audience | Intermediate to Advanced. |
| Course Duration | 6 Hour |
| Course Curriculum | Chapter 1: SUMMARIZING DATA (58 min)Advanced SubtotalsFormatting the Subtotal RowsAdding and Copying with SubtotalsConsolidating DataIntroducing the SUMIF CommandWorking with the SUMIF CommandUsing Array FormulasLooking at AutoSum TricksUtilizing Fill Handle TricksChapter 2: WORKING WITH PIVOT TABLES (52 min)Creating a Pivot TableRearranging Fields in a Pivot TableExplaining the Report Layout OptionsUsing the Report Filters FeatureUsing Top 10 & Date FiltersHandling Blank CellsDrilling Down in the Pivot TableSorting a Pivot TableFormatting a Pivot TableCreating Custom FormatsExplaining the Grouping OptionsAdding Formulas to a Pivot TableChanging a Calculation in a Pivot TableReplicating a Pivot TableCounting with a Pivot TableUsing Pivot ChartsChapter 3: CHARTING IN EXCEL (75 min)Charts RefresherMoving, Sizing & Copying ChartsFormatting ChartsFormatting a SeriesExploring the Home & Format RibbonsDeciding What Chart Format to UseShow a Time Series with Column or Line ChartsUsing Combination ChartsUsing Line Chart AccessoriesUsing Bar Charts to Show ComparisonsUsing Component ChartsUsing Correlation ChartsExploring Other ChartsChart Lies Revealed & Advanced Chart TypesCreating a Custom LayoutChapter 4: GETTING VISUAL (28 min)Using Conditional FormattingUsing Advanced Conditional FormattingHighlighting, Sorting & Filtering ColumnsUsing SmartArt FunctionsUsing Different SmartArt GraphicsEmbedding a Formula into a ShapeChapter 5: CREATING POWERFUL FORMULAS (85 min)Using Goal Seek to Find an AnswerAuditing FormulasShrinking the Formula BarUnderstanding ErrorsJoining Text ColumnsUsing Custom Formatting CodesPasting ValuesUsing Paste SpecialBreaking Apart TextConverting Text to NumbersUsing Date FunctionsUsing Bizarre Date FunctionsUsing ExponentsUsing the VLOOKUP FunctionUsing Index MatchUsing the Offset FunctionUsing the Convert FunctionLooking at Interesting but Obscure FunctionsUsing the Rand FunctionWorking with RegressionRanking & Sorting FormulasChapter 6: RECORDING MACROS (18 min)Displaying the Developer TabRecording a Simple MacroSimplifying the MacroRecording Using Relative ReferencesChapter 7: TIPS & TRICKS (28 min)Showing Off New Tips in Excel 2007Tips for Handling WorksheetsUsing Excel as a Word ProcessorMiscellaneous TipsValidating DataChanging Text Entry DirectionUsing Speak CellsFinal Comments & Credits |
| Brand Name | Total Training |
| Training Method | Self Training |
| Training Subject | For Microsoft Excel 2007: Advanced |
| Quick Glance | |
Related Business/Personal Management
 |
Microsoft Project 2013 Professional 32/64-bit - License - 1 ...Project Pro 2013 Medialess PKC |
$390.00 |
 |
10291 Project 2010 Standard - Complete Product - 1 PC (P...Microsoft Project Standard 2010 gives you a new and easier way to manage... |
$358.00 |
 |
Microsoft Outlook 2010 (Full Product)Microsoft Outlook 2010 gives you a richer set of experiences to meet your... |
$138.00 |
 |
Microsoft Outlook 2013 - Download (Full Product)Communicate more effectively by connecting efficiently with others... |
$91.00 |
 |
Microsoft Project 2003 Professional (Full Product)Microsoft Project Pro 2003 is the Microsoft desktop enterprise project... |
$199.00 |