|
|
001 Welcome.mp4
|
MP4
|
4.97 MB
|
|
|
002 Using the exercise files.mp4
|
MP4
|
1004.85 KB
|
|
|
003 What you can do with Excel 2016.mp4
|
MP4
|
6.42 MB
|
|
|
004 Exploring the Excel 2016 program window.mp4
|
MP4
|
11.72 MB
|
|
|
005 Introducing the Ribbon for the Mac.mp4
|
MP4
|
9.7 MB
|
|
|
006 Setting program preferences.mp4
|
MP4
|
10.19 MB
|
|
|
007 Getting help in Excel.mp4
|
MP4
|
7.95 MB
|
|
|
008 Opening, creating, and saving workbooks.mp4
|
MP4
|
8.33 MB
|
|
|
009 Setting workbook properties.mp4
|
MP4
|
6.17 MB
|
|
|
010 Creating and modifying workbook templates.mp4
|
MP4
|
8.55 MB
|
|
|
011 Managing workbooks across multiple versions of Excel.mp4
|
MP4
|
6.83 MB
|
|
|
012 Selecting cells and groups of cells.mp4
|
MP4
|
9.84 MB
|
|
|
013 Copying and pasting cell data.mp4
|
MP4
|
9.95 MB
|
|
|
014 Entering data using AutoFill and other techniques.mp4
|
MP4
|
8.78 MB
|
|
|
015 Inserting symbols and special characters.mp4
|
MP4
|
12.12 MB
|
|
|
016 Creating named ranges.mp4
|
MP4
|
14.71 MB
|
|
|
017 Creating an Excel table.mp4
|
MP4
|
10.47 MB
|
|
|
018 Locating and changing data using Find and Replace.mp4
|
MP4
|
13.79 MB
|
|
|
019 Restricting input using validation rules.mp4
|
MP4
|
16.91 MB
|
|
|
020 Using lists to limit data entered into a cell.mp4
|
MP4
|
6.91 MB
|
|
|
021 Sorting worksheet data.mp4
|
MP4
|
7.44 MB
|
|
|
022 Creating a custom sort order.mp4
|
MP4
|
11.41 MB
|
|
|
023 Filtering worksheet data.mp4
|
MP4
|
8.77 MB
|
|
|
024 Inserting, moving, and deleting cells and cell ranges.mp4
|
MP4
|
9.7 MB
|
|
|
025 Splitting and freezing rows and columns.mp4
|
MP4
|
15.15 MB
|
|
|
026 Managing worksheets.mp4
|
MP4
|
11.43 MB
|
|
|
027 Creating, editing, and deleting headers and footers.mp4
|
MP4
|
8.27 MB
|
|
|
028 Introducing Excel formulas and functions.mp4
|
MP4
|
6.76 MB
|
|
|
029 Adding a formula to a cell.mp4
|
MP4
|
9.04 MB
|
|
|
030 Introducing arithmetic operators.mp4
|
MP4
|
9.97 MB
|
|
|
031 Using relative and absolute cell references.mp4
|
MP4
|
13.17 MB
|
|
|
032 Controlling how Excel copies and pastes formulas.mp4
|
MP4
|
10.29 MB
|
|
|
033 Referring to Excel table data in formulas.mp4
|
MP4
|
8.33 MB
|
|
|
034 Creating an AutoSum formula.mp4
|
MP4
|
9.4 MB
|
|
|
035 Summarizing data on the status bar.mp4
|
MP4
|
5.29 MB
|
|
|
036 Summarizing data using an IF function.mp4
|
MP4
|
10.74 MB
|
|
|
037 Summarizing data using SUMIF and other conditional functions.mp4
|
MP4
|
14.4 MB
|
|
|
038 Creating formulas to count cells.mp4
|
MP4
|
6.02 MB
|
|
|
039 Rounding cell values.mp4
|
MP4
|
9.06 MB
|
|
|
040 Joining text in cells with concatenation.mp4
|
MP4
|
8.09 MB
|
|
|
041 Finding data using VLOOKUP and HLOOKUP.mp4
|
MP4
|
7.77 MB
|
|
|
042 Auditing formulas by identifying precedents and dependents.mp4
|
MP4
|
6.8 MB
|
|
|
043 Managing Excel formula error indicators.mp4
|
MP4
|
10.12 MB
|
|
|
044 Managing scenarios.mp4
|
MP4
|
15.95 MB
|
|
|
045 Performing Goal Seek analysis.mp4
|
MP4
|
6.66 MB
|
|
|
046 Applying fonts, background colors, and borders.mp4
|
MP4
|
11.84 MB
|
|
|
047 Applying number and date formats to cells.mp4
|
MP4
|
11.94 MB
|
|
|
048 Managing text alignment.mp4
|
MP4
|
10.61 MB
|
|
|
049 Copying cell formats.mp4
|
MP4
|
7.91 MB
|
|
|
050 Managing cell styles.mp4
|
MP4
|
10.56 MB
|
|
|
051 Managing Office themes.mp4
|
MP4
|
13.6 MB
|
|
|
052 Creating rule-based conditional formats.mp4
|
MP4
|
10.68 MB
|
|
|
053 Defining top 10 conditional formats.mp4
|
MP4
|
10.93 MB
|
|
|
054 Defining data bar, color scale, and icon set conditional formats.mp4
|
MP4
|
15.91 MB
|
|
|
055 Editing, ordering, and deleting conditional formats.mp4
|
MP4
|
9.62 MB
|
|
|
056 Creating bar and column charts.mp4
|
MP4
|
11.95 MB
|
|
|
057 Creating pie charts.mp4
|
MP4
|
5.51 MB
|
|
|
058 Creating line charts.mp4
|
MP4
|
7.43 MB
|
|
|
059 Creating XY (scatter) charts.mp4
|
MP4
|
5.6 MB
|
|
|
060 Creating stock charts.mp4
|
MP4
|
5.94 MB
|
|
|
061 Changing chart types and layouts.mp4
|
MP4
|
5.8 MB
|
|
|
062 Changing the appearance of chart elements.mp4
|
MP4
|
8.08 MB
|
|
|
063 Managing chart axes and numbering.mp4
|
MP4
|
6.77 MB
|
|
|
064 Adding trendlines to charts.mp4
|
MP4
|
7.87 MB
|
|
|
065 Creating sparkline charts.mp4
|
MP4
|
9.81 MB
|
|
|
066 Importing data from comma-separated value (CSV) or text files.mp4
|
MP4
|
8.94 MB
|
|
|
067 Connecting to an external data source.mp4
|
MP4
|
3.4 MB
|
|
|
068 Using hyperlinks.mp4
|
MP4
|
9.5 MB
|
|
|
069 Including an Excel workbook in another Office document.mp4
|
MP4
|
8.06 MB
|
|
|
070 Linking to an Excel chart from another Office program.mp4
|
MP4
|
5.74 MB
|
|
|
071 Creating and formatting shapes.mp4
|
MP4
|
12.68 MB
|
|
|
072 Adding and adjusting images.mp4
|
MP4
|
13.05 MB
|
|
|
073 Manipulating text boxes.mp4
|
MP4
|
7.88 MB
|
|
|
074 Cropping, compressing, and removing image backgrounds.mp4
|
MP4
|
11.96 MB
|
|
|
075 Creating SmartArt graphics.mp4
|
MP4
|
9.52 MB
|
|
|
076 Creating WordArt.mp4
|
MP4
|
6.26 MB
|
|
|
077 Aligning and layering objects.mp4
|
MP4
|
11.99 MB
|
|
|
078 Introducing PivotTable reports.mp4
|
MP4
|
6.66 MB
|
|
|
079 Creating a PivotTable report.mp4
|
MP4
|
7.47 MB
|
|
|
080 Pivoting a PivotTable report.mp4
|
MP4
|
7.3 MB
|
|
|
081 Managing subtotals and grand totals.mp4
|
MP4
|
7.8 MB
|
|
|
082 Summarizing more than one data field.mp4
|
MP4
|
4.6 MB
|
|
|
083 Changing the data field summary operation.mp4
|
MP4
|
11.9 MB
|
|
|
084 Changing the data field number format.mp4
|
MP4
|
4.66 MB
|
|
|
085 Filtering a PivotTable report.mp4
|
MP4
|
14.91 MB
|
|
|
086 Applying a PivotTable style.mp4
|
MP4
|
6.36 MB
|
|
|
087 Checking spelling.mp4
|
MP4
|
6.47 MB
|
|
|
088 Setting AutoCorrect and automatic Replace options.mp4
|
MP4
|
9.99 MB
|
|
|
089 Managing workbook comments.mp4
|
MP4
|
7.43 MB
|
|
|
090 Tracking and reviewing changes.mp4
|
MP4
|
9.89 MB
|
|
|
091 Printing a worksheet or workbook.mp4
|
MP4
|
6.72 MB
|
|
|
092 Setting and removing print areas.mp4
|
MP4
|
6.07 MB
|
|
|
093 Exporting to other formats.mp4
|
MP4
|
6.64 MB
|
|
|
094 Protecting a workbook.mp4
|
MP4
|
7.53 MB
|
|
|
095 Running an existing macro.mp4
|
MP4
|
7.86 MB
|
|
|
096 Recording a macro.mp4
|
MP4
|
6.37 MB
|
|
|
097 Renaming, viewing, and deleting macros.mp4
|
MP4
|
6.1 MB
|
|
|
098 Adding comments to a macro.mp4
|
MP4
|
5.62 MB
|
|
|
099 Turning off screen updating in a macro.mp4
|
MP4
|
7.77 MB
|
|
|
100 Next steps.mp4
|
MP4
|
3.2 MB
|
|
|
Exercise Files
|
|
Chapter01
|
|
|
Chapter02
|
|
|
Chapter03
|
|
|
Chapter04
|
|
|
Chapter05
|
|
|
Chapter06
|
|
|
Chapter07
|
|
|
Chapter08
|
|
|
Chapter09
|
|
|
Chapter10
|
|
|
Chapter11
|
|
|
Chapter12
|
|
|
Chapter13
|
|
