1.4.Lynda.com.Excel.2010.Power.Shortcuts/02 Ribbon and Quick Access Toolbar Tips/0201 Expanding and collapsing the Ribbon and Full Screen view.mov2.8MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/02 Ribbon and Quick Access Toolbar Tips/0202 Keyboard command access.mov2.72MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0301 Split screens and frozen titles in a flash.mov12.71MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0302 Repeating title creation and suppression.mov9.78MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0303 Customizing your display of Status Bar totals.mov2.71MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0403 Navigating within worksheets.mov7.82MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0402 Tips for navigating between workbooks.mov6.53MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/00 Introduction/0001 Welcome.mov8.64MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/00 Introduction/0002 Using the exercise files.mov764.91KB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0103 Controlling Excel 2010 with keyboard shortcuts.mov6.81MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0104 Understanding the new file formats.mov5.82MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0102 Exploring the new Ribbon and Backstage view.mov5.36MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0101 Understanding the reasons to switch.mov3.59MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0203 Changing the default file format in Excel 2010.mov4MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0201 Saving Excel 2010 spreadsheets to Excel 2003.mov3.95MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0204 Managing Excel 2003 files in Compatibility Mode.mov3.3MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0205 Working with Excel 2010 files in older versions of Excel us.mov3.22MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0202 Converting older spreadsheets to Excel 2010.mov3.16MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/02 Using Excel 2003 and Excel 2010 in a Mixed Environment/0206 Best practices for managing files in a mixed environment.mov1.37MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0305 Customizing the Ribbon and the Quick Access toolbar.mov8.94MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0306 Creating macro-enabled workbooks and templates.mov7.95MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0302 Using Excel tables to manage lists of data.mov6.76MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0304 Using conditional formatting.mov5.15MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0303 Formatting a workbook.mov4.8MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0301 Working with formulas and functions.mov3.92MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/04 Conclusion/0401 Goodbye.mov324.7KB
Lynda.com Excel 2010 Working with Dates and Times/00 Introduction/0001 Welcome.mov9.22MB
Lynda.com Excel 2010 Working with Dates and Times/00 Introduction/0002 Using the exercise files.mov362.17KB
Lynda.com Excel 2010 Working with Dates and Times/01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov4.98MB
Lynda.com Excel 2010 Working with Dates and Times/01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov1.68MB
Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov6.45MB
Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0203 Using TODAY and NOW functions for dynamic date time entry.mov3.16MB
Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0201 Looking at standard date time entry options and acceptable alternatives.mov3.16MB
Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0202 Using instant date time entry.mov1.56MB
Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0303 Creating custom date formatting.mov2.88MB
Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0302 Formatting time for hours over 24.mov2.44MB
Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov2.32MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0401 EOMONTH and EDATE Setting ends of months and future past dates.mov4.83MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0402 DATEDIF Calculating date differences by year, month, day, and more.mov4.79MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov3.38MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0404 NETWORKDAYS Calculating working days.mov2.54MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov1.99MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0403 WEEKDAY Determining the day of the week.mov1.96MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov6.26MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov5.85MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov5.44MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0505 Using times with currency calculations.mov2.9MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0501 Calculating date differences across days, months, and years.mov2.05MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov1.96MB
Lynda.com Excel 2010 Working with Dates and Times/06 Using Dates and Times with Excel Commands/0602 Using date controls in data validation rules.mov6.29MB
Lynda.com Excel 2010 Working with Dates and Times/06 Using Dates and Times with Excel Commands/0601 Using special date filters with date data.mov4.5MB
Lynda.com Excel 2010 Working with Dates and Times/06 Using Dates and Times with Excel Commands/0604 Converting unusually formatted dates into usable data (text to columns).mov4.3MB
Lynda.com Excel 2010 Working with Dates and Times/06 Using Dates and Times with Excel Commands/0603 Using date functions in data validation rules.mov3.47MB
Lynda.com Excel 2010 Working with Dates and Times/07 Conclusion/0701 Goodbye.mov269.41KB
Lynda.com.Excel.VBA.in.Depth-QUASAR/00 Introduction/0002 Using the exercise files.mov279.59KB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov6.57MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0106 Creating a subroutine or function.mov5.74MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0103 Working in the Visual Basic editor.mov4.98MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0109 Running a VBA routine.mov4.59MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0102 Examining the Excel object model.mov3.59MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0108 Adding comments to the code.mov3.54MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0107 Controlling procedure scope and visibility.mov3.28MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0110 Adding code to a recorded macro.mov3.18MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0104 Setting VBA project properties.mov2.38MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0101 Introducing object-oriented programming.mov1.62MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0206 Defining arrays.mov7.06MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0201 Introducing Excel VBA data types.mov6.72MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0204 Defining static variables and constants.mov5.07MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0202 Declaring variables and requiring declaration before use.mov4.19MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0203 Managing variable scope.mov3.71MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0208 Streamlining code references using With End With statements.mov3.6MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0205 Creating a calculation using mathematical operators.mov3.55MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0207 Defining and using object variables.mov2.78MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0304 Performing a task when conditions are met using If Then.mov7.18MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0303 Repeating a task with a Do loop.mov5.3MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0302 Stepping through all items of a collection using a For Each loop.mov3.05MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0301 Repeating a task using a For Next loop.mov2.49MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0305 Selecting which action to take using a Case statement.mov1.76MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0402 Stepping through a subroutine or function.mov5.64MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0401 Managing errors using On Error statements.mov4.68MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0404 Verifying output using the Immediate window.mov3.82MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0405 Watching a value in a routine.mov2.94MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0403 Setting breakpoints in the code.mov2.57MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0507 Managing worksheets with VBA.mov5.59MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0502 Cutting, copying, and pasting cell data.mov5.14MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0503 Finding values in cells.mov4.21MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0505 Concatenating text strings.mov4.01MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0508 Managing workbooks with VBA.mov3.89MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0501 Writing a value to a cell.mov3.62MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0504 Referring to cells using the Offset function.mov2.97MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0506 Returning part of a string.mov2.83MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0603 Acquiring values using an input box or message box.mov5.13MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0601 Turning off screen updating within a macro.mov2.54MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0602 Using worksheet functions in a macro.mov2.38MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0604 Calling a subroutine from another subroutine.mov2.02MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/07 Using Excel Events in Your VBA Code/0702 Running a procedure when a cell range changes.mov4.58MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/07 Using Excel Events in Your VBA Code/0701 Running a procedure when you open, close, or save a workbook.mov4.32MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/07 Using Excel Events in Your VBA Code/0703 Triggering a procedure using a specific key sequence.mov3.71MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/08 Putting it All Together/0801 Applying techniques in a Capstone project.mov6.06MB