1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1102 Cleaning up spaces.mov 9.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov 9.4 MB
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.mov 9.4 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1003 Adding background color for readability.mov 8.7 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov 8.5 MB
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.mov 8.3 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0403 Navigating within worksheets.mov 8.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0401 Formatting numbers and dates.mov 8.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0706 Managing worksheets.mov 8.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0405 Using custom conditional formatting.mov 8.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov 8.0 MB
Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0107 Preparing to share a document.mov 7.1 MB
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.mov 7.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov 7.0 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0201 Introducing Excel VBA data types.mov 7.0 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov 7.0 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0802 Selecting all cells that depend on the active cell.mov 7.0 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov 6.9 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/05 Selection Shortcuts/0503 Selecting the current region and moving around region corne.mov 6.9 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0402 Tips for navigating between workbooks.mov 6.9 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1004 Using data tables in formulas.mov 6.8 MB
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.mov 6.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0110 Zooming in and out quickly.mov 6.6 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov 6.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1203 Creating and manipulating shapes.mov 6.4 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0602 Auto-Fill techniques for entering dates.mov 6.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/06 Printing Preparation/0601 Making the pieces fit.mov 6.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov 6.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0204 Targeting large data groups.mov 6.4 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov 6.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov 6.1 MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0104 Understanding the new file formats.mov 6.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1003 Working with Goal Seek.mov 6.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov 5.9 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0507 Managing worksheets with VBA.mov 5.9 MB
Lynda.com.Excel.2010.New.Features-QUASAR/04 Graphic Features/0404 Editing pictures with the improved picture tools.mov 5.8 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov 5.8 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0805 Rounding shortcuts.mov 5.8 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0404 Using conditional formatting.mov 5.8 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov 5.7 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0103 Finding the commands you need.mov 5.2 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0105 Instantly displaying all worksheet formulas.mov 5.2 MB
Lynda.com Excel 2010 Working with Dates and Times/01 Excel's Date Time Entries/0101 Understanding how Excel records and stores dates.mov 5.2 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0103 Working in the Visual Basic editor.mov 5.2 MB
Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0106 Changing the file type and converting to Adobe PDF.mov 5.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0303 Adding numbers manually.mov 5.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0702 Freezing panes.mov 5.1 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0109 Undo Redo Repeat.mov 5.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0309 Using IF.mov 5.1 MB
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.mov 5.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0502 Coordinating a look using themes.mov 5.1 MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0303 Formatting a workbook.mov 5.0 MB
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.mov 5.0 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0703 Dragging and inserting variations.mov 5.0 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1202 Inserting Sparklines.mov 4.7 MB
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.mov 4.7 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/06 Printing Preparation/0602 Inserting headers and footers.mov 4.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0807 Counting unique entries.mov 4.6 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0703 Repeating row and column titles.mov 4.5 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1106 Forcing dates to be weekdays only.mov 4.5 MB
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.mov 4.5 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov 4.5 MB
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).mov 4.5 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0202 Techniques for copying and pasting.mov 4.5 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1007 Applying strikethroughs and borders.mov 4.5 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0704 Instantly displaying Paste Special options.mov 4.5 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0503 Finding values in cells.mov 4.4 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0202 Declaring variables and requiring declaration before use.mov 4.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0311 Naming and using cell ranges.mov 4.3 MB
Lynda.com.Excel.2010.New.Features-QUASAR/02 Collaboration Tools/0202 Sharing a document by email.mov 4.2 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0505 Concatenating text strings.mov 4.2 MB
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.mov 4.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0701 Finding and replacing data.mov 4.2 MB
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.mov 4.1 MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0301 Working with formulas and functions.mov 4.1 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0104 Using Backstage view or the File tab.mov 4.1 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0508 Managing workbooks with VBA.mov 4.1 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0806 Generating random numbers.mov 4.1 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0404 Verifying output using the Immediate window.mov 4.0 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0103 Copying data or formulas down a column instantly.mov 4.0 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0808 Performing calculations without formulas.mov 3.9 MB
Lynda.com.Excel.2010.New.Features-QUASAR/03 Data Tools/0301 Using enhanced smart tags and the Paste preview.mov 3.9 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1203 Creating a column chart.mov 3.8 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0805 Tracking changes.mov 3.8 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0501 Writing a value to a cell.mov 3.8 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0208 Streamlining code references using With End With statements.mov 3.8 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0102 Examining the Excel object model.mov 3.8 MB
Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0101 Understanding the reasons to switch.mov 3.8 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0205 Creating a calculation using mathematical operators.mov 3.7 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0108 Adding comments to the code.mov 3.7 MB
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.mov 3.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0102 Converting formulas to values with a simple drag.mov 3.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0803 Selecting all cells that can affect the active cell.mov 3.6 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0308 Working with times and dates.mov 3.5 MB
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.mov 3.5 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0302 Entering data in a worksheet.mov 3.5 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0605 Cell editing tips.mov 3.5 MB
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.mov 3.5 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0107 Controlling procedure scope and visibility.mov 3.4 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0104 Adjusting all or selected column widths or row heights in a.mov 3.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0101 Exploring three common uses for Excel.mov 3.4 MB
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.mov 3.4 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0804 AutoSum shortcuts.mov 3.4 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0110 Adding code to a recorded macro.mov 3.3 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1201 Placing and adjusting charts.mov 3.3 MB
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.mov 3.3 MB
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.mov 3.3 MB
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.mov 3.3 MB
Lynda.com.Excel.2010.New.Features-QUASAR/03 Data Tools/0302 Filtering a table by searching.mov 3.3 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0506 Creating and using original templates.mov 3.2 MB
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.mov 3.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov 3.2 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov 3.2 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0603 Auto-Fill techniques for entering times.mov 3.1 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0504 Referring to cells using the Offset function.mov 3.1 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0405 Watching a value in a routine.mov 3.1 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0505 Using times with currency calculations.mov 3.0 MB
Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0303 Creating custom date formatting.mov 3.0 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1004 Formatting data conditionally.mov 3.0 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0506 Returning part of a string.mov 3.0 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/13 Creating and Using Macros/1301 Understanding macros.mov 2.9 MB
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.mov 2.9 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0207 Defining and using object variables.mov 2.9 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0602 Using worksheet functions in a macro.mov 2.5 MB
Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov 2.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov 2.4 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1002 Using evaluation in Excel.mov 2.4 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0501 Calculating date differences across days, months, and years.mov 2.1 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0604 Calling a subroutine from another subroutine.mov 2.1 MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov 2.1 MB
Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov 2.1 MB
Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0403 WEEKDAY Determining the day of the week.mov 2.1 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1107 Displaying unique items from large lists.mov 2.0 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0305 Adding a whole worksheet.mov 2.0 MB
Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0305 Selecting which action to take using a Case statement.mov 1.8 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0804 Sharing a workbook.mov 1.8 MB
Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1201 Choosing chart types.mov 1.8 MB
Lynda.com Excel 2010 Working with Dates and Times/01 Excel's Date Time Entries/0102 Understanding how Excel records and stores times.mov 1.8 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0107 Print Preview.mov 1.8 MB
Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0202 Using instant date time entry.mov 1.6 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0106 Two quick shortcuts for creating charts.mov 1.5 MB
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.mov 1.4 MB
1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0108 Instant date or time entry.mov 1.4 MB