Lynda - Office 365 for Mac Essential Training: Excel
File List
| File | Size |
|---|---|
| 019 Restricting input using validation rules.mp4 | 16.91 MB |
| 044 Managing scenarios.mp4 | 15.96 MB |
| 054 Defining data bar, color scale, and icon set conditional formats.mp4 | 15.91 MB |
| 025 Splitting and freezing rows and columns.mp4 | 15.11 MB |
| 085 Filtering a PivotTable report.mp4 | 14.9 MB |
| 016 Creating named ranges.mp4 | 14.7 MB |
| 037 Summarizing data using SUMIF and other conditional functions.mp4 | 14.42 MB |
| 018 Locating and changing data using Find and Replace.mp4 | 13.74 MB |
| 051 Managing Office themes.mp4 | 13.6 MB |
| 031 Using relative and absolute cell references.mp4 | 13.17 MB |
| 072 Adding and adjusting images.mp4 | 13.04 MB |
| 071 Creating and formatting shapes.mp4 | 12.69 MB |
| 015 Inserting symbols and special characters.mp4 | 12.12 MB |
| 077 Aligning and layering objects.mp4 | 12 MB |
| 047 Applying number and date formats to cells.mp4 | 11.97 MB |
| 074 Cropping, compressing, and removing image backgrounds.mp4 | 11.94 MB |
| 056 Creating bar and column charts.mp4 | 11.94 MB |
| 083 Changing the data field summary operation.mp4 | 11.9 MB |
| 046 Applying fonts, background colors, and borders.mp4 | 11.85 MB |
| 004 Exploring the Excel 2016 program window.mp4 | 11.73 MB |
| 026 Managing worksheets.mp4 | 11.43 MB |
| 022 Creating a custom sort order.mp4 | 11.39 MB |
| 053 Defining top 10 conditional formats.mp4 | 10.91 MB |
| 036 Summarizing data using an IF function.mp4 | 10.75 MB |
| 052 Creating rule-based conditional formats.mp4 | 10.66 MB |
| 048 Managing text alignment.mp4 | 10.62 MB |
| 050 Managing cell styles.mp4 | 10.57 MB |
| 017 Creating an Excel table.mp4 | 10.47 MB |
| 032 Controlling how Excel copies and pastes formulas.mp4 | 10.27 MB |
| 006 Setting program preferences.mp4 | 10.19 MB |
| 043 Managing Excel formula error indicators.mp4 | 10.16 MB |
| 088 Setting AutoCorrect and automatic Replace options.mp4 | 10.02 MB |
| 030 Introducing arithmetic operators.mp4 | 9.97 MB |
| 013 Copying and pasting cell data.mp4 | 9.95 MB |
| 090 Tracking and reviewing changes.mp4 | 9.91 MB |
| 012 Selecting cells and groups of cells.mp4 | 9.85 MB |
| 065 Creating sparkline charts.mp4 | 9.79 MB |
| 024 Inserting, moving, and deleting cells and cell ranges.mp4 | 9.7 MB |
| 005 Introducing the Ribbon for the Mac.mp4 | 9.7 MB |
| 055 Editing, ordering, and deleting conditional formats.mp4 | 9.62 MB |
| 068 Using hyperlinks.mp4 | 9.51 MB |
| 075 Creating SmartArt graphics.mp4 | 9.5 MB |
| 034 Creating an AUTOSUM formula.mp4 | 9.4 MB |
| 039 Rounding cell values.mp4 | 9.07 MB |
| 029 Adding a formula to a cell.mp4 | 9.04 MB |
| 066 Importing data from comma-separated value (CSV) or text files.mp4 | 8.92 MB |
| 014 Entering data using AutoFill and other techniques.mp4 | 8.78 MB |
| 023 Filtering worksheet data.mp4 | 8.76 MB |
| 010 Creating and modifying workbook templates.mp4 | 8.56 MB |
| 008 Opening, creating, and saving workbooks.mp4 | 8.33 MB |
| 033 Referring to Excel table data in formulas.mp4 | 8.33 MB |
| 027 Creating, editing, and deleting headers and footers.mp4 | 8.27 MB |
| 040 Joining text in cells with concatenation.mp4 | 8.09 MB |
| 069 Including an Excel workbook in another Office document.mp4 | 8.08 MB |
| 062 Changing the appearance of chart elements.mp4 | 8.08 MB |
| 007 Getting help in Excel.mp4 | 7.96 MB |
| 049 Copying cell formats.mp4 | 7.91 MB |
| 064 Adding trendlines to charts.mp4 | 7.89 MB |
| 073 Manipulating text boxes.mp4 | 7.88 MB |
| 095 Running an existing macro.mp4 | 7.86 MB |
| 081 Managing subtotals and grand totals.mp4 | 7.83 MB |
| 041 Finding data using VLOOKUP and HLOOKUP.mp4 | 7.78 MB |
| 099 Turning off screen updating in a macro.mp4 | 7.77 MB |
| 094 Protecting a workbook.mp4 | 7.52 MB |
| 079 Creating a PivotTable report.mp4 | 7.48 MB |
| 058 Creating line charts.mp4 | 7.48 MB |
| 089 Managing workbook comments.mp4 | 7.44 MB |
| 021 Sorting worksheet data.mp4 | 7.44 MB |
| 080 Pivoting a PivotTable report.mp4 | 7.29 MB |
| 020 Using lists to limit data entered into a cell.mp4 | 6.91 MB |
| 011 Managing workbooks across multiple versions of Excel.mp4 | 6.82 MB |
| 042 Auditing formulas by identifying precedents and dependents.mp4 | 6.8 MB |
| 063 Managing chart axes and numbering.mp4 | 6.8 MB |
| 028 Introducing Excel formulas and functions.mp4 | 6.77 MB |
| 091 Printing a worksheet or workbook.mp4 | 6.73 MB |
| 078 Introducing PivotTable reports.mp4 | 6.67 MB |
| 045 Performing Goal Seek analysis.mp4 | 6.66 MB |
| 093 Exporting to other formats.mp4 | 6.63 MB |
| 087 Checking spelling.mp4 | 6.48 MB |
| 003 What you can do with Excel 2016.mp4 | 6.42 MB |
| 096 Recording a macro.mp4 | 6.37 MB |
| 086 Applying a PivotTable style.mp4 | 6.3 MB |
| 076 Creating WordArt.mp4 | 6.25 MB |
| 009 Setting workbook properties.mp4 | 6.16 MB |
| 097 Renaming, viewing, and deleting macros.mp4 | 6.12 MB |
| 092 Setting and removing print areas.mp4 | 6.07 MB |
| 038 Creating formulas to count cells.mp4 | 6.02 MB |
| 060 Creating stock charts.mp4 | 5.94 MB |
| 001 Welcome.mp4 | 5.9 MB |
| 061 Changing chart types and layouts.mp4 | 5.81 MB |
| 070 Linking to an Excel chart from another Office program.mp4 | 5.72 MB |
| 098 Adding comments to a macro.mp4 | 5.63 MB |
| 059 Creating XY (scatter) charts.mp4 | 5.6 MB |
| 057 Creating pie charts.mp4 | 5.51 MB |
| 035 Summarizing data on the status bar.mp4 | 5.3 MB |
| 084 Changing the data field number format.mp4 | 4.67 MB |
| 082 Summarizing more than one data field.mp4 | 4.58 MB |
| 067 Connecting to an external data source.mp4 | 3.4 MB |
| 100 Next steps.mp4 | 2.96 MB |
| 002 Using the exercise files.mp4 | 1002.54 KB |
Trackers
No trackers found.