zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
(2015-2021) Excel Tips Weekly (Updated 09.02.2021)
magnet:?xt=urn:btih:1e173b857dda2393edd309e59f63ec0bc51b20d9&dn=(2015-2021) Excel Tips Weekly (Updated 09.02.2021)
磁力链接详情
文件列表详情
1e173b857dda2393edd309e59f63ec0bc51b20d9
infohash:
295
文件数量
6 GB
文件大小
2021-3-8 07:19
创建日期
2024-11-14 03:32
最后访问
相关分词
2015-2021
Excel
Tips
Weekly
Updated
09
02
2021
001 - Hide and unhide worksheets securely.mp4 17.01 MB
002 - Resizing, moving, copying, and manipulating charts and other objects.mp4 27.85 MB
003 - Using list boxes and combo boxes to facilitate forms creation.mp4 21.48 MB
004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 16.4 MB
005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 23.75 MB
006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 29.4 MB
007 - Using check boxes and conditional formatting together for dynamic displays.mp4 40.45 MB
008 - Becoming more productive with these 10 tiny tips you'll use often.mp4 24.1 MB
009 - Transposing data and charts for a different perspective on your data.mp4 30.3 MB
010 - Applying conditional formatting across rows of data.mp4 20.45 MB
011 - Exploring various layouts for your PivotTable.mp4 13.86 MB
012 - Splitting and consolidating workbooks.mp4 20.53 MB
013 - Using date and time as metrics in a PivotTable.mp4 23.2 MB
014 - Adding illustrations to your workbook.mp4 33.62 MB
015 - Using a pick list, VLOOKUP, table, and chart together.mp4 22.57 MB
016 - Using formulas to calculate values across worksheets and workbooks.mp4 29.52 MB
017 - Dynamically presenting data via chart slicers.mp4 20.42 MB
018 - Parsing your data to create unique lists.mp4 14.51 MB
019 - Using the REPT function to represent data visually.mp4 8.82 MB
020 - Using source data from a table to make your PivotTable more dynamic.mp4 24.96 MB
021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4 23.25 MB
022 - Increasing your productivity with custom lists.mp4 20.89 MB
023 - Highlighting PivotTable results with conditional formatting.mp4 19.23 MB
024 - Customizing templates to fit your unique needs.mp4 20.37 MB
025 - Creating dynamic charts with in-cell conditional formatting.mp4 11.49 MB
026 - Enhancing table filtering with slicers.mp4 20.19 MB
027 - Converting charts into pictures.mp4 15.93 MB
028 - Custom grouping in PivotTables.mp4 12.99 MB
029 - Quick formatting tips.mp4 23.4 MB
030 - The top five unknown but useful keyboard shortcuts.mp4 25.61 MB
031 - Using the TREND and GROWTH functions for projecting future results.mp4 21.61 MB
032 - Using scroll bars and spin buttons to facilitate forms creation.mp4 23.56 MB
033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 21.88 MB
034 - Calculating with hours, minutes, and times of day.mp4 29.66 MB
035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4 21.74 MB
036 - Discovering time-saving tools in the Go To Special feature.mp4 40.04 MB
037 - Adding, managing, and printing comments for worksheet documentation.mp4 19.26 MB
038 - Reducing data entry time by expanding AutoCorrect options.mp4 18.99 MB
039 - Setting up custom views for quick access to different worksheet displays.mp4 25.08 MB
040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 21.15 MB
041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 24.18 MB
042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 19.93 MB
043 - Exploring what-if scenarios using Goal Seek.mp4 28.04 MB
044 - Creating text, numerical, date, and time lists in a flash.mp4 17.89 MB
045 - Creating variable conditional formatting rules.mp4 30.8 MB
046 - Handling dates with unusual formats.mp4 20.25 MB
047 - Using wildcards (asterisk, tilde, and question mark).mp4 38.13 MB
048 - Custom formats using asterisk, semicolon, and brackets.mp4 39.18 MB
049 - Meeting unusual filtering needs via Advanced Filter.mp4 47.68 MB
050 - Create an organization chart.mp4 23.64 MB
051 - Two-way lookup using the MATCH and INDEX functions.mp4 50.68 MB
052 - Using Excel error-checking functions.mp4 33.63 MB
053 - Custom formats, relative addressing, and conditional formatting.mp4 23.95 MB
054 - Auditing.mp4 30.66 MB
055 - Adding comments and shapes.mp4 25.43 MB
056 - Drawing borders and border grids.mp4 21.36 MB
057 - Building a flexible monthly table using functions.mp4 32.81 MB
058 - Adding pictures as worksheet backgrounds.mp4 20.05 MB
059 - ADDRESS, ROW, and COLUMN functions.mp4 27.67 MB
060 - Join data with new CONCAT and TEXTJOIN functions.mp4 17.57 MB
061 - Working with formulas in tables.mp4 48.15 MB
062 - Locating data validation rules and violations.mp4 28.54 MB
063 - Creating an Excel template.mp4 23.18 MB
064 - Restoring missing column titles.mp4 26.37 MB
065 - Creating a pick list dependent on another pick list.mp4 18.84 MB
066 - Using command shortcuts with the Alt key.mp4 20.2 MB
067 - Set up a macro for sorting dynamic data.mp4 28.18 MB
068 - Use random number functions for sorting and creating sample data.mp4 28.83 MB
069 - Use calcuated fields and calculated items in a PivotTable.mp4 26.32 MB
070 - Replace characters by position with the REPLACE function.mp4 15.57 MB
071 - Work with formulas in tables.mp4 30.04 MB
072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 55.03 MB
073 - Use special tricks for working with dates in charts.mp4 33.2 MB
074 - Use a data form for data entry and exploring data.mp4 24.91 MB
075 - Creating an Excel template to simplify updating a monthly file.mp4 19.66 MB
076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4 22.16 MB
077 - Create dynamic sheet name references with the INDIRECT function.mp4 19.17 MB
078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4 20.84 MB
079 - Hide worksheets, row, columns, cells and other Excel elements.mp4 27.8 MB
080 - Use slicers and charts together for dynamic presentations.mp4 29.07 MB
081 - Save a chart as a template Use the template for current or new charts.mp4 18.4 MB
082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4 22.7 MB
083 - Adjust a chart's source data and adjust its series order.mp4 25.94 MB
084 - Use the OFFSET function for tabulating moving data.mp4 30.82 MB
085 - Alter numeric data without formulas.mp4 37.41 MB
086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 34.31 MB
087 - Adjust banded-row formatting.mp4 57.78 MB
088 - Change the shape of comment boxes and other objects.mp4 19.25 MB
089 - How and when to use the 10 rounding functions in Excel.mp4 35.35 MB
090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4 18.91 MB
091 - How to use mixed cell references.mp4 23.41 MB
092 - Activate the Speak On Enter and Speak Cells features.mp4 14.71 MB
093 - Accelerate data entry with five special techniques.mp4 31.52 MB
094 - Insert a text box or shape and link a cell's content to it.mp4 16.99 MB
095 - Use Watch Window and other techniques to track changing cells.mp4 29.69 MB
096 - How to create time interval entrie.mp4 32.38 MB
097 - How to create frequency tabulations and distributions.mp4 24.93 MB
098 - Create an expanded list from a summary using PivotTable techniques.mp4 36.74 MB
099 - Solve matching issues with matching phone numbers and SS numbers.mp4 35.66 MB
100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4 16.52 MB
101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 35.93 MB
102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 30.07 MB
103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 29.79 MB
104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 29.86 MB
105 - Formula nesting - Using multiple functions in the same formula.mp4 38.99 MB
106 - Keyboard shortcuts for numeric formats.mp4 25.85 MB
107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 41.35 MB
108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4 24.59 MB
109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4 24.29 MB
110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 29.82 MB
111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4 29.38 MB
112 - Working with hidden data when copying cells and creating charts.mp4 40.93 MB
113 - Use conditional formatting data bars to accentuate negative data.mp4 11.45 MB
114 - Creative use of sparklines in merged cells with axes.mp4 19.03 MB
115 - Copy formats quickly using dragging techniques and the Format Painter.mp4 17.39 MB
116 - Displaying multiple worksheets and workbooks together.mp4 32.4 MB
117 - Tips for creating and updating sample data.mp4 31.62 MB
118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4 24.14 MB
119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 29.89 MB
120 - Summarize data from different worksheets with a PivotTable.mp4 23.43 MB
121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4 20.22 MB
122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4 24.27 MB
123 - Use custom formulas in data validation to keep out bad data.mp4 35.01 MB
124 - Dealing with circular errors.mp4 22.37 MB
125 - Tips for creating charts quickly.mp4 19.24 MB
126 - Creating heat maps using conditional formatting.mp4 34.91 MB
127 - Using the INDEX function to extract data by row and column.mp4 28.38 MB
128 - Displaying tips when using Excel in presentations.mp4 29.65 MB
129 - The Wrap Text, Merge and Center, and Indent options.mp4 30.35 MB
130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4 17.05 MB
131 - Working with multiple worksheets simultaneously.mp4 25.99 MB
132 - Exploring font choices not found on the Home tab.mp4 11.68 MB
133 - Using WordArt for special titles and headings.mp4 14.54 MB
134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4 22.8 MB
135 - Borders and gridlines - Exploring variations, options, and differences.mp4 25.12 MB
136 - New Excel 2016 chart types Tree map and sunburst.mp4 30.13 MB
137 - Freezing column and row titles.mp4 41.85 MB
138 - Use data validation to force entries to be uppercase or lowercase.mp4 25.51 MB
139 - Avoiding common chart distortions.mp4 32.73 MB
140 - Use the new funnel chart available in Excel 365.mp4 10.63 MB
141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4 15.23 MB
142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4 28.07 MB
143 - Creating cross-totals with the SUMIFS function and mixed references.mp4 17.62 MB
144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4 28.03 MB
145 - Using the AND and OR functions independently or within IF functions.mp4 27.92 MB
146 - Vertical and horizontal alignment settings and orientation options.mp4 18.54 MB
147 - Sorting tips and shortcuts.mp4 32.43 MB
148 - A look at new chart types in Excel 2016 - Waterfall.mp4 17.99 MB
149 - Work with formulas and formats Decimals and fractions.mp4 13.53 MB
150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4 27.89 MB
151 - Control gridlines in charts and on worksheets.mp4 21.68 MB
152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4 20.16 MB
153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4 21.95 MB
154 - Control phone number and postal code formats using built-in options or customized formats.mp4 18.7 MB
155 - Change the default Excel chart type; create and use chart templates.mp4 19.14 MB
156 - Create your own customized date and time formats.mp4 22.5 MB
157 - Create on-screen warnings and reminders with comments or data validation messages.mp4 18.79 MB
158 - Use REPLACE for formats only, for data only, or for both.mp4 22.46 MB
159 - Create numeric formats - Display in thousands or millions.mp4 35.8 MB
160 - Converting dates like 20102006 into usable date entries.mp4 11.98 MB
161 - Create custom lists for letter series like A to Z.mp4 28.74 MB
162 - Freeze Panes and Split.mp4 30.26 MB
163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4 14.74 MB
164 - Calculate % of change.mp4 14 MB
165 - Fill in all blank cells within a range with either formatting or data.mp4 16.56 MB
166 - Use the COUNT and COUNTA functions.mp4 13.93 MB
167 - Use workbook protection to prevent use of sheet commands.mp4 18 MB
168 - Rank data with the RANK and RANK.AVG functions.mp4 16.11 MB
169 - Use nonstandard fiscal years and quarters in PivotTables.mp4 18.83 MB
170 - Identify or extract unique entries in a list.mp4 22.68 MB
171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4 27.06 MB
172 - Create artistic charts with random numbers.mp4 22.72 MB
173 - Extract day, month, and year from date fields.mp4 13.15 MB
174 - Compare data with EXACT, FIND, and SEARCH functions.mp4 13.17 MB
175 - How to covert ROMAN numberals.mp4 13.25 MB
176 - Use range names for more readable formulas.mp4 15.5 MB
177 - Customize your Quick Access Toolbar.mp4 20.33 MB
178 - Conditional formatting based on date proximity.mp4 13.75 MB
179 - How to adjust names.mp4 16.21 MB
180 - Differences and limitations of converting data to a table.mp4 18.78 MB
181 - Avoid the #DIV0 error message.mp4 13.76 MB
182 - Explore formatting options not available on the Home tab.mp4 15.55 MB
183 - Control table formatting with custom formats.mp4 12.2 MB
184 - Use date functions for age and tenure calculations.mp4 16.43 MB
185 - Avoid unintentional entries when typing code numbers.mp4 9.52 MB
186 - Sorting by moving columns.mp4 15.31 MB
187 - Calculating cumulative totals.mp4 11.22 MB
188 - Using the CONVERT function for different numbering systems.mp4 12.85 MB
189 - Creating an automatically expanding chart by basing it on a table.mp4 11.3 MB
190 - Keystroke shortcuts using the Alt key.mp4 14.71 MB
191 - Using the Solver Add-in.mp4 11.75 MB
192 - Column widths, row heights, merging cells, and related formatting issues.mp4 10.97 MB
193 - Adjusting default layouts and date grouping in PivotTables.mp4 11.42 MB
194 - Auditing cell content with Watch Window and dependent cell formulas.mp4 9.94 MB
195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4 10.58 MB
196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4 11.98 MB
197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4 12.71 MB
198 - Helpful keystroke shortcuts.mp4 21.27 MB
199 - Identify weekdays and weekend days in data.mp4 11.98 MB
200 - Use chart and filter for presentations.mp4 9.52 MB
201 - Create picture links.mp4 19.23 MB
202 - How to use the error-checking rules in Excel.mp4 13.63 MB
203 - Protect worksheets and lock cells.mp4 17.24 MB
204 - Use mixed addresses in Excel formulas.mp4 12.68 MB
205 - Rapid filtering with Filter by Selection.mp4 12.68 MB
206 - Display large values.mp4 17.27 MB
207 - Tracking down conditional formatting and data validation rules.mp4 18.94 MB
208 - Transposing data and using the TRANSPOSE function.mp4 13.41 MB
209 - Displaying gridlines, borders, and column_row headings when printing.mp4 13.46 MB
210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9.03 MB
211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 11.87 MB
212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 12.95 MB
213 - Tabulating totals with the VLOOKUP function and array constants.mp4 13.51 MB
214 - Working with array formulas more easily.mp4 11.05 MB
215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10.23 MB
216 - Creating and updating sample data.mp4 15.74 MB
217 - Format macros to make you a more efficient Excel user.mp4 14.5 MB
218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 17.7 MB
219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11.3 MB
220 - Calculate loan payments and investments with PMT and FV functions.mp4 12.35 MB
221 - Use the XLOOKUP function to replace VLOOKUP.mp4 14.96 MB
222 - Chart display options with blank cells in source data.mp4 10.13 MB
223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12.08 MB
224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 13.68 MB
225 - Sort or filter data based on color font or cell color background.mp4 23.75 MB
226 - Simplify the use of special characters and symbols.mp4 11.49 MB
227 - Select from over 800 icons to enliven worksheets.mp4 16.46 MB
228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 15.76 MB
229 - How and when to use an area chart.mp4 11.11 MB
230 - Insert colorful images with the People Graph Add-in.mp4 14.87 MB
231 - Use formulas to create interactive charts.mp4 11.25 MB
232 - Track variables using the Scenario Manager.mp4 16.33 MB
233 - Get totals quickly without creating formulas.mp4 16.76 MB
234 - Use column or row references to create dynamic formulas.mp4 13.23 MB
235 - Overcoming obstacles when working with dates in charts.mp4 12.15 MB
236 - Create map-type charts based on geographical locations.mp4 9.49 MB
237 - Techniques for creating date series.mp4 10.81 MB
238 - Extract filtered data with data validation and the FILTER function.mp4 13.97 MB
239 - Use Find and Replace to change cell contents and formats.mp4 21.75 MB
240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 16.51 MB
241 - Change PivotTable settings for titles and summaries.mp4 16.75 MB
242 - Use the Excel filtering capability for dates.mp4 13.11 MB
243 - Use worksheet names in formulas.mp4 11.93 MB
244 - Use data validation rules with special phone and social security formats.mp4 12.94 MB
245 - Work with time calculations in formulas.mp4 11.43 MB
246 - Prevent and locate duplicate worksheet entries.mp4 13.8 MB
247 - Look forward and backward using EDATE and other date functions.mp4 15.84 MB
248 - Display and highlight worksheet formula cells.mp4 15.23 MB
249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13.17 MB
250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 12.72 MB
251 - Use the XMATCH function to replace MATCH.mp4 9.47 MB
252 - Create a powerful macro.mp4 13.8 MB
253 - Work with hidden and visible data in filtered and subtotaled lists.mp4 21.59 MB
254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4 15.99 MB
255 - Use data validation rules to prevent duplicate entries in a range.mp4 16 MB
256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4 18.09 MB
257 - Align, arrange, and rotate shapes in worksheets.mp4 17.31 MB
258 - File documentation with the Workbook Statistics button.mp4 11.33 MB
259 - Avoid misleading visuals when rescaling.mp4 13.63 MB
260 - Use the Fill Justify feature to wrap long text.mp4 10.18 MB
261 - Create range names from Column and Row headings.mp4 12.14 MB
262 - Use the SUBSTITUTE and REPLACE functions.mp4 14.28 MB
263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4 13.7 MB
264 - Use wildcard symbols in functions.mp4 17.98 MB
265 - Use wildcard symbols in filtering and commands.mp4 20.6 MB
266 - Condense lengthy nested IF functions with the newer IFS function.mp4 11.21 MB
267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4 14.54 MB
268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4 15.31 MB
269 - Retrieve vital data based on location using the Geography tool.mp4 11.44 MB
270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4 10.87 MB
271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4 14.22 MB
272 - Create a list box to facilitate selection of data from a list.mp4 14.72 MB
273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4 14.73 MB
274 - Enhance readability with banded rows via conditional formatting.mp4 18.76 MB
275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4 16.74 MB
276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4 13.43 MB
277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4 10.61 MB
278 - Analyze PivotTable data with 13 different Show Values As options.mp4 21.79 MB
279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4 22.22 MB
280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4 21.4 MB
281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4 17.9 MB
282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4 13.73 MB
283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.mp4 20.94 MB
284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.mp4 15.42 MB
285 - Using the LET function to simplify formulas via programming concepts.mp4 17.3 MB
286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.mp4 14.37 MB
287 - Create moving averages with formulas and chart trendlines.mp4 17.39 MB
288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.mp4 19.93 MB
289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.mp4 14.44 MB
290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.mp4 19.68 MB
291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.mp4 17.56 MB
292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.mp4 24.25 MB
293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.mp4 17.91 MB
294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.mp4 21.08 MB
295 - Where does that cell get its data from - Tracking down cell precedents.mp4 16.2 MB
其他位置