Hot：244  Size：568.62 MB  Created：2017-09-15 17:13:47  File Count：113

048 Printing each item on its own page.mp4  16.57 MB
052 Creating a simple PivotTable presentation kit.mp4  15.62 MB
051 Running an Excel macro.mp4  15.46 MB
028 Creating a PivotTable style.mp4  15.4 MB
035 Formatting cells using icon sets.mp4  15.35 MB

Hot：1536  Size：993.15 MB  Created：2017-08-27 16:50:00  File Count：76

01. Introduction/01_01-Welcome.mp4  6.52 MB
01. Introduction/01_02-Using the exercise files.mp4  1.39 MB
02. Formula and Function Tips and Shortcuts/02_01-Displaying and highlighting formulas.mp4  16.37 MB
02. Formula and Function Tips and Shortcuts/02_02-Using Auditing tools.mp4  22.4 MB
02. Formula and Function Tips and Shortcuts/02_03-Using entire row and column references.mp4  11.74 MB

Hot：3214  Size：285.66 MB  Created：2017-08-26 07:30:23  File Count：30

Create value-based formatting using data bars, color scales, and icons-473602.mp4  27.64 MB
Set special formats for dates, times, phone numbers, and zip codes-473597.mp4  25.07 MB
Apply border styles and adjust gridlines-473586.mp4  21.67 MB
Build custom numeric formats-473598.mp4  20.89 MB
Adjust horizontal and vertical cell alignment-473589.mp4  18.09 MB

Hot：126  Size：155.26 MB  Created：2017-09-06 23:52:02  File Count：14

01. Introduction/01_01-Welcome.mp4  8.79 MB
01. Introduction/01_02-Using the exercise files.mp4  1.15 MB
02. Day 1 Payday Chart/02_01-Challenge Complete a payday chart using Auto Fill and yeartodate formulas.mp4  4.3 MB
02. Day 1 Payday Chart/02_02-Solution Complete a payday chart using Auto Fill and yeartodate formulas.mp4  10.3 MB
03. Day 2 Employee List/03_01-Challenge Reorder names in an employee list.mp4  4.69 MB

Hot：4035  Size：568.62 MB  Created：2017-08-28 07:54:44  File Count：113

048 Printing each item on its own page.mp4  16.57 MB
052 Creating a simple PivotTable presentation kit.mp4  15.62 MB
051 Running an Excel macro.mp4  15.46 MB
028 Creating a PivotTable style.mp4  15.4 MB
035 Formatting cells using icon sets.mp4  15.35 MB

Hot：582  Size：194.53 MB  Created：2019-02-15 13:50:28  File Count：27

3.2. Tables/09.Using slicers to facilitate table filtering.mp4  24.35 MB
2.1. Database Design Concerns/03.Designing for large lists and restructuring data.mp4  22.9 MB
4.3. Controlling the Creation of New Data/11.Using data validation to restrict data entries.mp4  19.8 MB
4.3. Controlling the Creation of New Data/10.Using the Form tool to build and view data.mp4  19.08 MB
3.2. Tables/05.Converting data into tables.mp4  18.67 MB

Hot：1195  Size：976.6 MB  Created：2017-08-31 16:13:27  File Count：83

13. Database Features/13_02-Inserting subtotals in a sorted list.mp4  36.28 MB
05. Formatting/05_08-Creating and using tables.mp4  30.23 MB
16. Introduction to Macros/16_03-Running a macro.mp4  25.09 MB
07. Printing/07_01-Exploring the Page Layout tab and view.mp4  24.86 MB
14. PivotTables/14_02-Manipulating PivotTable data.mp4  21.7 MB

Hot：2073  Size：1.02 GB  Created：2017-08-28 10:49:28  File Count：92

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions-463375.mp4  23.32 MB
Tabulating data from multiple sheets-463302.mp4  22.59 MB
Using Auditing tools-463295.mp4  22.4 MB
Understanding Excel date and time capabilities in formulas-463345.mp4  22.36 MB
Using the powerful AGGREGATE function to bypass errors and hidden data-463342.mp4  21.06 MB

Hot：3325  Size：185.07 MB  Created：2017-08-27 01:22:13  File Count：91

03 Adding Logic to Your VBA Code/0304 Performing a task when conditions are met using If Then.mov  7.18 MB
02 Defining Variables, Constants, and Calculations/0206 Defining arrays.mov  7.06 MB
02 Defining Variables, Constants, and Calculations/0201 Introducing Excel VBA data types.mov  6.72 MB
01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov  6.57 MB
08 Putting it All Together/0801 Applying techniques in a Capstone project.mov  6.06 MB

Hot：1271  Size：553.82 MB  Created：2017-08-29 10:21:38  File Count：55

Working with tables-157962.mp4  54.11 MB
Setting up data for outlining-157974.mp4  33.22 MB
Creating value-based formatting using data bars, color scales, and icons-157958.mp4  25.5 MB
Creating linked worksheet images-157985.mp4  24.31 MB
Working with the Hide and Unhide options-157967.mp4  22.21 MB

Hot：884  Size：111.81 MB  Created：2017-08-26 14:43:43  File Count：18

00.03.Controlling.The.Creation.Of.New.Data/89046_03_01_SC11_form.mov  18.17 MB
00.01.Database.Design.Concerns/89046_01_01_SC11_design.mov  15.93 MB
00.03.Controlling.The.Creation.Of.New.Data/89046_03_02_SC11_validation.mov  15.02 MB
00.02.Tables/89046_02_02_SC11_ribbon.mov  14.79 MB
00.02.Tables/89046_02_01_SC11_tables.mov  10.8 MB

Hot：68  Size：212.48 MB  Created：2017-09-03 14:57:50  File Count：30

03. Creating Date and Time Entries/03_04-Using AutoFill to enter a date or time series rapidly.mp4  18 MB
05. Date and Time Functions/05_02-DATEDIF Date differences by year, month, day, and more.mp4  14.85 MB
02. The Excel Date and Time Systems/02_01-How Excel records and stores dates.mp4  13.23 MB
07. Using Dates and Times with Excel Commands/07_01-Using special date filters with date data Advanced data filter applications.mp4  13.17 MB
03. Creating Date and Time Entries/03_01-Standard date- and time-entry options and acceptable alternatives.mp4  9.98 MB

Hot：303  Size：288.73 MB  Created：2017-08-27 01:49:35  File Count：41

01. Introduction/01_01-Welcome.mp4  7.46 MB
01. Introduction/01_02-What you should know before watching this course.mp4  3.22 MB
01. Introduction/01_03-Using the exercise files.mp4  1.4 MB
02. Working with Solver/02_01-Finding target values using Goal Seek.mp4  6.07 MB
02. Working with Solver/02_02-Introducing linear and integer programming.mp4  4.08 MB

Hot：2740  Size：619.43 MB  Created：2017-08-27 17:38:11  File Count：153

Animating large tables and objects-152270.mp4  34.8 MB
Converting SmartArt to shapes-152263.mp4  23.01 MB
Formatting a range as a table-152230.mp4  21.24 MB
Copying tables and pasting pictures-152256.mp4  17.6 MB
Creating and formatting a PivotTable-152249.mp4  17.3 MB

Hot：3553  Size：429.87 MB  Created：2017-08-26 13:49:06  File Count：67

022 Sourcing calendars.mp4  31.8 MB
006 Exploring data types.mp4  27.83 MB
015 Understanding single table evaluation context.mp4  23.88 MB
008 Exploring the PowerPivot data model.mp4  23.66 MB
019 Exploring how CALCULATE works.mp4  21.23 MB

Hot：2  Size：976.6 MB  Created：2019-04-08 10:09:45  File Count：83

13. Database Features/13_02-Inserting subtotals in a sorted list.mp4  36.28 MB
05. Formatting/05_08-Creating and using tables.mp4  30.23 MB
16. Introduction to Macros/16_03-Running a macro.mp4  25.09 MB
07. Printing/07_01-Exploring the Page Layout tab and view.mp4  24.86 MB
14. PivotTables/14_02-Manipulating PivotTable data.mp4  21.7 MB

Hot：330  Size：402.39 MB  Created：2021-04-02 05:31:57  File Count：未知

Hot：1985  Size：190.64 MB  Created：2017-08-26 17:16:20  File Count：27

Exercise Files/Ch_03.xlsx  29.88 KB
Exercise Files/Ch_05b.xlsx  92.89 KB
Exercise Files/Ch_05a.xlsx  93.15 KB
Exercise Files/Ch_02.xlsx  114.67 KB
Exercise Files/Ch_04.xlsx  186.61 KB

Hot：740  Size：491.6 MB  Created：2017-08-28 17:01:18  File Count：35

0. Introduction/01. Welcome.mp4  7.91 MB
0. Introduction/02. Using the exercise files.mp4  1.54 MB
1. Sorting Data/01. Sorting concepts and Sort dialog options.mp4  31.43 MB
1. Sorting Data/02. Sorting from menu icons.mp4  13.3 MB
1. Sorting Data/03. Multiple-key sorting.mp4  17.42 MB

Hot：7  Size：369.67 MB  Created：2022-10-08 07:47:57  File Count：47

04_02-The_User_Interface_Model_Usage_Group.mp4  37.53 MB
04_01-The_User_Interface_Data_Preperation_Tab.mp4  34.3 MB
00_04-Building_an_environment.mp4  30.1 MB
04_04-The_User_Interface_Data_Modeling_Group.mp4  22.1 MB
04_03-The_User_Interface_Accuracy_and_Validation_Group.mp4  21.49 MB