| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/00 Introduction/0001 Welcome.mov |
18.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/00 Introduction/0002 Using the exercise files.mov |
340 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0110 Zooming in and out quickly.mov |
6.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0105 Instantly displaying all worksheet formulas.mov |
5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0109 Undo Redo Repeat.mov |
4.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0103 Copying data or formulas down a column instantly.mov |
3.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0102 Converting formulas to values with a simple drag.mov |
3.5 MB |
| excel 2010 training videos/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.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0101 Entering data or formulas in non-adjacent cells simultaneou.mov |
2.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0107 Print Preview.mov |
1.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0106 Two quick shortcuts for creating charts.mov |
1.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/01 Top Ten Shortcuts/0108 Instant date or time entry.mov |
1.4 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/02 Ribbon and Quick Access Toolbar Tips/0203 Quick Access toolbar display tips.mov |
7.2 MB |
| excel 2010 training videos/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.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/02 Ribbon and Quick Access Toolbar Tips/0202 Keyboard command access.mov |
2.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0301 Split screens and frozen titles in a flash.mov |
12.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0302 Repeating title creation and suppression.mov |
9.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/03 Display Shortcuts/0303 Customizing your display of Status Bar totals.mov |
2.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0403 Navigating within worksheets.mov |
7.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0402 Tips for navigating between workbooks.mov |
6.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/04 Navigation Shortcuts/0401 Navigation shortcuts.mov |
3.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/05 Selection Shortcuts/0502 Selecting noncontiguous ranges and visible cells only.mov |
6.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/05 Selection Shortcuts/0503 Selecting the current region and moving around region corne.mov |
6.6 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/05 Selection Shortcuts/0501 Selecting an entire row column or worksheet.mov |
5.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0604 Custom lists for rapid entry.mov |
11.6 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0601 Accelerating data entry.mov |
7.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0602 Auto-Fill techniques for entering dates.mov |
6.1 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0605 Cell editing tips.mov |
3.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/06 Data Entry and Editing Shortcuts/0603 Auto-Fill techniques for entering times.mov |
3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0703 Dragging and inserting variations.mov |
4.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0704 Instantly displaying Paste Special options.mov |
4.2 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0701 Copy Move acceleration tips.mov |
4.2 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/07 Drag-and-Drop Techniques/0702 Worksheet Copy Move shortcuts.mov |
3.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0802 Selecting all cells that depend on the active cell.mov |
6.6 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0805 Rounding shortcuts.mov |
5.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0801 Rapid formula creation.mov |
4.6 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0807 Counting unique entries.mov |
4.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0806 Generating random numbers.mov |
3.9 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0808 Performing calculations without formulas.mov |
3.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0803 Selecting all cells that can affect the active cell.mov |
3.4 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/08 Formula Shortcuts/0804 AutoSum shortcuts.mov |
3.2 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/09 Operational Shortcuts/0901 Controlling rows and columns.mov |
11 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/09 Operational Shortcuts/0903 Handling blank cells.mov |
7.5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/09 Operational Shortcuts/0904 Collapsing and expanding detail.mov |
5.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/09 Operational Shortcuts/0902 Realigning imported text.mov |
2.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1001 Formatting numbers.mov |
10.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1005 Creating custom formats.mov |
9 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1003 Adding background color for readability.mov |
8.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1002 Aligning data.mov |
5.1 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1007 Applying strikethroughs and borders.mov |
4.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1006 Formatting periods over 24 hours.mov |
3.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/10 Formatting Shortcuts/1004 Formatting data conditionally.mov |
2.8 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1102 Cleaning up spaces.mov |
9 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1103 Identifying duplicates.mov |
6.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1104 Splitting columns.mov |
5 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1106 Forcing dates to be weekdays only.mov |
4.3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1101 Sorting shortcuts.mov |
3.6 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1105 Ensuring unique entries.mov |
3 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/11 Database Techniques/1107 Displaying unique items from large lists.mov |
1.9 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1204 Linking and unlinking pictures.mov |
12.9 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1203 Creating and manipulating shapes.mov |
6.2 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1201 Placing and adjusting charts.mov |
3.2 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/12 Charting and Visual Object Tips/1202 Creating chart titles from cell content.mov |
2.7 MB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/13 Conclusion/1301 Goodbye.mov |
132 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter04.xlsx |
597 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter11.xlsx |
283 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter10.xlsx |
227 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter01.xlsx |
158 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter06.xlsx |
118 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter07.xlsx |
117 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter09.xlsx |
116 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter03.xlsx |
115 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter12.xlsx |
113 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter08.xlsx |
107 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter02.xlsx |
106 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter05.xlsx |
105 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/Exercise Files/Chapter04A.xlsx |
27 KB |
| excel 2010 training videos/1.4.Lynda.com.Excel.2010.Power.Shortcuts/jgtiso.nfo |
7 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/00 Introduction/0001 Welcome.mov |
8.6 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/00 Introduction/0002 Using the exercise files.mov |
765 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0103 Controlling Excel 2010 with keyboard shortcuts.mov |
6.8 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0104 Understanding the new file formats.mov |
5.8 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0102 Exploring the new Ribbon and Backstage view.mov |
5.4 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/01 Getting Started/0101 Understanding the reasons to switch.mov |
3.6 MB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/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 |
3.9 MB |
| excel 2010 training videos/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.3 MB |
| excel 2010 training videos/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.2 MB |
| excel 2010 training videos/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.2 MB |
| excel 2010 training videos/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 |
| excel 2010 training videos/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 |
8.9 MB |
| excel 2010 training videos/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 |
7.9 MB |
| excel 2010 training videos/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 |
6.8 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0304 Using conditional formatting.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/03 Performing Common Excel 2003 Tasks in Excel 2010/0303 Formatting a workbook.mov |
4.8 MB |
| excel 2010 training videos/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 |
3.9 MB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/04 Conclusion/0401 Goodbye.mov |
325 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap01/01_02/TT Billing Statement1.xls |
66 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap01/01_02/TT Billing Statement1.xlsx |
36 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap01/01_03/TT Billing Statement2.xls |
67 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap01/01_03/TT Billing Statement2.xlsx |
36 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap01/01_04/TT Billing Statement3.xls |
67 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap02/02_01/Expense Report.xlsx |
56 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap02/02_02/ExpenseBudget.xls |
56 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap02/02_03/ExpenseBudget.xlsx |
21 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap02/02_04/ExpenseBudget.xls |
41 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap02/02_05/ExpenseBudget.xlsx |
21 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_01/TTExpenses.xls |
55 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_02/RevTable.xls |
26 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_03/Sales Report1.xls |
64 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_03/Sales Report1.xlsx |
30 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_04/TTExpenses.xls |
48 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_04/TTExpenses.xlsx |
25 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_05/TTExpenses.xls |
48 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_05/TTExpenses.xlsx |
25 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_06/TTExpenses.xls |
48 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_06/TTExpenses.xlsm |
30 KB |
| excel 2010 training videos/Lynda.com - Migrating from Excel 2003 to Excel 2010/Exercise Files/Chap03/03_06/TTExpenses.xlsx |
25 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/00 Introduction/0001 Welcome.mov |
9.2 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/00 Introduction/0002 Using the exercise files.mov |
362 KB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/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.7 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0204 Using Auto Fill to enter date and time series.mov |
6.5 MB |
| excel 2010 training videos/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.2 MB |
| excel 2010 training videos/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.2 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/02 Creating Date Time Entries/0202 Using instant date time entry.mov |
1.6 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0303 Creating custom date formatting.mov |
2.9 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0302 Formatting time for hours over 24.mov |
2.4 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/03 Date Time Formatting/0301 Exploring keystroke shortcuts.mov |
2.3 MB |
| excel 2010 training videos/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 |
4.8 MB |
| excel 2010 training videos/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 |
4.8 MB |
| excel 2010 training videos/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.4 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0404 NETWORKDAYS Calculating working days.mov |
2.5 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/04 Excel's Date Time Functions/0405 WORKDAY Calculating an ending date.mov |
2 MB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0503 Calculating fiscal years and quarters.mov |
6.3 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0502 Calculating time differences within and across days.mov |
5.9 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0504 Rounding time calculations to convenient intervals.mov |
5.4 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/05 Calculating with Dates and Times/0505 Using times with currency calculations.mov |
2.9 MB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/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.3 MB |
| excel 2010 training videos/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.5 MB |
| excel 2010 training videos/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.3 MB |
| excel 2010 training videos/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.5 MB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/07 Conclusion/0701 Goodbye.mov |
269 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter01/02_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter01/01_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter02/04_BusinessData.xlsx |
134 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter02/01_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter02/02_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter02/03_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter03/02_BusinessData.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter03/03_BusinessData.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter03/01_BusinessData.xlsx |
132 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/06_BusinessData.xlsx |
157 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/01_BusinessData.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/03_BusinessData.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/02_BusinessData.xlsx |
134 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/04_BusinessData.xlsx |
133 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter04/05_BusinessData.xlsx |
133 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/05_BusinessData.xlsx |
157 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/06_BusinessData.xlsx |
157 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/04_BusinessData.xlsx |
157 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/03_BusinessData.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/01_BusinessData.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter05/02_BusinessData.xlsx |
145 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter06/02_BusinessData.xlsx |
148 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter06/03_BusinessData.xlsx |
146 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter06/04_BusinessData.xlsx |
146 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/Exercise Files/Chapter06/01_BusinessData.xlsx |
144 KB |
| excel 2010 training videos/Lynda.com Excel 2010 Working with Dates and Times/quasar.nfo |
3 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/00 Introduction/0001 Welcome.mov |
7.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/00 Introduction/0002 Using the exercise files.mov |
757 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0102 Touring the interface.mov |
7.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0105 Maintaining file compatibility.mov |
7.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0103 Finding the commands you need.mov |
5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0104 Using Backstage view or the File tab.mov |
3.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/01 Getting Started/0101 Exploring three common uses for Excel.mov |
3.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0204 Targeting large data groups.mov |
6.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov |
5.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0201 Creating a worksheet.mov |
5.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0202 Techniques for copying and pasting.mov |
4.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/02 Worksheet Basics/0205 Changing a worksheet's structure.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov |
6.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov |
6.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0306 Working with numbers in columns.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0303 Adding numbers manually.mov |
4.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0309 Using IF.mov |
4.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0301 Understanding formulas and functions.mov |
4.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0311 Naming and using cell ranges.mov |
4.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0308 Working with times and dates.mov |
3.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0302 Entering data in a worksheet.mov |
3.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/03 Excel Formula Basics/0305 Adding a whole worksheet.mov |
1.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0406 Adding pictures and shapes.mov |
9.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0401 Formatting numbers and dates.mov |
7.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0405 Using custom conditional formatting.mov |
7.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0404 Using conditional formatting.mov |
5.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov |
5.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0501 Inserting SmartArt.mov |
8.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0504 Creating and sharing styles.mov |
7.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0502 Coordinating a look using themes.mov |
4.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0503 Applying built-in styles.mov |
4.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0505 Using templates.mov |
4.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/05 Advanced Formatting/0506 Creating and using original templates.mov |
3.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/06 Printing Preparation/0601 Making the pieces fit.mov |
6.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/06 Printing Preparation/0603 Printing and PDFs.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/06 Printing Preparation/0602 Inserting headers and footers.mov |
4.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov |
8.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0706 Managing worksheets.mov |
7.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov |
7.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov |
7.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0702 Freezing panes.mov |
4.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0703 Repeating row and column titles.mov |
4.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/07 Large Excel Projects/0701 Finding and replacing data.mov |
4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0806 Saving files in shared locations.mov |
12.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov |
10.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0803 Inserting and editing comments.mov |
8.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0802 Setting workbook permissions.mov |
7.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0805 Tracking changes.mov |
3.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/08 Collaborating with Others/0804 Sharing a workbook.mov |
1.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov |
8.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov |
6.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov |
6.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov |
5.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov |
4.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov |
3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov |
9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1001 Using auditing to diagram.mov |
7.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1004 Using data tables in formulas.mov |
6.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1005 Using scenarios in formulas.mov |
5.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1003 Working with Goal Seek.mov |
5.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/10 Analyzing Data/1002 Using evaluation in Excel.mov |
2.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov |
7.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov |
7.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov |
3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov |
2.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov |
8.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1204 Modifying a column chart.mov |
6.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov |
5.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1202 Inserting Sparklines.mov |
4.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1203 Creating a column chart.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/12 Creating and Using Charts/1201 Choosing chart types.mov |
1.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/13 Creating and Using Macros/1302 Recording and using a simple macro.mov |
14.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/13 Creating and Using Macros/1303 Editing a macro.mov |
7.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/13 Creating and Using Macros/1301 Understanding macros.mov |
2.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/14 Customizing Excel/1402 Customizing the Ribbon bar.mov |
13.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/14 Customizing Excel/1403 Setting Excel options.mov |
9.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov |
4.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/15 Conclusion/1501 Goodbye.mov |
244 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/backstage view.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/ribbon bar.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/current format.xlsx |
146 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/what is excel for.xlsx |
144 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/touring the interface.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 1/older format workbook.xls |
35 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/data tables.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/analysis toolpack.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/auditing.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/goal seek.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/scenarios.xlsx |
133 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 10/evaluate.xlsx |
22 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 11/pivot table.xlsx |
156 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 11/pivot chart.xlsx |
147 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 11/modifying a pivottable.xlsx |
141 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 11/create pivot table.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/placing chart.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/modifying a chart.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/sparklines.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/column chart.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/pie chart.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/insert pie chart.pptx |
75 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 12/insert pie chart.docx |
43 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/editing macro.xlsm |
157 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/west data.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/overseas data.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/recording macro.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/northeast data.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 13/southeast data.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 14/setting options.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 14/customizing ribbon.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 14/customizing QAT.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 14/Bob's Customizations.exportedUI |
1 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 2/rows and columns.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 2/selections.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 2/autofill.xlsx |
9 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 2/clipboard.xlsx |
9 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/sumif.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/if.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/creating range names.xlsx |
21 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/sum.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/whole worksheet.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/average.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/dates.xlsx |
11 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/manual.xlsx |
11 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/absolute refs.xlsx |
11 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/expense report.xlsx |
9 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 3/formulas and functions.xlsx |
9 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/custom conditional formatting.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/conditional formatting.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/pictures - finished.xlsx |
74 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/bottle.jpg |
48 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/pictures.xlsx |
15 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/adjusting.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/fonts.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 4/formatting numbers.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/logo.jpg |
161 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/custom styles.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/styles.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/merge styles.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/smart art.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/turn into template.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/garlic.jpg |
51 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/gift pack.jpg |
31 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/themes.xlsx |
25 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 5/herbs.jpg |
19 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 6/create PDFs.xlsx |
89 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 6/headers and footers.xlsx |
68 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 6/page size.xlsx |
68 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 6/logo.jpg |
24 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/freezing panes.xlsx |
153 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/3D formulas.xlsx |
152 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/views.xlsx |
140 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/grouping.xlsx |
138 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/repeating rows.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/find and replace.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 7/managing worksheets.xlsx |
137 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/comments.xlsx |
201 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/permissions.xlsx |
144 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/sharing.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/protecting.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/import into this.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/export this.xlsx |
136 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/kalamata.jpg |
62 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/multi-pack 1.jpg |
31 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/saving shared locations.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/import data.csv |
2 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 8/import data.txt |
2 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/tables.xlsx |
140 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/subtotals.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/sorting.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/merging.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/splitting.xlsx |
139 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/Exercise Files/chapt 9/lookups.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.Essential.Training-QUASAR/quasar.nfo |
3 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/00 Introduction/0001 Welcome.mov |
7.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/00 Introduction/0002 Using the exercise files.mov |
575 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0101 Customizing the Ribbon bar.mov |
10.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0103 Maintaining compatibility.mov |
7.2 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0107 Preparing to share a document.mov |
6.8 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0104 Making templates easier.mov |
6.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0105 Handling document versions.mov |
5.3 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0106 Changing the file type and converting to Adobe PDF.mov |
4.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0108 Making printing easier.mov |
4.5 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/01 File Tab, AKA Backstage View/0102 Looking at Backstage view.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/02 Collaboration Tools/0203 Sharing a document on the free Microsoft SkyDrive web site.mov |
10.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/02 Collaboration Tools/0204 Sharing a document through a Microsoft SharePoint portal.mov |
6.9 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/02 Collaboration Tools/0202 Sharing a document by email.mov |
4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/02 Collaboration Tools/0201 Setting document permissions.mov |
4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/03 Data Tools/0301 Using enhanced smart tags and the Paste preview.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/03 Data Tools/0302 Filtering a table by searching.mov |
3.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/04 Graphic Features/0403 Formatting math equations with the improved equation tools.mov |
7 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/04 Graphic Features/0401 Inserting Sparklines.mov |
6.1 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/04 Graphic Features/0404 Editing pictures with the improved picture tools.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/04 Graphic Features/0402 Applying the enhanced conditional formatting features.mov |
2.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/05 Pivot Tables/0502 Analyzing data from multiple sources using the PowerPivot plug-in.mov |
15 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/05 Pivot Tables/0501 Using the Slicer to make PivotTables more interactive.mov |
2.6 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/06 Going Beyond the Desktop/0601 Editing a worksheet in the Excel Web App.mov |
10.4 MB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/07 Conclusion/0701 Goodbye.mov |
199 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_06_converting.xlsx |
396 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_05_properties.xlsx |
396 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/03 older format workbook.xls |
261 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_03_current format.xlsx |
161 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_02_backstage.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_08_printing.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_04_turn into template.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 1/01_07_preparing.xlsx |
146 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 2/02_02_sharing.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 2/02_01_permissions.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 2/02_04_sharepoint.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 2/02_03_sky drive.xlsx |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 3/03_01_smart tags.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 3/03_02_filter.xlsx |
135 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 4/04_03_equations.xlsx |
154 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 4/04_02_conditional formatting.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 4/04_01_sparklines.xlsx |
151 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 4/04_04_olive_tree_valley.jpg |
48 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 4/04_04_bottles.jpg |
31 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 5/Finished/05_02_powerpivot analysis.xlsx |
276 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 5/05_02_product codes.accdb |
412 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 5/05_01_slicer.xlsx |
140 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 5/05_02_powerpivot sales volume.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 5/05_02_powerpivot sales reps.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/Exercise Files/chapt 6/06_01_web app.xlsx |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.2010.New.Features-QUASAR/quasar.nfo |
3 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/00 Introduction/0001 Welcome.mov |
4.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/00 Introduction/0002 Using the exercise files.mov |
280 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov |
6.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0106 Creating a subroutine or function.mov |
5.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0103 Working in the Visual Basic editor.mov |
5 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0109 Running a VBA routine.mov |
4.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0102 Examining the Excel object model.mov |
3.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0108 Adding comments to the code.mov |
3.5 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0107 Controlling procedure scope and visibility.mov |
3.3 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0110 Adding code to a recorded macro.mov |
3.2 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0104 Setting VBA project properties.mov |
2.4 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/01 Introducing Visual Basic for Applications/0101 Introducing object-oriented programming.mov |
1.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0206 Defining arrays.mov |
7.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0201 Introducing Excel VBA data types.mov |
6.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0204 Defining static variables and constants.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0202 Declaring variables and requiring declaration before use.mov |
4.2 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0203 Managing variable scope.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0208 Streamlining code references using With End With statements.mov |
3.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0205 Creating a calculation using mathematical operators.mov |
3.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/02 Defining Variables, Constants, and Calculations/0207 Defining and using object variables.mov |
2.8 MB |
| excel 2010 training videos/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.mov |
7.2 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0303 Repeating a task with a Do loop.mov |
5.3 MB |
| excel 2010 training videos/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.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/03 Adding Logic to Your VBA Code/0301 Repeating a task using a For Next loop.mov |
2.5 MB |
| excel 2010 training videos/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 |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0402 Stepping through a subroutine or function.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0401 Managing errors using On Error statements.mov |
4.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0404 Verifying output using the Immediate window.mov |
3.8 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0405 Watching a value in a routine.mov |
2.9 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/04 Debugging You VBA Code/0403 Setting breakpoints in the code.mov |
2.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0507 Managing worksheets with VBA.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0502 Cutting, copying, and pasting cell data.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0503 Finding values in cells.mov |
4.2 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0505 Concatenating text strings.mov |
4 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0508 Managing workbooks with VBA.mov |
3.9 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0501 Writing a value to a cell.mov |
3.6 MB |
| excel 2010 training videos/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 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/05 Managing Workbook Elements and Data in VBA/0506 Returning part of a string.mov |
2.8 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0603 Acquiring values using an input box or message box.mov |
5.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0601 Turning off screen updating within a macro.mov |
2.5 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0602 Using worksheet functions in a macro.mov |
2.4 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/06 Adding Advanced Elements to Your Workbook/0604 Calling a subroutine from another subroutine.mov |
2 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/07 Using Excel Events in Your VBA Code/0702 Running a procedure when a cell range changes.mov |
4.6 MB |
| excel 2010 training videos/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.3 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/07 Using Excel Events in Your VBA Code/0703 Triggering a procedure using a specific key sequence.mov |
3.7 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/08 Putting it All Together/0801 Applying techniques in a Capstone project.mov |
6.1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/09 Conclusion/0901 Goodbye.mov |
251 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/Scope.xlsm |
41 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/Comments.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/RunAMacro.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/Commission.xlsm |
38 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/Scope.xlsx |
37 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/RecordFirst.xlsm |
18 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/ProjectProperties.xlsm |
16 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/VBEditor.xlsm |
14 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/ModulesManaged.xlsm |
10 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch01/VBEditor.xlsx |
10 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/Operators.xlsm |
41 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/ConstantStatic.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/DimVariables.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/VariableScope.xlsm |
38 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/MonthlySales.xlsm |
18 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/ShippingCharges.xlsm |
18 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/Types.xlsm |
16 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch02/WithExample.xlsm |
9 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch03/Suggestions.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch03/IfThen.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch03/Case.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch03/ForEach.xlsm |
18 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch03/ForNext.xlsm |
17 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch04/Stepping.xlsm |
43 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch04/Immediate.xlsm |
42 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch04/Breaking.xlsm |
42 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch04/Watch.xlsm |
17 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch04/CheckError.xlsm |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Writing.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Offset.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Worksheets.xlsm |
38 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/CutPaste.xlsm |
17 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Concatenate.xlsm |
15 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Find.xlsm |
13 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/CutStrings.xlsm |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch05/Workbooks.xlsm |
12 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch06/Flashing.xlsm |
41 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch06/Boxes.xlsm |
41 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch06/Calling.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch06/WorksheetFunctions.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch07/.TEMP_com.apple.iWork.Numbers_1443_296003542_1/image1.tiff |
1 MB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch07/ManipulateWorkbook.xlsm |
41 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch07/OnKey.xlsm |
40 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch07/ChangeRange.xlsm |
39 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/Exercise Files/Ch08/Capstone.xlsm |
46 KB |
| excel 2010 training videos/Lynda.com.Excel.VBA.in.Depth-QUASAR/quasar.nfo |
3 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.01.Introduction/60273_00_01_MM01_welcome.mov |
2.5 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.01.Introduction/60273_00_02_SC11_exerfiles.mov |
517 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.02.Microsoft Excel/60273_01_05_SC11_pasting.mov |
5.9 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.02.Microsoft Excel/60273_01_04_SC11_visual.mov |
5.8 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.02.Microsoft Excel/60273_01_03_SC11_pivot.mov |
5.7 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.02.Microsoft Excel/60273_01_02_SC11_custom.mov |
5.6 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.02.Microsoft Excel/60273_01_01_SC11_sparklines.mo.mov |
4.5 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.03.Conclusion/60273_02_01_SC11_goodbye.mov |
193 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/AllData.xlsx |
1 MB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/Hydrangeas.jpg |
581 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/GreenhouseTiming.xlsx |
63 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/SalesPerformance.xlsx |
20 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/Customizing.xlsm |
19 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/Hydrangea.xlsx |
8 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/00.04.Exercise Files/NewProductReports.xlsx |
8 KB |
| excel 2010 training videos/Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO/ironiso.nfo |
7 KB |
| excel 2010 training videos/i.nfo |
2 KB |
Magnet link
