|
Tutorial Introduction ├─Part 1: Basics│ 1.1 To learn Excel well, you only need to do these three things.mp4
│ 1.10 Basic elements of Excel2016.mp4
│ 1.11 Set up automatic saving.mp4
│ 1.2 Microsoft Office download website.mp4
│ 1.3 Version Compatibility.mp4
│ 1.4 The uniqueness of Excel2016.mp4
│ 1.5 Install Excel2016.mp4
│ 1.6 Start Excel2016.mp4
│ 1.7 Exit Excel2016.mp4
│ 1.8 Excel2016 operation interface.mp4
│ 1.9 Customized operation interface.mp4
│ 2.1 Types of workbooks.mp4
│ 2.10 Create a new worksheet.mp4
│ 2.11 Delete worksheet.mp4
│ 2.12 Rename worksheet.mp4
│ 2.13 Moving and copying worksheets.mp4
│ 2.14 Show and hide worksheets.mp4
│ 2.15 Setting the worksheet tab color.mp4
│ 2.16 Protect Worksheet.mp4
│ 2.2 Create a new workbook.mp4
│ 2.3 Save workbook.mp4
│ 2.4 Save as compatible format .mp4
│ 2.5 Set the default save format to .mp4
│ 2.6 Recovering an unsaved workbook.mp4
│ 2.7 Opening and closing workbooks.mp4
│ 2.8 Set workbook permission password.mp4
│ 2.9 Revoke workbook permission password.mp4
│ 3.1 The concept of rows, columns and cells.mp4
│ 3.10 Selecting a cell area.mp4
│ 3.2 Selecting rows and columns.mp4
│ 3.3 Inserting rows and columns.mp4
│ 3.4 Deleting rows and columns.mp4
│ 3.5 Moving rows and columns.mp4
│ 3.6 Copying rows and columns.mp4
│ 3.7 Setting row height and column width.mp4
│ 3.8 Select Cell.mp4
│ 3.9 Merge and split cells.mp4
│ 4.1 Value.mp4
│ 4.10 Deleting cell contents.mp4
│ 4.11 Automatic line break and forced line break.mp4
│ 4.12 Undo and Redo.mp4
│ 4.13 AutoFill.mp4
│ 4.14 Custom Fill Sequence.mp4
│ 4.15 General format.mp4
│ 4.16 Numerical format.mp4
│ 4.17 Text format.mp4
│ 4.18 Create custom format .mp4
│ 4.19 How to input numbers starting with 0.mp4
│ 4.2 Text.mp4
│ 4.3 Logical Value.mp4
│ 4.4 Entering data in cells.mp4
│ 4.5 Batch input of the same data in multiple cells.mp4
│ 4.6 Input superscript and subscript.mp4
│ 4.7 Enable AutoComplete.mp4
│ 4.8 Select .mp4 from the drop-down list
│ 4.9 Modify cell contents.mp4
│ 5.1 Horizontal and vertical alignment.mp4
│ 5.10 Apply built-in table styles.mp4
│ 5.11 Create a new table style.mp4
│ 5.2 General Alignment.mp4
│ 5.3 Horizontal and vertical alignment.mp4
│ 5.4 Centering across columns and merging cells.mp4
│ 5.5 Filling.mp4
│ 5.6 Setting text direction.mp4
│ 5.7 Set text direction.mp4
│ 5.8 New Cell Style.mp4
│ 5.9 Merge Style.mp4
│ 6.1 Normal view.mp4
│ 6.10 Split Window.mp4
│ 6.11 Freeze Pane.mp4
│ 6.12 Setting the paper size.mp4
│ 6.13 Setting the paper orientation.mp4
│ 6.14 Setting the zoom ratio.mp4
│ 6.15 Set the starting page number.mp4
│ 6.16 Setting page margins.mp4
│ 6.17 Setting header and footer.mp4
│ 6.18 Print different headers and footers for odd and even pages.mp4
│ 6.19 Setting the print area.mp4
│ 6.2 Page preview view.mp4
│ 6.20 Discontinuous areas printed on one page.mp4
│ 6.21 Printing header rows and header columns.mp4
│ 6.22 Other printing parameter settings.mp4
│ 6.23 Print preview.mp4
│ 6.3 Page Layout View.mp4
│ 6.4 Four elements of table display.mp4
│ 6.5 Setting the table display ratio.mp4
│ 6.6 New Window.mp4
│ 6.7 Rearrange Window.mp4
│ 6.8 Switch Window.mp4
│ 6.9 Window side-by-side viewing and synchronous scrolling.mp4
│ 7.1 Sorting.mp4
│ 7.2 Filter.mp4
│ 7.3 Conditional Formatting.mp4
│
├─Part 3: Pivot Table│ 1.1 Purpose of Pivot Table.mp4
│ 1.10 Creating a dynamic pivot table.mp4
│ 1.11 Create a single-page field pivot table.mp4
│ 1.12 Creating a custom page field pivot table.mp4
│ 1.13 Using external data sources.mp4
│ 1.2 Create a PivotTable.mp4
│ 1.3 Pivot table structure and field list.mp4
│ 1.4 Display of Pivot Table.mp4
│ 1.5 Clearing, selecting and moving pivot tables.mp4
│ 1.6 Change data source and refresh.mp4
│ 1.7 Activity Field Settings.mp4
│ 1.8 Parent field items and child field items.mp4
│ 1.9 Composite fields.mp4
│ 2.1 Pivot table layout.mp4
│ 2.2 Repeating tags and merging tags.mp4
│ 2.3 Setting of subtotals, totals and blank lines.mp4
│ 2.4 Pivot table style.mp4
│ 3.1 Insert Slicer.mp4
│ 3.2 Filter Connection.mp4
│ 3.3 Report connection (slicer linkage).mp4
│ 3.4 Common settings for slicers.mp4
│ 3.5 Insert schedule.mp4
│ 4.1 Automatic date grouping.mp4
│ 4.2 Automatic grouping of values.mp4
│ 4.3 Custom Grouping.mp4
│ 5.1 Calculated Fields.mp4
│ 5.2 Calculation Items.mp4
│ 5.3 Solving order and listing formulas.mp4
│ 6.1 Value aggregation method.mp4
│ 6.2 Value Display Method.mp4
│ 7.1 Pivot table sorting.mp4
│ 7.2 Pivot table filtering.mp4
│ 8.1 Using Conditional Formatting in PivotTables.mp4
│ 9.1 Creating a Pivot Chart.mp4
│ 9.2 Setting up a pivot chart.mp4
│
├─Part 2: Formula Function│ 1.1 If you want to learn Excel functions well, you have to do this.mp4
│ 1.2 The difference between formula and function.mp4
│ 1.3 Operator.mp4
│ 1.4 Relative references, absolute references and mixed references.mp4
│ 2.1 If function.mp4
│ 2.2 IfError function.mp4
│ 2.3 And function.mp4
│ 2.4 Or function.mp4
│ 2.5 Not function.mp4
│ 3.1 Left function.mp4
│ 3.10 Search function.mp4
│ 3.11 Trim function.mp4
│ 3.12 Text function.mp4
│ 3.13 Value function.mp4
│ 3.2 Right function.mp4
│ 3.3 Mid function.mp4
│ 3.4 Len function.mp4
│ 3.5 Lower function.mp4
│ 3.6 Upper function.mp4
│ 3.7 Substitute function.mp4
│ 3.8 Replace function.mp4
│ 3.9 Find function.mp4
│ 4.1 Lookup function.mp4
│ 4.10 Offset function.mp4
│ 4.11 Transpose function.mp4
│ 4.2 Vlookup function.mp4
│ 4.3 HLookup function.mp4
│ 4.4 Column function.mp4
│ 4.5 Row function.mp4
│ 4.6 Address function.mp4
│ 4.7 Indirect function.mp4
│ 4.8 Index function.mp4
│ 4.9 Match function.mp4
│ 5.1 Sum function.mp4
│ 5.10 Abs function.mp4
│ 5.11 Mod function.mp4
│ 5.12 Rand function.mp4
│ 5.2 SumIf function.mp4
│ 5.3 SumIfs function.mp4
│ 5.4 SubTotal function.mp4
│ 5.5 Product function.mp4
│ 5.6 SumProduct function.mp4
│ 5.7 Round function.mp4
│ 5.8 Trunc function.mp4
│ 5.9 Int function.mp4
│ 6.1 Average function.mp4
│ 6.10 Min function.mp4
│ 6.11 Large Function.mp4
│ 6.12 Small function.mp4
│ 6.13 Rank function.mp4
│ 6.2 AverageIf function.mp4
│ 6.3 AverageIfs function.mp4
│ 6.4 Count function.mp4
│ 6.5 CountIf function.mp4
│ 6.6 CountIfs function.mp4
│ 6.7 CountA function.mp4
│ 6.8 CountBlank function.mp4
│ 6.9 Max function.mp4
│ 7.1 Today function.mp4
│ 7.2 Now function.mp4
│ 7.3 Year function.mp4
│ 7.4 Month function.mp4
│ 7.5 Day function.mp4
│ 7.6 Hour function.mp4
│ 7.7 Minute function.mp4
│ 7.8 Second function.mp4
│ 7.9 WeekDay function.mp4
│ 8.1 Cell function.mp4
│
└─Part 4: Charts
1.1 Uses and features of charts.mp4
1.2 Create chart.mp4
1.3 Chart composition.mp4
1.4 Basis for selecting chart type.mp4
2.1 Column chart.mp4
2.10 Combination picture.mp4
2.11 3D Map.mp4
2.2 Bar chart.mp4
2.3 Line chart.mp4
2.4 pie chart.mp4
2.5 Donut chart.mp4
2.6 Area Chart.mp4
2.7 XY Scatter Plot.mp4
2.8 Bubble chart.mp4
2.9 Radar chart.mp4
3.1 Sparkline creation and deletion.mp4
3.2 Mini-image settings and beautification.mp4 |
