Learn to summarize, sort, count, and chart your data with Excel PivotTables.
Reveals over 65 tips, tricks, and shortcuts in Excel.
Shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010.
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
Provides comprehensive, hands-on tutorials on Excel PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.
Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.
Shows how to share data between multiple worksheets and workbooks, including tips for adding, moving, and navigating worksheets and workbooks efficiently.
Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.
Shares tips and shortcuts to increase efficiency and get the full power out of Excel 2010.
Offers solutions for optimizing the use of dates and times in Excel 2007.
Offers solutions for optimizing the use of dates and times in Excel 2010.
Shows business owners and managers how to use Excel to create useful budgets that help them manage resources prudently.
Shows how to move and copy data to multiple worksheets and gives tips for efficiently adding, moving, and navigating worksheets and workbooks in Excel.
Demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros in Excel 2007.
Demonstrates the powerful new features and enhancements to Excel 2010.
Simple and powerful techniques for making data readable and understandable, including keyboard shortcuts and tips for smoother formatting.
Shows how simple data in Excel can be used to build exciting and updatable charts.
Shows how to set up an efficient and flexible invoice management system.
Teaches shortcuts to make navigation, cell selection, formatting, and data entry faster for any Excel user.
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.
Shows how to create PivotTable reports, an amazing tool for data analysis, using internal Excel data and outside data sources.
Provides a basic fluency in corporate finance, enabling users to grasp the meaning behind the calculations.
“Since joining lynda.com, my technical skills and creativity have improved tremendously. Kudos for making learning fun.” —Jim F.
more from our members »