(2015-2022) Excel Tips Weekly (Updated 10.05.2022)
File List
- 087 - Adjust banded-row formatting.mp4 57.8 MB
- 072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 55.0 MB
- 051 - Two-way lookup using the MATCH and INDEX functions.mp4 50.7 MB
- 061 - Working with formulas in tables.mp4 48.1 MB
- 049 - Meeting unusual filtering needs via Advanced Filter.mp4 47.7 MB
- 137 - Freezing column and row titles.mp4 41.8 MB
- 107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 41.4 MB
- 112 - Working with hidden data when copying cells and creating charts.mp4 40.9 MB
- 007 - Using check boxes and conditional formatting together for dynamic displays.mp4 40.5 MB
- 036 - Discovering time-saving tools in the Go To Special feature.mp4 40.0 MB
- 048 - Custom formats using asterisk, semicolon, and brackets.mp4 39.2 MB
- 105 - Formula nesting - Using multiple functions in the same formula.mp4 39.0 MB
- 047 - Using wildcards (asterisk, tilde, and question mark).mp4 38.1 MB
- 085 - Alter numeric data without formulas.mp4 37.4 MB
- 098 - Create an expanded list from a summary using PivotTable techniques.mp4 36.7 MB
- 101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 35.9 MB
- 159 - Create numeric formats - Display in thousands or millions.mp4 35.8 MB
- 099 - Solve matching issues with matching phone numbers and SS numbers.mp4 35.7 MB
- 089 - How and when to use the 10 rounding functions in Excel.mp4 35.3 MB
- 123 - Use custom formulas in data validation to keep out bad data.mp4 35.0 MB
- 126 - Creating heat maps using conditional formatting.mp4 34.9 MB
- 086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 34.3 MB
- 052 - Using Excel error-checking functions.mp4 33.6 MB
- 014 - Adding illustrations to your workbook.mp4 33.6 MB
- 073 - Use special tricks for working with dates in charts.mp4 33.2 MB
- 057 - Building a flexible monthly table using functions.mp4 32.8 MB
- 139 - Avoiding common chart distortions.mp4 32.7 MB
- 147 - Sorting tips and shortcuts.mp4 32.4 MB
- 116 - Displaying multiple worksheets and workbooks together.mp4 32.4 MB
- 096 - How to create time interval entrie.mp4 32.4 MB
- 117 - Tips for creating and updating sample data.mp4 31.6 MB
- 093 - Accelerate data entry with five special techniques.mp4 31.5 MB
- 084 - Use the OFFSET function for tabulating moving data.mp4 30.8 MB
- 045 - Creating variable conditional formatting rules.mp4 30.8 MB
- 054 - Auditing.mp4 30.7 MB
- 129 - The Wrap Text, Merge and Center, and Indent options.mp4 30.4 MB
- 308 - Quick number formatting with keystroke shortcuts and icon buttons.mp4 30.3 MB
- 009 - Transposing data and charts for a different perspective on your data.mp4 30.3 MB
- 162 - Freeze Panes and Split.mp4 30.3 MB
- 136 - New Excel 2016 chart types Tree map and sunburst.mp4 30.1 MB
- 102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 30.1 MB
- 071 - Work with formulas in tables.mp4 30.0 MB
- 119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 29.9 MB
- 104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 29.9 MB
- 110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 29.8 MB
- 103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 29.8 MB
- 095 - Use Watch Window and other techniques to track changing cells.mp4 29.7 MB
- 034 - Calculating with hours, minutes, and times of day.mp4 29.7 MB
- 128 - Displaying tips when using Excel in presentations.mp4 29.6 MB
- 016 - Using formulas to calculate values across worksheets and workbooks.mp4 29.5 MB
- 006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 29.4 MB
- 111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4 29.4 MB
- 080 - Use slicers and charts together for dynamic presentations.mp4 29.1 MB
- 330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.mp4 29.0 MB
- 068 - Use random number functions for sorting and creating sample data.mp4 28.8 MB
- 161 - Create custom lists for letter series like A to Z.mp4 28.7 MB
- 062 - Locating data validation rules and violations.mp4 28.5 MB
- 312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.mp4 28.4 MB
- 127 - Using the INDEX function to extract data by row and column.mp4 28.4 MB
- 067 - Set up a macro for sorting dynamic data.mp4 28.2 MB
- 142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4 28.1 MB
- 043 - Exploring what-if scenarios using Goal Seek.mp4 28.0 MB
- 144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4 28.0 MB
- 311 - Using slicers as analytical tools.mp4 27.9 MB
- 145 - Using the AND and OR functions independently or within IF functions.mp4 27.9 MB
- 150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4 27.9 MB
- 002 - Resizing, moving, copying, and manipulating charts and other objects.mp4 27.8 MB
- 079 - Hide worksheets, row, columns, cells and other Excel elements.mp4 27.8 MB
- 059 - ADDRESS, ROW, and COLUMN functions.mp4 27.7 MB
- 322 - Sort your data based on a Custom List that you define.mp4 27.1 MB
- 171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4 27.1 MB
- 064 - Restoring missing column titles.mp4 26.4 MB
- 069 - Use calcuated fields and calculated items in a PivotTable.mp4 26.3 MB
- 355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.mp4 26.2 MB
- 131 - Working with multiple worksheets simultaneously.mp4 26.0 MB
- 083 - Adjust a chart's source data and adjust its series order.mp4 25.9 MB
- 106 - Keyboard shortcuts for numeric formats.mp4 25.9 MB
- 030 - The top five unknown but useful keyboard shortcuts.mp4 25.6 MB
- 138 - Use data validation to force entries to be uppercase or lowercase.mp4 25.5 MB
- 055 - Adding comments and shapes.mp4 25.4 MB
- 135 - Borders and gridlines - Exploring variations, options, and differences.mp4 25.1 MB
- 039 - Setting up custom views for quick access to different worksheet displays.mp4 25.1 MB
- 020 - Using source data from a table to make your PivotTable more dynamic.mp4 25.0 MB
- 301 - Refine filtering needs via custom filter options.mp4 25.0 MB
- 097 - How to create frequency tabulations and distributions.mp4 24.9 MB
- 074 - Use a data form for data entry and exploring data.mp4 24.9 MB
- 314 - Contrasting uses of clustered column and stacked column charts.mp4 24.6 MB
- 108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4 24.6 MB
- 313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.mp4 24.4 MB
- 109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4 24.3 MB
- 122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4 24.3 MB
- 292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.mp4 24.3 MB
- 041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 24.2 MB
- 118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4 24.1 MB
- 008 - Becoming more productive with these 10 tiny tips you'll use often.mp4 24.1 MB
- 053 - Custom formats, relative addressing, and conditional formatting.mp4 23.9 MB
- 305 - Tips for saving time when typing function names.mp4 23.9 MB
- 005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 23.8 MB
- 225 - Sort or filter data based on color font or cell color background.mp4 23.8 MB
- 050 - Create an organization chart.mp4 23.6 MB
- 032 - Using scroll bars and spin buttons to facilitate forms creation.mp4 23.6 MB
- 328 - Using new formula-writing techniques to simplify wide-ranging formulas.mp4 23.5 MB
- 335 - Exploring Excel's Sunburst chart to display hierarchical data.mp4 23.5 MB
- 120 - Summarize data from different worksheets with a PivotTable.mp4 23.4 MB
- 091 - How to use mixed cell references.mp4 23.4 MB
- 029 - Quick formatting tips.mp4 23.4 MB
- 340 - Exploring treemap charts to display hierarchical data.mp4 23.4 MB
- 297 - Remove duplicates from a list vs. creating a new list without duplicates.mp4 23.3 MB
- 021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4 23.2 MB
- 013 - Using date and time as metrics in a PivotTable.mp4 23.2 MB
- 063 - Creating an Excel template.mp4 23.2 MB
- 134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4 22.8 MB
- 172 - Create artistic charts with random numbers.mp4 22.7 MB
- 082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4 22.7 MB
- 170 - Identify or extract unique entries in a list.mp4 22.7 MB
- 015 - Using a pick list, VLOOKUP, table, and chart together.mp4 22.6 MB
- 156 - Create your own customized date and time formats.mp4 22.5 MB
- 158 - Use REPLACE for formats only, for data only, or for both.mp4 22.5 MB
- 124 - Dealing with circular errors.mp4 22.4 MB
- 279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4 22.2 MB
- 331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.mp4 22.2 MB
- 076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4 22.2 MB
- 153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4 22.0 MB
- 299 - Use the FILTER and UNIQUE functions together for dynamic extractions.mp4 21.9 MB
- 033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 21.9 MB
- 278 - Analyze PivotTable data with 13 different Show Values As options.mp4 21.8 MB
- 310 - Using wildcards in the new XLOOKUP and XMATCH functions.mp4 21.8 MB
- 239 - Use Find and Replace to change cell contents and formats.mp4 21.7 MB
- 351 - Use the Advanced Filter for specialized filtering needs.mp4 21.7 MB
- 035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4 21.7 MB
- 151 - Control gridlines in charts and on worksheets.mp4 21.7 MB
- 332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.mp4 21.7 MB
- 031 - Using the TREND and GROWTH functions for projecting future results.mp4 21.6 MB
- 253 - Work with hidden and visible data in filtered and subtotaled lists.mp4 21.6 MB
- 003 - Using list boxes and combo boxes to facilitate forms creation.mp4 21.5 MB
- 280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4 21.4 MB
- 056 - Drawing borders and border grids.mp4 21.4 MB
- 347 - Use the Go To Special option to select and populate blank cells.mp4 21.3 MB
- 302 - Comparing column charts and bar charts Pros and cons.mp4 21.3 MB
- 198 - Helpful keystroke shortcuts.mp4 21.3 MB
- 317 - Using TRIM, CLEAN and other functions to clean up text data.mp4 21.3 MB
- 040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 21.2 MB
- 294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.mp4 21.1 MB
- 283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.mp4 20.9 MB
- 022 - Increasing your productivity with custom lists.mp4 20.9 MB
- 078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4 20.8 MB
- 265 - Use wildcard symbols in filtering and commands.mp4 20.6 MB
- 012 - Splitting and consolidating workbooks.mp4 20.5 MB
- 010 - Applying conditional formatting across rows of data.mp4 20.5 MB
- 017 - Dynamically presenting data via chart slicers.mp4 20.4 MB
- 024 - Customizing templates to fit your unique needs.mp4 20.4 MB
- 177 - Customize your Quick Access Toolbar.mp4 20.3 MB
- 046 - Handling dates with unusual formats.mp4 20.2 MB
- 121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4 20.2 MB
- 348 - Accentuate values with conditional formatting and sparklines.mp4 20.2 MB
- 066 - Using command shortcuts with the Alt key.mp4 20.2 MB
- 026 - Enhancing table filtering with slicers.mp4 20.2 MB
- 152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4 20.2 MB
- 353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.mp4 20.1 MB
- 325 - Use dragging techniques for faster Paste Special options.mp4 20.1 MB
- 058 - Adding pictures as worksheet backgrounds.mp4 20.0 MB
- 288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.mp4 19.9 MB
- 042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 19.9 MB
- 290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.mp4 19.7 MB
- 350 - Use emojis and other symbols in formulas and charts.mp4 19.7 MB
- 075 - Creating an Excel template to simplify updating a monthly file.mp4 19.7 MB
- 037 - Adding, managing, and printing comments for worksheet documentation.mp4 19.3 MB
- 088 - Change the shape of comment boxes and other objects.mp4 19.2 MB
- 125 - Tips for creating charts quickly.mp4 19.2 MB
- 306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.mp4 19.2 MB
- 201 - Create picture links.mp4 19.2 MB
- 023 - Highlighting PivotTable results with conditional formatting.mp4 19.2 MB
- 077 - Create dynamic sheet name references with the INDIRECT function.mp4 19.2 MB
- 155 - Change the default Excel chart type; create and use chart templates.mp4 19.1 MB
- 114 - Creative use of sparklines in merged cells with axes.mp4 19.0 MB
- 038 - Reducing data entry time by expanding AutoCorrect options.mp4 19.0 MB
- 337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.mp4 18.9 MB
- 207 - Tracking down conditional formatting and data validation rules.mp4 18.9 MB
- 090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4 18.9 MB
- 344 - Unhide multiple worksheets at once and use the very hidden option.mp4 18.8 MB
- 065 - Creating a pick list dependent on another pick list.mp4 18.8 MB
- 169 - Use nonstandard fiscal years and quarters in PivotTables.mp4 18.8 MB
- 315 - Use the XLOOKUP function with multiple column criteria and multiple column results.mp4 18.8 MB
- 157 - Create on-screen warnings and reminders with comments or data validation messages.mp4 18.8 MB
- 180 - Differences and limitations of converting data to a table.mp4 18.8 MB
- 274 - Enhance readability with banded rows via conditional formatting.mp4 18.8 MB
- 154 - Control phone number and postal code formats using built-in options or customized formats.mp4 18.7 MB
- 334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.mp4 18.6 MB
- 146 - Vertical and horizontal alignment settings and orientation options.mp4 18.5 MB
- 081 - Save a chart as a template Use the template for current or new charts.mp4 18.4 MB
- 333 - Using the Distinct vs. Unique options when using the UNIQUE function.mp4 18.3 MB
- 256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4 18.1 MB
- 167 - Use workbook protection to prevent use of sheet commands.mp4 18.0 MB
- 148 - A look at new chart types in Excel 2016 - Waterfall.mp4 18.0 MB
- 264 - Use wildcard symbols in functions.mp4 18.0 MB
- 293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.mp4 17.9 MB
- 342 - Create a number series with the Ctrl key and left-right mouse button.mp4 17.9 MB
- 281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4 17.9 MB
- 044 - Creating text, numerical, date, and time lists in a flash.mp4 17.9 MB
- 218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 17.7 MB
- 143 - Creating cross-totals with the SUMIFS function and mixed references.mp4 17.6 MB
- 060 - Join data with new CONCAT and TEXTJOIN functions.mp4 17.6 MB
- 291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.mp4 17.6 MB
- 300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.mp4 17.5 MB
- 318 - Create multiple range names from the top row and-or left column.mp4 17.4 MB
- 115 - Copy formats quickly using dragging techniques and the Format Painter.mp4 17.4 MB
- 287 - Create moving averages with formulas and chart trendlines.mp4 17.4 MB
- 257 - Align, arrange, and rotate shapes in worksheets.mp4 17.3 MB
- 285 - Using the LET function to simplify formulas via programming concepts.mp4 17.3 MB
- 206 - Display large values.mp4 17.3 MB
- 203 - Protect worksheets and lock cells.mp4 17.2 MB
- 329 - Calculate time differences within days and across multiple days.mp4 17.1 MB
- 130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4 17.1 MB
- 001 - Hide and unhide worksheets securely.mp4 17.0 MB
- 094 - Insert a text box or shape and link a cell's content to it.mp4 17.0 MB
- 303 - How to use exponentiation (powers and roots) in Excel formulas.mp4 17.0 MB
- 233 - Get totals quickly without creating formulas.mp4 16.8 MB
- 241 - Change PivotTable settings for titles and summaries.mp4 16.8 MB
- 275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4 16.7 MB
- 326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.mp4 16.7 MB
- 327 - Five indispensable keystroke shortcuts for Windows and Mac users.mp4 16.6 MB
- 165 - Fill in all blank cells within a range with either formatting or data.mp4 16.6 MB
- 100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4 16.5 MB
- 240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 16.5 MB
- 354 - Exploring Edit Default Layout options when using PivotTables.mp4 16.5 MB
- 227 - Select from over 800 icons to enliven worksheets.mp4 16.5 MB
- 184 - Use date functions for age and tenure calculations.mp4 16.4 MB
- 004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 16.4 MB
- 352 - Combo charts Combine different chart types to present data more clearly.mp4 16.4 MB
- 232 - Track variables using the Scenario Manager.mp4 16.3 MB
- 179 - How to adjust names.mp4 16.2 MB
- 295 - Where does that cell get its data from - Tracking down cell precedents.mp4 16.2 MB
- 168 - Rank data with the RANK and RANK.AVG functions.mp4 16.1 MB
- 349 - Transpose data with formula substitution and the TRANSPOSE function.mp4 16.0 MB
- 255 - Use data validation rules to prevent duplicate entries in a range.mp4 16.0 MB
- 254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4 16.0 MB
- 027 - Converting charts into pictures.mp4 15.9 MB
- 247 - Look forward and backward using EDATE and other date functions.mp4 15.8 MB
- 298 - New data types Extract valuable online data into your worksheets.mp4 15.8 MB
- 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 15.8 MB
- 216 - Creating and updating sample data.mp4 15.7 MB
- 320 - Use the LAMBDA function to create worksheet functions.mp4 15.6 MB
- 070 - Replace characters by position with the REPLACE function.mp4 15.6 MB
- 182 - Explore formatting options not available on the Home tab.mp4 15.5 MB
- 176 - Use range names for more readable formulas.mp4 15.5 MB
- 284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.mp4 15.4 MB
- 321 - Get the formula results you want using Goal Seek.mp4 15.4 MB
- 186 - Sorting by moving columns.mp4 15.3 MB
- 268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4 15.3 MB
- 307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.mp4 15.2 MB
- 141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4 15.2 MB
- 248 - Display and highlight worksheet formula cells.mp4 15.2 MB
- 221 - Use the XLOOKUP function to replace VLOOKUP.mp4 15.0 MB
- 230 - Insert colorful images with the People Graph Add-in.mp4 14.9 MB
- 163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4 14.7 MB
- 273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4 14.7 MB
- 272 - Create a list box to facilitate selection of data from a list.mp4 14.7 MB
- 092 - Activate the Speak On Enter and Speak Cells features.mp4 14.7 MB
- 190 - Keystroke shortcuts using the Alt key.mp4 14.7 MB
- 133 - Using WordArt for special titles and headings.mp4 14.5 MB
- 267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4 14.5 MB
- 018 - Parsing your data to create unique lists.mp4 14.5 MB
- 217 - Format macros to make you a more efficient Excel user.mp4 14.5 MB
- 343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.mp4 14.4 MB
- 289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.mp4 14.4 MB
- 286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.mp4 14.4 MB
- 262 - Use the SUBSTITUTE and REPLACE functions.mp4 14.3 MB
- 271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4 14.2 MB
- 164 - Calculate % of change.mp4 14.0 MB
- 238 - Extract filtered data with data validation and the FILTER function.mp4 14.0 MB
- 166 - Use the COUNT and COUNTA functions.mp4 13.9 MB
- 011 - Exploring various layouts for your PivotTable.mp4 13.9 MB
- 252 - Create a powerful macro.mp4 13.8 MB
- 246 - Prevent and locate duplicate worksheet entries.mp4 13.8 MB
- 181 - Avoid the #DIV0 error message.mp4 13.8 MB
- 178 - Conditional formatting based on date proximity.mp4 13.7 MB
- 282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4 13.7 MB
- 263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4 13.7 MB
- 224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 13.7 MB
- 259 - Avoid misleading visuals when rescaling.mp4 13.6 MB
- 202 - How to use the error-checking rules in Excel.mp4 13.6 MB
- 149 - Work with formulas and formats Decimals and fractions.mp4 13.5 MB
- 213 - Tabulating totals with the VLOOKUP function and array constants.mp4 13.5 MB
- 209 - Displaying gridlines, borders, and column_row headings when printing.mp4 13.5 MB
- 276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4 13.4 MB
- 208 - Transposing data and using the TRANSPOSE function.mp4 13.4 MB
- 338 - Use Data Validation based on multiple criteria.mp4 13.3 MB
- 175 - How to covert ROMAN numberals.mp4 13.3 MB
- 234 - Use column or row references to create dynamic formulas.mp4 13.2 MB
- 309 - Date calculation and formatting issues related to the 2029-2030 switch.mp4 13.2 MB
- 174 - Compare data with EXACT, FIND, and SEARCH functions.mp4 13.2 MB
- 249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13.2 MB
- 173 - Extract day, month, and year from date fields.mp4 13.2 MB
- 242 - Use the Excel filtering capability for dates.mp4 13.1 MB
- 028 - Custom grouping in PivotTables.mp4 13.0 MB
- 316 - Tips for updating entire columns of date entries when using real or sample data.mp4 13.0 MB
- 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 12.9 MB
- 244 - Use data validation rules with special phone and social security formats.mp4 12.9 MB
- 188 - Using the CONVERT function for different numbering systems.mp4 12.9 MB
- 341 - Use the Quick Analysis tool for easy access to power tools.mp4 12.8 MB
- 323 - Create a dynamic sheet name reference with the INDIRECT function.mp4 12.8 MB
- 250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 12.7 MB
- 197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4 12.7 MB
- 204 - Use mixed addresses in Excel formulas.mp4 12.7 MB
- 205 - Rapid filtering with Filter by Selection.mp4 12.7 MB
- 336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.mp4 12.6 MB
- 220 - Calculate loan payments and investments with PMT and FV functions.mp4 12.4 MB
- 183 - Control table formatting with custom formats.mp4 12.2 MB
- 324 - Calculate dates and-or days of the week for selected future holidays.mp4 12.2 MB
- 235 - Overcoming obstacles when working with dates in charts.mp4 12.2 MB
- 261 - Create range names from Column and Row headings.mp4 12.1 MB
- 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12.1 MB
- 199 - Identify weekdays and weekend days in data.mp4 12.0 MB
- 196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4 12.0 MB
- 160 - Converting dates like 20102006 into usable date entries.mp4 12.0 MB
- 243 - Use worksheet names in formulas.mp4 11.9 MB
- 211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 11.9 MB
- 191 - Using the Solver Add-in.mp4 11.7 MB
- 132 - Exploring font choices not found on the Home tab.mp4 11.7 MB
- 304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.mp4 11.6 MB
- 226 - Simplify the use of special characters and symbols.mp4 11.5 MB
- 025 - Creating dynamic charts with in-cell conditional formatting.mp4 11.5 MB
- 113 - Use conditional formatting data bars to accentuate negative data.mp4 11.5 MB
- 269 - Retrieve vital data based on location using the Geography tool.mp4 11.4 MB
- 245 - Work with time calculations in formulas.mp4 11.4 MB
- 193 - Adjusting default layouts and date grouping in PivotTables.mp4 11.4 MB
- 258 - File documentation with the Workbook Statistics button.mp4 11.3 MB
- 219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11.3 MB
- 189 - Creating an automatically expanding chart by basing it on a table.mp4 11.3 MB
- 231 - Use formulas to create interactive charts.mp4 11.2 MB
- 187 - Calculating cumulative totals.mp4 11.2 MB
- 266 - Condense lengthy nested IF functions with the newer IFS function.mp4 11.2 MB
- 229 - How and when to use an area chart.mp4 11.1 MB
- 214 - Working with array formulas more easily.mp4 11.1 MB
- 339 - Customize the Quick Access Toolbar using the Alt key or a mouse.mp4.crdownload 11.0 MB
- 346 - Create a 15th day or end-of-month series and adjust to weekdays only.mp4 11.0 MB
- 192 - Column widths, row heights, merging cells, and related formatting issues.mp4 11.0 MB
- 270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4 10.9 MB
- 237 - Techniques for creating date series.mp4 10.8 MB
- 140 - Use the new funnel chart available in Excel 365.mp4 10.6 MB
- 277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4 10.6 MB
- 195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4 10.6 MB
- 319 - Use dragging techniques to extend dates by weekdays only, month, or year.mp4 10.5 MB
- 296 - Controlling date entry restrictions using data validation.mp4 10.4 MB
- 215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10.2 MB
- 260 - Use the Fill Justify feature to wrap long text.mp4 10.2 MB
- 222 - Chart display options with blank cells in source data.mp4 10.1 MB
- 345 - Use the Fill Justify command to quickly rewrap text into different cells.mp4 10.0 MB
- 194 - Auditing cell content with Watch Window and dependent cell formulas.mp4 9.9 MB
- 185 - Avoid unintentional entries when typing code numbers.mp4 9.5 MB
- 200 - Use chart and filter for presentations.mp4 9.5 MB
- 236 - Create map-type charts based on geographical locations.mp4 9.5 MB
- 251 - Use the XMATCH function to replace MATCH.mp4 9.5 MB
- 210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9.0 MB
- 019 - Using the REPT function to represent data visually.mp4 8.8 MB
- Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip 1.5 MB
- Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip 1.5 MB
- Exercise Files/26_05_SUM_SUMPRODUCT_SUMIF.zip 1.3 MB
- Exercise Files/28_08_Screen_Snip.zip 1.1 MB
- Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip 1.1 MB
- Exercise Files/124_Quick_Charts.zip 862.2 KB
- Exercise Files/28_10_Shadow_Glow_Reflection.zip 834.6 KB
- Exercise Files/28_09_Sunburst_Charts.zip 651.4 KB
- Exercise Files/29_03_Treemap_Charts.zip 650.8 KB
- Exercise Files/29_07_Hide_Unhide_Worksheets.zip 602.0 KB
- Exercise Files/30_06_Navigation.zip 554.9 KB
- Exercise Files/133_Weekday_Weekend.zip 512.5 KB
- Exercise Files/126_INDEX_Function.zip 491.9 KB
- Exercise Files/30_04_MID_SEQUENCE_LEN_Functions.zip 478.0 KB
- Exercise Files/123_Book1.zip 460.0 KB
- Exercise Files/26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip 457.8 KB
- Exercise Files/273_SEQUENCE_function.zip 438.5 KB
- Exercise Files/135_Borders_Gridlines.zip 438.2 KB
- Exercise Files/261_Worksheet_Statistics.zip 427.0 KB
- Exercise Files/132_WordArt_Variations.zip 426.5 KB
- Exercise Files/211_GoTo_Special.zip 406.3 KB
- Exercise Files/30_01_Emojis_and_Pictures.zip 398.8 KB
- Exercise Files/131_Other_Font_Options.zip 367.3 KB
- Exercise Files/134_Two_Way_Lookups.zip 360.6 KB
- Exercise Files/215_AdvancedFilter.zip 345.0 KB
- Exercise Files/127_Display_Tips.zip 334.5 KB
- Exercise Files/223_BlankCellsInCharts.zip 333.0 KB
- Exercise Files/201_Error_Checking_Indicators.zip 315.6 KB
- Exercise Files/301_New_Data_Types.zip 314.7 KB
- Exercise Files/27_07_Goal_Seek.zip 309.0 KB
- Exercise Files/197_Helpful_Keystroke_Shortcuts.zip 305.8 KB
- Exercise Files/27_11_Paste_Special_Drag_Options.zip 293.0 KB
- Exercise Files/268_Wildcards_Part_2_Functions_.zip 292.6 KB
- Exercise Files/28_02_New_Formula_Techniques.zip 262.6 KB
- Exercise Files/171_Zoom_and_Display_Variations.zip 258.7 KB
- Exercise Files/28_06_Analyze_Data.zip 252.9 KB
- Exercise Files/198_Weekdays_and_Weekends.zip 248.3 KB
- Exercise Files/182_FormattingOptions.zip 237.7 KB
- Exercise Files/180_Table_Differences.zip 236.8 KB
- Exercise Files/283_AGGREGATE_Function.zip 235.4 KB
- Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226.0 KB
- Exercise Files/167_Excel_Sheet_Commands.zip 219.0 KB
- Exercise Files/170_Unique_and_Duplicate_Data.zip 211.0 KB
- Exercise Files/28_05_Outlining_Tools.zip 202.3 KB
- Exercise Files/266_Buttons_for_Conditional_Formatting.zip 190.7 KB
- Exercise Files/157_Comments_and_Reminders.zip 183.4 KB
- Exercise Files/277_Banded_Rows_or_Columns.zip 181.5 KB
- Exercise Files/300_Managing_Duplicate_Data.zip 176.1 KB
- Exercise Files/259_Hide_cells_rows_columns_sheets.zip 173.0 KB
- Exercise Files/30_02_Advanced_Filter.zip 169.5 KB
- Exercise Files/29_04_Quick_Analysis_Button.zip 167.5 KB
- Exercise Files/243_XLOOKUP_Function.zip 165.0 KB
- Exercise Files/176_Range_Names.zip 164.9 KB
- Exercise Files/28_01_Five_Invaluable_Keystroke_Shortcuts.zip 163.9 KB
- Exercise Files/27_01_XLOOKUP.zip 160.1 KB
- Exercise Files/240_Find_Select.zip 157.7 KB
- Exercise Files/158_Replace_Format_or_Content.zip 154.7 KB
- Exercise Files/165_Fill_in_Blanks.zip 152.6 KB
- Exercise Files/169_PivotTable_Date_Grouping.zip 150.6 KB
- Exercise Files/196_Double_and_Triple_Spaced_Printing.zip 146.8 KB
- Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144.0 KB
- Exercise Files/160_Date_Format_Conversions.zip 133.7 KB
- Exercise Files/26_10_Slicers_Analysis.zip 129.7 KB
- Exercise Files/250_EDate_EMonth_DatedIF.zip 129.2 KB
- Exercise Files/184_Date_Calculations.zip 128.5 KB
- Exercise Files/216_ArrayFormulaUpdates.zip 128.0 KB
- Exercise Files/275_List_Box.zip 126.8 KB
- Exercise Files/153_Expand_Collapse_PivotTables.zip 123.4 KB
- Exercise Files/183_New_Table_Style.zip 123.3 KB
- Exercise Files/269_IFS_Function.zip 121.1 KB
- Exercise Files/156_Date_Time_Formats.zip 120.4 KB
- Exercise Files/282_Subtotal.zip 120.1 KB
- Exercise Files/161_Custom_Lists.zip 118.0 KB
- Exercise Files/27_02_Update_Date_Entries.zip 115.3 KB
- Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115.0 KB
- Exercise Files/207_CheckBox_ConditionalFormatting.zip 107.2 KB
- Exercise Files/206_ConditionalFormatting_and_DataValidation.zip 107.1 KB
- Exercise Files/194_Watch_Window.zip 105.3 KB
- Exercise Files/29_10_Filling_Blank_Cells.zip 103.5 KB
- Exercise Files/26_04_Function_Names.zip 100.7 KB
- Exercise Files/26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip 95.2 KB
- Exercise Files/27_12_SS_Numbers.zip 94.1 KB
- Exercise Files/255_Hidden_Visible_Data.zip 85.2 KB
- Exercise Files/278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip 81.0 KB
- Exercise Files/27_08_Sort_by_Custom_List.zip 80.0 KB
- Exercise Files/28_04_Zoom_Techniques.zip 79.1 KB
- Exercise Files/249_Prevent_Locate_Duplicates.zip 77.5 KB
- Exercise Files/304_Custom_Filter.zip 77.5 KB
- Exercise Files/281_PivotTable_Analysis.zip 77.5 KB
- Exercise Files/28_11_Printing_Tips.zip 77.3 KB
- Exercise Files/30_05_PivotTable_Settings.zip 76.8 KB
- Exercise Files/285_XLOOKUP_XMATCH.zip 76.7 KB
- Exercise Files/195_TRIM_and_CLEAN.zip 75.1 KB
- Exercise Files/246_Sheet_Names.zip 74.0 KB
- Exercise Files/226_Sort_by_Color.zip 73.8 KB
- Exercise Files/295_Fonts.zip 73.7 KB
- Exercise Files/204_Filter_by_Selection.zip 73.3 KB
- Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73.0 KB
- Exercise Files/27_06_LAMBDA_Function.zip 71.1 KB
- Exercise Files/239_Data_Validation_and_Filter.zip 70.4 KB
- Exercise Files/192_PivotTable_Settings.zip 67.4 KB
- Exercise Files/200_Linking_Pictures.zip 66.2 KB
- Exercise Files/234_Status_Bar.zip 65.3 KB
- Exercise Files/150_Mixed_References.zip 65.3 KB
- Exercise Files/151_Chart_gridlines_and_borders.zip 64.5 KB
- Exercise Files/265_SUBSTITUTE_and_REPLACE_Functions.zip 63.2 KB
- Exercise Files/220_SORT_and_SORTBY_Functions.zip 62.6 KB
- Exercise Files/286_Paste_Special_Options.zip 61.9 KB
- Exercise Files/128_Wrap_text_Merge_Indent.zip 60.1 KB
- Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 59.9 KB
- Exercise Files/235_Columns_and_Rows.zip 59.8 KB
- Exercise Files/231_People_Graph.zip 59.4 KB
- Exercise Files/26_11_Heat_Maps.zip 58.3 KB
- Exercise Files/26_12_Validation_with_UNIQUE_and_SORT_functions.zip 58.1 KB
- Exercise Files/168_Ranking_Data.zip 57.9 KB
- Exercise Files/257_TODAY_NOW_Date_Functions.zip 57.4 KB
- Exercise Files/241_AverageCountSubscript.zip 57.2 KB
- Exercise Files/262_Re_scaling_Column_and_Line_Charts.zip 56.6 KB
- Exercise Files/271_Protect_Cell_Ranges.zip 56.2 KB
- Exercise Files/202_Worksheet_Protection.zip 55.5 KB
- Exercise Files/302_FILTER_and_UNIQUE_functions.zip 55.1 KB
- Exercise Files/276_COUNT_COUNTA_and_COUNTBLANK_functions.zip 52.1 KB
- Exercise Files/218_Sample_Data.zip 51.2 KB
- Exercise Files/125_Heat_Maps.zip 51.2 KB
- Exercise Files/294_Dynamic_Arrays.zip 51.0 KB
- Exercise Files/28_07_UNIQUE_Unique_vs_Distinct.zip 49.9 KB
- Exercise Files/258_Prevent_Duplicates.zip 49.0 KB
- Exercise Files/248_Time_Math.zip 48.2 KB
- Exercise Files/28_03_Time_differencees.zip 47.2 KB
- Exercise Files/244_PivotTable_Settings.zip 46.4 KB
- Exercise Files/225_New_Formulas.zip 45.2 KB
- Exercise Files/228_Icons.zip 42.4 KB
- Exercise Files/26_13_Clustered_vs_Stacked_Chart_Types.zip 42.1 KB
- Exercise Files/217_UNIQUE_function.zip 41.2 KB
- Exercise Files/159_Number_Formats.zip 41.1 KB
- Exercise Files/221_Themes.zip 40.0 KB
- Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 39.9 KB
- Exercise Files/194_LEN_and_REPT.zip 39.2 KB
- Exercise Files/26_06_Binary_Octal_Decimal_Hexadecimal.zip 39.1 KB
- Exercise Files/186_Sort_by_Moving_Columns.zip 38.8 KB
- Exercise Files/254_XMATCH_Function.zip 38.3 KB
- Exercise Files/288_LET_function.zip 37.3 KB
- Exercise Files/290_MovingAverage.zip 36.4 KB
- Exercise Files/29_02_Quick_Access_Toolbar_QAT_Tips.zip 35.5 KB
- Exercise Files/205_Displaying_Large_Values.zip 32.8 KB
- Exercise Files/298_Cell_Precedents.zip 31.4 KB
- 072 - Keystroke shortcuts from A to Z Using the Ctrl key.srt 31.2 KB
- Exercise Files/270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip 30.2 KB
- Exercise Files/181_Avoiding_DIV_Error.zip 29.6 KB
- Exercise Files/245_FilterYearDay.zip 28.4 KB
- 087 - Adjust banded-row formatting.srt 28.1 KB
- 061 - Working with formulas in tables.srt 28.0 KB
- Exercise Files/267_Wildcards_Part_1_Filter_and_Commands.zip 27.7 KB
- Exercise Files/233_ScenarioManager.zip 27.3 KB
- Exercise Files/280_Chart_Design_Tools.zip 27.2 KB
- Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27.1 KB
- Exercise Files/293_Cell_Colors_Patterns_Effects.zip 27.0 KB
- Exercise Files/149_Decimals_and_Fractions.zip 26.4 KB
- 105 - Formula nesting - Using multiple functions in the same formula.srt 25.1 KB
- Exercise Files/129_Fill_Effects.zip 24.7 KB
- Exercise Files/27_09_INDIRECT_function.zip 24.7 KB
- Exercise Files/189_Alt_Key_Shortcuts.zip 24.6 KB
- Exercise Files/26_02_Powers_and_Roots.zip 24.3 KB
- 089 - How and when to use the 10 rounding functions in Excel.srt 24.2 KB
- 057 - Building a flexible monthly table using functions.srt 23.6 KB
- 093 - Accelerate data entry with five special techniques.srt 23.3 KB
- Exercise Files/29_12_Transpose.zip 23.2 KB
- 014 - Adding illustrations to your workbook.srt 22.9 KB
- Exercise Files/242_CopyFormats.zip 22.9 KB
- 007 - Using check boxes and conditional formatting together for dynamic displays.srt 22.8 KB
- 123 - Use custom formulas in data validation to keep out bad data.srt 22.5 KB
- 016 - Using formulas to calculate values across worksheets and workbooks.srt 22.5 KB
- 048 - Custom formats using asterisk, semicolon, and brackets.srt 22.5 KB
- Exercise Files/29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip 22.3 KB
- 049 - Meeting unusual filtering needs via Advanced Filter.srt 22.2 KB
- Exercise Files/164_Percent_change_and_Goal_Seek.zip 22.1 KB
- 112 - Working with hidden data when copying cells and creating charts.srt 22.1 KB
- 051 - Two-way lookup using the MATCH and INDEX functions.srt 21.9 KB
- 159 - Create numeric formats - Display in thousands or millions.srt 21.7 KB
- 139 - Avoiding common chart distortions.srt 21.5 KB
- 104 - Create linkage formulas that refer to other worksheets and workbooks.srt 21.4 KB
- 096 - How to create time interval entrie.srt 21.3 KB
- Exercise Files/27_10_Holiday_Calculations.zip 21.1 KB
- 073 - Use special tricks for working with dates in charts.srt 21.0 KB
- 117 - Tips for creating and updating sample data.srt 20.8 KB
- Exercise Files/279_SWITCH_function.zip 20.8 KB
- Exercise Files/224_CondFormattingBreakpoints.zip 20.7 KB
- Exercise Files/284_The_F9_Key.zip 20.7 KB
- 036 - Discovering time-saving tools in the Go To Special feature.srt 20.6 KB
- 052 - Using Excel error-checking functions.srt 20.4 KB
- Exercise Files/26_07_Numeric_Formatting.zip 20.4 KB
- Exercise Files/175_ROMAN_ARABIC.zip 20.3 KB
- Exercise Files/27_04_Create_Range_Names_From_Headings.zip 20.1 KB
- 116 - Displaying multiple worksheets and workbooks together.srt 20.1 KB
- Exercise Files/292_Line_Wrap_and_Wrap_Text.zip 20.0 KB
- 138 - Use data validation to force entries to be uppercase or lowercase.srt 20.0 KB
- 127 - Using the INDEX function to extract data by row and column.srt 20.0 KB
- 068 - Use random number functions for sorting and creating sample data.srt 19.9 KB
- 084 - Use the OFFSET function for tabulating moving data.srt 19.7 KB
- Exercise Files/296_3D_Formulas.zip 19.5 KB
- 103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.srt 19.2 KB
- 085 - Alter numeric data without formulas.srt 19.2 KB
- Exercise Files/179_Date_Proximity_Formatting_final.zip 19.1 KB
- 110 - Use the FIND, MID, LEFT, and RIGHT functions.srt 19.1 KB
- 002 - Resizing, moving, copying, and manipulating charts and other objects.srt 19.0 KB
- 086 - Use Flash Fill to rapidly combine or separate columnar data.srt 19.0 KB
- 119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.srt 18.8 KB
- 032 - Using scroll bars and spin buttons to facilitate forms creation.srt 18.7 KB
- Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 18.7 KB
- Exercise Files/178_Adjusting_Names.zip 18.6 KB
- 067 - Set up a macro for sorting dynamic data.srt 18.6 KB
- 034 - Calculating with hours, minutes, and times of day.srt 18.5 KB
- 102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.srt 18.4 KB
- 099 - Solve matching issues with matching phone numbers and SS numbers.srt 18.4 KB
- 144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.srt 18.3 KB
- Exercise Files/203_Mixed_Cell_Addresses.zip 18.3 KB
- Exercise Files/260_Align_Arrange_Rotate_Shapes.zip 18.3 KB
- 142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.srt 18.1 KB
- 054 - Auditing.srt 18.1 KB
- 006 - Summarizing data from diverse ranges with Data - Consolidate.srt 18.0 KB
- 131 - Working with multiple worksheets simultaneously.srt 18.0 KB
- 071 - Work with formulas in tables.srt 17.8 KB
- 145 - Using the AND and OR functions independently or within IF functions.srt 17.7 KB
- 101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.srt 17.6 KB
- 080 - Use slicers and charts together for dynamic presentations.srt 17.6 KB
- Exercise Files/29_08_Fill_Justify_Re_wrap_text.zip 17.6 KB
- 047 - Using wildcards (asterisk, tilde, and question mark).srt 17.5 KB
- 083 - Adjust a chart's source data and adjust its series order.srt 17.5 KB
- Exercise Files/210_SmartArt.zip 17.4 KB
- 129 - The Wrap Text, Merge and Center, and Indent options.srt 17.3 KB
- 050 - Create an organization chart.srt 17.2 KB
- 069 - Use calcuated fields and calculated items in a PivotTable.srt 17.1 KB
- Exercise Files/27_03_Eliminate_Spaces_and_Special_Characters.zip 17.0 KB
- Exercise Files/256_Macro_Highlight_Formula_Cells.zip 16.9 KB
- Exercise Files/299_Date_Controls_with_Data_Validation.zip 16.9 KB
- 009 - Transposing data and charts for a different perspective on your data.srt 16.9 KB
- Exercise Files/219_Utility_Macros.zip 16.8 KB
- Exercise Files/130_Multiple_Worksheets.zip 16.8 KB
- 107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.srt 16.8 KB
- 109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.srt 16.8 KB
- Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16.5 KB
- Exercise Files/29_11_Sparklines_and_Conditional_Formatting.zip 16.5 KB
- 147 - Sorting tips and shortcuts.srt 16.4 KB
- 135 - Borders and gridlines - Exploring variations, options, and differences.srt 16.4 KB
- Exercise Files/209_Borders_Gridlines_Printing.zip 16.3 KB
- 008 - Becoming more productive with these 10 tiny tips you'll use often.srt 16.3 KB
- 043 - Exploring what-if scenarios using Goal Seek.srt 16.2 KB
- 063 - Creating an Excel template.srt 16.2 KB
- Exercise Files/238_Date_Time_Series.zip 16.2 KB
- Exercise Files/251_Find_Highlight_Formula_cells.zip 16.1 KB
- 015 - Using a pick list, VLOOKUP, table, and chart together.srt 16.1 KB
- 108 - Work with MAX, MAXIFS, LARGE, and related functions.srt 16.1 KB
- Exercise Files/213_Shapes_and_Stars.zip 16.0 KB
- Exercise Files/272_Geography_Data.zip 16.0 KB
- 059 - ADDRESS, ROW, and COLUMN functions.srt 16.0 KB
- Exercise Files/208_Transpose.zip 16.0 KB
- 118 - Use conditional formatting to overcome formatting limitations of the IF function.srt 15.9 KB
- 091 - How to use mixed cell references.srt 15.8 KB
- 055 - Adding comments and shapes.srt 15.8 KB
- Exercise Files/199_Charts_and_Filters.zip 15.6 KB
- 053 - Custom formats, relative addressing, and conditional formatting.srt 15.6 KB
- 126 - Creating heat maps using conditional formatting.srt 15.6 KB
- 095 - Use Watch Window and other techniques to track changing cells.srt 15.5 KB
- 122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.srt 15.4 KB
- 136 - New Excel 2016 chart types Tree map and sunburst.srt 15.4 KB
- Exercise Files/214_Array_Constants_withVLOOKUP.zip 15.3 KB
- 021 - Accelerating Cut, Copy, Paste, and Insert tasks.srt 15.1 KB
- 106 - Keyboard shortcuts for numeric formats.srt 15.1 KB
- 082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.srt 14.9 KB
- 029 - Quick formatting tips.srt 14.9 KB
- 079 - Hide worksheets, row, columns, cells and other Excel elements.srt 14.8 KB
- 062 - Locating data validation rules and violations.srt 14.8 KB
- 111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.srt 14.7 KB
- Exercise Files/29_01_Data_Validation_Multiple_Criteria.zip 14.7 KB
- 005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.srt 14.7 KB
- 156 - Create your own customized date and time formats.srt 14.7 KB
- 151 - Control gridlines in charts and on worksheets.srt 14.6 KB
- 020 - Using source data from a table to make your PivotTable more dynamic.srt 14.6 KB
- Exercise Files/291_Error_Checking_Functions.zip 14.6 KB
- 124 - Dealing with circular errors.srt 14.6 KB
- 172 - Create artistic charts with random numbers.srt 14.6 KB
- 137 - Freezing column and row titles.srt 14.5 KB
- Exercise Files/191_Columns_Widths.zip 14.5 KB
- 003 - Using list boxes and combo boxes to facilitate forms creation.srt 14.5 KB
- 042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.srt 14.5 KB
- Exercise Files/297_Date_Formats.zip 14.5 KB
- 045 - Creating variable conditional formatting rules.srt 14.5 KB
- 017 - Dynamically presenting data via chart slicers.srt 14.5 KB
- Exercise Files/30_03_Combo_Charts.zip 14.4 KB
- 308 - Quick number formatting with keystroke shortcuts and icon buttons.srt 14.4 KB
- 076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.srt 14.4 KB
- Exercise Files/232_GrowingChart.zip 14.2 KB
- 310 - Using wildcards in the new XLOOKUP and XMATCH functions.srt 14.0 KB
- 097 - How to create frequency tabulations and distributions.srt 14.0 KB
- 150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.srt 13.9 KB
- 100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.srt 13.9 KB
- 314 - Contrasting uses of clustered column and stacked column charts.srt 13.9 KB
- 037 - Adding, managing, and printing comments for worksheet documentation.srt 13.9 KB
- 153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.srt 13.8 KB
- 040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.srt 13.7 KB
- 065 - Creating a pick list dependent on another pick list.srt 13.6 KB
- 075 - Creating an Excel template to simplify updating a monthly file.srt 13.6 KB
- Exercise Files/274_LEN_SUBSTITUTE_and_TRIM_functions.zip 13.6 KB
- 064 - Restoring missing column titles.srt 13.6 KB
- 013 - Using date and time as metrics in a PivotTable.srt 13.4 KB
- Exercise Files/303_UPPER_lower_Proper.zip 13.4 KB
- 154 - Control phone number and postal code formats using built-in options or customized formats.srt 13.4 KB
- 120 - Summarize data from different worksheets with a PivotTable.srt 13.3 KB
- 090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.srt 13.3 KB
- 078 - Avoid errors and hidden data with the powerful AGGREGATE function.srt 13.3 KB
- 098 - Create an expanded list from a summary using PivotTable techniques.srt 13.3 KB
- Exercise Files/287_Data_Entry_Tips.zip 13.2 KB
- 148 - A look at new chart types in Excel 2016 - Waterfall.srt 13.1 KB
- Exercise Files/289_Create_Worksheets_Fast.zip 13.1 KB
- Exercise Files/154_Phone_and_ZipCode_Formats.zip 13.1 KB
- 114 - Creative use of sparklines in merged cells with axes.srt 13.0 KB
- Exercise Files/29_05_Dragging_Number_Cells.zip 13.0 KB
- 305 - Tips for saving time when typing function names.srt 13.0 KB
- Exercise Files/229_Random_Functions.zip 13.0 KB
- 012 - Splitting and consolidating workbooks.srt 13.0 KB
- 146 - Vertical and horizontal alignment settings and orientation options.srt 13.0 KB
- 041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.srt 13.0 KB
- 074 - Use a data form for data entry and exploring data.srt 13.0 KB
- 125 - Tips for creating charts quickly.srt 13.0 KB
- 134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt 12.9 KB
- 121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.srt 12.9 KB
- Exercise Files/227_Special_Characters.zip 12.8 KB
- 293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.srt 12.6 KB
- 337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.srt 12.6 KB
- 292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.srt 12.6 KB
- 056 - Drawing borders and border grids.srt 12.6 KB
- 088 - Change the shape of comment boxes and other objects.srt 12.5 KB
- 001 - Hide and unhide worksheets securely.srt 12.5 KB
- 044 - Creating text, numerical, date, and time lists in a flash.srt 12.4 KB
- 077 - Create dynamic sheet name references with the INDIRECT function.srt 12.4 KB
- 306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.srt 12.3 KB
- 353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.srt 12.3 KB
- 161 - Create custom lists for letter series like A to Z.srt 12.3 KB
- 024 - Customizing templates to fit your unique needs.srt 12.3 KB
- 081 - Save a chart as a template Use the template for current or new charts.srt 12.3 KB
- 094 - Insert a text box or shape and link a cell's content to it.srt 12.2 KB
- 311 - Using slicers as analytical tools.srt 12.2 KB
- 010 - Applying conditional formatting across rows of data.srt 12.2 KB
- 294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.srt 12.2 KB
- 348 - Accentuate values with conditional formatting and sparklines.srt 12.2 KB
- Exercise Files/27_05_Date_Series_Creation.zip 12.2 KB
- 033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.srt 12.1 KB
- 313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.srt 12.1 KB
- 267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.srt 12.0 KB
- 342 - Create a number series with the Ctrl key and left-right mouse button.srt 12.0 KB
- 227 - Select from over 800 icons to enliven worksheets.srt 11.9 KB
- 152 - Use the INDIRECT function with intersection formulas and range names to extract data.srt 11.9 KB
- 281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.srt 11.8 KB
- 030 - The top five unknown but useful keyboard shortcuts.srt 11.8 KB
- 340 - Exploring treemap charts to display hierarchical data.srt 11.8 KB
- 023 - Highlighting PivotTable results with conditional formatting.srt 11.7 KB
- 355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.srt 11.7 KB
- 155 - Change the default Excel chart type; create and use chart templates.srt 11.7 KB
- Exercise Files/187_Cumulative_Totals.zip 11.6 KB
- 157 - Create on-screen warnings and reminders with comments or data validation messages.srt 11.6 KB
- 128 - Displaying tips when using Excel in presentations.srt 11.6 KB
- 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt 11.6 KB
- 352 - Combo charts Combine different chart types to present data more clearly.srt 11.6 KB
- 141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.srt 11.5 KB
- Exercise Files/26_08_Dates_and_the_1930_2029_split.zip 11.5 KB
- 328 - Using new formula-writing techniques to simplify wide-ranging formulas.srt 11.5 KB
- 162 - Freeze Panes and Split.srt 11.5 KB
- 320 - Use the LAMBDA function to create worksheet functions.srt 11.5 KB
- 322 - Sort your data based on a Custom List that you define.srt 11.5 KB
- 060 - Join data with new CONCAT and TEXTJOIN functions.srt 11.5 KB
- 317 - Using TRIM, CLEAN and other functions to clean up text data.srt 11.5 KB
- 284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.srt 11.4 KB
- 331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.srt 11.4 KB
- 332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.srt 11.4 KB
- 039 - Setting up custom views for quick access to different worksheet displays.srt 11.3 KB
- 225 - Sort or filter data based on color font or cell color background.srt 11.3 KB
- 275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.srt 11.3 KB
- 288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.srt 11.3 KB
- 276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.srt 11.3 KB
- 220 - Calculate loan payments and investments with PMT and FV functions.srt 11.3 KB
- 287 - Create moving averages with formulas and chart trendlines.srt 11.2 KB
- 038 - Reducing data entry time by expanding AutoCorrect options.srt 11.2 KB
- 035 - Tracking down cell dependencies across multiple worksheets and workbooks.srt 11.2 KB
- 271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.srt 11.2 KB
- 350 - Use emojis and other symbols in formulas and charts.srt 11.2 KB
- 167 - Use workbook protection to prevent use of sheet commands.srt 11.2 KB
- 254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.srt 11.1 KB
- 329 - Calculate time differences within days and across multiple days.srt 11.1 KB
- 177 - Customize your Quick Access Toolbar.srt 11.1 KB
- 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt 11.1 KB
- Exercise Files/29_09_Date_Series_15th_and_Month_End.zip 11.1 KB
- 046 - Handling dates with unusual formats.srt 11.0 KB
- 168 - Rank data with the RANK and RANK.AVG functions.srt 11.0 KB
- 158 - Use REPLACE for formats only, for data only, or for both.srt 11.0 KB
- 066 - Using command shortcuts with the Alt key.srt 11.0 KB
- 241 - Change PivotTable settings for titles and summaries.srt 11.0 KB
- 190 - Keystroke shortcuts using the Alt key.srt 10.9 KB
- 330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.srt 10.9 KB
- 231 - Use formulas to create interactive charts.srt 10.9 KB
- 265 - Use wildcard symbols in filtering and commands.srt 10.8 KB
- 244 - Use data validation rules with special phone and social security formats.srt 10.8 KB
- 335 - Exploring Excel's Sunburst chart to display hierarchical data.srt 10.8 KB
- 171 - Keyboard, mouse, and command techniques for viewing worksheets.srt 10.8 KB
- 351 - Use the Advanced Filter for specialized filtering needs.srt 10.7 KB
- 327 - Five indispensable keystroke shortcuts for Windows and Mac users.srt 10.7 KB
- 347 - Use the Go To Special option to select and populate blank cells.srt 10.7 KB
- 301 - Refine filtering needs via custom filter options.srt 10.7 KB
- 279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.srt 10.7 KB
- 004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt 10.7 KB
- Exercise Files/252_Text_Columns_Flash_Fill.zip 10.7 KB
- 338 - Use Data Validation based on multiple criteria.srt 10.7 KB
- 149 - Work with formulas and formats Decimals and fractions.srt 10.6 KB
- 230 - Insert colorful images with the People Graph Add-in.srt 10.6 KB
- 339 - Customize the Quick Access Toolbar using the Alt key or a mouse.srt 10.6 KB
- 318 - Create multiple range names from the top row and-or left column.srt 10.6 KB
- 184 - Use date functions for age and tenure calculations.srt 10.6 KB
- 312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.srt 10.6 KB
- 170 - Identify or extract unique entries in a list.srt 10.5 KB
- 163 - NETWORKDAYS.INTL and WORKDAY.INTL.srt 10.5 KB
- 283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.srt 10.5 KB
- 257 - Align, arrange, and rotate shapes in worksheets.srt 10.5 KB
- 239 - Use Find and Replace to change cell contents and formats.srt 10.4 KB
- 169 - Use nonstandard fiscal years and quarters in PivotTables.srt 10.4 KB
- 221 - Use the XLOOKUP function to replace VLOOKUP.srt 10.4 KB
- 270 - Use the new SEQUENCE function to quickly build numeric and date arrays.srt 10.4 KB
- 325 - Use dragging techniques for faster Paste Special options.srt 10.4 KB
- 115 - Copy formats quickly using dragging techniques and the Format Painter.srt 10.4 KB
- 268 - Control worksheet security by allowing selected users to edit specific cell ranges.srt 10.4 KB
- 058 - Adding pictures as worksheet backgrounds.srt 10.3 KB
- 143 - Creating cross-totals with the SUMIFS function and mixed references.srt 10.3 KB
- 243 - Use worksheet names in formulas.srt 10.3 KB
- 195 - Use the LEN and REPT functions for specialized cell testing and display options.srt 10.3 KB
- 130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.srt 10.3 KB
- 272 - Create a list box to facilitate selection of data from a list.srt 10.3 KB
- 026 - Enhancing table filtering with slicers.srt 10.2 KB
- 196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.srt 10.2 KB
- 207 - Tracking down conditional formatting and data validation rules.srt 10.2 KB
- 298 - New data types Extract valuable online data into your worksheets.srt 10.2 KB
- 208 - Transposing data and using the TRANSPOSE function.srt 10.2 KB
- 259 - Avoid misleading visuals when rescaling.srt 10.1 KB
- 248 - Display and highlight worksheet formula cells.srt 10.1 KB
- 070 - Replace characters by position with the REPLACE function.srt 10.1 KB
- 031 - Using the TREND and GROWTH functions for projecting future results.srt 10.1 KB
- 164 - Calculate % of change.srt 10.1 KB
- 226 - Simplify the use of special characters and symbols.srt 10.1 KB
- 289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.srt 10.1 KB
- 280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.srt 10.1 KB
- 213 - Tabulating totals with the VLOOKUP function and array constants.srt 10.0 KB
- 202 - How to use the error-checking rules in Excel.srt 10.0 KB
- Exercise Files/236_Dates_in_Charts.zip 10.0 KB
- 303 - How to use exponentiation (powers and roots) in Excel formulas.srt 10.0 KB
- 192 - Column widths, row heights, merging cells, and related formatting issues.srt 10.0 KB
- 180 - Differences and limitations of converting data to a table.srt 10.0 KB
- Exercise Files/212_CEILINGandFLOOR.zip 10.0 KB
- 273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.srt 9.9 KB
- 176 - Use range names for more readable formulas.srt 9.9 KB
- 274 - Enhance readability with banded rows via conditional formatting.srt 9.9 KB
- Exercise Files/264_Names_Based_On_Column_Row_Headings.zip 9.9 KB
- 205 - Rapid filtering with Filter by Selection.srt 9.9 KB
- 253- Work with hidden and visible data in filtered and subtotaled lists.srt 9.9 KB
- 216 - Creating and updating sample data.srt 9.8 KB
- 179 - How to adjust names.srt 9.8 KB
- 197 - Create double-spaced and triple-spaced printouts while repeating column headings.srt 9.8 KB
- 173 - Extract day, month, and year from date fields.srt 9.8 KB
- 250 - Highlight milestone data with conditional formatting and cumulative formulas.srt 9.8 KB
- 326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.srt 9.7 KB
- 344 - Unhide multiple worksheets at once and use the very hidden option.srt 9.7 KB
- 247 - Look forward and backward using EDATE and other date functions.srt 9.6 KB
- Exercise Files/253_Cumulative_Formulas.zip 9.6 KB
- 198 - Helpful keystroke shortcuts.srt 9.6 KB
- 218 - Use the new SORT and SORTBY functions to extract sorted lists.srt 9.6 KB
- 235 - Overcoming obstacles when working with dates in charts.srt 9.6 KB
- 092 - Activate the Speak On Enter and Speak Cells features.srt 9.6 KB
- 174 - Compare data with EXACT, FIND, and SEARCH functions.srt 9.5 KB
- 204 - Use mixed addresses in Excel formulas.srt 9.5 KB
- Exercise Files/188_CONVERT_Function.zip 9.5 KB
- 181 - Avoid the #DIV0 error message.srt 9.5 KB
- 291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.srt 9.5 KB
- 022 - Increasing your productivity with custom lists.srt 9.4 KB
- 299 - Use the FILTER and UNIQUE functions together for dynamic extractions.srt 9.4 KB
- 224 - Discover new formula capabilities with new functions and dynamic arrays.srt 9.4 KB
- 211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt 9.4 KB
- Exercise Files/263_Fill_Justify_Wrap_Text.zip 9.3 KB
- 300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.srt 9.3 KB
- 240 - Add formula tools and symbols to the Quick Access Toolbar.srt 9.3 KB
- 277 - Adjust charts quickly with quick layout, change colors, and chart styles options.srt 9.3 KB
- 309 - Date calculation and formatting issues related to the 2029-2030 switch.srt 9.2 KB
- 178 - Conditional formatting based on date proximity.srt 9.2 KB
- 200 - Use chart and filter for presentations.srt 9.2 KB
- 217 - Format macros to make you a more efficient Excel user.srt 9.2 KB
- 336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.srt 9.2 KB
- 321 - Get the formula results you want using Goal Seek.srt 9.1 KB
- 256 - Use various techniques to hide cells, rows, columns, and worksheets.srt 9.1 KB
- 343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.srt 9.1 KB
- 285 - Using the LET function to simplify formulas via programming concepts.srt 9.1 KB
- Exercise Files/247_Phone_ZipFormats.zip 9.0 KB
- Exercise Files/222_Financial_Functions.zip 9.0 KB
- 233 - Get totals quickly without creating formulas.srt 9.0 KB
- 209 - Displaying gridlines, borders, and column_row headings when printing.srt 9.0 KB
- 237 - Techniques for creating date series.srt 9.0 KB
- Exercise Files/190_Solver.zip 9.0 KB
- 027 - Converting charts into pictures.srt 9.0 KB
- 264 - Use wildcard symbols in functions.srt 8.9 KB
- 290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.srt 8.9 KB
- 315 - Use the XLOOKUP function with multiple column criteria and multiple column results.srt 8.9 KB
- 262 - Use the SUBSTITUTE and REPLACE functions.srt 8.9 KB
- 346 - Create a 15th day or end-of-month series and adjust to weekdays only.srt 8.8 KB
- 349 - Transpose data with formula substitution and the TRANSPOSE function.srt 8.8 KB
- 133 - Using WordArt for special titles and headings.srt 8.8 KB
- 113 - Use conditional formatting data bars to accentuate negative data.srt 8.7 KB
- 278 - Analyze PivotTable data with 13 different Show Values As options.srt 8.7 KB
- 333 - Using the Distinct vs. Unique options when using the UNIQUE function.srt 8.7 KB
- 028 - Custom grouping in PivotTables.srt 8.7 KB
- Exercise Files/230_Area_Charts.zip 8.7 KB
- 242 - Use the Excel filtering capability for dates.srt 8.7 KB
- 323 - Create a dynamic sheet name reference with the INDIRECT function.srt 8.7 KB
- 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt 8.6 KB
- 249 - Split or join columnar data with Text to Columns or Flash Fill.srt 8.6 KB
- 304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.srt 8.6 KB
- 245 - Work with time calculations in formulas.srt 8.6 KB
- 269 - Retrieve vital data based on location using the Geography tool.srt 8.5 KB
- 297 - Remove duplicates from a list vs. creating a new list without duplicates.srt 8.5 KB
- 307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.srt 8.5 KB
- 140 - Use the new funnel chart available in Excel 365.srt 8.5 KB
- 011 - Exploring various layouts for your PivotTable.srt 8.4 KB
- 324 - Calculate dates and-or days of the week for selected future holidays.srt 8.4 KB
- 201 - Create picture links.srt 8.4 KB
- 165 - Fill in all blank cells within a range with either formatting or data.srt 8.4 KB
- 334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.srt 8.4 KB
- 255 - Use data validation rules to prevent duplicate entries in a range.srt 8.4 KB
- 316 - Tips for updating entire columns of date entries when using real or sample data.srt 8.3 KB
- 229 - How and when to use an area chart.srt 8.3 KB
- 236 - Create map-type charts based on geographical locations.srt 8.3 KB
- 246 - Prevent and locate duplicate worksheet entries.srt 8.3 KB
- 266 - Condense lengthy nested IF functions with the newer IFS function.srt 8.2 KB
- 188 - Using the CONVERT function for different numbering systems.srt 8.2 KB
- 282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.srt 8.2 KB
- 252 - Create a powerful macro.srt 8.2 KB
- 354 - Exploring Edit Default Layout options when using PivotTables.srt 8.1 KB
- 286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.srt 8.1 KB
- Exercise Files/237_Geographic_Maps.zip 8.1 KB
- 238 - Extract filtered data with data validation and the FILTER function.srt 8.1 KB
- 185 - Avoid unintentional entries when typing code numbers.srt 8.0 KB
- 182 - Explore formatting options not available on the Home tab.srt 8.0 KB
- 160 - Converting dates like 20102006 into usable date entries.srt 8.0 KB
- 189 - Creating an automatically expanding chart by basing it on a table.srt 8.0 KB
- 232 - Track variables using the Scenario Manager.srt 8.0 KB
- 194 - Auditing cell content with Watch Window and dependent cell formulas.srt 7.9 KB
- 295 - Where does that cell get its data from - Tracking down cell precedents.srt 7.9 KB
- 175 - How to covert ROMAN numberals.srt 7.9 KB
- 214 - Working with array formulas more easily.srt 7.9 KB
- 234 - Use column or row references to create dynamic formulas.srt 7.9 KB
- 186 - Sorting by moving columns.srt 7.8 KB
- 166 - Use the COUNT and COUNTA functions.srt 7.8 KB
- 193 - Adjusting default layouts and date grouping in PivotTables.srt 7.8 KB
- 258 - File documentation with the Workbook Statistics button.srt 7.8 KB
- 203 - Protect worksheets and lock cells.srt 7.8 KB
- 191 - Using the Solver Add-in.srt 7.7 KB
- 263 - Accelerate Conditional Formatting with the Quick Access Toolbar.srt 7.7 KB
- 222 - Chart display options with blank cells in source data.srt 7.7 KB
- 187 - Calculating cumulative totals.srt 7.6 KB
- Exercise Files/185_Unintentional_Entries.zip 7.6 KB
- 296 - Controlling date entry restrictions using data validation.srt 7.4 KB
- 132 - Exploring font choices not found on the Home tab.srt 7.4 KB
- 219 - Use themes to adjust worksheet colors, fonts, and effects.srt 7.3 KB
- 341 - Use the Quick Analysis tool for easy access to power tools.srt 7.3 KB
- 260 - Use the Fill Justify feature to wrap long text.srt 7.3 KB
- 319 - Use dragging techniques to extend dates by weekdays only, month, or year.srt 7.2 KB
- 261 - Create range names from Column and Row headings.srt 7.1 KB
- 210 - Exploring some of the 200-plus SmartArt graphic options.srt 7.1 KB
- 345 - Use the Fill Justify command to quickly rewrap text into different cells.srt 7.0 KB
- 199 - Identify weekdays and weekend days in data.srt 6.9 KB
- 206 - Display large values.srt 6.6 KB
- 018 - Parsing your data to create unique lists.srt 6.6 KB
- Exercise Files/189_Chart_based_on_a_Table.zip 6.5 KB
- 025 - Creating dynamic charts with in-cell conditional formatting.srt 6.4 KB
- 183 - Control table formatting with custom formats.srt 6.2 KB
- 215 - Using the new UNIQUE function to count and copy unique list entries.srt 6.2 KB
- 251 - Use the XMATCH function to replace MATCH.srt 6.1 KB
- 019 - Using the REPT function to represent data visually.srt 5.9 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via anywarmservice[AT]gmail.com. Remember to include the full url in your complaint.