| 001 Welcome.mp4 | 4.97 MB | ||
| 002 Using the exercise files.mp4 | 1004.85 KB | ||
| 003 What you can do with Excel 2016.mp4 | 6.42 MB | ||
| 004 Exploring the Excel 2016 program window.mp4 | 11.72 MB | ||
| 005 Introducing the Ribbon for the Mac.mp4 | 9.7 MB | ||
| 006 Setting program preferences.mp4 | 10.19 MB | ||
| 007 Getting help in Excel.mp4 | 7.95 MB | ||
| 008 Opening, creating, and saving workbooks.mp4 | 8.33 MB | ||
| 009 Setting workbook properties.mp4 | 6.17 MB | ||
| 010 Creating and modifying workbook templates.mp4 | 8.55 MB | ||
| 011 Managing workbooks across multiple versions of Excel.mp4 | 6.83 MB | ||
| 012 Selecting cells and groups of cells.mp4 | 9.84 MB | ||
| 013 Copying and pasting cell data.mp4 | 9.95 MB | ||
| 014 Entering data using AutoFill and other techniques.mp4 | 8.78 MB | ||
| 015 Inserting symbols and special characters.mp4 | 12.12 MB | ||
| 016 Creating named ranges.mp4 | 14.71 MB | ||
| 017 Creating an Excel table.mp4 | 10.47 MB | ||
| 018 Locating and changing data using Find and Replace.mp4 | 13.79 MB | ||
| 019 Restricting input using validation rules.mp4 | 16.91 MB | ||
| 020 Using lists to limit data entered into a cell.mp4 | 6.91 MB | ||
| 021 Sorting worksheet data.mp4 | 7.44 MB | ||
| 022 Creating a custom sort order.mp4 | 11.41 MB | ||
| 023 Filtering worksheet data.mp4 | 8.77 MB | ||
| 024 Inserting, moving, and deleting cells and cell ranges.mp4 | 9.7 MB | ||
| 025 Splitting and freezing rows and columns.mp4 | 15.15 MB | ||
| 026 Managing worksheets.mp4 | 11.43 MB | ||
| 027 Creating, editing, and deleting headers and footers.mp4 | 8.27 MB | ||
| 028 Introducing Excel formulas and functions.mp4 | 6.76 MB | ||
| 029 Adding a formula to a cell.mp4 | 9.04 MB | ||
| 030 Introducing arithmetic operators.mp4 | 9.97 MB | ||
| 031 Using relative and absolute cell references.mp4 | 13.17 MB | ||
| 032 Controlling how Excel copies and pastes formulas.mp4 | 10.29 MB | ||
| 033 Referring to Excel table data in formulas.mp4 | 8.33 MB | ||
| 034 Creating an AutoSum formula.mp4 | 9.4 MB | ||
| 035 Summarizing data on the status bar.mp4 | 5.29 MB | ||
| 036 Summarizing data using an IF function.mp4 | 10.74 MB | ||
| 037 Summarizing data using SUMIF and other conditional functions.mp4 | 14.4 MB | ||
| 038 Creating formulas to count cells.mp4 | 6.02 MB | ||
| 039 Rounding cell values.mp4 | 9.06 MB | ||
| 040 Joining text in cells with concatenation.mp4 | 8.09 MB | ||
| 041 Finding data using VLOOKUP and HLOOKUP.mp4 | 7.77 MB | ||
| 042 Auditing formulas by identifying precedents and dependents.mp4 | 6.8 MB | ||
| 043 Managing Excel formula error indicators.mp4 | 10.12 MB | ||
| 044 Managing scenarios.mp4 | 15.95 MB | ||
| 045 Performing Goal Seek analysis.mp4 | 6.66 MB | ||
| 046 Applying fonts, background colors, and borders.mp4 | 11.84 MB | ||
| 047 Applying number and date formats to cells.mp4 | 11.94 MB | ||
| 048 Managing text alignment.mp4 | 10.61 MB | ||
| 049 Copying cell formats.mp4 | 7.91 MB | ||
| 050 Managing cell styles.mp4 | 10.56 MB | ||
| 051 Managing Office themes.mp4 | 13.6 MB | ||
| 052 Creating rule-based conditional formats.mp4 | 10.68 MB | ||
| 053 Defining top 10 conditional formats.mp4 | 10.93 MB | ||
| 054 Defining data bar, color scale, and icon set conditional formats.mp4 | 15.91 MB | ||
| 055 Editing, ordering, and deleting conditional formats.mp4 | 9.62 MB | ||
| 056 Creating bar and column charts.mp4 | 11.95 MB | ||
| 057 Creating pie charts.mp4 | 5.51 MB | ||
| 058 Creating line charts.mp4 | 7.43 MB | ||
| 059 Creating XY (scatter) charts.mp4 | 5.6 MB | ||
| 060 Creating stock charts.mp4 | 5.94 MB | ||
| 061 Changing chart types and layouts.mp4 | 5.8 MB | ||
| 062 Changing the appearance of chart elements.mp4 | 8.08 MB | ||
| 063 Managing chart axes and numbering.mp4 | 6.77 MB | ||
| 064 Adding trendlines to charts.mp4 | 7.87 MB | ||
| 065 Creating sparkline charts.mp4 | 9.81 MB | ||
| 066 Importing data from comma-separated value (CSV) or text files.mp4 | 8.94 MB | ||
| 067 Connecting to an external data source.mp4 | 3.4 MB | ||
| 068 Using hyperlinks.mp4 | 9.5 MB | ||
| 069 Including an Excel workbook in another Office document.mp4 | 8.06 MB | ||
| 070 Linking to an Excel chart from another Office program.mp4 | 5.74 MB | ||
| 071 Creating and formatting shapes.mp4 | 12.68 MB | ||
| 072 Adding and adjusting images.mp4 | 13.05 MB | ||
| 073 Manipulating text boxes.mp4 | 7.88 MB | ||
| 074 Cropping, compressing, and removing image backgrounds.mp4 | 11.96 MB | ||
| 075 Creating SmartArt graphics.mp4 | 9.52 MB | ||
| 076 Creating WordArt.mp4 | 6.26 MB | ||
| 077 Aligning and layering objects.mp4 | 11.99 MB | ||
| 078 Introducing PivotTable reports.mp4 | 6.66 MB | ||
| 079 Creating a PivotTable report.mp4 | 7.47 MB | ||
| 080 Pivoting a PivotTable report.mp4 | 7.3 MB | ||
| 081 Managing subtotals and grand totals.mp4 | 7.8 MB | ||
| 082 Summarizing more than one data field.mp4 | 4.6 MB | ||
| 083 Changing the data field summary operation.mp4 | 11.9 MB | ||
| 084 Changing the data field number format.mp4 | 4.66 MB | ||
| 085 Filtering a PivotTable report.mp4 | 14.91 MB | ||
| 086 Applying a PivotTable style.mp4 | 6.36 MB | ||
| 087 Checking spelling.mp4 | 6.47 MB | ||
| 088 Setting AutoCorrect and automatic Replace options.mp4 | 9.99 MB | ||
| 089 Managing workbook comments.mp4 | 7.43 MB | ||
| 090 Tracking and reviewing changes.mp4 | 9.89 MB | ||
| 091 Printing a worksheet or workbook.mp4 | 6.72 MB | ||
| 092 Setting and removing print areas.mp4 | 6.07 MB | ||
| 093 Exporting to other formats.mp4 | 6.64 MB | ||
| 094 Protecting a workbook.mp4 | 7.53 MB | ||
| 095 Running an existing macro.mp4 | 7.86 MB | ||
| 096 Recording a macro.mp4 | 6.37 MB | ||
| 097 Renaming, viewing, and deleting macros.mp4 | 6.1 MB | ||
| 098 Adding comments to a macro.mp4 | 5.62 MB | ||
| 099 Turning off screen updating in a macro.mp4 | 7.77 MB | ||
| 100 Next steps.mp4 | 3.2 MB | ||
| Exercise Files | |||
| Chapter01 | |||
| GettingHelp.xlsx | 10.41 KB | ||
| Preferences.xlsx | 10.55 KB | ||
| RibbonTour.xlsx | 12.95 KB | ||
| WhatToDo.xlsx | 13.31 KB | ||
| Chapter02 | |||
| FileManagement.xlsx | 11.76 KB | ||
| Properties.xlsx | 9.74 KB | ||
| SalesReport.xlsx | 10.12 KB | ||
| Versions.xlsx | 10.02 KB | ||
| Chapter03 | |||
| CopyPaste.xlsx | 11.01 KB | ||
| EnterData.xlsx | 10.97 KB | ||
| ExcelTables.xlsx | 9.67 KB | ||
| Find.xlsx | 9.55 KB | ||
| FreezeSplit.xlsx | 11.26 KB | ||
| Headers.xlsx | 10.94 KB | ||
| ManageCells.xlsx | 33.63 KB | ||
| ManageWorksheets.xlsx | 12.1 KB | ||
| NamedRanges.xlsx | 10.86 KB | ||
| Select.xlsx | 10.81 KB | ||
| Symbols.xlsx | 27.82 KB | ||
| ValidList.xlsx | 9.75 KB | ||
| Validation.xlsx | 9.99 KB | ||
| landon_final.png | 5.05 KB | ||
| Chapter04 | |||
| CustomSort.xlsx | 9.91 KB | ||
| ExcelTables.xlsx | 10.85 KB | ||
| Filter.xlsx | 9.66 KB | ||
| Freeze.xlsx | 12.42 KB | ||
| Headers.xlsx | 10.89 KB | ||
| ManageCells.xlsx | 9.65 KB | ||
| ManageWorksheets.xlsx | 11.96 KB | ||
| MoveTarget.xlsx | 15.29 KB | ||
| RegentStreet.jpg?042148 | 13.51 KB | ||
| Sort.xlsx | 9.94 KB | ||
| Chapter05 | |||
| AutoSum.xlsx | 8.99 KB | ||
| CellRefs.xlsx | 8.71 KB | ||
| Conditional.xlsx | 8.75 KB | ||
| CopyFormulas.xlsx | 9.5 KB | ||
| CreatingFormulas.xlsx | 9.31 KB | ||
| ExcelTables.xlsx | 9.98 KB | ||
| FormulaIntro.xlsx | 8.19 KB | ||
| IfFormulas.xlsx | 8.25 KB | ||
| Operators.xlsx | 8.19 KB | ||
| StatusBar.xlsx | 8.53 KB | ||
| Chapter06 | |||
| Concatenate.xlsx | 9.6 KB | ||
| Counting.xlsx | 9.36 KB | ||
| ErrorIndicators.xlsx | 10 KB | ||
| GoalSeek.xlsx | 9.85 KB | ||
| ManageScenarios.xlsx | 8.63 KB | ||
| Rounding.xlsx | 9.27 KB | ||
| Tracing.xlsx | 10.32 KB | ||
| VLookup.xlsx | 9.1 KB | ||
| Chapter07 | |||
| Alignment.xlsx | 25.94 KB | ||
| BasicFormatting.xlsx | 28.52 KB | ||
| CellFormats.xlsx | 31.3 KB | ||
| CellStyle.xlsx | 33.73 KB | ||
| Conditional.xlsx | 26.95 KB | ||
| CopyFormat.xlsx | 32.77 KB | ||
| MngConds.xlsx | 29.22 KB | ||
| NewConds.xlsx | 31.02 KB | ||
| NumberFormats.xlsx | 26.71 KB | ||
| Themes.xlsx | 27.96 KB | ||
| TopTen.xlsx | 24.83 KB | ||
| Chapter08 | |||
| ChartAxes.xlsx | 14.82 KB | ||
| ChartElements.xlsx | 14.94 KB | ||
| ChartLayout.xlsx | 14.94 KB | ||
| ColumnChart.xlsx | 9.64 KB | ||
| LineChart.xlsx | 9.65 KB | ||
| PieChart.xlsx | 9.67 KB | ||
| Sparkline.xlsx | 9.83 KB | ||
| StockChart.xlsx | 10.03 KB | ||
| Trendline.xlsx | 14.39 KB | ||
| XYChart.xlsx | 10.09 KB | ||
| Chapter09 | |||
| Chart.docx | 11.51 KB | ||
| ChartLink.xlsx | 12.52 KB | ||
| Hyperlinks.xlsx | 9.5 KB | ||
| ImportCSV.csv | 1.47 KB | ||
| ImportTarget.xlsx | 8.7 KB | ||
| Include.xlsx | 9.88 KB | ||
| LinkToWeb.xlsx | 19.04 KB | ||
| PivotReport.xlsx | 17.97 KB | ||
| Summary.docx | 11.67 KB | ||
| WebData.htm | 16.8 KB | ||
| Chapter10 | |||
| Aligning.xlsx | 63.75 KB | ||
| Images.xlsx | 8.77 KB | ||
| London.jpg?042148 | 21.05 KB | ||
| ManageImages.xlsx | 36.57 KB | ||
| Shapes.xlsx | 8.77 KB | ||
| SmartArt.xlsx | 8.74 KB | ||
| TextBox.xlsx | 12.4 KB | ||
| WestEnd.jpg?042148 | 16.48 KB | ||
| WomanShopping.jpg?042148 | 15.63 KB | ||
| WordArt.xlsx | 8.74 KB | ||
| Chapter11 | |||
| CreatePivot.xlsx | 11.47 KB | ||
| DataFormat.xlsx | 17.74 KB | ||
| Filters.xlsx | 17.8 KB | ||
| MultipleDataFields.xlsx | 17.14 KB | ||
| PivotIntro.xlsx | 17.01 KB | ||
| Pivoting.xlsx | 16.29 KB | ||
| Styles.xlsx | 18.04 KB | ||
| SummaryOperation.xlsx | 16.97 KB | ||
| Totals.xlsx | 17.05 KB | ||
| Chapter12 | |||
| AutoCorrect.xlsx | 28.38 KB | ||
| Changes.xlsx | 9.69 KB | ||
| Comments.xlsx | 9.69 KB | ||
| NewFormat.xlsx | 10.7 KB | ||
| Print.xlsx | 11.35 KB | ||
| PrintAreas.xlsx | 10.03 KB | ||
| Protect.xlsx | 10.03 KB | ||
| Spelling.xlsx | 9.54 KB | ||
| Chapter13 | |||
| Comments.xlsm | 27.72 KB | ||
| ManageMacros.xlsm | 40.35 KB | ||
| NoFlash.xlsm | 39.92 KB | ||
| Record.xlsx | 24.16 KB | ||
| Relative.xlsm | 22.63 KB | ||
| Relative.xlsx | 22.12 KB | ||
| RunAMacro.xlsm | 15.08 KB | ||
| ▲ 215 total files | |||
Lynda - Excel for Mac 2016 Essential Training
This Course will be good to the Best for DL within 30 days after has been post, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive.
6h 26m Beginner Aug 07, 2015 | Uploaded in Nov 15, 2015 by 2boweb
Subject: Business
Software: Excel for Mac Office for Mac
Author: Curt Frye
Learn everything you need to master the Mac 2016 version of the world's most popular spreadsheet program. Curt Frye provides a comprehensive overview of Excel for Mac 2016, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.
Topics include:
• Customizing the Ribbon
• Formatting worksheets, cells, and cell data
• Sorting and filtering data
• Working with formulas
• Detecting formula errors
• Creating charts
• Importing data
• Inserting objects and graphics
• Using PivotTables
• Recording macros
• Sharing workbooks
//////////////////////////////////////////////////////
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
[ CourseWikia ] Lynda - Excel for the Web Tips and Tricks (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
185.6 MB | freecoursewb | 5 years | 0 | 0 |
| 91.7 MB | freecoursewb | 5 years | 0 | 0 | |
| 868.6 MB | freecoursewb | 5 years | 0 | 0 | |
|
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
207.9 MB | freecoursewb | 5 years | 0 | 0 |
| 215.36 MB | tutsnode | 5 years | 12 | 1 |
All Comments