Lynda Office 365 for Mac Essential Training Excel | E306560E6D5800616E1BBE5AF0D828E5F335EABA

Lynda Office 365 for Mac Essential Training Excel

Name	Lynda - Office 365 for Mac Essential Training: Excel	DOWNLOAD Copy Link
Total Size	937.9 MB
Total Files	215
Hash	E306560E6D5800616E1BBE5AF0D828E5F335EABA

/
019 Restricting input using validation rules.mp4	17.7 MB
044 Managing scenarios.mp4	16.7 MB
054 Defining data bar, color scale, and icon set conditional formats.mp4	16.7 MB
025 Splitting and freezing rows and columns.mp4	15.8 MB
085 Filtering a PivotTable report.mp4	15.6 MB
016 Creating named ranges.mp4	15.4 MB
037 Summarizing data using SUMIF and other conditional functions.mp4	15.1 MB
018 Locating and changing data using Find and Replace.mp4	14.4 MB
051 Managing Office themes.mp4	14.3 MB
031 Using relative and absolute cell references.mp4	13.8 MB
072 Adding and adjusting images.mp4	13.7 MB
071 Creating and formatting shapes.mp4	13.3 MB
015 Inserting symbols and special characters.mp4	12.7 MB
077 Aligning and layering objects.mp4	12.6 MB
047 Applying number and date formats to cells.mp4	12.6 MB
074 Cropping, compressing, and removing image backgrounds.mp4	12.5 MB
056 Creating bar and column charts.mp4	12.5 MB
083 Changing the data field summary operation.mp4	12.5 MB
046 Applying fonts, background colors, and borders.mp4	12.4 MB
004 Exploring the Excel 2016 program window.mp4	12.3 MB
026 Managing worksheets.mp4	12.0 MB
022 Creating a custom sort order.mp4	11.9 MB
053 Defining top 10 conditional formats.mp4	11.4 MB
036 Summarizing data using an IF function.mp4	11.3 MB
052 Creating rule-based conditional formats.mp4	11.2 MB
048 Managing text alignment.mp4	11.1 MB
050 Managing cell styles.mp4	11.1 MB
017 Creating an Excel table.mp4	11.0 MB
032 Controlling how Excel copies and pastes formulas.mp4	10.8 MB
006 Setting program preferences.mp4	10.7 MB
043 Managing Excel formula error indicators.mp4	10.6 MB
088 Setting AutoCorrect and automatic Replace options.mp4	10.5 MB
030 Introducing arithmetic operators.mp4	10.5 MB
013 Copying and pasting cell data.mp4	10.4 MB
090 Tracking and reviewing changes.mp4	10.4 MB
012 Selecting cells and groups of cells.mp4	10.3 MB
065 Creating sparkline charts.mp4	10.3 MB
024 Inserting, moving, and deleting cells and cell ranges.mp4	10.2 MB
005 Introducing the Ribbon for the Mac.mp4	10.2 MB
055 Editing, ordering, and deleting conditional formats.mp4	10.1 MB
068 Using hyperlinks.mp4	10.0 MB
075 Creating SmartArt graphics.mp4	10.0 MB
034 Creating an AUTOSUM formula.mp4	9.9 MB
039 Rounding cell values.mp4	9.5 MB
029 Adding a formula to a cell.mp4	9.5 MB
066 Importing data from comma-separated value (CSV) or text files.mp4	9.4 MB
014 Entering data using AutoFill and other techniques.mp4	9.2 MB
023 Filtering worksheet data.mp4	9.2 MB
010 Creating and modifying workbook templates.mp4	9.0 MB
008 Opening, creating, and saving workbooks.mp4	8.7 MB
033 Referring to Excel table data in formulas.mp4	8.7 MB
027 Creating, editing, and deleting headers and footers.mp4	8.7 MB
040 Joining text in cells with concatenation.mp4	8.5 MB
069 Including an Excel workbook in another Office document.mp4	8.5 MB
062 Changing the appearance of chart elements.mp4	8.5 MB
007 Getting help in Excel.mp4	8.4 MB
049 Copying cell formats.mp4	8.3 MB
064 Adding trendlines to charts.mp4	8.3 MB
073 Manipulating text boxes.mp4	8.3 MB
095 Running an existing macro.mp4	8.2 MB
081 Managing subtotals and grand totals.mp4	8.2 MB
041 Finding data using VLOOKUP and HLOOKUP.mp4	8.2 MB
099 Turning off screen updating in a macro.mp4	8.1 MB
094 Protecting a workbook.mp4	7.9 MB
079 Creating a PivotTable report.mp4	7.8 MB
058 Creating line charts.mp4	7.8 MB
089 Managing workbook comments.mp4	7.8 MB
021 Sorting worksheet data.mp4	7.8 MB
080 Pivoting a PivotTable report.mp4	7.6 MB
020 Using lists to limit data entered into a cell.mp4	7.2 MB
011 Managing workbooks across multiple versions of Excel.mp4	7.2 MB
042 Auditing formulas by identifying precedents and dependents.mp4	7.1 MB
063 Managing chart axes and numbering.mp4	7.1 MB
028 Introducing Excel formulas and functions.mp4	7.1 MB
091 Printing a worksheet or workbook.mp4	7.1 MB
078 Introducing PivotTable reports.mp4	7.0 MB
045 Performing Goal Seek analysis.mp4	7.0 MB
093 Exporting to other formats.mp4	7.0 MB
087 Checking spelling.mp4	6.8 MB
003 What you can do with Excel 2016.mp4	6.7 MB
096 Recording a macro.mp4	6.7 MB
086 Applying a PivotTable style.mp4	6.6 MB
076 Creating WordArt.mp4	6.6 MB
009 Setting workbook properties.mp4	6.5 MB
097 Renaming, viewing, and deleting macros.mp4	6.4 MB
092 Setting and removing print areas.mp4	6.4 MB
038 Creating formulas to count cells.mp4	6.3 MB
060 Creating stock charts.mp4	6.2 MB
001 Welcome.mp4	6.2 MB
061 Changing chart types and layouts.mp4	6.1 MB
070 Linking to an Excel chart from another Office program.mp4	6.0 MB
098 Adding comments to a macro.mp4	5.9 MB
059 Creating XY (scatter) charts.mp4	5.9 MB
057 Creating pie charts.mp4	5.8 MB
035 Summarizing data on the status bar.mp4	5.6 MB
084 Changing the data field number format.mp4	4.9 MB
082 Summarizing more than one data field.mp4	4.8 MB
067 Connecting to an external data source.mp4	3.6 MB
100 Next steps.mp4	3.1 MB
002 Using the exercise files.mp4	1.0 MB
/Exercise Files/Chapter10/
Aligning.xlsx	65.3 KB
ManageImages.xlsx	37.4 KB
London.jpg	21.6 KB
WestEnd.jpg	16.9 KB
WomanShopping.jpg	16.0 KB
TextBox.xlsx	12.7 KB
Shapes.xlsx	9.0 KB
Images.xlsx	9.0 KB
SmartArt.xlsx	9.0 KB
WordArt.xlsx	9.0 KB
/Exercise Files/Chapter13/
ManageMacros.xlsm	41.3 KB
NoFlash.xlsm	40.9 KB
Comments.xlsm	28.4 KB
Record.xlsx	24.7 KB
Relative.xlsm	23.2 KB
Relative.xlsx	22.7 KB
RunAMacro.xlsm	15.4 KB
/Exercise Files/Chapter07/
CellStyle.xlsx	34.5 KB
CopyFormat.xlsx	33.6 KB
CellFormats.xlsx	32.1 KB
NewConds.xlsx	31.8 KB
MngConds.xlsx	29.9 KB
BasicFormatting.xlsx	29.2 KB
Themes.xlsx	28.6 KB
Conditional.xlsx	27.6 KB
NumberFormats.xlsx	27.4 KB
Alignment.xlsx	26.6 KB
TopTen.xlsx	25.4 KB
/Exercise Files/Chapter03/
ManageCells.xlsx	34.4 KB
Symbols.xlsx	28.5 KB
ManageWorksheets.xlsx	12.4 KB
FreezeSplit.xlsx	11.5 KB
CopyPaste.xlsx	11.3 KB
EnterData.xlsx	11.2 KB
Headers.xlsx	11.2 KB
NamedRanges.xlsx	11.1 KB
Select.xlsx	11.1 KB
Validation.xlsx	10.2 KB
ValidList.xlsx	10.0 KB
ExcelTables.xlsx	9.9 KB
Find.xlsx	9.8 KB
landon_final.png	5.2 KB
/Exercise Files/Chapter12/
AutoCorrect.xlsx	29.1 KB
Print.xlsx	11.6 KB
NewFormat.xlsx	11.0 KB
Protect.xlsx	10.3 KB
PrintAreas.xlsx	10.3 KB
Comments.xlsx	9.9 KB
Changes.xlsx	9.9 KB
Spelling.xlsx	9.8 KB
/Exercise Files/Chapter09/
LinkToWeb.xlsx	19.5 KB
PivotReport.xlsx	18.4 KB
WebData.htm	17.2 KB
ChartLink.xlsx	12.8 KB
Summary.docx	12.0 KB
Chart.docx	11.8 KB
Include.xlsx	10.1 KB
Hyperlinks.xlsx	9.7 KB
ImportTarget.xlsx	8.9 KB
ImportCSV.csv	1.5 KB
/Exercise Files/Chapter11/
Styles.xlsx	18.5 KB
Filters.xlsx	18.2 KB
DataFormat.xlsx	18.2 KB
MultipleDataFields.xlsx	17.6 KB
Totals.xlsx	17.5 KB
PivotIntro.xlsx	17.4 KB
SummaryOperation.xlsx	17.4 KB
Pivoting.xlsx	16.7 KB
CreatePivot.xlsx	11.7 KB
/Exercise Files/Chapter04/
MoveTarget.xlsx	15.7 KB
RegentStreet.jpg	13.8 KB
Freeze.xlsx	12.7 KB
ManageWorksheets.xlsx	12.2 KB
Headers.xlsx	11.2 KB
ExcelTables.xlsx	11.1 KB
Sort.xlsx	10.2 KB
CustomSort.xlsx	10.2 KB
Filter.xlsx	9.9 KB
ManageCells.xlsx	9.9 KB
/Exercise Files/Chapter08/
ChartElements.xlsx	15.3 KB
ChartLayout.xlsx	15.3 KB
ChartAxes.xlsx	15.2 KB
Trendline.xlsx	14.7 KB
XYChart.xlsx	10.3 KB
StockChart.xlsx	10.3 KB
Sparkline.xlsx	10.1 KB
PieChart.xlsx	9.9 KB
LineChart.xlsx	9.9 KB
ColumnChart.xlsx	9.9 KB
/Exercise Files/Chapter01/
WhatToDo.xlsx	13.6 KB
RibbonTour.xlsx	13.3 KB
Preferences.xlsx	10.8 KB
GettingHelp.xlsx	10.7 KB
/Exercise Files/Chapter02/
FileManagement.xlsx	12.0 KB
SalesReport.xlsx	10.4 KB
Versions.xlsx	10.3 KB
Properties.xlsx	10.0 KB
/Exercise Files/Chapter06/
Tracing.xlsx	10.6 KB
ErrorIndicators.xlsx	10.2 KB
GoalSeek.xlsx	10.1 KB
Concatenate.xlsx	9.8 KB
Counting.xlsx	9.6 KB
Rounding.xlsx	9.5 KB
VLookup.xlsx	9.3 KB
ManageScenarios.xlsx	8.8 KB
/Exercise Files/Chapter05/
ExcelTables.xlsx	10.2 KB
CopyFormulas.xlsx	9.7 KB
CreatingFormulas.xlsx	9.5 KB
AutoSum.xlsx	9.2 KB
Conditional.xlsx	9.0 KB
CellRefs.xlsx	8.9 KB
StatusBar.xlsx	8.7 KB
IfFormulas.xlsx	8.5 KB
FormulaIntro.xlsx	8.4 KB
Operators.xlsx	8.4 KB
Total files 215