Lynda - Excel for Mac 2016 Essential Training

seeders: 17
leechers: 10
Added on October 10, 2015 by krish.princein Other > Tutorials
Torrent verified.



Lynda - Excel for Mac 2016 Essential Training (Size: 893.35 MB)
 01_01-Welcome.mp44.97 MB
 01_02-Using the exercise files.mp41004.81 KB
 02_01-What you can do with Excel 2016.mp46.42 MB
 02_02-Exploring the Excel 2016 program window.mp411.72 MB
 02_03-Introducing the Ribbon for the Mac.mp49.7 MB
 02_04-Setting program preferences.mp410.19 MB
 02_05-Getting help in Excel.mp47.95 MB
 03_01-Opening, creating, and saving workbooks.mp48.33 MB
 03_02-Setting workbook properties.mp46.16 MB
 03_03-Creating and modifying workbook templates.mp48.55 MB
 03_04-Managing workbooks across multiple versions of Excel.mp46.83 MB
 04_01-Selecting cells and groups of cells.mp49.84 MB
 04_02-Copying and pasting cell data.mp49.95 MB
 04_03-Entering data using AutoFill and other techniques.mp48.78 MB
 04_04-Inserting symbols and special characters.mp412.12 MB
 04_05-Creating named ranges.mp414.71 MB
 04_06-Creating an Excel table.mp410.47 MB
 04_07-Locating and changing data using Find and Replace.mp413.79 MB
 04_08-Restricting input using validation rules.mp416.91 MB
 04_09-Using lists to limit data entered into a cell.mp46.91 MB
 05_01-Sorting worksheet data.mp47.44 MB
 05_02-Creating a custom sort order.mp411.41 MB
 05_03-Filtering worksheet data.mp48.77 MB
 05_04-Inserting, moving, and deleting cells and cell ranges.mp49.7 MB
 05_05-Splitting and freezing rows and columns.mp415.15 MB
 05_06-Managing worksheets.mp411.43 MB
 05_07-Creating, editing, and deleting headers and footers.mp48.27 MB
 06_01-Introducing Excel formulas and functions.mp46.76 MB
 06_02-Adding a formula to a cell.mp49.04 MB
 06_03-Introducing arithmetic operators.mp49.97 MB
 06_04-Using relative and absolute cell references.mp413.17 MB
 06_05-Controlling how Excel copies and pastes formulas.mp410.29 MB
 06_06-Referring to Excel table data in formulas.mp48.33 MB
 06_07-Creating an AutoSum formula.mp49.4 MB
 06_08-Summarizing data on the status bar.mp45.29 MB
 06_09-Summarizing data using an IF function.mp410.74 MB
 06_10-Summarizing data using SUMIF and other conditional functions.mp414.4 MB
 07_01-Creating formulas to count cells.mp46.02 MB
 07_02-Rounding cell values.mp49.06 MB
 07_03-Joining text in cells with concatenation.mp48.09 MB
 07_04-Finding data using VLOOKUP and HLOOKUP.mp47.77 MB
 07_05-Auditing formulas by identifying precedents and dependents.mp46.8 MB
 07_06-Managing Excel formula error indicators.mp410.12 MB
 07_07-Managing scenarios.mp415.95 MB
 07_08-Performing Goal Seek analysis.mp46.66 MB
 08_01-Applying fonts, background colors, and borders.mp411.84 MB
 08_02-Applying number and date formats to cells.mp411.94 MB
 08_03-Managing text alignment.mp410.61 MB
 08_04-Copying cell formats.mp47.91 MB
 08_05-Managing cell styles.mp410.56 MB
 08_06-Managing Office themes.mp413.6 MB
 08_07-Creating rulebased conditional formats.mp410.68 MB
 08_08-Defining top 10 conditional formats.mp410.93 MB
 08_09-Defining data bar, color scale, and icon set conditional formats.mp415.91 MB
 08_10-Editing, ordering, and deleting conditional formats.mp49.62 MB
 09_01-Creating bar and column charts.mp411.95 MB
 09_02-Creating pie charts.mp45.51 MB
 09_03-Creating line charts.mp47.43 MB
 09_04-Creating XY scatter charts.mp45.6 MB
 09_05-Creating stock charts.mp45.94 MB
 09_06-Changing chart types and layouts.mp45.8 MB
 09_07-Changing the appearance of chart elements.mp48.08 MB
 09_08-Managing chart axes and numbering.mp46.77 MB
 09_09-Adding trendlines to charts.mp47.87 MB
 09_10-Creating sparkline charts.mp49.81 MB
 10_01-Importing data from commaseparated value CSV or text files.mp48.94 MB
 10_02-Connecting to an external data source.mp43.4 MB
 10_03-Using hyperlinks.mp49.5 MB
 10_04-Including an Excel workbook in another Office document.mp48.06 MB
 10_05-Linking to an Excel chart from another Office program.mp45.74 MB
 11_01-Creating and formatting shapes.mp412.68 MB
 11_02-Adding and adjusting images.mp413.05 MB
 11_03-Manipulating text boxes.mp47.88 MB
 11_04-Cropping, compressing, and removing image backgrounds.mp411.96 MB
 11_05-Creating SmartArt graphics.mp49.52 MB
 11_06-Creating WordArt.mp46.26 MB
 11_07-Aligning and layering objects.mp411.99 MB
 12_01-Introducing PivotTable reports.mp46.66 MB
 12_02-Creating a PivotTable report.mp47.47 MB
 12_03-Pivoting a PivotTable report.mp47.3 MB
 12_04-Managing subtotals and grand totals.mp47.8 MB
 12_05-Summarizing more than one data field.mp44.6 MB
 12_06-Changing the data field summary operation.mp411.9 MB
 12_07-Changing the data field number format.mp44.66 MB
 12_08-Filtering a PivotTable report.mp414.91 MB
 12_09-Applying a PivotTable style.mp46.36 MB
 13_01-Checking spelling.mp46.47 MB
 13_02-Setting AutoCorrect and automatic Replace options.mp49.99 MB
 13_03-Managing workbook comments.mp47.43 MB
 13_04-Tracking and reviewing changes.mp49.89 MB
 13_05-Printing a worksheet or workbook.mp46.72 MB
 13_06-Setting and removing print areas.mp46.07 MB
 13_07-Exporting to other formats.mp46.64 MB
 13_08-Protecting a workbook.mp47.53 MB
 14_01-Running an existing macro.mp47.86 MB
 14_02-Recording a macro.mp46.37 MB
 14_03-Renaming, viewing, and deleting macros.mp46.1 MB
 14_04-Adding comments to a macro.mp45.62 MB
 14_05-Turning off screen updating in a macro.mp47.77 MB
 15_01-Next steps.mp43.2 MB
 Ex_Files_ExcelMac2016_EssT.zip1.35 MB


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
893.35 MB
seeders:17
leechers:10
Lynda - Excel for Mac 2016 Essential Training