Lynda - Office 365 for Mac Essential Training: Excel

mp4   Hot：40   Size：894.43 MB   Created：2017-09-05 15:33:32   Update：2021-12-11 04:29:36  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 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
    Exercise Files/Chapter10/Aligning.xlsx 63.75 KB
    Exercise Files/Chapter13/ManageMacros.xlsm 40.35 KB
    Exercise Files/Chapter13/NoFlash.xlsm 39.92 KB
    Exercise Files/Chapter10/ManageImages.xlsx 36.57 KB
    Exercise Files/Chapter07/CellStyle.xlsx 33.73 KB
    Exercise Files/Chapter03/ManageCells.xlsx 33.63 KB
    Exercise Files/Chapter07/CopyFormat.xlsx 32.77 KB
    Exercise Files/Chapter07/CellFormats.xlsx 31.3 KB
    Exercise Files/Chapter07/NewConds.xlsx 31.02 KB
    Exercise Files/Chapter07/MngConds.xlsx 29.22 KB
    Exercise Files/Chapter07/BasicFormatting.xlsx 28.52 KB
    Exercise Files/Chapter12/AutoCorrect.xlsx 28.38 KB
    Exercise Files/Chapter07/Themes.xlsx 27.96 KB
    Exercise Files/Chapter03/Symbols.xlsx 27.82 KB
    Exercise Files/Chapter13/Comments.xlsm 27.72 KB
    Exercise Files/Chapter07/Conditional.xlsx 26.95 KB
    Exercise Files/Chapter07/NumberFormats.xlsx 26.71 KB
    Exercise Files/Chapter07/Alignment.xlsx 25.94 KB
    Exercise Files/Chapter07/TopTen.xlsx 24.83 KB
    Exercise Files/Chapter13/Record.xlsx 24.16 KB
    Exercise Files/Chapter13/Relative.xlsm 22.63 KB
    Exercise Files/Chapter13/Relative.xlsx 22.12 KB
    Exercise Files/Chapter10/London.jpg 21.05 KB
    Exercise Files/Chapter09/LinkToWeb.xlsx 19.04 KB
    Exercise Files/Chapter11/Styles.xlsx 18.04 KB
    Exercise Files/Chapter09/PivotReport.xlsx 17.97 KB
    Exercise Files/Chapter11/Filters.xlsx 17.8 KB
    Exercise Files/Chapter11/DataFormat.xlsx 17.74 KB
    Exercise Files/Chapter11/MultipleDataFields.xlsx 17.14 KB
    Exercise Files/Chapter11/Totals.xlsx 17.05 KB
    Exercise Files/Chapter11/PivotIntro.xlsx 17.01 KB
    Exercise Files/Chapter11/SummaryOperation.xlsx 16.97 KB
    Exercise Files/Chapter09/WebData.htm 16.8 KB
    Exercise Files/Chapter10/WestEnd.jpg 16.48 KB
    Exercise Files/Chapter11/Pivoting.xlsx 16.29 KB
    Exercise Files/Chapter10/WomanShopping.jpg 15.63 KB
    Exercise Files/Chapter04/MoveTarget.xlsx 15.29 KB
    Exercise Files/Chapter13/RunAMacro.xlsm 15.08 KB
    Exercise Files/Chapter08/ChartElements.xlsx 14.94 KB
    Exercise Files/Chapter08/ChartLayout.xlsx 14.94 KB
    Exercise Files/Chapter08/ChartAxes.xlsx 14.82 KB
    Exercise Files/Chapter08/Trendline.xlsx 14.39 KB
    Exercise Files/Chapter04/RegentStreet.jpg 13.51 KB
    Exercise Files/Chapter01/WhatToDo.xlsx 13.31 KB
    Exercise Files/Chapter01/RibbonTour.xlsx 12.95 KB
    Exercise Files/Chapter09/ChartLink.xlsx 12.52 KB
    Exercise Files/Chapter04/Freeze.xlsx 12.42 KB
    Exercise Files/Chapter10/TextBox.xlsx 12.4 KB
    Exercise Files/Chapter03/ManageWorksheets.xlsx 12.1 KB
    Exercise Files/Chapter04/ManageWorksheets.xlsx 11.96 KB
    Exercise Files/Chapter02/FileManagement.xlsx 11.76 KB
    Exercise Files/Chapter09/Summary.docx 11.67 KB
    Exercise Files/Chapter09/Chart.docx 11.51 KB
    Exercise Files/Chapter11/CreatePivot.xlsx 11.47 KB
    Exercise Files/Chapter12/Print.xlsx 11.35 KB
    Exercise Files/Chapter03/FreezeSplit.xlsx 11.26 KB
    Exercise Files/Chapter03/CopyPaste.xlsx 11.01 KB
    Exercise Files/Chapter03/EnterData.xlsx 10.97 KB
    Exercise Files/Chapter03/Headers.xlsx 10.94 KB
    Exercise Files/Chapter04/Headers.xlsx 10.89 KB
    Exercise Files/Chapter03/NamedRanges.xlsx 10.86 KB
    Exercise Files/Chapter04/ExcelTables.xlsx 10.85 KB
    Exercise Files/Chapter03/Select.xlsx 10.81 KB
    Exercise Files/Chapter12/NewFormat.xlsx 10.7 KB
    Exercise Files/Chapter01/Preferences.xlsx 10.55 KB
    Exercise Files/Chapter01/GettingHelp.xlsx 10.41 KB
    Exercise Files/Chapter06/Tracing.xlsx 10.32 KB
    Exercise Files/Chapter02/SalesReport.xlsx 10.12 KB
    Exercise Files/Chapter08/XYChart.xlsx 10.09 KB
    Exercise Files/Chapter12/Protect.xlsx 10.03 KB
    Exercise Files/Chapter12/PrintAreas.xlsx 10.03 KB
    Exercise Files/Chapter08/StockChart.xlsx 10.03 KB
    Exercise Files/Chapter02/Versions.xlsx 10.02 KB
    Exercise Files/Chapter06/ErrorIndicators.xlsx 10 KB
    Exercise Files/Chapter03/Validation.xlsx 9.99 KB
    Exercise Files/Chapter05/ExcelTables.xlsx 9.98 KB
    Exercise Files/Chapter04/Sort.xlsx 9.94 KB
    Exercise Files/Chapter04/CustomSort.xlsx 9.91 KB
    Exercise Files/Chapter09/Include.xlsx 9.88 KB
    Exercise Files/Chapter06/GoalSeek.xlsx 9.85 KB
    Exercise Files/Chapter08/Sparkline.xlsx 9.83 KB
    Exercise Files/Chapter03/ValidList.xlsx 9.75 KB
    Exercise Files/Chapter02/Properties.xlsx 9.74 KB
    Exercise Files/Chapter12/Comments.xlsx 9.69 KB
    Exercise Files/Chapter12/Changes.xlsx 9.69 KB
    Exercise Files/Chapter03/ExcelTables.xlsx 9.67 KB
    Exercise Files/Chapter08/PieChart.xlsx 9.67 KB
    Exercise Files/Chapter04/Filter.xlsx 9.66 KB
    Exercise Files/Chapter04/ManageCells.xlsx 9.65 KB
    Exercise Files/Chapter08/LineChart.xlsx 9.65 KB
    Exercise Files/Chapter08/ColumnChart.xlsx 9.64 KB
    Exercise Files/Chapter06/Concatenate.xlsx 9.6 KB
    Exercise Files/Chapter03/Find.xlsx 9.55 KB
    Exercise Files/Chapter12/Spelling.xlsx 9.54 KB
    Exercise Files/Chapter05/CopyFormulas.xlsx 9.5 KB
    Exercise Files/Chapter09/Hyperlinks.xlsx 9.5 KB
    Exercise Files/Chapter06/Counting.xlsx 9.36 KB
    Exercise Files/Chapter05/CreatingFormulas.xlsx 9.31 KB
    Exercise Files/Chapter06/Rounding.xlsx 9.27 KB
    Exercise Files/Chapter06/VLookup.xlsx 9.1 KB
    Exercise Files/Chapter05/AutoSum.xlsx 8.99 KB
    Exercise Files/Chapter10/Shapes.xlsx 8.77 KB
    Exercise Files/Chapter10/Images.xlsx 8.77 KB
    Exercise Files/Chapter05/Conditional.xlsx 8.75 KB
    Exercise Files/Chapter10/SmartArt.xlsx 8.74 KB
    Exercise Files/Chapter10/WordArt.xlsx 8.74 KB
    Exercise Files/Chapter05/CellRefs.xlsx 8.71 KB
    Exercise Files/Chapter09/ImportTarget.xlsx 8.7 KB
    Exercise Files/Chapter06/ManageScenarios.xlsx 8.63 KB
    Exercise Files/Chapter05/StatusBar.xlsx 8.53 KB
    Exercise Files/Chapter05/IfFormulas.xlsx 8.25 KB
    Exercise Files/Chapter05/FormulaIntro.xlsx 8.19 KB
    Exercise Files/Chapter05/Operators.xlsx 8.19 KB
    Exercise Files/Chapter03/landon_final.png 5.05 KB
    Exercise Files/Chapter09/ImportCSV.csv 1.47 KB

Download Info

  • Tips

    “Lynda - Office 365 for Mac Essential Training: Excel” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.