excel -移花宫 -武林禁地，闲人禁止入内

Extending formula capabilities with arrays-135786.mp4 26.6 MB
Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp4 19.7 MB
Finding approximate matches with VLOOKUP-135750.mp4 18.2 MB
Using MATCH and INDEX together-135757.mp4 18.1 MB
Tabulating blank cells with COUNTBLANK-135765.mp4 17.5 MB
Understanding Excel date_time capabilities in formulas-135777.mp4 17.3 MB
Practical uses for the random number functions RAND and RANDBETWEEN-135772.mp4 15.8 MB
Counting unique entries in a range with an array formula-135787.mp4 15.7 MB
Auditing tools-135729.mp4 15.3 MB
Enhancing readability with range names-135735.mp4 14.8 MB
Displaying and highlighting formulas-135728.mp4 14.1 MB
Using the powerful AGGREGATE function to bypass errors and hidden data-135774.mp4 14.1 MB
Using the AND and OR functions with IF to create compound logical tests-135747.mp4 14.0 MB
Using other utility text functions - LEN, REPT, VALUE, TEXT-135803.mp4 13.3 MB
Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA-135807.mp4 13.2 MB
Ranking data without sorting with RANK-135763.mp4 13.1 MB
Using and extending AutoSum button capabilities-135741.mp4 12.9 MB
Looking up information with VLOOKUP and HLOOKUP-135749.mp4 12.8 MB
Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF-135759.mp4 12.8 MB
Tabulating date differences with DATEDIF-135782.mp4 12.1 MB

[磁力链接] 添加时间:2017-03-25 大小:762.3 MB 最近下载:2025-10-10 热度:374

Pluralsight - Working with Excel on the iPad

01. Introduction to Excel on an iPad/01_01-Introduction to the Course.mp4 5.5 MB
01. Introduction to Excel on an iPad/01_02-Working with Workbooks.mp4 5.4 MB
01. Introduction to Excel on an iPad/01_03-Screen Interface Elements.mp4 6.1 MB
01. Introduction to Excel on an iPad/01_04-Saving and Closing a Workbook.mp4 6.2 MB
01. Introduction to Excel on an iPad/01_05-Printing Your Data.mp4 8.1 MB
01. Introduction to Excel on an iPad/01_06-Summary.mp4 725.1 kB
02. Entering and Editing Data/02_01-Introduction.mp4 1.0 MB
02. Entering and Editing Data/02_02-Working with Cell Entries.mp4 12.7 MB
02. Entering and Editing Data/02_03-Cell Comments.mp4 5.7 MB
02. Entering and Editing Data/02_04-Cut Copy and Paste.mp4 7.9 MB
02. Entering and Editing Data/02_05-Auto Fill.mp4 7.3 MB
02. Entering and Editing Data/02_06-Summary.mp4 839.9 kB
03. Formatting Your Data/03_01-Introduction.mp4 1.7 MB
03. Formatting Your Data/03_02-Resizing Columns and Rows.mp4 18.5 MB
03. Formatting Your Data/03_03-Inserting and Deleting Columns and Rows.mp4 8.8 MB
03. Formatting Your Data/03_04-Applying Formatting to a Cell.mp4 42.9 MB
03. Formatting Your Data/03_05-Hiding and Unhiding Columns and Rows.mp4 9.0 MB
03. Formatting Your Data/03_06-Using Cell Styles.mp4 6.4 MB
03. Formatting Your Data/03_07-Summary.mp4 1.0 MB
04. Creating Formulas and Using Functions/04_01-Introduction.mp4 2.3 MB

[磁力链接] 添加时间:2017-03-25 大小:383.4 MB 最近下载:2025-04-24 热度:192

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

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

[磁力链接] 添加时间:2017-03-25 大小:300.0 MB 最近下载:2025-10-10 热度:4505

Microsoft-Office-Xp-Pro-(Word,-Excel,.Powerpoint,.Outlook,.Access,.Frontpage,.Publisher 2003)

AUTORUN.INF 184 Bytes
FILES/MOD/ACCESSRT.MSI 846.8 kB
FILES/OSP/1033/FILES/SYSTEM/EXTRACT.EXE 53.0 kB
FILES/OSP/1033/FILES/SYSTEM/MLANG.DAT 673.1 kB
FILES/OSP/1033/FILES/SYSTEM/MLANG.DLL 522.5 kB
FILES/OSP/1033/FILES/SYSTEM/MSXML.DLL 521.5 kB
FILES/OSP/1033/FILES/SYSTEM/T2EMBED.DLL 194.3 kB
FILES/OSP/1033/FILES/WINDOWS/HELP/OSP.HLP 14.2 kB
FILES/OSP/1033/FILES/WINDOWS/HELP/PSS10.TXT 20.5 kB
FILES/OSP/1033/IE5/EN/ACTSETUP.CAB 145.0 kB
FILES/OSP/1033/IE5/EN/ADVAUTH.CAB 86.6 kB
FILES/OSP/1033/IE5/EN/AOLSUPP.CAB 169.6 kB
FILES/OSP/1033/IE5/EN/AXA.CAB 656.4 kB
FILES/OSP/1033/IE5/EN/AXA2.CAB 83.5 kB
FILES/OSP/1033/IE5/EN/AXA3.CAB 207.5 kB
FILES/OSP/1033/IE5/EN/BRANDING.CAB 7.9 kB
FILES/OSP/1033/IE5/EN/DCOM95.EXE 1.2 MB
FILES/OSP/1033/IE5/EN/DXDDEX.CAB 36.0 kB
FILES/OSP/1033/IE5/EN/DXMINI.CAB 339.3 kB
FILES/OSP/1033/IE5/EN/FONTCORE.CAB 762.2 kB

[磁力链接] 添加时间:2017-03-26 大小:729.8 MB 最近下载:2018-07-31 热度:47

Microsoft Excel.rar

Microsoft Excel.rar 307.9 MB

[磁力链接] 添加时间:2017-03-26 大小:307.9 MB 最近下载:2024-11-06 热度:112

Lynda - Excel for Mac 2011 - Charts in Depth

01. Introduction/01_01-Welcome.mp4 6.9 MB
01. Introduction/01_02-Using the exercise files.mp4 985.0 kB
02. Creating Basic Charts Quickly/02_01-Selecting data to display on a chart.mp4 12.7 MB
02. Creating Basic Charts Quickly/02_02-Creating charts with a keystroke or using ribbon icons.mp4 15.1 MB
03. Understanding Excel Chart Concepts/03_01-Identifying chart elements.mp4 9.0 MB
03. Understanding Excel Chart Concepts/03_02-Selecting the right chart type.mp4 22.3 MB
03. Understanding Excel Chart Concepts/03_03-Understanding chart terminology.mp4 13.2 MB
03. Understanding Excel Chart Concepts/03_04-Understanding the Charts Ribbon tab.mp4 5.5 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_01-Changing a charts type.mp4 8.9 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_02-Changing the location of a charts source data.mp4 8.2 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_03-Dealing with empty and hidden cells.mp4 16.6 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_04-Using Switch Plot for a different view of the data.mp4 9.9 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_05-Choosing a chart layout from the Chart Quick Layouts group.mp4 13.2 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_06-Choosing a chart style from the Chart Styles gallery of 48 variations.mp4 7.1 MB
04. Creating and Adjusting Chart Appearances with Charts Tab Choices/04_07-Saving a chart as a template for easy access later.mp4 7.7 MB
05. Using Chart Layout Tab Options/05_01-Adding, editing, and removing chart titles and axis titles.mp4 11.1 MB
05. Using Chart Layout Tab Options/05_02-Linking titles to content.mp4 5.7 MB
05. Using Chart Layout Tab Options/05_03-Adding, editing, and removing legends.mp4 11.3 MB
05. Using Chart Layout Tab Options/05_04-Adding and editing data labels.mp4 16.4 MB
05. Using Chart Layout Tab Options/05_05-Adding a data table.mp4 8.3 MB

[磁力链接] 添加时间:2017-03-26 大小:783.2 MB 最近下载:2024-05-18 热度:26

Excel 2016 - Adv. Formulas & Functions {AM}

AM.Torrents.nfo 4.9 kB
00 Introduction/431188_00_02 - Using the exercise files.mp4 1.5 MB
13 Conclusion/431188_13_01 - Next steps.mp4 2.0 MB
Exercise Files/Ex_Files_Excel2016_AdvancedFormulas.zip 2.1 MB
06 Statistical Functions/431188_06_03 - Finding the largest and smallest values with the LARGE and SMALL functions.mp4 5.0 MB
00 Introduction/431188_00_01 - Welcome.mp4 6.9 MB
04 Lookup & Reference Functions/431188_04_06 - Finding table-like information within a function using the CHOOSE function.mp4 6.9 MB
06 Statistical Functions/431188_06_01 - Finding the middle value with MEDIAN and most common value with MODE.mp4 7.5 MB
03 IF & Related Functions/431188_03_04 - Using IFS for multiple conditions.mp4 8.3 MB
04 Lookup & Reference Functions/431188_04_09 - Retrieving information by location.mp4 8.5 MB
12 Information Functions/431188_12_04 - Tracking and highlighting formula cells with the ISFORMULA function.mp4 8.7 MB
07 Math Functions/431188_07_06 - Converting a value between measurement systems with CONVERT.mp4 8.8 MB
10 Reference Functions/431188_10_02 - Returning references with the INDIRECT function.mp4 8.9 MB
07 Math Functions/431188_07_02 - Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4 9.1 MB
01 Formula & Function Tips & Shortcuts/431188_01_06 - Updating values without formulas.mp4 9.6 MB
01 Formula & Function Tips & Shortcuts/431188_01_04 - Copying column formulas instantly.mp4 9.7 MB
06 Statistical Functions/431188_06_05 - Using COUNT, COUNTA, and the status bar.mp4 9.9 MB
04 Lookup & Reference Functions/431188_04_08 - Locating data with the MATCH function.mp4 10.0 MB
11 Text Functions/431188_11_02 - Extracting specific data with the LEFT and RIGHT functions.mp4 10.0 MB
12 Information Functions/431188_12_01 - Extracting information with the CELL and INFO functions.mp4 10.9 MB

[磁力链接] 添加时间:2017-03-26 大小:1.1 GB 最近下载:2024-10-07 热度:91

Lynda - Excel Workshop_ Building a Dynamic Heat Map

017 COUNTIFS.mp4 20.1 MB
014 Accident type.mp4 18.8 MB
013 True Season.mp4 18.5 MB
023 SEASON filter.mp4 18.0 MB
010 VLOOKUP.mp4 17.3 MB
011 EOMONTH.mp4 15.8 MB
016 Heat map framework.mp4 15.8 MB
008 Categorization.mp4 15.0 MB
012 YEARFRAC.mp4 14.5 MB
022 Accident type COUNTIFS.mp4 11.1 MB
025 Formatting with ROW and COLUMN functions.mp4 9.9 MB
015 Using ISBLANK.mp4 9.9 MB
009 WEEKDAY.mp4 9.6 MB
007 DATEVALUE.mp4 9.2 MB
005 Getting familiar with the data.mp4 8.1 MB
020 Quick QA - Identifying and eliminating inaccurate data.mp4 8.1 MB
024 Using the NOW and TODAY functions.mp4 7.8 MB
021 Data validation.mp4 7.1 MB
018 Color scale formatting.mp4 7.1 MB
027 Adding the finishing touches.mp4 6.8 MB

[磁力链接] 添加时间:2017-03-26 大小:311.4 MB 最近下载:2024-12-23 热度:106

EXCEL EDU

DTLite4491-0356.exe 13.4 MB
excel tools study.nrg 5.8 GB

[磁力链接] 添加时间:2017-03-26 大小:5.8 GB 最近下载:2017-04-13 热度:5

MICROSOFT OFFICE 2010 EXCEL CRACKED version

MICROSOFT OFFICE 2010 EXCEL CRACKED version.zip 383.8 MB
MICROSOFT.nfo 76 Bytes

[磁力链接] 添加时间:2017-03-26 大小:383.8 MB 最近下载:2025-02-08 热度:54

Lynda.com Excel.2007 Advanced Formulas And Functions !h33t!

00. Introduction/00 01. Welcome.mov 11.6 MB
00. Introduction/00 02. Using the exercise files.mov 1.3 MB
01. Formula and Function Tips-Shortcuts/01 09. Creating range names to enhance readability.mov 8.0 MB
01. Formula and Function Tips-Shortcuts/01 06. Showing all formulas with a single command.mov 8.0 MB
01. Formula and Function Tips-Shortcuts/01 04. Creating 3D formulas to gather data from multiple sheets.mov 6.8 MB
01. Formula and Function Tips-Shortcuts/01 08. Simplifying debugging formulas.mov 6.5 MB
01. Formula and Function Tips-Shortcuts/01 02. Copying column formulas instantly.mov 6.0 MB
01. Formula and Function Tips-Shortcuts/01 01. Using the entire row-column references.mov 5.5 MB
01. Formula and Function Tips-Shortcuts/01 07. Highlighting formulas with two clicks.mov 5.3 MB
01. Formula and Function Tips-Shortcuts/01 03. Converting formulas to values with a simple drag.mov 5.2 MB
01. Formula and Function Tips-Shortcuts/01 05. Updating values without formulas.mov 4.0 MB
02. Excel Functions/02 01. Understanding and using basic Excel functions.mov 11.6 MB
02. Excel Functions/02 02. Using common functions SUM, AVERAGE, MAX, and MIN.mov 7.5 MB
02. Excel Functions/02 03. Using and extending AutoSum.mov 6.3 MB
03. IF and Related Functions/03 03. Using the AND, OR, and NOT functions with IF to create compound logical tests.mov 7.4 MB
03. IF and Related Functions/03 01. Exploring IF logical tests and using relational operators.mov 6.2 MB
03. IF and Related Functions/03 02. Creating and expanding the use of nested IFs.mov 5.9 MB
04. Lookup and Reference Functions/04 02. Using VLOOKUP for approximate matches.mov 9.8 MB
04. Lookup and Reference Functions/04 08. Using MATCH and INDEX together.mov 8.8 MB
04. Lookup and Reference Functions/04 01. Looking up information with VLOOKUP and HLOOKUP.mov 7.4 MB

[磁力链接] 添加时间:2017-03-26 大小:391.3 MB 最近下载:2025-10-10 热度:956

Excel 2016 Cleaning Up Your Data

Download/551486_07_01 - Next steps.en.srt 1.0 kB
Download/551486_00_01 - Welcome.en.srt 1.5 kB
Download/551486_02_04 - Remove trailing minus signs while converting data to negative.en.srt 5.5 kB
Download/551486_03_04 - Convert between time units_ Day_hour, year_day, etc.en.srt 7.9 kB
Download/551486_01_02 - Transpose row_column into column_row layouts.en.srt 7.9 kB
Download/551486_02_02 - Deal with special characters, wildcards, and REPLACE function.en.srt 8.1 kB
Download/551486_01_01 - Move and insert rows and columns of data with a simple drag.en.srt 8.2 kB
Download/551486_03_03 - Use the DATEVALUE and TIMEVALUE functions.en.srt 8.3 kB
Download/551486_03_02 - Use a Text to Column option for selected date formats.en.srt 9.7 kB
Download/551486_05_04 - Split data into columns with the Text to Columns feature.en.srt 10.2 kB
Download/551486_05_01 - Use text functions.en.srt 10.4 kB
Download/551486_01_03 - Use Sort to eliminate empty rows and columns.en.srt 10.6 kB
Download/551486_06_03 - Remove duplicate rows from a list.en.srt 11.1 kB
Download/551486_03_05 - Convert to and from Julian dates.en.srt 12.1 kB
Download/551486_02_03 - Remove leading single quotes.en.srt 12.3 kB
Download/551486_04_01 - Convert text data to values.en.srt 12.9 kB
Download/551486_06_01 - Fill in missing title information.en.srt 13.3 kB
Download/551486_03_01 - Split unusual date formats into columns.en.srt 14.7 kB
Download/551486_04_02 - Add leading zeroes_ Zip codes, other numerical codes, and text codes.en.srt 15.0 kB
Download/551486_05_02 - Use the CONCAT and TEXTJOIN functions to combine data.en.srt 17.4 kB

[磁力链接] 添加时间:2017-03-27 大小:458.5 MB 最近下载:2025-06-06 热度:920