Get a new productivity-boosting tip every Tuesday from Excel expert Dennis Taylor.

Syllabus

Excel Tips: New This Week

Powerful uses of the new COPILOT function with other Excel functions

Previous Episodes

Accentuating Positive/Negative values with Conditional Formatting
Using the XLOOKUP, VLOOKUP, and HLOOKUP functions for approximate matches
Update and alter numeric data using Paste Special options instead of formulas
Filtering Tables using slicers and the AGGREGATE function
Accelerate data entry with a variety of special techniques
Utilize AI tools to analyze your data with the powerful Copilot feature
Rearranging data with TOROW/TOCOL and WRAPCOLS/WRAPROWS functions
Creating dynamic charts with in-cell conditional formatting
How to use date functions: TODAY, NOW, YEARFRAC, and DATEDIF
Using date and time as metrics in a PivotTable
Using Pick list, XLOOKUP, Table, and Chart together
Using the new COPILOT function to clean up and categorize your existing data
Calculating unusual workday patterns with WORKDAY.INTL and NETWORKDAYS.INTL
Use Data Validation rules to prevent duplicate entries in a range
Using the REPT function for in-cell charting and other number display variations
Use Scenario Manager to store and rapidly recall different sets of values
Use SWITCH, IFS, and CHOOSE functions, contrasted with XLOOKUP
Collapse and expand column and row totals with the Excel AutoOutline feature
Altering the left-right order of columns with SORTBY, CHOOSECOLS, and the Sort command
Discovering time-saving tools in the Go To Special feature
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