Lynda Com Excel for Mac 2011 Essential Training
File List
| File | Size |
|---|---|
| 00 Introduction/0001 Welcome.mov | 8.27 MB |
| 00 Introduction/0002 Using the exercise files.mov | 633.81 KB |
| 01 Getting Started with Excel/0101 Exploring the Excel 2011 window.mov | 5.12 MB |
| 01 Getting Started with Excel/0102 Introducing the Ribbon for Mac.mov | 5.64 MB |
| 01 Getting Started with Excel/0103 Customizing the Ribbon.mov | 5.16 MB |
| 01 Getting Started with Excel/0104 Setting program preferences.mov | 4.05 MB |
| 01 Getting Started with Excel/0105 Getting help in Excel.mov | 6.75 MB |
| 02 Managing Workbooks/0201 Opening creating and saving workbooks.mov | 6.4 MB |
| 02 Managing Workbooks/0202 Setting workbook properties.mov | 5.22 MB |
| 02 Managing Workbooks/0203 Creating and modifying workbook templates.mov | 5.15 MB |
| 02 Managing Workbooks/0204 Managing workbooks across multiple versions of Excel.mov | 8.42 MB |
| 03 Managing Worksheets Cells and Cell Data/0301 Selecting cells and groups of cells.mov | 5.46 MB |
| 03 Managing Worksheets Cells and Cell Data/0302 Copying and pasting cell data.mov | 2.96 MB |
| 03 Managing Worksheets Cells and Cell Data/0303 Entering data using AutoFill and other techniques.mov | 4.91 MB |
| 03 Managing Worksheets Cells and Cell Data/0304 Entering data using AutoFill and other techniques.mov | 6.08 MB |
| 03 Managing Worksheets Cells and Cell Data/0305 Creating an Excel table.mov | 5.26 MB |
| 03 Managing Worksheets Cells and Cell Data/0306 Locating and changing data using Find and Replace.mov | 5.43 MB |
| 03 Managing Worksheets Cells and Cell Data/0307 Restricting input using validation rules.mov | 5.02 MB |
| 03 Managing Worksheets Cells and Cell Data/0308 Using lists to limit data entered into a cell.mov | 2.84 MB |
| 03 Managing Worksheets Cells and Cell Data/0309 Sorting worksheet data.mov | 3.47 MB |
| 03 Managing Worksheets Cells and Cell Data/0310 Creating a custom sort order.mov | 4.45 MB |
| 03 Managing Worksheets Cells and Cell Data/0311 Filtering worksheet data.mov | 4.4 MB |
| 03 Managing Worksheets Cells and Cell Data/0312 Inserting moving and deleting cells and cell ranges .mov | 4.21 MB |
| 03 Managing Worksheets Cells and Cell Data/0313 Splitting and freezing rows and columns.mov | 4.69 MB |
| 03 Managing Worksheets Cells and Cell Data/0314 Managing worksheets.mov | 10.56 MB |
| 03 Managing Worksheets Cells and Cell Data/0315 Creating editing and deleting headers and footers.mov | 5.42 MB |
| 04 Summarizing Data Using Formulas and Functions/0401 Introducing Excel formulas and functions.mov | 3.96 MB |
| 04 Summarizing Data Using Formulas and Functions/0402 Adding a formula to a cell.mov | 4.15 MB |
| 04 Summarizing Data Using Formulas and Functions/0403 Introducing arithmetic operators.mov | 4.41 MB |
| 04 Summarizing Data Using Formulas and Functions/0404 Using absolute and relative cell references.mov | 7.19 MB |
| 04 Summarizing Data Using Formulas and Functions/0405 Controlling how Excel copies and pastes formulas.mov | 6.38 MB |
| 04 Summarizing Data Using Formulas and Functions/0406 Referring to Excel table data in formulas.mov | 2.2 MB |
| 04 Summarizing Data Using Formulas and Functions/0407 Creating an AutoSum formula.mov | 3.53 MB |
| 04 Summarizing Data Using Formulas and Functions/0408 Summarizing data on the status bar.mov | 2.78 MB |
| 04 Summarizing Data Using Formulas and Functions/0409 Joining text in cells with concatenation.mov | 4.01 MB |
| 04 Summarizing Data Using Formulas and Functions/0410 Summarizing data using an IF function.mov | 6.27 MB |
| 04 Summarizing Data Using Formulas and Functions/0411 Summarizing data using SUMIF and other conditional function.mov | 5.62 MB |
| 04 Summarizing Data Using Formulas and Functions/0412 Creating formulas to count cells.mov | 2.59 MB |
| 04 Summarizing Data Using Formulas and Functions/0413 Rounding cell values up and down.mov | 4.98 MB |
| 04 Summarizing Data Using Formulas and Functions/0414 Finding data using VLOOKUP and HLOOKUP.mov | 6.58 MB |
| 04 Summarizing Data Using Formulas and Functions/0415 Auditing formulas by identifying precedents and dependents.mov | 3.57 MB |
| 04 Summarizing Data Using Formulas and Functions/0416 Managing Excel formula error indicators.mov | 8.35 MB |
| 04 Summarizing Data Using Formulas and Functions/0417 Managing scenarios.mov | 5.2 MB |
| 04 Summarizing Data Using Formulas and Functions/0418 Performing Goal Seek analysis.mov | 3.47 MB |
| 05 Formatting Worksheet Elements/0501 Applying fonts background colors and borders.mov | 7.39 MB |
| 05 Formatting Worksheet Elements/0502 Applying number and date formats to cells.mov | 7.51 MB |
| 05 Formatting Worksheet Elements/0503 Managing text alignment.mov | 4.05 MB |
| 05 Formatting Worksheet Elements/0504 Copying cell formats.mov | 4.23 MB |
| 05 Formatting Worksheet Elements/0505 Managing cell styles.mov | 3.79 MB |
| 05 Formatting Worksheet Elements/0506 Managing Office themes.mov | 6.53 MB |
| 05 Formatting Worksheet Elements/0507 Creating rule-based conditional formats.mov | 4.19 MB |
| 05 Formatting Worksheet Elements/0508 Defining Top 10 conditional formats.mov | 4.36 MB |
| 05 Formatting Worksheet Elements/0509 Defining data bar color scale and icon set conditional form.mov | 6.97 MB |
| 05 Formatting Worksheet Elements/0510 Editing ordering and deleting conditional formats.mov | 4.15 MB |
| 06 Working with Charts/0601 Creating bar and column charts.mov | 6.03 MB |
| 06 Working with Charts/0602 Creating pie charts.mov | 2.66 MB |
| 06 Working with Charts/0603 Creating line charts.mov | 5.19 MB |
| 06 Working with Charts/0604 Creating XY scatter charts.mov | 1.81 MB |
| 06 Working with Charts/0605 Creating stock charts.mov | 4.23 MB |
| 06 Working with Charts/0606 Changing chart types and layouts.mov | 2.35 MB |
| 06 Working with Charts/0607 Changing the appearance of a chart.mov | 5.1 MB |
| 06 Working with Charts/0608 Managing chart axes and numbering.mov | 3.04 MB |
| 06 Working with Charts/0609 Adding trendlines to charts.mov | 4.42 MB |
| 06 Working with Charts/0610 Creating sparkline charts.mov | 5.39 MB |
| 07 Working with External Data/0701 Importing data from comma separated value CSV or text files.mov | 5.13 MB |
| 07 Working with External Data/0702 Connecting to an external data source.mov | 2.6 MB |
| 07 Working with External Data/0703 Using hyperlinks.mov | 8.26 MB |
| 07 Working with External Data/0704 Including an Excel workbook in another Office document.mov | 3.64 MB |
| 07 Working with External Data/0705 Linking to an Excel chart from another Office program.mov | 3.31 MB |
| 08 Working with Objects/0801 Creating and formatting shapes.mov | 3.46 MB |
| 08 Working with Objects/0802 Adding and adjusting images.mov | 7.53 MB |
| 08 Working with Objects/0803 Cropping compressing and removing image backgrounds.mov | 6.36 MB |
| 08 Working with Objects/0804 Creating SmartArt graphics.mov | 5.24 MB |
| 08 Working with Objects/0805 Creating WordArt.mov | 2.82 MB |
| 08 Working with Objects/0806 Aligning and layering objects.mov | 6.85 MB |
| 09 Exploring PivotTable Reports/0901 Exploring PivotTable Reports.mov | 5.1 MB |
| 09 Exploring PivotTable Reports/0902 Creating a PivotTable report.mov | 4.98 MB |
| 09 Exploring PivotTable Reports/0903 Pivoting a PivotTable report.mov | 4.6 MB |
| 09 Exploring PivotTable Reports/0904 Managing subtotals and grand totals.mov | 3.62 MB |
| 09 Exploring PivotTable Reports/0905 Summarizing more than one data field.mov | 1.83 MB |
| 09 Exploring PivotTable Reports/0906 Changing the data field summary operation.mov | 2.96 MB |
| 09 Exploring PivotTable Reports/0907 Changing the data field number format.mov | 2.59 MB |
| 09 Exploring PivotTable Reports/0908 Filtering a PivotTable report.mov | 3.03 MB |
| 09 Exploring PivotTable Reports/0909 Applying a PivotTable style.mov | 3.17 MB |
| 09 Exploring PivotTable Reports/0910 Creating and editing styles.mov | 3.53 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1001 Checking spelling.mov | 3.76 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1002 Setting AutoCorrect and automatic Replace options.mov | 4.27 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1003 Managing workbook comments.mov | 4.08 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1004 Tracking and reviewing changes.mov | 8.62 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1005 Printing a worksheet or workbook.mov | 6.02 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1006 Setting and removing print areas.mov | 2.94 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1007 Exporting to other formats.mov | 1.84 MB |
| 10 Reviewing and Sharing Your Spreadsheets/1008 Protecting a workbook.mov | 2.7 MB |
| 11 Automating Workbooks Using Macros/1101 Running an existing macro.mov | 5.32 MB |
| 11 Automating Workbooks Using Macros/1102 Recording a macro.mov | 4.15 MB |
| 11 Automating Workbooks Using Macros/1103 Recording a macro using relative references.mov | 8.91 MB |
| 11 Automating Workbooks Using Macros/1104 Renaming viewing and deleting macros.mov | 3.11 MB |
| 11 Automating Workbooks Using Macros/1105 Adding comments to a macro.mov | 2.72 MB |
| 11 Automating Workbooks Using Macros/1106 Turning off screen updating in a macro.mov | 3.31 MB |
| 12 Conclusion/1201 Additional resources.mov | 892.91 KB |
Trackers
No trackers found.