• 0%
    0 votes
  • Rate this season
    What did you think?
  • 1


Season 2

  • 80 mins
  • Documentary, Special Interest

This course provides the core knowledge to begin programming in any language. Simon Allardice uses JavaScript to explore the core syntax of a programming language, and shows how to write and execute your first application and understand what's going on under the hood. The course covers creating small programs to explore conditions, loops, variables, and expressions; working with different kinds of data and seeing how they affect memory; writing modular code; and how to debug, all using different approaches to constructing software applications.

1 episode

2x01 Lynda.com - Excel 2010 Pivot Tables in Depth

  • Season Premiere

    no air date — 80 mins

Lynda.com - Excel 2010: Pivot Tables in Depth In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course. Topics include: Formatting data for use in a PivotTable Connecting to an external data source Refreshing a data source Adding, removing, and positioning subtotals and grand totals Creating a calculated field Grouping PivotTable fields Clearing and reapplying PivotTable filters Applying field styles Formatting cells Creating a PivotChart Printing PivotTables and PivotCharts Creating relationships between tables in a PowerPivot model Using the DAX language for advanced summaries in PowerPivot