Lynda - Office 2016 for Mac Essential Training: Excel
File List
- 019 Restricting input using validation rules.mp4 16.9 MB
- 044 Managing scenarios.mp4 15.9 MB
- 054 Defining data bar, color scale, and icon set conditional formats.mp4 15.9 MB
- 025 Splitting and freezing rows and columns.mp4 15.1 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.4 MB
- 018 Locating and changing data using Find and Replace.mp4 13.8 MB
- 051 Managing Office themes.mp4 13.6 MB
- 031 Using relative and absolute cell references.mp4 13.2 MB
- 072 Adding and adjusting images.mp4 13.1 MB
- 071 Creating and formatting shapes.mp4 12.7 MB
- 015 Inserting symbols and special characters.mp4 12.1 MB
- 077 Aligning and layering objects.mp4 12.0 MB
- 074 Cropping, compressing, and removing image backgrounds.mp4 12.0 MB
- 056 Creating bar and column charts.mp4 12.0 MB
- 047 Applying number and date formats to cells.mp4 11.9 MB
- 083 Changing the data field summary operation.mp4 11.9 MB
- 046 Applying fonts, background colors, and borders.mp4 11.8 MB
- 004 Exploring the Excel 2016 program window.mp4 11.7 MB
- 026 Managing worksheets.mp4 11.4 MB
- 022 Creating a custom sort order.mp4 11.4 MB
- 053 Defining top 10 conditional formats.mp4 10.9 MB
- 036 Summarizing data using an IF function.mp4 10.7 MB
- 052 Creating rule-based conditional formats.mp4 10.7 MB
- 048 Managing text alignment.mp4 10.6 MB
- 050 Managing cell styles.mp4 10.6 MB
- 017 Creating an Excel table.mp4 10.5 MB
- 032 Controlling how Excel copies and pastes formulas.mp4 10.3 MB
- 006 Setting program preferences.mp4 10.2 MB
- 043 Managing Excel formula error indicators.mp4 10.1 MB
- 088 Setting AutoCorrect and automatic Replace options.mp4 10.0 MB
- 030 Introducing arithmetic operators.mp4 10.0 MB
- 013 Copying and pasting cell data.mp4 9.9 MB
- 090 Tracking and reviewing changes.mp4 9.9 MB
- 012 Selecting cells and groups of cells.mp4 9.8 MB
- 065 Creating sparkline charts.mp4 9.8 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.6 MB
- 075 Creating SmartArt graphics.mp4 9.5 MB
- 068 Using hyperlinks.mp4 9.5 MB
- 034 Creating an AutoSum formula.mp4 9.4 MB
- 039 Rounding cell values.mp4 9.1 MB
- 029 Adding a formula to a cell.mp4 9.0 MB
- 066 Importing data from comma-separated value (CSV) or text files.mp4 8.9 MB
- 014 Entering data using AutoFill and other techniques.mp4 8.8 MB
- 023 Filtering worksheet data.mp4 8.8 MB
- 010 Creating and modifying workbook templates.mp4 8.5 MB
- 033 Referring to Excel table data in formulas.mp4 8.3 MB
- 008 Opening, creating, and saving workbooks.mp4 8.3 MB
- 027 Creating, editing, and deleting headers and footers.mp4 8.3 MB
- 040 Joining text in cells with concatenation.mp4 8.1 MB
- 062 Changing the appearance of chart elements.mp4 8.1 MB
- 069 Including an Excel workbook in another Office document.mp4 8.1 MB
- 007 Getting help in Excel.mp4 8.0 MB
- 049 Copying cell formats.mp4 7.9 MB
- 073 Manipulating text boxes.mp4 7.9 MB
- 064 Adding trendlines to charts.mp4 7.9 MB
- 095 Running an existing macro.mp4 7.9 MB
- 081 Managing subtotals and grand totals.mp4 7.8 MB
- 041 Finding data using VLOOKUP and HLOOKUP.mp4 7.8 MB
- 099 Turning off screen updating in a macro.mp4 7.8 MB
- 094 Protecting a workbook.mp4 7.5 MB
- 079 Creating a PivotTable report.mp4 7.5 MB
- 021 Sorting worksheet data.mp4 7.4 MB
- 089 Managing workbook comments.mp4 7.4 MB
- 058 Creating line charts.mp4 7.4 MB
- 080 Pivoting a PivotTable report.mp4 7.3 MB
- 020 Using lists to limit data entered into a cell.mp4 6.9 MB
- 011 Managing workbooks across multiple versions of Excel.mp4 6.8 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.8 MB
- 091 Printing a worksheet or workbook.mp4 6.7 MB
- 078 Introducing PivotTable reports.mp4 6.7 MB
- 045 Performing Goal Seek analysis.mp4 6.7 MB
- 093 Exporting to other formats.mp4 6.6 MB
- 087 Checking spelling.mp4 6.5 MB
- 003 What you can do with Excel 2016.mp4 6.4 MB
- 096 Recording a macro.mp4 6.4 MB
- 086 Applying a PivotTable style.mp4 6.4 MB
- 076 Creating WordArt.mp4 6.3 MB
- 009 Setting workbook properties.mp4 6.2 MB
- 097 Renaming, viewing, and deleting macros.mp4 6.1 MB
- 092 Setting and removing print areas.mp4 6.1 MB
- 038 Creating formulas to count cells.mp4 6.0 MB
- 060 Creating stock charts.mp4 5.9 MB
- 061 Changing chart types and layouts.mp4 5.8 MB
- 070 Linking to an Excel chart from another Office program.mp4 5.7 MB
- 098 Adding comments to a macro.mp4 5.6 MB
- 059 Creating XY (scatter) charts.mp4 5.6 MB
- 057 Creating pie charts.mp4 5.5 MB
- 035 Summarizing data on the status bar.mp4 5.3 MB
- 001 Welcome.mp4 5.0 MB
- 084 Changing the data field number format.mp4 4.7 MB
- 082 Summarizing more than one data field.mp4 4.6 MB
- 067 Connecting to an external data source.mp4 3.4 MB
- 100 Next steps.mp4 3.2 MB
- 002 Using the exercise files.mp4 1004.8 KB
- Exercise Files/Chapter10/Aligning.xlsx 63.7 KB
- Exercise Files/Chapter13/ManageMacros.xlsm 40.4 KB
- Exercise Files/Chapter13/NoFlash.xlsm 39.9 KB
- Exercise Files/Chapter10/ManageImages.xlsx 36.6 KB
- Exercise Files/Chapter07/CellStyle.xlsx 33.7 KB
- Exercise Files/Chapter03/ManageCells.xlsx 33.6 KB
- Exercise Files/Chapter07/CopyFormat.xlsx 32.8 KB
- Exercise Files/Chapter07/CellFormats.xlsx 31.3 KB
- Exercise Files/Chapter07/NewConds.xlsx 31.0 KB
- Exercise Files/Chapter07/MngConds.xlsx 29.2 KB
- Exercise Files/Chapter07/BasicFormatting.xlsx 28.5 KB
- Exercise Files/Chapter12/AutoCorrect.xlsx 28.4 KB
- Exercise Files/Chapter07/Themes.xlsx 28.0 KB
- Exercise Files/Chapter03/Symbols.xlsx 27.8 KB
- Exercise Files/Chapter13/Comments.xlsm 27.7 KB
- Exercise Files/Chapter07/Conditional.xlsx 27.0 KB
- Exercise Files/Chapter07/NumberFormats.xlsx 26.7 KB
- Exercise Files/Chapter07/Alignment.xlsx 25.9 KB
- Exercise Files/Chapter07/TopTen.xlsx 24.8 KB
- Exercise Files/Chapter13/Record.xlsx 24.2 KB
- Exercise Files/Chapter13/Relative.xlsm 22.6 KB
- Exercise Files/Chapter13/Relative.xlsx 22.1 KB
- Exercise Files/Chapter10/London.jpg 21.0 KB
- Exercise Files/Chapter09/LinkToWeb.xlsx 19.0 KB
- Exercise Files/Chapter11/Styles.xlsx 18.0 KB
- Exercise Files/Chapter09/PivotReport.xlsx 18.0 KB
- Exercise Files/Chapter11/Filters.xlsx 17.8 KB
- Exercise Files/Chapter11/DataFormat.xlsx 17.7 KB
- Exercise Files/Chapter11/MultipleDataFields.xlsx 17.1 KB
- Exercise Files/Chapter11/Totals.xlsx 17.1 KB
- Exercise Files/Chapter11/PivotIntro.xlsx 17.0 KB
- Exercise Files/Chapter11/SummaryOperation.xlsx 17.0 KB
- Exercise Files/Chapter09/WebData.htm 16.8 KB
- Exercise Files/Chapter10/WestEnd.jpg 16.5 KB
- Exercise Files/Chapter11/Pivoting.xlsx 16.3 KB
- Exercise Files/Chapter10/WomanShopping.jpg 15.6 KB
- Exercise Files/Chapter04/MoveTarget.xlsx 15.3 KB
- Exercise Files/Chapter13/RunAMacro.xlsm 15.1 KB
- Exercise Files/Chapter08/ChartElements.xlsx 14.9 KB
- Exercise Files/Chapter08/ChartLayout.xlsx 14.9 KB
- Exercise Files/Chapter08/ChartAxes.xlsx 14.8 KB
- Exercise Files/Chapter08/Trendline.xlsx 14.4 KB
- Exercise Files/Chapter04/RegentStreet.jpg 13.5 KB
- Exercise Files/Chapter01/WhatToDo.xlsx 13.3 KB
- Exercise Files/Chapter01/RibbonTour.xlsx 13.0 KB
- Exercise Files/Chapter09/ChartLink.xlsx 12.5 KB
- Exercise Files/Chapter04/Freeze.xlsx 12.4 KB
- Exercise Files/Chapter10/TextBox.xlsx 12.4 KB
- Exercise Files/Chapter03/ManageWorksheets.xlsx 12.1 KB
- Exercise Files/Chapter04/ManageWorksheets.xlsx 12.0 KB
- Exercise Files/Chapter02/FileManagement.xlsx 11.8 KB
- Exercise Files/Chapter09/Summary.docx 11.7 KB
- Exercise Files/Chapter09/Chart.docx 11.5 KB
- Exercise Files/Chapter11/CreatePivot.xlsx 11.5 KB
- Exercise Files/Chapter12/Print.xlsx 11.4 KB
- Exercise Files/Chapter03/FreezeSplit.xlsx 11.3 KB
- Exercise Files/Chapter03/CopyPaste.xlsx 11.0 KB
- Exercise Files/Chapter03/EnterData.xlsx 11.0 KB
- Exercise Files/Chapter03/Headers.xlsx 10.9 KB
- Exercise Files/Chapter04/Headers.xlsx 10.9 KB
- Exercise Files/Chapter03/NamedRanges.xlsx 10.9 KB
- Exercise Files/Chapter04/ExcelTables.xlsx 10.9 KB
- Exercise Files/Chapter03/Select.xlsx 10.8 KB
- Exercise Files/Chapter12/NewFormat.xlsx 10.7 KB
- Exercise Files/Chapter01/Preferences.xlsx 10.5 KB
- Exercise Files/Chapter01/GettingHelp.xlsx 10.4 KB
- Exercise Files/Chapter06/Tracing.xlsx 10.3 KB
- Exercise Files/Chapter02/SalesReport.xlsx 10.1 KB
- Exercise Files/Chapter08/XYChart.xlsx 10.1 KB
- Exercise Files/Chapter12/Protect.xlsx 10.0 KB
- Exercise Files/Chapter12/PrintAreas.xlsx 10.0 KB
- Exercise Files/Chapter08/StockChart.xlsx 10.0 KB
- Exercise Files/Chapter02/Versions.xlsx 10.0 KB
- Exercise Files/Chapter06/ErrorIndicators.xlsx 10.0 KB
- Exercise Files/Chapter03/Validation.xlsx 10.0 KB
- Exercise Files/Chapter05/ExcelTables.xlsx 10.0 KB
- Exercise Files/Chapter04/Sort.xlsx 9.9 KB
- Exercise Files/Chapter04/CustomSort.xlsx 9.9 KB
- Exercise Files/Chapter09/Include.xlsx 9.9 KB
- Exercise Files/Chapter06/GoalSeek.xlsx 9.9 KB
- Exercise Files/Chapter08/Sparkline.xlsx 9.8 KB
- Exercise Files/Chapter03/ValidList.xlsx 9.7 KB
- Exercise Files/Chapter02/Properties.xlsx 9.7 KB
- Exercise Files/Chapter12/Comments.xlsx 9.7 KB
- Exercise Files/Chapter12/Changes.xlsx 9.7 KB
- Exercise Files/Chapter03/ExcelTables.xlsx 9.7 KB
- Exercise Files/Chapter08/PieChart.xlsx 9.7 KB
- Exercise Files/Chapter04/Filter.xlsx 9.7 KB
- Exercise Files/Chapter04/ManageCells.xlsx 9.6 KB
- Exercise Files/Chapter08/LineChart.xlsx 9.6 KB
- Exercise Files/Chapter08/ColumnChart.xlsx 9.6 KB
- Exercise Files/Chapter06/Concatenate.xlsx 9.6 KB
- Exercise Files/Chapter03/Find.xlsx 9.5 KB
- Exercise Files/Chapter12/Spelling.xlsx 9.5 KB
- Exercise Files/Chapter05/CopyFormulas.xlsx 9.5 KB
- Exercise Files/Chapter09/Hyperlinks.xlsx 9.5 KB
- Exercise Files/Chapter06/Counting.xlsx 9.4 KB
- Exercise Files/Chapter05/CreatingFormulas.xlsx 9.3 KB
- Exercise Files/Chapter06/Rounding.xlsx 9.3 KB
- Exercise Files/Chapter06/VLookup.xlsx 9.1 KB
- Exercise Files/Chapter05/AutoSum.xlsx 9.0 KB
- Exercise Files/Chapter10/Shapes.xlsx 8.8 KB
- Exercise Files/Chapter10/Images.xlsx 8.8 KB
- Exercise Files/Chapter05/Conditional.xlsx 8.8 KB
- Exercise Files/Chapter10/SmartArt.xlsx 8.7 KB
- Exercise Files/Chapter10/WordArt.xlsx 8.7 KB
- Exercise Files/Chapter05/CellRefs.xlsx 8.7 KB
- Exercise Files/Chapter09/ImportTarget.xlsx 8.7 KB
- Exercise Files/Chapter06/ManageScenarios.xlsx 8.6 KB
- Exercise Files/Chapter05/StatusBar.xlsx 8.5 KB
- Exercise Files/Chapter05/IfFormulas.xlsx 8.3 KB
- Exercise Files/Chapter05/FormulaIntro.xlsx 8.2 KB
- Exercise Files/Chapter05/Operators.xlsx 8.2 KB
- Exercise Files/Chapter03/landon_final.png 5.1 KB
- Exercise Files/Chapter09/ImportCSV.csv 1.5 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.