• 1
    collected

Lynda.com

Season 2

  • 1h 20m
  • 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.
Private Notes
Add
Private Notes
Add to history
Add to collection
Add to list
Add comment

1 episode

Season Premiere

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

0%

Season Premiere

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

  • no air date — 1h 20m

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

Loading...