نکات هفتگی اکسل

مدرس Dennis Taylor

انتشار 2015/01/16

به‌روز‌رسانی 2025/10/28

مدت زمان 54h 59m

سطح متوسط

فایل تمرینی دارد

آموزش Excel Tips Weekly

این دوره آموزشی مبتنی بر نکات، ترفندهای افزایش بهره‌وری، ویژگی‌های پنهان جالب، توابع ضروری و محتوای پیشرفته در موضوعاتی مانند استفاده از PivotTables برای تجزیه و تحلیل داده‌ها را به کاربران اکسل نشان می‌دهد. هر سه شنبه برای یک نکته جدید از متخصص دنیس تیلور هماهنگ کنید. هر آموزش یک درس کوتاه و مستقل است که تضمین می‌کند بینش جدیدی در مورد اکسل به شما ارائه می‌دهد.توجه: از آنجایی که این یک مجموعه در حال انجام است، بینندگان گواهی پایان کار را دریافت نخواهند کرد.

Data Analysis Microsoft Excel Spreadsheets

Excel Tips - New This Week

Discovering time-saving tools in the Go To Special feature ()

Previous Episodes

Exploring various Information functions: ISTEXT, ISFORMULA, ISBLANK, and more… ()

Using list boxes and combo boxes to facilitate forms creation ()

Use the TEXTSPLIT function to split data based on one or more characters ()

Using the UNIQUE function when the FILTER function is using multiple AND or OR criteria ()

Creating PivotTables from data on different worksheets or workbooks ()

Chart efficiency tips: Create, transpose, add titles, adjust gap width, change layouts ()

Using data validation and the MROUND function to limit time entries to specific intervals ()

Working with Page Break Preview options ()

Using the Analyze Data command (formerly IDEAS button) on the Home tab ()

EOMONTH, EDATE, and related date functions ()

Displaying cell contents in specific chart type, chart titles, and text boxes ()

Using the Advanced filter for unusual filtering and creating unique lists ()

Creating linkage formulas using different worksheets and different workbooks ()

Using 2-digit year entries and adjusting to the 2029 date switch boundary ()

Using FIND, MID, TEXTBEFORE, and TEXTAFTER functions to extract text data ()

Group PivotTable data in different time frames, year, quarter, month, week, and more ()

New TRANSLATE and DETECTLANGUAGE functions uses with foreign languages ()

Working with hidden and visible data in filtered and subtotaled lists ()

Exploring TAKE function capabilities, like replacing the INDEX function ()

Exploring 12 overlooked database functions ()

Contrasting uses of borders and gridlines in displays and printouts ()

Creative and powerful uses of the SEQUENCE function for quick list creation ()

Exploring Excel settings under the File Options General command ()

Conditional Formatting with the INDEX and XMATCH functions ()

Creating and manipulating shapes using the Shift, Ctrl, and Alt keys ()

Working with Excel's new TRIMRANGE function and trim references ()

Accelerate copy/move/insert tasks with dragging techniques ()

Create Custom Lists for specialized sorting and quick data entry for lists ()

Exploring the new Focus Cell on the View tab ()

Use the PIVOTBY function to aggregate values by row and column fields ()

Using the Alt key for for faster menu access and for command shortcuts ()

Calculating with hours, minutes, and times of day ()

Use the new Check Box tool with conditional formatting for dynamic displays ()

Using the GROUPBY function to create a summary of list data via formulas ()

PMT and FV functions: Calculating monthly payments and earnings ()

Use Excel's various count functions: COUNT, COUNTA, COUNTBLANK, and more ()

Insert stock 3D models; move and resize similar images; rotate along three axes ()

Create custom number formats: Display leading symbols, in thousands or millions ()

Using the Allow Edit Ranges command to control cell editing by various users ()

Using Flash Fill to automatically fill in data based on patterns ()

Manipulating PivotTable layouts using Subtotals and Report Layout commands ()

Manage worksheet objects with the Selection Pane (alt+F10) ()

Benefits of using Bar charts: The horizontal version of Column charts ()

Clean up and adjust data with the SUBSTITUTE and REPLACE functions ()

Hide repeating title information to improve readability and restore missing titles ()

Exploring multiple what-if type scenarios with Goal Seek options ()

Transposing data, charts, and using the TRANSPOSE function ()

Filtering lists with the dynamic and colorful slicer feature ()

Using the ISFORMULA function and managing worksheet formula cells ()

Group PivotTable fields on the fly: Create expand/collapse scenarios ()

Creating chart templates and adjusting the default chart type ()

Use the FORECAST sheet tool to create a new worksheet to predict data trends ()

Using the powerful XLOOKUP function with multiple fields ()

Updating and testing sample data (salaries, dates, etc.) quickly ()

Adding shadow boxes to charts and other objects for flair and emphasis ()

Calculating percentages using formulas and the new PERCENTOF function ()

Create custom views ()

Extracting data from an online image ()

Use SORT and FILTER function to create charts based on dynamic arrays ()

Using Ctrl+Shift+V and other quick methods to copy values without formulas ()

Using the new Checkbox button on the Insert tab ()

Quick searching for menu commands with the right mouse button ()

Creating 3D and other formulas that use data from different worksheets ()

Using the new GROUPBY and PIVOTBY functions ()

Random number functions: RAND, RANDBETWEEN, and RANDARRAY ()

Expand, collapse and sort displayed results when using Subtotal ()

Consolidate and split workbooks ()

Create custom and built-in lists to sort and fill in sequences ()

Dynamic sheet name reference with INDIRECT ()

Use AutoSum to simplify and accelerate formula creations ()

Highlight negative positive values with Conditional Formatting and Data Bars ()

Use CEILING and FLOOR for specialized numeric rounding needs ()

Use Freeze Panes and Split to view different worksheet portions ()

Use TODAY and NOW for real-time up-to-date calculations ()

Expand and collapse date displays in PivotTables ()

Apply conditional formatting across data rows ()

Show gain/loss in census figures with the RANK, IF, and LET functions ()

Use keystroke and mouse shortcuts to display and navigate worksheets ()

Compare and contrast multiple column sorting with SORT and SORTBY ()

Create dynamic presentations with Slicers, Filters, and Charts ()

Using XLOOKUP and CHOOSECOLS to return multiple non-adjacent column data ()

Using Excel's Accessibility Checker to follow best practices for those with disabilities ()

Using entire column (or row) references to create more dynamic formulas ()

Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions ()

Tips and techniques for displaying Excel worksheets effectively during presentations ()

Refine chart elements quickly with the powerful and overlooked Quick Layout button ()

Analyze data using TOCOL, TOROW, LARGE, and SMALL ()

Learn about the new Office Theme, the default Aptos Font and new colors in M365 apps ()

Nested use of FILTER, SORT, and CHOOSECOLS functions for selective column retrieval ()

Pros and cons of using Stacked Area charts and Stacked Column Charts ()

Combine a Validation list, XLOOKUP function, table, and chart to build a presentation model ()

Use a single SEQUENCE function to create various date layouts ()

Explore multiple approaches for locating, preventing, and deleting duplicate data ()

Use AGGREGATE to avoid errors and ignore hidden data ()

Locate and track a worksheet's Data Validation rules and violations ()

Show relationships between sets of values with a Scatter(XY) Chart ()

Use the powerful COUNTIF family—8 functions—for statistical analysis ()

Use ALT and other shortcuts when working with AutoComplete, Data Validation, etc. ()

Use Excel's Advanced Options to fine-tune settings and increase efficiency ()

Combine data with the TEXTJOIN, CONCAT, and CONCATENATE ()

Use various techniques to flip lists upside-down or left-to-right ()

Using the AND and OR functions independently or within IF functions ()

Comparing the Data Analysis Histogram feature and Excel's Histogram chart ()

Using SEARCH, FIND, and COUNT to tabulate data occurrences ()

Using wildcards (asterisk, question mark, and tilde) in formulas and commands ()

Sorting by day of month for birthday and anniversary lists ()

Dynamically presenting data via chart slicers ()

Create shapes and text boxes with content linked to worksheet cells ()

Using Indent buttons to control text displays and currency formatting ()

Using Conditional Formatting for analysis and data emphasis ()

Sorting by moving columns left/right - in tables, Pivot Tables, SORT and SORTBY ()

Calculating chronological and fiscal quarters ()

Discovering timesaving tools in the Go To Special feature ()

Manipulating text functions LEFT, MID, and TEXT to create new ID numbers ()

Reviewing Excel Information functions - ISBLANK, ISNUMBER, ISTEXT, etc. ()

Inserting special symbols using AutoCorrect options and the Insert Symbol command ()

Various techniques for highlighting (selecting) cell ranges quickly ()

Contrasating uses of the newer functions: XMATCH and XLOOKUP ()

Calculating day of the week totals from a large transaction list ()

New VSTACK and HSTACK functions ()

Exploring 3-D Column and 3-D Bar charts ()

Create formulas rapidly with these shortcuts ()

Using new BYROW and BYCOL functions to analyze data ()

Using three functions to track worksheet cells that are text, numbers, or formulas ()

Converting charts into pictures ()

Rapid sorting via right-clicking options ()

Advantages and disadvantages of using pie charts to display data ()

An overview of the 12 database functions in Excel ()

Highlighting PivotTable results with conditional formatting ()

Overcoming rounding concerns in formulas with functions and decimal displays ()

Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions ()

Multiple tips for creating charts quickly ()

Working with date and time-based data and the over-24-hour display issue ()

Restructure column/row data using new WRAPROWS and WRAPCOLS functions ()

Rapid filtering by content, cell color, or font color via right-clicking ()

Create new lists by changing the PivotTable Report Layout to Tabular and adding repeating labels ()

Use the TAKE, DROP, FILTER and SORTBY functions to build dependent lists ()

Quickly link cell content for main titles and axis titles for selected chart types ()

Extract text from cells using the new TEXTBEFORE and TEXTAFTER functions ()

Command and keystroke shortcuts for sorting frequently used data ()

Customize and utilize status bar displays and copy/paste its data ()

Try these editing tips and keystroke shortcuts to use with long formulas ()

Locate formula precedents via keystroke shortcuts and the Trace Precedents command ()

Use shrink-to-fit options to adjust the display of cell content and compress printed output ()

Contrast TEXTJOIN, CONCAT, and TEXTSPLIT to gather and split data ()

Filtering lists with AND and OR criteria when using the FILTER function ()

Use bubble charts to show relationships between sets of values ()

Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows ()

Use TOCOL and TOROW to realign array data into single columns and rows ()

Use the IMAGE function to paste an image into a cell ()

Explore icon sets in the Excel Conditional Formatting feature ()

Create multiple PivotTables from a single source ()

Use the UNIQUE, TRANSPOSE, SUMIF, and SUMIFS functions in table formulas ()

Link pictures of data ranges to changing data ()

Redesigned Data Validation feature: Now more efficient when using large lists ()

Create a moving average with a chart or by using a formula ()

Use the FILTER and SORT functions to maintain updated lists and rapidly changing source data ()

Create forms using check boxes and option buttons to simplify data entry ()

Replace text based on formats, like cell attributes (bold, text color, etc.) ()

Locate formula dependencies via keystroke shortcuts and the Trace Dependents command ()

Examples of TRANSPOSE and other functions working differently with the new calculation engine ()

Control gridlines: Change colors, turn them on/off, and assign to a macro button ()

Stock charts: Adding Open, High, Low, Close, and Volume values ()

Use dragging techniques to create a forecast based on TREND and GROWTH functions ()

Use XLOOKUP instead of complex combinations of VLOOKUP, INDEX, and MATCH ()

Use formulas to calculate values across worksheets and workbooks ()

Sort data based on months and weekdays, even when entered as text ()

WordArt Transform: Special text character layouts ()

Use DATEDIF to calculate months or days after yearly or monthly anniversaries ()

Navigation tips: Shortcuts to jump within and between worksheets and workbooks ()

Exploring Edit Default Layout options when using PivotTables ()

Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells ()

Combo charts: Combine different chart types to present data more clearly ()

Use the Advanced Filter for specialized filtering needs ()

Use emojis and other symbols in formulas and charts ()

Transpose data with formula substitution and the TRANSPOSE function ()

Accentuate values with conditional formatting and sparklines ()

Use the Go To Special option to select and populate blank cells ()

Create a 15th day or end-of-month series and adjust to weekdays only ()

Use the Fill Justify command to quickly rewrap text into different cells ()

Unhide multiple worksheets at once and use the very hidden option ()

Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales ()

Create a number series with the Ctrl key and left/right mouse button ()

Use the Quick Analysis tool for easy access to power tools ()

Exploring treemap charts to display hierarchical data ()

Customize the Quick Access Toolbar using the Alt key or a mouse ()

Use Data Validation based on multiple criteria ()

Page Setup tip: Print repeating titles, shrink-to-fit, landscape/portrait, double-spaced layout ()

Creating floating text boxes with shadow, reflection, glow, and other shape effects ()

Exploring Excel's Sunburst chart to display hierarchical data ()

Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it ()

Create map-type charts based on geographical locations ()

Using the Distinct vs. Unique options when using the UNIQUE function ()

Get data analysis suggestions with the Analyze Data (formerly Ideas) tool ()

Make dynamic presentations with rapid expand/collapse detail features in outlining ()

Use keyboard, mouse, and commands to zoom in/out quickly in Excel Windows and Mac versions ()

Calculate time differences within days and across multiple days ()

Using new formula-writing techniques to simplify wide-ranging formulas ()

Five indispensable keystroke shortcuts for Windows and Mac users ()

How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999 ()

Use dragging techniques for faster Paste Special options ()

Calculate dates and/or days of the week for selected future holidays ()

Create a dynamic sheet name reference with the INDIRECT function ()

Sort your data based on a Custom List that you define ()

Get the formula results you want using Goal Seek ()

Use the LAMBDA function to create worksheet functions ()

Use dragging techniques to extend dates by weekdays only, month, or year ()

Create multiple range names from the top row and/or left column ()

Using TRIM, CLEAN and other functions to clean up text data ()

Tips for updating entire columns of date entries when using real or sample data ()

Use the XLOOKUP function with multiple column criteria and multiple column results ()

Contrasting uses of clustered column and stacked column charts ()

Create dynamic pick lists using the UNIQUE and SORT functions, and data validation ()

Conditional formatting using contrasting heat maps on multiple vs.single ranges ()

Using slicers as analytical tools ()

Using wildcards in the new XLOOKUP and XMATCH functions ()

Date calculation and formatting issues related to the 2029/2030 switch ()

Quick number formatting with keystroke shortcuts and icon buttons ()

Conversion of values into binary, octal, decimal, and hexadecimal equivalents ()

SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted ()

Tips for saving time when typing function names ()

Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions ()

How to use exponentiation (powers and roots) in Excel formulas ()

Comparing column charts and bar charts: Pros and cons ()

Refine filtering needs via custom filter options ()

Adjusting text entries with the UPPER, LOWER, and PROPER functions ()

Use the FILTER and UNIQUE functions together for dynamic extractions ()

New data types: Extract valuable online data into your worksheets ()

Remove duplicates from a list vs. creating a new list without duplicates ()

Controlling date entry restrictions using data validation ()

Where does that cell get its data from?: Tracking down cell precedents ()

Multiple built-in date formats as well as tons of self-defined variations; m/d/y and mmm-d-yyyy ()

Use 3D formulas to tabulate data from multiple worksheets with the same layout ()

Fonts such as Arial and Calibri and a rundown of various available fonts in Excel ()

Dynamic array formulas, new ways to calculate: One formula displays results in multiple cells ()

Work with cell colors, patterns, and effects to emphasize data and provide visual flair ()

Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability ()

Use error-checking functions in Excel: IFERROR, ISERR, and ISERROR ()

Create moving averages with formulas and chart trendlines ()

Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash ()

Using the LET function to simplify formulas via programming concepts ()

Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect ()

Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more ()

Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH ()

Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration ()

Use the AGGREGATE function to circumvent errors and ignore hidden data ()

Expand/collapse or sort displayed results when using the SUBTOTAL command ()

Analyze PivotTable data with 13 different Show Values As options ()

Adjust charts quickly with quick layout, change colors, and chart styles options ()

Use the SWITCH function: Compare with IFS, CHOOSE, and other lookup functions ()

Seven different ways to drag data using the Ctrl, Shift, and Alt keys ()

Enhance readability with banded rows via conditional formatting ()

Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more ()

Create a list box to facilitate selection of data from a list ()

Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions ()

Use the new SEQUENCE function to quickly build numeric and date arrays ()

Retrieve vital data based on location using the Geography tool ()

Control worksheet security by allowing selected users to edit specific cell ranges ()

Add flair to charts with these formatting options: Gap width, shadow, glow, 3D, and more ()

Condense lengthy nested IF functions with the newer IFS function ()

Use wildcard symbols in filtering and commands ()

Use wildcard symbols in functions ()

Accelerate Conditional Formatting with the Quick Access Toolbar ()

Use the SUBSTITUTE and REPLACE functions ()

Create range names from Column and Row headings ()

Use the Fill Justify feature to wrap long text ()

Avoid misleading visuals when rescaling ()

File documentation with the Workbook Statistics button ()

Align, arrange, and rotate shapes in worksheets ()

Use various techniques to hide cells, rows, columns, and worksheets ()

Use data validation rules to prevent duplicate entries in a range ()

Use TODAY, NOW, YEARFRAC, and DATEDIF ()

Work with hidden and visible data in filtered and subtotaled lists ()

Create a powerful macro ()

Use the XMATCH function to replace MATCH ()

Highlight milestone data with conditional formatting and cumulative formulas ()

Split or join columnar data with Text to Columns or Flash Fill ()

Display and highlight worksheet formula cells ()

Look forward and backward using EDATE and other date functions ()

Prevent and locate duplicate worksheet entries ()

Work with time calculations in formulas ()

Use data validation rules with special phone and social security formats ()

Use worksheet names in formulas ()

Use the Excel filtering capability for dates ()

Change PivotTable settings for titles and summaries ()

Use the XLOOKUP function to replace VLOOKUP ()

Add formula tools and symbols to the Quick Access Toolbar ()

Use Find and Replace to change cell contents and formats ()

Extract filtered data with data validation and the FILTER function ()

Techniques for creating date series ()

Overcoming obstacles when working with dates in charts ()

Use column or row references to create dynamic formulas ()

Get totals quickly without creating formulas ()

Track variables using the Scenario Manager ()

Use formulas to create interactive charts ()

Insert colorful images with the People Graph Add-in ()

How and when to use an area chart ()

Use the new RANDARRAY function that replaces RAND and RANDBETWEEN ()

Select from over 800 icons to enliven worksheets ()

Simplify the use of special characters and symbols ()

Sort or filter data based on color font or cell color background ()

Discover new formula capabilities with new functions and dynamic arrays ()

Adjust Conditional Formatting rules by altering percentage breakpoints ()

Chart display options with blank cells in source data ()

Calculate loan payments and investments with PMT and FV functions ()

Use themes to adjust worksheet colors, fonts, and effects ()

Use the new SORT and SORTBY functions to extract sorted lists ()

Format macros to make you a more efficient Excel user ()

Creating and updating sample data ()

Using the new UNIQUE function to count and copy unique list entries ()

Working with array formulas more easily ()

Tabulating totals with the VLOOKUP function and array constants ()

Inserting, reshaping, and formatting shapes: Rectangles, arrows, stars, and banners ()

Using the CEILING and FLOOR functions for specialized rounding needs ()

Exploring some of the 200-plus SmartArt graphic options ()

Displaying gridlines, borders, and column/row headings when printing ()

Transposing data and using the TRANSPOSE function ()

Tracking down conditional formatting and data validation rules ()

Display large values ()

Rapid filtering with Filter by Selection ()

Use mixed addresses in Excel formulas ()

Protect worksheets and lock cells ()

How to use the error-checking rules in Excel ()

Create picture links ()

Use chart and filter for presentations ()

Identify weekdays and weekend days in data ()

Helpful keystroke shortcuts ()

Create double-spaced and triple-spaced printouts while repeating column headings ()

Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters ()

Use the LEN and REPT functions for specialized cell testing and display options ()

Auditing cell content with Watch Window and dependent cell formulas ()

Adjusting default layouts and date grouping in PivotTables ()

Column widths, row heights, merging cells, and related formatting issues ()

Using the Solver Add-in ()

Keystroke shortcuts using the Alt key ()

Creating an automatically expanding chart by basing it on a table ()

Using the CONVERT function for different numbering systems ()

Calculating cumulative totals ()

Sorting by moving columns ()

Avoid unintentional entries when typing code numbers ()

Use date functions for age and tenure calculations ()

Control table formatting with custom formats ()

Explore formatting options not available on the Home tab ()

Avoid the #DIV/0 error message ()

Differences and limitations of converting data to a table ()

How to adjust names ()

Conditional formatting based on date proximity ()

Customize your Quick Access Toolbar ()

Use range names for more readable formulas ()

How to covert ROMAN numberals ()

Compare data with EXACT, FIND, and SEARCH functions ()

Extract day, month, and year from date fields ()

Create artistic charts with random numbers ()

Keyboard, mouse, and command techniques for viewing worksheets ()

Identify or extract unique entries in a list ()

Use nonstandard fiscal years and quarters in PivotTables ()

Rank data with the RANK and RANK.AVG functions ()

Use workbook protection to prevent use of sheet commands ()

Use the COUNT and COUNTA functions ()

Fill in all blank cells within a range with either formatting or data ()

Calculate % of change ()

NETWORKDAYS.INTL and WORKDAY.INTL ()

Freeze Panes and Split ()

Create custom lists for letter series like A to Z ()

Converting dates like 20102006 into usable date entries ()

Create numeric formats: Display in thousands or millions ()

Use REPLACE for formats only, for data only, or for both ()

Create on-screen warnings and reminders with comments or data validation messages ()

Create your own customized date and time formats ()

Change the default Excel chart type; create and use chart templates ()

Control phone number and postal code formats using built-in options or customized formats ()

Using Expand/Collapse on PivotTables and PivotCharts for rapid display changes ()

Use the INDIRECT function with intersection formulas and range names to extract data ()

Control gridlines in charts and on worksheets ()

Creating mixed reference formulas; converting to a table; applying conditional formatting ()

Work with formulas and formats: Decimals and fractions ()

A look at new chart types in Excel 2016: Waterfall ()

Sorting tips and shortcuts ()

Vertical and horizontal alignment settings and orientation options ()

View all worksheet names with new Navigation pane on the View tab ()

Using the AND and OR functions independently or within IF functions ()

Ten quick tips to use daily: formulas, formatting, and accessing commands ()

New Excel 2016 chart types: Histogram, Pareto, and box, and whisker ()

Creating cross-totals with the SUMIFS function and mixed references ()

Recognizing Excel Formula errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM, and #NAME! ()

Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character ()

Use the new funnel chart available in Excel 365 ()

Avoiding common chart distortions ()

Use data validation to force entries to be uppercase or lowercase ()

Freezing column and row titles ()

New Excel 2016 chart types: Tree map and sunburst ()

Borders and gridlines: Exploring variations, options, and differences ()

Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions ()

Using WordArt for special titles and headings ()

Exploring font choices not found on the Home tab ()

Working with multiple worksheets simultaneously ()

Using fill effects (gradients, patterns, styles) for colorful cell background variations ()

The Wrap Text, Merge and Center, and Indent options ()

Displaying tips when using Excel in presentations ()

Using the INDEX function to extract data by row and column ()

Creating heat maps using conditional formatting ()

Tips for creating charts quickly ()

Dealing with circular errors ()

Use custom formulas in data validation to keep out bad data ()

Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions ()

AutoFill shortcuts for date series, one/two week intervals, EOM, and formulas ()

Summarize data from different worksheets with a PivotTable ()

Use VLOOKUP, MATCH, and INDEX functions with array formulas ()

Use conditional formatting to overcome formatting limitations of the IF function ()

Tips for creating and updating sample data ()

Displaying multiple worksheets and workbooks together ()

Copy formats quickly using dragging techniques and the Format Painter ()

Creative use of sparklines in merged cells with axes ()

Use conditional formatting data bars to accentuate negative data ()

Working with hidden data when copying cells and creating charts ()

Flip the left-to-right order of columns with the INDEX function or sort by columns ()

Use the FIND, MID, LEFT, and RIGHT functions ()

Use the dynamic TODAY and NOW functions for real-time up-to-date calculations ()

Work with MAX, MAXIFS, LARGE, and related functions ()

Use the Subtotal command to analyze data with single- or multiple-level subtotals ()

Keyboard shortcuts for numeric formats ()

Formula nesting: Using multiple functions in the same formula ()

Create linkage formulas that refer to other worksheets and workbooks ()

Create lists of all 2nd Tuesdays, last Tuesdays. and other date series ()

Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting ()

Use outlining tools to quickly expand and collapse data for dynamic presentations ()

Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative ()

Solve matching issues with matching phone numbers and SS numbers ()

Create an expanded list from a summary using PivotTable techniques ()

How to create frequency tabulations and distributions ()

How to create time interval entries ()

Use Watch Window and other techniques to track changing cells ()

Insert a text box or shape and link a cell's content to it ()

Accelerate data entry with five special techniques ()

Activate the Speak On Enter and Speak Cells features ()

How to use mixed cell references ()

Calculate faster with the AutoSum button and AutoSum keystroke shortcut ()

How and when to use the 10 rounding functions in Excel ()

Change the shape of comment boxes and other objects ()

Adjust banded-row formatting ()

Use Flash Fill to rapidly combine or separate columnar data ()

Alter numeric data without formulas ()

Use the OFFSET function for tabulating moving data ()

Adjust a chart's source data and adjust its series order ()

MAXIFS and MINIFS added to the COUNTIF/SUMIF family of functions ()

Save a chart as a template: Use the template for current or new charts ()

Use slicers and charts together for dynamic presentations ()

Hide worksheets, row, columns, cells and other Excel elements ()

Avoid errors and hidden data with the powerful AGGREGATE function ()

Create dynamic sheet name references with the INDIRECT function ()

Calculate dates efficiently using Excel's hidden function - DATEDIF ()

Creating an Excel template to simplify updating a monthly file ()

Use a data form for data entry and exploring data ()

Use special tricks for working with dates in charts ()

Keystroke shortcuts from A to Z: Using the Ctrl key ()

Work with formulas in tables ()

Replace characters by position with the REPLACE function ()

Use calcuated fields and calculated items in a PivotTable ()

Use random number functions for sorting and creating sample data ()

Set up a macro for sorting dynamic data ()

Using command shortcuts with the Alt key ()

Creating a pick list dependent on another pick list ()

Restoring missing column titles ()

Creating an Excel template ()

Locating data validation rules and violations ()

Working with formulas in tables ()

Join data with new CONCAT and TEXTJOIN functions ()

ADDRESS, ROW, and COLUMN functions ()

Adding pictures as worksheet backgrounds ()

Building a flexible monthly table using functions ()

Drawing borders and border grids ()

Adding comments and shapes ()

Auditing ()

Custom formats, relative addressing, and conditional formatting ()

Using Excel error-checking functions ()

Two-way lookup using the MATCH and INDEX functions ()

Create an organization chart ()

Meeting unusual filtering needs via Advanced Filter ()

Custom formats using asterisk, semicolon, and brackets ()

Using wildcards (asterisk, tilde, and question mark) ()

Handling dates with unusual formats ()

Creating variable conditional formatting rules ()

Creating text, numerical, date, and time lists in a flash ()

Exploring what-if scenarios using Goal Seek ()

Using option buttons, group boxes, and checkboxes to facilitate forms creation ()

Controlling worksheet security by allowing selected users to edit specific cell ranges ()

Using hyperlinks for rapidly switching worksheet locations and jumping to websites ()

Setting up custom views for quick access to different worksheet displays ()

Reducing data entry time by expanding AutoCorrect options ()

Using Go To Special ()

Discovering time-saving tools in the Go To Special feature ()

Tracking down cell dependencies across multiple worksheets and workbooks ()

Calculating with hours, minutes, and times of day ()

Creating colorful 3D buttons for worksheet annotation and macro buttons ()

Using scroll bars and spin buttons to facilitate forms creation ()

Using the TREND and GROWTH functions for projecting future results ()

The top five unknown but useful keyboard shortcuts ()

Quick formatting tips ()

Custom grouping in PivotTables ()

Converting charts into pictures ()

Enhancing table filtering with slicers ()

Creating dynamic charts with in-cell conditional formatting ()

Customizing templates to fit your unique needs ()

Highlighting PivotTable results with conditional formatting ()

Increasing your productivity with custom lists ()

Accelerating Cut, Copy, Paste, and Insert tasks ()

Using source data from a table to make your PivotTable more dynamic ()

Using the REPT function to represent data visually ()

Parsing your data to create unique lists ()

Dynamically presenting data via chart slicers ()

Using formulas to calculate values across worksheets and workbooks ()

Using a pick list, VLOOKUP, table, and chart together ()

Adding illustrations to your workbook ()

Using date and time as metrics in a PivotTable ()

Splitting and consolidating workbooks ()

Exploring various layouts for your PivotTable ()

Applying conditional formatting across rows of data ()

Transposing data and charts for a different perspective on your data ()

Becoming more productive with these 10 tiny tips you'll use often ()

Using check boxes and conditional formatting together for dynamic displays ()

Summarizing data from diverse ranges with Data > Consolidate ()

Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells ()

Using the FORMULATEXT and N functions for worksheet and formula documentation ()

Using list boxes and combo boxes to facilitate forms creation ()

Resizing, moving, copying, and manipulating charts and other objects ()

Hide and unhide worksheets securely ()

162_Freeze_Panes_and_Split_Screens.zip (123 KB)

161_Custom_Lists.zip (123 KB)

160_Date_Format_Conversions.zip (143 KB)

159_Number_Formats.zip (41 KB)

158_Replace_Format_or_Content.zip (164 KB)

157_Comments_and_Reminders.zip (195 KB)

156_Date_Time_Formats.zip (123 KB)

155_Default_Chart_Type_and_Chart_Templates.zip (41 KB)

154_Phone_and_ZipCode_Formats.zip (13 KB)

153_Expand_Collapse_PivotTables.zip (10 KB)

152_INDIRECT_Intersection_RangeNames.zip (18 KB)

151_Chart_gridlines_and_borders.zip (61 KB)

150_Mixed_References.zip (61 KB)

149_Decimals_and_Fractions.zip (21 KB)

163_NETWORKDAYS_and_WORKDAY.zip (31 KB)

164_Percent_change_and_Goal_Seek.zip (21 KB)

166_COUNT_COUNTA_and_Status_Bar.zip (154 KB)

Ex_Files_Excel_Tips_Weekly_2018_Q1.zip (1.3 MB)

180_Table_Differences.zip (246 KB)

179_Date_Proximity_Formatting_final.zip (21 KB)

178_Adjusting_Names.zip (21 KB)

177_Customize_the_Quick_Access_Toolbar.zip (61 KB)

176_Range_Names.zip (174 KB)

175_ROMAN_ARABIC.zip (21 KB)

174_EXACT_FIND_SEARCH_Functions.zip (21 KB)

173_YEAR_MONTH_DAY_WEEKDAY.zip (236 KB)

172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip (72 KB)

171_Zoom_and_Display_Variations.zip (277 KB)

170_Unique_and_Duplicate_Data.zip (225 KB)

169_PivotTable_Date_Grouping.zip (154 KB)

168_Ranking_Data.zip (61 KB)

167_Excel_Sheet_Commands.zip (225 KB)

165_Fill_in_Blanks.zip (164 KB)

126_INDEX_Function.zip (512 KB)

261_Worksheet_Statistics.zip (437 KB)

260_Align_Arrange_Rotate_Shapes.zip (19 KB)

254_XMATCH_Function.zip (39 KB)

253_Cumulative_Formulas.zip (10 KB)

252_Text_Columns_Flash_Fill.zip (11 KB)

250_EDate_EMonth_DatedIF.zip (132 KB)

246_Sheet_Names.zip (76 KB)

245_FilterYearDay.zip (245 KB)

244_PivotTable_Settings.zip (48 KB)

240_Find_Select.zip (161 KB)

231_People_Graph.zip (61 KB)

239_Data_Validation_and_Filter.zip (72 KB)

235_Columns_and_Rows.zip (61 KB)

234_Status_Bar.zip (67 KB)

262_Re_scaling_Column_and_Line_Charts.zip (58 KB)

241_AverageCountSubscript.zip (59 KB)

237_Geographic_Maps.zip (8 KB)

236_Dates_in_Charts.zip (10 KB)

233_ScenarioManager.zip (28 KB)

232_GrowingChart.zip (15 KB)

242_CopyFormats.zip (23 KB)

228_Icons.zip (43 KB)

227_Special_Characters.zip (13 KB)

224_CondFormattingBreakpoints.zip (21 KB)

220_SORT_and_SORTBY_Functions.zip (64 KB)

219_Utility_Macros.zip (17 KB)

226_Sort_by_Color.zip (76 KB)

230_Area_Charts.zip (9 KB)

229_Random_Functions.zip (13 KB)

225_New_Formulas.zip (46 KB)

238_Date_Time_Series.zip (17 KB)

263_Fill_Justify_Wrap_Text.zip (10 KB)

265_SUBSTITUTE_and_REPLACE_Functions.zip (65 KB)

266_Buttons_for_Conditional_Formatting.zip (195 KB)

300_Managing_Duplicate_Data.zip (180 KB)

296_3D_Formulas.zip (20 KB)

295_Fonts.zip (75 KB)

297_Date_Formats.zip (15 KB)

292_Line_Wrap_and_Wrap_Text.zip (23 KB)

301_New_Data_Types.zip (322 KB)

298_Cell_Precedents.zip (32 KB)

294_Dynamic_Arrays.zip (52 KB)

291_Error_Checking_Functions.zip (15 KB)

289_Create_Worksheets_Fast.zip (13 KB)

282_Subtotal.zip (138 KB)

286_Paste_Special_Options.zip (63 KB)

285_XLOOKUP_XMATCH.zip (79 KB)

283_AGGREGATE_Function.zip (241 KB)

290_MovingAverage.zip (37 KB)

288_LET_function.zip (38 KB)

287_Data_Entry_Tips.zip (13 KB)

269_IFS_Function.zip (124 KB)

270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip (31 KB)

271_Protect_Cell_Ranges.zip (56 KB)

272_Geography_Data.zip (16 KB)

276_COUNT_COUNTA_and_COUNTBLANK_functions.zip (53 KB)

277_Banded_Rows_or_Columns.zip (185 KB)

223_BlankCellsInCharts.zip (341 KB)

278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip (63 KB)

273_SEQUENCE_function.zip (448 KB)

274_LEN_SUBSTITUTE_and_TRIM_functions.zip (14 KB)

275_List_Box.zip (130 KB)

279_SWITCH_function.zip (21 KB)

281_PivotTable_Analysis.zip (79 KB)

284_The_F9_Key.zip (21 KB)

280_Chart_Design_Tools.zip (29 KB)

293_Cell_Colors_Patterns_Effects.zip (28 KB)

222_Financial_Functions.zip (9 KB)

216_ArrayFormulaUpdates.zip (131 KB)

264_Names_Based_On_Column_Row_Headings.zip (10 KB)

268_Wildcards_Part_2_Functions_.zip (300 KB)

259_Hide_cells_rows_columns_sheets.zip (177 KB)

257_TODAY_NOW_Date_Functions.zip (59 KB)

256_Macro_Highlight_Formula_Cells.zip (17 KB)

248_Time_Math.zip (49 KB)

243_XLOOKUP_Function.zip (169 KB)

255_Hidden_Visible_Data.zip (87 KB)

251_Find_Highlight_Formula_cells.zip (16 KB)

249_Prevent_Locate_Duplicates.zip (79 KB)

247_Phone_ZipFormats.zip (9 KB)

189_Alt_Key_Shortcuts.zip (21 KB)

194_Watch_Window.zip (113 KB)

192_PivotTable_Settings.zip (72 KB)

258_Prevent_Duplicates.zip (50 KB)

191_Columns_Widths.zip (21 KB)

135_Borders_Gridlines.zip (460 KB)

134_Two_Way_Lookups.zip (378 KB)

133_Weekday_Weekend.zip (538 KB)

132_WordArt_Variations.zip (451 KB)

131_Other_Font_Options.zip (385 KB)

130_Multiple_Worksheets.zip (17 KB)

129_Fill_Effects.zip (26 KB)

128_Wrap_text_Merge_Indent.zip (64 KB)

127_Display_Tips.zip (351 KB)

Ex_Files_Excel_Tips_Weekly_2018_Q2.zip (1.7 MB)

189_Chart_based_on_a_Table.zip (21 KB)

123_Book1.zip (482 KB)

124_Quick_Charts.zip (904 KB)

125_Heat_Maps.zip (53 KB)

190_Solver.zip (92 KB)

267_Wildcards_Part_1_Filter_and_Commands.zip (28 KB)

194_LEN_and_REPT.zip (41 KB)

195_TRIM_and_CLEAN.zip (41 KB)

215_AdvancedFilter.zip (353 KB)

211_GoTo_Special.zip (416 KB)

210_SmartArt.zip (18 KB)

218_Sample_Data.zip (52 KB)

217_UNIQUE_function.zip (42 KB)

212_CEILINGandFLOOR.zip (10 KB)

209_Borders_Gridlines_Printing.zip (17 KB)

206_ConditionalFormatting_and_DataValidation.zip (110 KB)

214_Array_Constants_withVLOOKUP.zip (16 KB)

213_Shapes_and_Stars.zip (16 KB)

208_Transpose.zip (16 KB)

207_CheckBox_ConditionalFormatting.zip (110 KB)

188_CONVERT_Function.zip (21 KB)

187_Cumulative_Totals.zip (21 KB)

186_Sort_by_Moving_Columns.zip (82 KB)

185_Unintentional_Entries.zip (21 KB)

184_Date_Calculations.zip (133 KB)

196_Double_and_Triple_Spaced_Printing.zip (164 KB)

197_Helpful_Keystroke_Shortcuts.zip (328 KB)

198_Weekdays_and_Weekends.zip (277 KB)

199_Charts_and_Filters.zip (21 KB)

200_Linking_Pictures.zip (113 KB)

201_Error_Checking_Indicators.zip (358 KB)

221_Themes.zip (41 KB)

202_Worksheet_Protection.zip (61 KB)

204_Filter_by_Selection.zip (82 KB)

205_Displaying_Large_Values.zip (38 KB)

Ex_Files_Excel_Tips_Weekly_2018_Q3.zip (1.7 MB)

181_Avoiding_DIV_Error.zip (31 KB)

182_FormattingOptions.zip (246 KB)

183_New_Table_Style.zip (133 KB)

203_Mixed_Cell_Addresses.zip (21 KB)

299_Date_Controls_with_Data_Validation.zip (17 KB)

302_FILTER_and_UNIQUE_functions.zip (57 KB)

303_UPPER_lower_Proper.zip (14 KB)

304_Custom_Filter.zip (80 KB)

26_01_Column_and_Bar_Charts.zip (34 KB)

26_02_Powers_and_Roots.zip (25 KB)

26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip (480 KB)

26_04_Function_Names.zip (105 KB)

26_05_SUM_SUMPRODUCT_SUMIF.zip (1.4 MB)

26_06_Binary_Octal_Decimal_Hexadecimal.zip (40 KB)

26_07_Numeric_Formatting.zip (21 KB)

26_08_Dates_and_the_1930_2029_split.zip (12 KB)

26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip (99 KB)

26_10_Slicers_Analysis.zip (136 KB)

26_11_Heat_Maps.zip (61 KB)

26_12_Validation_with_UNIQUE_and_SORT_functions.zip (61 KB)

26_13_Clustered_vs_Stacked_Chart_Types.zip (44 KB)

27_01_XLOOKUP.zip (163 KB)

27_02_Update_Date_Entries.zip (118 KB)

27_03_Eliminate_Spaces_and_Special_Characters.zip (17 KB)

27_04_Create_Range_Names_From_Headings.zip (20 KB)

27_05_Date_Series_Creation.zip (12 KB)

27_06_LAMBDA_Function.zip (72 KB)

27_07_Goal_Seek.zip (316 KB)

27_08_Sort_by_Custom_List.zip (81 KB)

27_09_INDIRECT_function.zip (25 KB)

27_10_Holiday_Calculations.zip (21 KB)

27_11_Paste_Special_Drag_Options.zip (300 KB)

27_12_SS_Numbers.zip (96 KB)

28_01_Five_Invaluable_Keystroke_Shortcuts.zip (167 KB)

28_02_New_Formula_Techniques.zip (268 KB)

28_03_Time_differencees.zip (48 KB)

28_04_Zoom_Techniques.zip (81 KB)

28_05_Outlining_Tools.zip (207 KB)

28_06_Analyze_Data.zip (258 KB)

28_07_UNIQUE_Unique_vs_Distinct.zip (51 KB)

28_08_Screen_Snip.zip (1.2 MB)

28_09_Sunburst_Charts.zip (667 KB)

28_10_Shadow_Glow_Reflection.zip (854 KB)

28_11_Printing_Tips.zip (79 KB)

29_01_Data_Validation_Multiple_Criteria.zip (15 KB)

29_02_Quick_Access_Toolbar_QAT_Tips.zip (36 KB)

29_03_Treemap_Charts.zip (666 KB)

29_04_Quick_Analysis_Button.zip (171 KB)

29_05_Dragging_Number_Cells.zip (13 KB)

29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip (22 KB)

29_07_Hide_Unhide_Worksheets.zip (616 KB)

29_08_Fill_Justify_Re_wrap_text.zip (17 KB)

29_09_Date_Series_15th_and_Month_End.zip (11 KB)

29_10_Filling_Blank_Cells.zip (106 KB)

29_11_Sparklines_and_Conditional_Formatting.zip (16 KB)

29_12_Transpose.zip (23 KB)

30_01_Emojis_and_Pictures.zip (408 KB)

30_02_Advanced_Filter.zip (173 KB)

30_03_Combo_Charts.zip (14 KB)

30_04_MID_SEQUENCE_LEN_Functions.zip (489 KB)

30_05_PivotTable_Settings.zip (78 KB)

30_06_Navigation.zip (568 KB)

30_07_DATEDIF_Function.zip (108 KB)

30_08_Word_Art_Transform.zip (198 KB)

30_09_Dates_Months_Weekdays.zip (158 KB)

378_TOROW_and_TOCOL_functions.zip (17 KB)

IMAGE_Function.zip (143 KB)

31_12_Conditional_Formatting_Icons.zip (142 KB)

31_11_Multiple_PivotTables_from_one_source.zip (53 KB)

31_10_SUMIF_and_SUMIFS.zip (53 KB)

31_09_Picture_Links.zip (74 KB)

31_08_Data_Validation.zip (112 KB)

31_07_Moving_Average.zip (16 KB)

379_Formulas_with_hidden_rows.zip (377 KB)

31_06_SORT_and_FILTER_Functions.zip (178 KB)

31_04_Replace_Formats.zip (115 KB)

31_03_Dependencies.zip (528 KB)

31_02_Formulas_Changes.zip (71 KB)

31_01_Gridlines_On_Off.zip (15 KB)

30_13_Stock_Charts.zip (1.5 MB)

30_12_TREND_and_GROWTH.zip (18 KB)

30_11_XLOOKUP_Solutions.zip (23 KB)

30_10_Linkage_Formulas.zip (22 KB)

31_05_Option_Buttons_and_Check_Boxes.zip (29 KB)

380_Bubble_charts.zip (17 KB)

381_CONCAT_TEXTJOIN_TEXTSPLIT_functions.zip (18 KB)

382_Shrink_to_fit_options.zip (108 KB)

383_Precedent_Cells.zip (394 KB)

384_Formula_editing.zip (84 KB)

385_Status_Bar_Control.zip (94 KB)

386_Sorting_Tips.zip (104 KB)

387_TEXTBEFORE_TEXTAFTER.zip (22 KB)

388_Quick_Chart_Titles.zip (357 KB)

390_TAKE_DROP_FILTER_SORTBY.zip (227 KB)

391_Pivot_Table_Detail.zip (134 KB)

392_Right_click_Filtering.zip (663 KB)

393_WRAPROWS_and_WRAPCOLS_Functions.zip (33 KB)

394_Dates_and_Times.zip (61 KB)

395_Creating_Charts_Quickly.zip (18 KB)

396_CHOOSEROWS_and_CHOOSECOLS_Functions.zip (70 KB)

397_Decimals_Rounding_Formulas.zip (9 KB)

398_Pivot_Table_Formatting.zip (190 KB)

399_DB_Functions.zip (125 KB)

400_Pie_Charts.zip (17 KB)

401_Quick_Sorting.zip (156 KB)

402_Charts_to_Pictures.zip (429 KB)

402_Tracking_Cell_Types.zip (544 KB)

403_BYROW_and_BYCOL_Functions.zip (185 KB)

404_Formula_Shortcuts.zip (769 KB)

405_3_D_Column_and_Bar_Chart.zip (56 KB)

406 _VSTACK_and_HSTACK_functions.zip (61 KB)

407_Calculating_by_Day_of_the_Week.zip (173 KB)

408_XMATCH_and_XLOOKUP.zip (12 KB)

409_Select_Cell_Ranges.zip (158 KB)

410_Inserting_Symbols.zip (143 KB)

411_Using_IS_Information_functions.zip (66 KB)

412_Using_LEFT_MID_TEXT_functions.zip (43 KB)

413_Edit_Go_To_Options.zip (214 KB)

414_Fiscal_Year_Calculations.zip (76 KB)

415_SORT_Left_Right.zip (112 KB)

416_Conditional_Formatting_Analysis.zip (26 KB)

417_Indenting.zip (31 KB)

418_FILTER_AND_OR_Functions.zip (112 KB)

419_Shapes_Linked_to_Worksheet_Cells.zip (26 KB)

420_Slicers_with_Charts.zip (48 KB)

421_Sort_by_Day_of_Month.zip (92 KB)

422_Wildcards.zip (106 KB)

423_FIND_SEARCH_COUNT_Functions.zip (64 KB)

424_Histogram_Charts.zip (125 KB)

425_AND_and_OR_Functions.zip (66 KB)

426_Flipping_Lists.zip (83 KB)

427_TEXTJOIN_CONCAT.zip (18 KB)

428_Excel_Options.zip (199 KB)

429_Alt_key_shortcuts.zip (525 KB)

430_COUNTIF_family.zip (58 KB)

431_Scatter_XY_Charts.zip (174 KB)

432_Tracking_Data_Validation.zip (78 KB)

433_AGGREGATE_Function.zip (324 KB)

434_Duplicate_Data.zip (88 KB)

435_SEQUENCE_Function.zip (17 KB)

436_Tables_Validation_XLOOKUP_Chart.zip (20 KB)

437_Stacked_Column_and_Area_Charts.zip (65 KB)

438_FILTER_SORT_and_CHOOSECOLS_functions.zip (758 KB)

440_New_Office_Theme.zip (3.2 MB)

441_TOCAL_LARGE_SMALL.zip (60 KB)

442_Chart_Quick_Layout_Options.zip (20 KB)

443_Display_and_Presentation_Tips.zip (179 KB)

444_WORKDAY_NETWORKDAYS_SEQUENCE.zip (19 KB)

445_Column_and_Row_References.zip (58 KB)

446_Accessibility.zip (385 KB)

447_XLOOKUP_multiple_column_return.zip (87 KB)

448_Charts_with_Filters_and_Slicers.zip (47 KB)

449_SORT_and_SORTBY_functions.zip (233 KB)

450_Navigation_Tools.zip (494 KB)

451_Using_RANK_and_LET_functions.zip (35 KB)

452_Conditional_Formatting_across_Rows.zip (1008 KB)

453_PivotTable_Dates.zip (150 KB)

454_TODAY_and_NOW_Functions.zip (47 KB)

455_Freeze_and_Split.zip (387 KB)

456_Rounding_functions_CEILING_and_FLOOR.zip (11 KB)

457_Data_Bars.zip (223 KB)

458_AutoSum_Tips.zip (18 KB)

459_INDIRECT_Function.zip (47 KB)

460_Custom_Lists.zip (129 KB)

461_Split_Consolidate.zip (36 KB)

462_Subtotals.zip (182 KB)

463_Random_Functions.zip (65 KB)

464_Ten_Quick_Tips.zip (19 KB)

465_GROUPBY_and_PIVOTBY_Functions.zip (241 KB)

466_Formulas_based_on_different_worksheets.zip (16 KB)

467_Command_Locator.zip (368 KB)

468_Check_Box.zip (71 KB)

469_Paste_Values.zip (425 KB)

470_Chart_Array_SORT_FILTER.zip (43 KB)

471_Extract_data_from_picture.zip (90 KB)

472_Custom_Views.zip (70 KB)

473_PERCENTOF.zip (22 KB)

474_Navigation_Pane.zip (336 KB)

475_Shadow_Boxes.zip (1.6 MB)

476_Updating.zip (48 KB)

477_XLOOKUP_multiple_columns.zip (95 KB)

478_Forecast_Tool.zip (355 KB)

479_Default_Chart_Type_Chart Templates.zip (23 KB)

480_Group_Pivot_Table_Fields.zip (49 KB)

481_ISFORMULA_and_Formula_Auditing.zip (47 KB)

482_Filtering_with_Slicers.zip (93 KB)

483_TRANSPOSE.zip (81 KB)

484_Goal_Seek.zip (78 KB)

485_Repeating_Tiles.zip (328 KB)

486_SUBSTITUTE_and_REPLACE_functions.zip (71 KB)

487_Bar_Charts.zip (39 KB)

488_Selection_Pane.zip (1.1 MB)

489_Pivot_Table_Layouts.zip (75 KB)

490_Flash_Fill.zip (24 KB)

491_Cell_Protection_Schemes.zip (192 KB)

492_Number_Formats.zip (29 KB)

493_3D_Models.zip (18.3 MB)

494_COUNT_COUNTA_COUNTBLANK_ISBLANK.zip (46 KB)

495_PMT_and_FV_Functions.zip (256 KB)

496_GROUPBY_Function.zip (95 KB)

497_Check_Box_Conditional_Formatting.zip (566 KB)

498_Time_Math.zip (85 KB)

499_Alt_Key_Shortcuts.zip (190 KB)

500_PIVOTBY_Function.zip (51 KB)

501_Focus_Feature.zip (733 KB)

502_Custom_Lists.zip (134 KB)

503_Dragging_Techniques.zip (139 KB)

504_TRIMRANGE_and_new_address_symbol.zip (547 KB)

505_Shapes.zip (125 KB)

506_XMATCH_and_INDEX.zip (27 KB)

507_Files_Options_General_Settings.zip (912 KB)

508_SEQUENCE_Function.zip (472 KB)

509_Borders_Gridlines.zip (318 KB)

510_Database_Functions.zip (196 KB)

511_TAKE_Function.zip (22 KB)

512_Hidden_Visible_Data.zip (147 KB)

513_TRANSLATE_and_STCTLANGUAGE.zip (31 KB)

514_PivotTable_Time_based_Grouping.zip (599 KB)

515_FIND_MID_TEXTAFTER_TEXTBEFORE_Functions.zip (27 KB)

516_2_digit_Year_Displays.zip (403 KB)

517_Multi_worksheet_Formulas.zip (17 KB)

518_Advanced_Filter.zip (214 KB)

519_Titles_linked_to_Charts_and_Shapes.zip (391 KB)

520_EOMONTH_EDATE.zip (118 KB)

521_Analyze_Data.zip (147 KB)

522_PageBreakPreview.zip (327 KB)

523_Time_Math.zip.zip (44 KB)

524_Chart_Efficiency.zip (24 KB)

525_PivotTable_Consolidation.zip (20 KB)

526_UNIQUE_and_FILTER_functions.zip (91 KB)

527_TEXTSPLIT.zip (27 KB)

528_List_and_Combo_Boxes.zip (25 KB)

529_Information_Functions.zip (36 KB)

530_Go_To_Special.zip (240 KB)

دانلود فایل فشرده

با توجه به امکانات آموزش و همچنین امکانات بسته انتخاب شده لینک دانلود فایل فشرده آماده خواهد شد. با در نظر داشتن این شرایط لطفا بسته مورد نظر خود را انتخاب کرده و روی دکمه درخواست لینک دانلود کلیک کنید

در حال به روزرسانی اطلاعات

درخواست لینک دانلود

در حال به روزرسانی اطلاعات

لطفا قبل از فعالسازی لینک دانلود به موارد زیر توجه کنید:

پسورد فایل‌های فشرده است.
لینک‌های آماده شده تا 8 روز پس از فعالسازی منقضی خواهند شد.
حجم فایل‌ها تخمینی هستند.
در صورتی که لینک دانلود تا 15دقیقه پس از درخواست آماده نشد، از بخش پشتیبانی پیگیری نمایید.