Hot：644  Size：184.91 MB  Created：2017-08-26 13:30:50  File Count：48

00 Introduction/0001 Welcome.mov  4.7 MB
00 Introduction/0002 Using the exercise files.mov  279.59 KB
01 Introducing Visual Basic for Applications/0105 Creating, exporting, and deleting code modules.mov  6.57 MB
01 Introducing Visual Basic for Applications/0106 Creating a subroutine or function.mov  5.74 MB
01 Introducing Visual Basic for Applications/0103 Working in the Visual Basic editor.mov  4.98 MB

Hot：923  Size：143.99 MB  Created：2017-08-26 13:15:57  File Count：17

0. Introduction/186873_00_01_WX30_Welcome.mp4  5.48 MB
0. Introduction/186873_00_02_XR15_Demonstration_of_the_dashboard_we_will_be_building.mp4  9.11 MB
0. Introduction/186873_00_03_XR15_Building_an_enviornment.mp4  5.88 MB
0. Introduction/186873_00_04_XR15_using_the_exercise_files.mp4  2.82 MB
1. Sourcing and Enhancing the Data Model/186873_01_01_XR15_Dashboard_Design_Guide_Lines.mp4  4.37 MB

Hot：3411  Size：16.23 MB  Created：2017-08-26 13:00:01  File Count：10

Screenshots/13635531.jpg  395.49 KB
Screenshots/13651915.jpg  321.03 KB
Screenshots/13651916.png  35.19 KB
Screenshots/13658059.jpg  349.68 KB
Screenshots/13662155.jpg  362.04 KB

Hot：831  Size：293.46 MB  Created：2017-08-26 12:59:16  File Count：98

Reading a corporate financial statement-55978.mp4  15.29 MB
Welcome-55962.mp4  12.44 MB
Calculating interest and principal components of loan repayments-56013.mp4  12 MB
Avoiding common mistakes-55967.mp4  10.85 MB
Introducing common-sizing strategies for analyzing financial statements-55979.mp4  8.63 MB

Hot：1103  Size：450.46 MB  Created：2017-08-26 11:14:45  File Count：16

01 Course Introduction/001 Course Introduction.mp4  5.93 MB
04 Effective Error handling using ISERRORIFERROR/001 Effective Error handling using ISERRORIFERROR.mp4  19.82 MB
06 Using formula auditing tools to avoid errors/001 Using formula auditing tools to avoid errors.mp4  15.45 MB
10 Implementing Slicers to build Interactive dashboards/001 Implementing Slicers to build Interactive dashboards.mp4  66.16 MB
11 Grouping and Sub Total of Data in Pivots/001 Grouping and Sub Total of Data in Pivots.mp4  39.06 MB

Hot：425  Size：314.75 MB  Created：2017-08-26 10:35:43  File Count：45

4 - Course Wrap Up/96509c3a-c374-4ec1-b3a2-a27e7efae7de.pdf  71.84 KB
4 - Course Wrap Up/ee990b46-e27a-41ed-9ed7-a1ae9a37a2f7.pdf  38.71 KB
03 Interview Questions Part 2/029 How do you find a value in Excel.mp4  6.23 MB
03 Interview Questions Part 2/030 How do dates work in Excel.mp4  16.44 MB
03 Interview Questions Part 2/032 What is the QAT.mp4  4.54 MB

Hot：1592  Size：141.85 MB  Created：2017-08-26 10:02:11  File Count：19

2 - Microsoft Excel Hacks 101/Hack 10 - Creating Custom AutoFill Lists.mp4  19.37 MB
1 - Course Introduction/Quick Course Overview and Introduction.mp4  12.27 MB
2 - Microsoft Excel Hacks 101/Hack 01 - Linking Text Boxes to Worksheet Cells.mp4  3.46 MB
2 - Microsoft Excel Hacks 101/Hack 02 - Effectively Deleting Empty Rows in a Data Set.mp4  7 MB
2 - Microsoft Excel Hacks 101/Hack 03 - Quickly Fill Blank Cells with a Value.mp4  19.18 MB

Hot：172  Size：241.59 MB  Created：2017-08-26 09:50:42  File Count：14

1_-_Welcome/1_-_What_will_you_learn_in_this_course_.mp4  5.01 MB
1_-_Welcome/2.1_-_Udemology_Excel_Exercise.xlsx  12.09 KB
2_-_Create_single_block_chart/3_-_Creating_the_formula_s_for_the_Single_Block_Chart.mp4  15.42 MB
2_-_Create_single_block_chart/4_-_Creating_the_graph_for_the_Single_Block_Chart.mp4  31.27 MB
2_-_Create_single_block_chart/5_-_Exercise_Single_block_chart.mp4  2.9 MB

Hot：216  Size：779.66 MB  Created：2017-08-26 09:15:02  File Count：83

00. Introduction/167361_00_01_WX30_Intro.mp4  6.22 MB
00. Introduction/167361_00_02_XR15_exfiles.mp4  1.29 MB
01. Top Ten Shortcuts/167361_01_01_XR15_nonadjacent.mp4  4.69 MB
01. Top Ten Shortcuts/167361_01_02_XR15_convertform.mp4  8.47 MB
01. Top Ten Shortcuts/167361_01_03_XR151_copydowncol.mp4  4.63 MB

Hot：1496  Size：1.05 GB  Created：2017-08-26 09:12:20  File Count：56

Exercise Files/Sample Files.zip  41.97 MB
0101 Welcome To Pivot Tables!.mp4  10.32 MB
0102 How To Learn Pivot Tables In This Course.mp4  10.72 MB
0201 Let's Create A Pivot Table.mp4  45.75 MB
0202 Good Data For Pivot Tables.mp4  31.99 MB

Hot：2753  Size：1.55 GB  Created：2017-08-26 09:03:57  File Count：41

autorun.inf  28 B
images/list.png  898 B
images/aff.png  1.19 KB
images/support.png  1.38 KB
css/styles.css  1.68 KB

Hot：856  Size：6.21 MB  Created：2017-08-26 08:59:02  File Count：未知

Hot：3193  Size：286.08 MB  Created：2017-08-26 08:39:51  File Count：1

Learn.Microsoft.Excel.2016.For.Beginners.mp4  286.08 MB

Hot：11  Size：5.36 MB  Created：2017-08-26 08:28:50  File Count：未知

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：872  Size：727.02 MB  Created：2017-08-26 06:38:11  File Count：86

Extending formula capabilities with arrays-135786.mp4  25.36 MB
Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp4  18.74 MB
Finding approximate matches with VLOOKUP-135750.mp4  17.33 MB
Using MATCH and INDEX together-135757.mp4  17.28 MB
Tabulating blank cells with COUNTBLANK-135765.mp4  16.65 MB

Hot：1206  Size：303.76 MB  Created：2017-08-26 05:18:09  File Count：29

1_-_Importing_Data/1_-_Opening_Intro.mp4  1.01 MB
1_-_Importing_Data/2_-_Power_Pivot_for_the_Excel_User_-_Introduction.mp4  1.47 MB
1_-_Importing_Data/3_-_Installing_Power_Pivot.mp4  5.09 MB
1_-_Importing_Data/4_-_Import_data_from_access.mp4  10.05 MB
1_-_Importing_Data/5_-_import_data_from_custom_query.mp4  5.55 MB

Hot：1641  Size：2.05 GB  Created：2017-08-26 04:56:57  File Count：259

第01章：Excel VBA基础知识/01-32综合运用(盘点清单核对).mp4  17.56 MB
第02章：Excel工作簿和工作表操作/02-11工作簿综合运用(拆分工作簿).mp4  15.62 MB
第03章：Excel单元格区域操作/03-02Range引用基础2.mp4  14.64 MB
第05章：Excel VBA数组/05-14Fileter函数与数组（巧用Filter实现多列结果）.mp4  13.91 MB
第06章：VBA与字典技术/06-10字典应用（多列合并计算）.mp4  13.78 MB

Hot：3546  Size：810.92 MB  Created：2017-08-26 04:47:01  File Count：72

045 Customize area, stock, and XY charts.mp4  38.17 MB
046 Customize doughnut, bubble, and radar charts.mp4  35.89 MB
042 Customize column and bar charts.mp4  26.45 MB
024 Modifying axes.mp4  23.31 MB
048 Create Gantt charts.mp4  22.23 MB

Hot：806  Size：390.22 MB  Created：2017-08-26 04:41:53  File Count：46

07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0701 Converting data into a table and reformatting it.mov  25.47 MB
07 Tables, Themes, Styles, and Other Essential Data Visualization Tools/0702 Using styles and themes for consistent formatting.mov  16.94 MB
01 Adjusting Numeric Formats Quickly/0101 Working with the numeric formatting options.mov  16.17 MB
01 Adjusting Numeric Formats Quickly/0103 Setting special formats for dates, times, phone numbers, fractions, etc.mov  15.15 MB
01 Adjusting Numeric Formats Quickly/0104 Building custom numeric formats.mov  14.27 MB