Contextures

Contextures Newsletter Article Index

From January 17, 2012 to November 30, 2021, Contextures published an Excel newsletter, filled with Excel shortcuts, function examples, pivot table tips, dashboard ideas, time-saving macros, and much more.

The newsletters also had links to useful Excel articles on other websites, to help you keep up to date with the latest spreadsheet news.

If you're looking for previous newsletter articles, check the interactive list of articles, shown below. You can sort any column, by clicking on its heading. Or, use the Search box above the list, to find specific articles.

Interactive Excel Newsletter Index

How to use this interactive list:

  • Sort: Click any heading cell, to sort by that column. Click again to change sort order.
  • Number: Select the number of articles (entries) that you want to see per page
  • Search: Type a topic in the Search box to see all the issues with that topic.
  • Read: Click the link in the first column, to go to that issue of the newsletter
  • NOTE: Details for older newsletters will be added as soon as possible.

Issue

Articles

Topics

Notes

20211130 10 Years of Tips; Interactive Filter; Quick Tip - Flash Fill; Keep in Touch; These are Frying Times Spill functions; Advanced filter; Slicers; Macros; Flash Fill; Formulas; Data validation Final Issue; Newsletter index; FILTER function; Choose criteria; SORT function; UNIQUE function; Split first and last names; Split addresses; 7-in-one kitchen appliance
20211116 Flexible Formula; Every 3rd Item; Excel Features; Pivot Table Fun; Charts; Read the Manual Functions; Formulas; Excel Features; Pivot Tables; Charts RANK function; OFFSET function; FILTER function; ROW function; Jon Acampora; Book Riot; Jon Peltier; Robot vacuum
20211102 Quick Tip: Formatting; Advanced Filter Magic; Spreadsheet Review; Excel Games; Spreadsheet History; Future Excel Expert Mouse Shortcuts; Keyboard Shortcuts; Advanced Filter; Macros; Workbook Tips Fill Formatting Only; Send Data to Different Sheet; ICAEW; Review a Spreadsheet; Spreadsheet Principles; Robert Gascon; Chess Game Viewer; Andrew Moss
20211019 Excel Checklist; Convert Measurements; Spreadsheet Day; Excel Functions; Data Cleaning Workbook tips; Excel functions; Excel history; Data analysis Matthew Kuo; Inspect Workbook; Bill Manville; Find Links; Comment macros; CONVERT function; Recipe calculator; Tiller site; Martin K; Data cleaning macros
20211005 Compare Years, Add Blank Rows; Spreadsheet Day; Excel Conference; Formulas; Safety First Excel chart; Pivot Table; Data Entry; Spreadsheet Day; Functions; Excel History Line Chart; Clustered Stacked Chart; Insert Blank Rows; Excel Virtually Global; Morning Brew; Fire Extinguisher; Excel history
20210921 Duplicate Numbers; Excel Blogs; New Excel Features; Formula Problems; 20 Years Remove Duplicates; Functions; Excel Blogs; Microsoft MVP Award Duplicates left in list; EXACT function; Worksheet XML file; Floating point precision; Planning Skills site; Browser bookmark; Mynda Treacy; Joseph Burton; Excel forums
20210907 Hide Used Items; Assign Players; Excel Resources; Formulas; Canadian Mystery Data Validation; Excel Functions; Excel videos; Excel Blogs Drop down list; SORT function; FILTER function; Golf schedule; Excel YouTube; Excel blogs; Hjalmar Gislason; Excel grid; Mystery writer Louise Penny
20210810 Power Query Problem; Zoom In; Merge or Not; Dashboards; Stargazers Power Query; Worksheet Tips; Dashboards; Merge Cells; Data Validation Ken Puls; Miguel Escobar; Master Your Data book; Queries and Connections pane; Zoom to Selection; Color Selector; Merge Cells; Jon Acampora; Mynda Treacy; Lilies
20210727 Drop Down Blanks; Microsoft Survey; Data Analysis; Add-ins; Celebration Data Validation; Programming; Data Analysis; Add-ins Drop down troubleshooting; User Defined Functions (UDFs); Excel Add-ins; Day of Data; Orcas; Jan Karel Pieterse; 90th birthday
20210713 Header Font Size; Office Scripts; Power BI; Movies; Garden Gold Page Layout; Automation; Power BI Headers and footers; Font size; Office Scripts; Jan Karel Pieterse; Matt Allington; Excelerator BI; Babe movie; Tomatoes
20210629 Rolling Totals; Power BI; Excel Battle; Spreadsheets; Strange Combo Excel Functions; Power BI; Spreadsheets SUMIF function; EOMONTH function; Jordan Goldmeier; Excel TV; Power BI dashboard; Chris Matyszezyk; Excel alternatives; Beer and cheese tasting
20210615 Date Range Totals; New or Old; Excel Battle; Secret Features; Garden Hearts Functions; Pivot Tables; Sorting; Excel Versions SUMIFS function; Date range; Pivot table sorting; Financial modelling; DATEDIF function; Google sheets; Bleeding hearts
20210601 Auto or Manual Calc; Workbook Stats; Saving Time; Power BI; Snow Calculation Mode; Gridline Colour; Macros; Status Bar; Power BI Calculation mode macro; UniMord; Workbook statistics; US airbase Kuwait; Macro time saving; Matt Allington; Chris Webb; May snow
20210518 Double-Sorted List; Custom Number Format; Dashboard; Excel Weekend; Garden Plans Data Validation; Spill Functions; Formatting; Dashboards; Excel Events SORTBY function; MAXIFS function; Spill functions; Latest used items at top; Drop down list; Custom number format; Inch mark; Unicode; Dr. Markus Kuhn; Chandoo
20210504 Fix MATCH Errors; Functions; Office Scripts; Excel Plans; Fridge Bins Excel errors; Excel functions; Office Scripts; Programming; Excel roadmap Text numbers; Double unary; Norm Harker; Game of Life; Brian Jones; Forward Thinking CFO podcast; Real Life Organizing; Cassandra Aarssen
20210420 Reverse Names with MID; Power Query; Challenges; Excel; Spring Sky Functions; Power Query; Challenges MID function; FIND function; LEN function; Reverse names; Jon Acampora; Bill Jelen; Explain Excel; April snow
20210406 Currency Format; Hide Used Items; Charts; Programming; Excel Challenge; Spring (Not) Cleaning Conditional Formatting; Data Validation; Charts; Macros; Functions Conditional formatting currency; Drop down lists; FILTER function; Carsten Sandtner; Analyst Cave; Robert Gascon
20210323 Pivot Chart Number Format; Formula Troubleshooting; Charts; Excel Tools; Celebrations Pivot Tables; Number Formatting; Functions; Charts; Excel Add-ins Pivot Chart; Axis Format; Trace Precedents; Audit Formulas; Dermot Balson; Formula Cell Colour Code macro; Jon Peltier; Sketchplanations; Jan Karel Pieterse; GitHub VBA Exporter; Daylight Saving Time
20210309 Formula Wildcards; IF Function; Power BI; Microsoft; Challenge; Lotus 1-2-3 Wildcards; Excel Functions; Power BI; Spreadsheets AVERAGEIF function; Wildcards; IF function; Nested IFs; Power BI; IEACW; Simon Hurst; Spreadsheet Knowledge Base; Matt Allington; Reddit AMA; Robert Gascon
20210223 Hyperlinks Oddity; Line Breaks; Charts; Microsoft; Challenge; Bird Feeder Hyperlinks; Macros; Data Entry; Find and Replace; Shortcuts; Charts; Formulas Text to Display; Alt+Enter; Ctrl+J; Kaiser Fung; Excel Reddit AMA; Robert Gascon; Cardinal
20210209 Comments Macro; Mouse Wheel; Functions; Challenge; Dashboards; Scottish Summit; Office Shelves Comments; Programming; Excel Tips; Dashboards Threaded Comments; Microsoft Word; Mouse Shortcuts; LAMBDA function; Analyst Cave; Mike James; Excel Hash; Jon Acampora; Mynda Treacy; Microsoft 365; Weekly Meal Planner
20210126 TEXTJOIN Line Breaks; Drop Down Trick; Excel Tips; XLOOKUP; Big Font Keyboard Functions; Data Validation; Excel Tips TEXTJOIN function; FILTER function; Line breaks; Drop down lists; Susan Harkins; big font keyboard
20210112 Quick Division; Data Bars; Charts; Tables; City Streets Data Entry; Conditional Formatting; Charts; Excel Tables Paste Special; Pivot Table Data Bars; Junk Charts; Kaiser Fung; Jon Acampora; Table Tips; City Roads Github
20201215 Count Words; Spell Check Problem; Excel VBA; New Function; Zoom Christmas Functions; Data Entry; Excel Training; New Functions Google Sheets SPLIT function; LEN function; SUBSTITUTE; FILTERXML; Spell Check; Excel Options; Charlie Nuttelman; Coursera; LAMBDA; Taskmaster; Gingerbread house
20201201 Holiday Excel; Troubleshooting; YouTube; Spreadsheets; Record Snow Holiday templates; Count Functions; Excel videos; Excel training Holiday planner; Advent calendar; Christmas tree; Formula challenge; YouTube search; University of York; Excel guides; Google Sheets guides
20201117 Show Difference; Custom Questions; Charts; Data Viz; Beer and Cheese Pivot Tables; Conditional Formatting; Charts; Data Viz Custom Calculations; Show Values As; Difference From; Hidden questions; Jon Peltier; Chandoo; Stonehooking; Gurth Pretty
20201103 MIN and MAX Criteria; Filter Time Saver; Dashboards; Power Query; November Functions; Filters; Dashboards; Power Query MINIFS function; MAXIFS function; AutoFilter; Quick Access Toolbar (QAT); Mynda Treacy; Dashboards; Erik Svensen; Power Query
20201020 Spill Formulas, Running Total Problem; Spreadsheet Day; Excel Tips; Spreadsheet Risks; Formulas; Ready for Winter Functions; Spreadsheets; Excel Tips Dermot Balson; Dynamic arrays; Excel Tables; Toronto Excel User Group; Rob Collie; Jon Acampora; ICAEW; David Lyford-Smith; Kevin Lehrbass; weighted blanket; masks
20201006 Excel Looks Strange; Project Tasks; Excel Tips; Dashboards; Good Start Excel Options; Data Validation; Dashboards Missing scroll bars; Optimize for Compatibility; Project Task Tracker; Eric Griffith; Kelly L. Williams; Rainbows; Spreadsheet Day
20200922 Dynamic Lists - FILTER; Check Box Trick; Spreadsheets; Ignite 2020; Fall Colours Functions; Check Boxes; Macros; Spreadsheets; Conferences Spill functions; SORT function; UNIQUE function; FILTER function; Check box macro; Toronto Excel User Group; Spreadsheet Day; Microsoft Ignite; Yew tree
20200908 Compact Hyperlink Buttons; TEXTJOIN Examples; Checklist; Navigation; Fall Lilacs Hyperlinks; Shapes; Functions; Charts; Comments AlexJ; Worksheet buttons; CONCATENATE; TEXT function; Robert Mundigl; Lilacs
20200825 Table Drop Downs; Formula Tricks; Learning; Power BI; Land Shark Data Validation; Functions; Data Science; Data Viz Dynamic array functions; dependent drop downs; Function arguments; Gordon Shotwell; Grace Teoh; Dog life jacket; Saturday Night Live
20200811 Slicer Groups; Date Problems; Excel Dashboards; Programming; Resources; New Laptop Pivot Tables; Data Entry; Dashboards; Macros; Excel Training; Excel Options Pivot Table values; Gene codes; Text Import Wizard; Mynda Treacy; University of Colorado; Dalhousie University; Ribbon Customization; Excel settings
20200728 Multi-Criteria Lookup; Pivot Table Trick; Hard Work; Documentation; Stormy Day Excel functions; Pivot Tables; Programming; Technical Writing Product code formula challenge; FILTER; INDEX/MATCH; Pivot Table shortcuts; Field Settings; Mark Lacey; Sandy Maguire; Tornado
20200714 Where's Workspace; Hide or Show Errors; Data Viz; Charts; Early Harvest Macros; Workbook Tips; Conditional Formatting; Formulas; Data Viz; Charts Discontinued features; Excel Workspace; List open workbooks; Multiplication practice; Highlight errors; Sara DeLong; Style guides; Jon Schwabish; Fireworks chart; Tomatoes
20200630 Date Challenge; Show Your Name; Product Update; Dashboards; Music; Phase Two Functions; Excel Options; Excel Products; Dashboards; Macros Date Functions; TEXT function; UniMord; User Name; Microsoft Word; Insert Note; UserForms for Data Entry; Spencer Baucke; David Napoli; Dylan Tallchief; Kottke
20200616 Day 44000; Choose Names; Power BI; Charts; Tumbling Tom Excel Dates; Macros; Excel Functions; Power BI; Charts Excel date system; Excel milestones; INDEX/MATCH; Golf tee off times; Power BI Global Virtual Converence; Robert Mundigl; Tomato plants
20200602 Excel Names; Table Problem; Security; Formulas; Procrastibaking Defined names; Excel Tables; Formulas; Excel Macros; Security List all names; See range names; Table references in formulas; Copy formulas; Excel 4 macros; XLOOKUP; Chandoo; Breakfast cookies
20200519 Sort Fiscal Months; Fractions; Excel Tips; Dashboard; Flowers and Penguins Functions; Number Formats; Excel Training; Dashboards Fiscal year, quarter, month; CHOOSE; TEXT; Number format; SUBSTITUTE; University of Edinburgh; Ingeborg Hawighorst; Power BI; Origami
20200512 Validation Troubleshooting; Excel Courses; Colour Banding; Mouse Wheel; Clean Your Data; Fancy Slicers; Sprouts Data Validation; Excel Training; Conditional Formatting; Excel Shortucts; Data Cleansing; Slicers Sheet details macro; List all data validation rules; Excel Tools add-in; Mynda Treacy; Excel MVPs; Jon Peltier; Investintech; Mike Alexander; Chick pea sprouts; Victoria Day
20200505 Colour Banding; Pivot Shortcut; Formula Challenge; Excel Tips; Spreadsheets; Excel Skills; More Flowers Conditional Formatting; Excel Tables; Pivot Tables; Functions; Excel Tips; Excel Training Alternating colour bands; Chip Pearson; Mouse scroll wheel; Expand and collapse pivot table; Formula challenge solutions; Wyn Hopkins; Reddit; Impressive spreadsheets; University of Colorado; Garden
20200428 AutoFill Tricks; Dashboards; Formulas; Excel Resources; Spring Flowers Data Entry; Dashboards; Functions; Websites AutoFill; Fill Handle; Fill Series; Dashboards; Project Management; Mynda Treacy; Kevin Lehrbass; Wind Chill; Excel TV; Narcissus
20200421 Row Height Quick Tip; Challenge Solutions; Functions; Speed; Face Masks Formatting; Formulas; New Functions; Performance Row AutoFit; Worksheet Tips; Formula Challenge; Sum functions; Mynda Treacy; Excel Performance; Aplat face mask pattern
20200414 Formula Challenge; UserForms; Show/Hide Worksheets; Easter Eggs; Exercise; Logic; Baking Bread Functions; UserForms; Macros; Worksheets; Puzzles Sum even and odd weeks; SUMPRODUCT; ISODD; ISEVEN; Option buttons; Check box; List; Show specific sheets; Excel macros; Chandoo; Easter Eggs; Frédéric Le Guen; Yeast
20200407 Which Workbook; Fix Slow Workbooks; Food Inventory; Collaborate; Dashboards; Online Lessons Workbook Tips; Sheet Tabs; Calculations; Excel Templates; Microsoft Teams; Dashboards Sheet tab colour; Open Read Only; FastExcel; Meal Planner with inventory; Ed Bott; Robert Mundigl; Table Slicers; FaceTime art sessions
20200331 Quick Backup Tool; Excel Error; Pivot Items; Power BI; Formula Challenge; In the Garden Macros; Workbook Tips; Pivot Tables; Excel Errors; Power BI; Formulas Free Backup Tool; Pivot Table refresh error; UniMord; Data Model; Pivot Items; Eugene Meidinger; Chandoo; Day Lilies
20200317 Error Message Trick; Formula Check Box; Be Careful; Functions; No Hoarding Excel Errors; Functions; Check Box; Macros Hidden error message number; Form control check box; Trustwave; Diana Lopera; Excel 4.0 macro; Function examples; Canada Food Board
20200310 Nth Weekday; Visible Rows Only; Don't Worry; Programming; Bee Happy Date Functions; Pivot Tables; Data Science; Programming Chip Pearson; WEEKDAY function; Thanksgiving date; Tyler Folkman; Think Like a Coder; TED-Ed; Zines
20200303 Sheet Navigation; Pivot Problem; Excel Problems; Name Manager; Advanced Excel Hyperlinks; Functions; Data Entry; Pivot Tables; Excel Tips; Named Ranges HYPERLINK function; First empty cell; Pivot Item captions; Computer problems; Bill Jelen; Jan Karel Pieterse; Steve Dalton
20200225 New Excel Functions; Quick Tip - Empty Cells; Copy Paste; Large Files; Office App; Pancake Day Functions; Dynamic Arrays; Excel Tips; Mobile Apps Dependent drop downs; Dynamic arrays; SORT function; UNIQUE function; FILTER function; Spill operator; Larry Tesler; Luke Dormehl; Kevin Languedoc; Easter date calculation
20200218 Sum for Date Range; Pivot Table Tool; Dashboards; New Features; Superhero; Genuinely Better Functions; Pivot Tables; Dashboards; Office Scripts SUMIFS; Operators; Pivot Power Free; Mynda Treacy; Office Scripts; XLOOKUP; From the Trenches podcast; David Boyar; Paul Meissner; Where's the Beef?
20200211 Send PDF from Excel; Copy and Paste Problems; Excel Questions; Dashboards; Map Class Excel macros; Excel email; Paste Special; Microsoft Excel; Dashboards Send email from Excel; PDF attachements; Copy multiple selections; Paste Special; Microsoft Excel team; Reddit AMA; Mynda Tready; Art Attack; Copenhagen map
20200204 Font Too Small; Excel Documentation; Hide Pivot Table Buttons; Filters; Data Analysis; Lazy Soup Data Validation; Macros; Formulas; Pivot Tables; Data Analysis; AutoFilters Data validation combo box; Data entry popup kit; John Culley; Zoom setting; Excel notes; Pivot table buttons; Bill Jelen; Roger Govier; Dr. Kate Lakowski; Blender soup prep
20200128 Freeze Panes Problems; Split Names Formula; AutoFilter Macros; Budget; Excel Skills; Dangerous Game Freeze Panes; Functions; AutoFilter; Excel templates Hidden rows; MID function; AutoFilter types; Excel budget templates; Gail Vaz-Oxlade; Reddit; Agatha Christie; Snap-dragon game
20200121 Shorter Formula; Pivot Table Refresh; Data Viz; Excel Tips; Old Technology Functions; Pivot Tables; DataViz; Data Cleanup MID function; REPLACE function; Reverse Names; Split Names; Evelina Judeikyte; FireEye; Newfoundland; BlackBerry
20200114 Strange Formula; Slow Macros; Bar Charts; XOR Function; Slow Stitching Functions; Macros; Charts MEDIAN function; Custom Functions (UDF); Numbers to Words; Jon Peltier; Jon Acampora; Hand sewing; Liz Kettle
20200107 Check for Cheaters; New Year Resolutions; Excel Skills; Excel Features; Excel-lent Wine Data Validation; Functions, Excel templates; Résumés.; new Excel Features Data validation custom rules; SUMPRODUCT; COUNTIF; Count duplicated items; Weight loss tracker; Calorie counter; Meal planner; Résumés; Chris Newman; Reverse Sear
20191210 Block Duplicates; Holiday Planner; Excel Christmas Tree; Macros; No Macros; Power Query; Not the Alps Data Validation; Functions; Planners; Scroll Bar; Macros; Power Query Prevent duplicate entries; COUNTIF; SUMPRODUCT; Event calendar; VLOOKUP; Jon Acampora; Advent of Code; Aila Albrecht; Mike Girvin; Alberta Clipper
20191203 Dynamic Drop Down; Advent Calendars; Duplicate Sets; Online Summit; Power BI; Winter Weekend Data Validation; Functions; Training; Power BI Drop down list; WORKDAY function; Advent Calendar; SMALL; TEXTJOIN; COUNTIF; Jonathan Cooper; Excel Online Summit; Bill Jelen; Jon Peltier; PASS Marathon BI
20191126 Find Duplicate Sets; Dinner Planner; Pie Shape Colour; Rich Data; What's New; November Functions; Templates; Shapes; Data Types; Excel Features MMULT function; TRANSPOSE function; Count Duplicates; Holiday dinner planner; Happy Face shape; Jon Peltier; Geographical data; Microsoft Impact
20191119 Rank Numbers, Printing Tips, Happy Face; Online Summit; Data Viz; Excel Tips; Not the Jack Pine Functions; Pivot Tables; Printing; Macros; Excel Tips; Data Visualization Show Values As; Custom Calculations; RANK Function; Data Validation; Bill Jelen; Jon Peltier; MaryJo Webster; Data Journalism; Alberto Cairo; Tom Thomson
20191112 Workbook Destruction; Compare Annual Data; Calendar; Shortcuts; Reminder; Chess Set Workbooks; Pivot Chart; Excel Functions; Dashboards Open as Copy; Save As; Pivot Chart; Pivot Table Grouping; Monthly Calendar; Keyboard Shortcuts; Dick Kusleika; Jon Wittwer; Mynda Treacy; Malawi
20191105 Pivot Table Tip; Loan Payment Details; Dashboards; Drop Downs; Too Much Candy Pivot Tables; Functions; Dashboards; Data Validation Remove pivot fields; Right-click menu; PMT function; conditional formatting; loan payments; Mynda Treacy; Josh Wayne; Canadian candy
20191029 Annoying Warning; Spot the Trends; Zombies; Data Analysis; Pumpkin Carving Trust Center; Workbooks; Conditional Formatting; Functions; Data Analysis Personal Information; Trust Center Settings; Excel Options; Color Scale; Conditional Formatting Rules; INDEX and MATCH; David Ringstrom; Lisa Charlotte Rost; Halloween
20191022 Outline Groups; Find and Replace; Data Viz; Excel Team; Fall Colour Outlining; Data Entry; Data Viz; Excel Help Grouping; Sam; Arrow Keys; AlexJ; Find and Replace; Wildcards; VisComm; Excel Team; Daylight Saving Time
20191015 Skip Blanks; Spreadsheet Day; Charts; Statistics; Pillow Project Data Entry; Spreadsheets; Charts; Statistics Paste Special; VisiCalc; Dan Bricklin; Bob Frankston; Mitch Kapor; Charles Simonyi; Elizabeth Ricks; Holiday Dinner Planner; Sewing
20191008 Count Items; Fun with Functions; Charts; Excel Tips; Formulas; 1999 Pivot Table; Functions; Charts; Excel Tips Pivot Table Count; Emojis; INDEX MATCH; Ken Puls; Wyn Hopkins; UNICODE, UNICHAR, HEX2DEC, DEC2HEX; Michelle Rial; Dawn Bjork; Formula Coach; Y2K
20191001 See Long Rules; TEXTJOIN Function; Charts; Excel Tips; Fall Flowers Conditional Formatting; Functions; Charts; Shortcuts Conditional Formatting rules; Lottery numbers; ConCat function; TEXTJOIN: Jon Peltier; Jon Acampora; Snowstorm
20190924 Pivot Field List; Multi-Item Slicer; Excel Tips; New Features; Power BI; Muggles Pivot Tables; Filters; Slicers; Excel Tips; Excel Versions PivotTable Field List; Data Validation; Drop Down Lists; Data Entry Popup; Multiple Selections; Insider Version; Matt Allington; Harry Potter
20190917 Worksheet Tips; Quick Pivot Field Trick; Formulas; Modelling; Charts; Late Summer Worksheet Navigation; Mouse Shortcuts; Pivot Tables; Functions; Financial Modelling; Charts Sheet tabs; AlexJ; Pivot table labels; Interactive lessons; Matthew Bernath; Podcast; Jon Peltier; Garden
20190910 New Lookup Function; Filter Trick; Baseball; Errors; Back to School Functions; Filters; Excel table; Conditional formatting XLOOKUP function; Jon Acampora; Filter by Color; Excel table; Conditional formatting; Baseball statistics; Ben Zorn; ExceLint; Backpack
20190827 Adjustable Hyperlinks; Hidden Formulas; Formulas; Functions; Tiny Laptop Hyperlinks; Weekly Planner; Conditional Formatting; Formulas; Functions Defined names; Hyperlink Function; CELL function; Line spacing; Excel weekly planner; Dick Kusleika; golf analysis; Liam Bastick; MOD function
20190813 Toolbar Tip; Product Update; Dashboards; Excel Uses; Data Viz; Camp Crafts Excel Ribbon; UserForms; Dashboards; Data Viz Quick Access Toolbar; Ribbon customization; QAT; Search Form Builder; UserForms; Mynda Treacy; Kat Boogaard; Seating plan; Science Goddess; Quilling; Abacua; Popsicle sticks
20190730 Locked Cells; Order Forms; Gantt Chart; Text Trick; Greatest Toys Excel Ribbon; Functions; Conditional Formatting; Macros; Printing; Charts; Text Ribbon customization; QAT; CELL function; Conditional Formatting; Print order forms; Leila Gharani; Gantt chart; Steve Collins; Justify; Skip-It toy; Greatest toys list
20190716 Number Format Trick; Formula Challenge; Charts; Formula; Excel Tips; Hidden Feature Number Format; Formulas; Charts; Excel Tips Custom number format; Decimal points; Count numbers in numbers; Multi-value cells; SUMPRODUCT; Dave Paradi; Kevin Lehrbass; Mouse logo button
20190702 Top Excel Tips; REPT Function Tricks; Data Viz; Equations; True North Excel tips; Functions; Data Viz; Formulas Excel Tables; Power Query; Backup macro; Excel Tools add-in; REPT function; In-cell chart; Google data design; Lagranian Point; Doug Jenkins; Tuktoyaktuk
20190618 List All Excel Files; Strange Functions; Spreadsheets; Excel Sessions; Almost Summer Macros; Functions; Spreadsheets; Excel Tips; Power BI Zipped Files; List Excel Files; Content Created Date; T Function; N Function; Journalists; Business Applications Summit; Lilacs; Toronto Raptors
20190604 Blank or Not, Pivot Table Fix, Spreadsheets, Excel Uses, It's the Thought Data Entry; Functions; Pivot Tables; Excel Options; Spreadsheets COUNTA; Blank cells; Text to Columns; Pivot table drop downs; Retain Items; Pivot Power Premium; VisiCalc, BBC; Unbundling Excel; Fitted sheets
20190521 Change a Shape, Date Formula Challenge, Charts, Dynamic Arrays, Excel Tips, Rockies Shapes; Comments; Functions; Charts; Excel Tips Change Shape; Change Comment Shape; WEEKDAY function; Date Functions; Gantt Chart; Jon Peltier; Dynamic Arrays; CheckDA; Charles Williams; Grainne Hallahan; Canadian Rockies
20190514 Lookup Formula; Excel Training; Excel Names; Data Viz; Troubleshooting; Tulip Festival Functions; Dashboards; Training; Names; Data Viz; Troubleshooting Find last item in column; LOOKUP function; Mynda Treacy; Excel Summit South; Defined Names; Alli Torban; Excel errors; Canadian Tulip Festival
20190507 Last Number Formula; Interactive Dashboards; Date Grouping; History; Charts; Perfect Gift Functions; Dashboards; Pivot Tables; Excel history; Charts LOOKUP function; Excel weight tracker; Mynda Treacy; Date grouping; AutoFilter; Data Options; Bill Gates; Chandoo; Key Influencers; USB Hub
20190430 Preview Picture, Naming Rules, Update, Power Query, Free Books, Calculators, Step on a Crack Excel Files; Pivot Tables; Power Query; Data Science; Calculators Preview Picture problem; Pivot table naming rules; Jeffrey Browne; Jeff Lenning; Excel University; Data Science books; Calculator Race; Dan Bricklin
20190416 Copy Pivot Format, Chart Challenge, Excel Tips, Organization, Grey Skies Pivot Tables; Formatting; Charts; Excel Tips; Templates Office Clipboard; Chart mystery; bar chart wrong lengths; Excel tips for beginners; Angela Lashbrook; Google Sheets
20190409 Status Bar Options, Macro Tweaks, Filter Challenge, Humour, Spring Indoors Status Bar; Programming; Filters Num Lock; Numerical Count; Status Bar messages; Edit Macros; Bill Jelen; BallmerCon
20190402 Style Problems, VLOOKUP, Product Update, Functions, Chart, More Snow Custom Styles; Named Tables; Pivot Tables; Protection; Functions; UserForms; Charts Custom Style problems; Sheet protection; Bill Jelen; VLOOKUP Week; UFDE; UserForm Builder; Chandoo; Kaiser Fung; Chart labels
20190326 Button Macros, Chart Problem Fix, Dashboards, Prediction, Maple Leaf Macros, Worksheet buttons, Charts, Dashboards, Formulas Stress test; Application.Caller; Hidden chart data; Chandoo; Excel Team; College Basketball; Canadian penny
20190312 Grouped Sheets, Workbook Tools, AI in Excel, Data Analysis, Art in Nature Macros, Grouped Sheets; Artificial Intelligence; Data Analysis Grouped sheet warning; Title Bar; Workbook Tools; Data From Picture; Keith McNulty; Jackfruit; Ingeborg Hawighort; Teylyn
20190305 Compare 2 Tables, Hide Duplicates, Charts, Power Query, Fancy Dinners Excel Tables; Functions; Conditional Formatting; Charts; Power Query SUMPRODUCT; UniMord; Hide duplicate headings; Stacked column chart; Jon Peltier; Pivot stacked data; Ken Puls; Candle Problem
20190226 Workbook Info, Button Trick, Product Updates, VisiCalc, Decisions, Altered Book Macros, Worksheet Buttons, Excel Products, Charts, Spreadsheets Macros; Pivot Tables; Names; Custom Macro Workbook; Worksheet Buttons; Switch Languages; Excel Tools; Chart Tools; Dan Bricklin; Decision Matrix; Altered Book
20190219 Hyperlink Quick Tip, Error Values, Nerds, Macros, Snow Days Hyperlinks, Cell Format, Errors, Macros Wrap Text; Hash error values; VLOOKUP; Trevor Fox; Macro recorder; Kevin Lehrbass; Wiarton Willie
20190212 Order Form Setup, Show Numbers as Text, Beer, Excel Versions, Dashboards, Museum of Play Functions, Data Validation, Pivot Tables, Number Format Drop down lists; VLOOKUP; Conditional formatting; Custom number format; Larry Carpenter; Brewing spreadsheet; Microsoft ad; Family Day; Strong Museum
20190205 Drop Down Lists, Pivot Table Formulas, Personal Finance, Spreadsheets, Temperatures Data Validation, Functions, Pivot Tables, Spreadsheets Drop down for filtered list; Subtotal function; Index and Match; Dynamic named range; Calculated item; Calculated field; Len Penzo; Ariel Mishman; Galileo thermometer
20190129 Hide Worksheet Info, Interactive Dashboards, Random Number Challenge, Data Entry Popup, Budgets, Rivalry, Siblings Conditional Formatting; Dashboards; Formulas; Excel products Hidden questions; Mynda Treacy; Random numbers; DVMSP kit; Personal budget; Debt reduction workbook; Dave Mandl; Lotus 1-2-3; Jack Bauer
20190122 Add Tables Rows, Flexible Conditional Formatting, PPP Add-in, Macros, Power BI, Functions, Guided Tour Excel Tables, Conditional Formatting, Excel Add-ins, Pivot Tables, Macros, Power BI, Functions Total Row; LARGE and SMALL functions; Highlight Top or Bottom; Pivot Power Premium; Jon Acampora; VBA Pro; Reza Rad; Power BI Desktop; User Defined Functions; Macintosh
20190115 Dynamic Title; Quick Subtotal; Excel Tips; Data Viz; Old Database Pivot Chart; Functions; Filters; Excel Tables; Data Visualization Link chart title to cell; Excel Table Total Row; Reddit; Ann K Emery; Q & A Database
20190108 Show Degree Symbol; Names List; Excel Tips; Charts; Data Viz, Who You Are Number formats; Excel Names; Excel Ribbon; Charts; Data Viz Custom Number Formats; Paste List; Lori Kaufman; AutoHide; Jon Peltier; Gantt Chart; Nathan Yau; Dagwood Photo Challenge
20181211 Quick Tip; Weekends Only; Challenge; Data Viz; Bumpy Ride Formatting; Data Validation; Formulas; Data Viz Unhide rows and columns; WEEKDAY function; Data validation custom rules; Titanic challenge; Reddit; Jonathan Schwabish; Gods River; Grumann Goose
20181204 Quick Fix; What Would You Do?; Quick Pick List; Advent Calendar; Charts; Data Analysis; High Tech Low Tech Pivot Tables; Functions; Data Entry; Sample Files; Charts; Data Analysis GetPivotData; Excel Options; Data Entry sheet; INDEX/MATCH; Keyboard shortcuts; Philip Treacy; Andy Pope; Alex Novet; Bissell; iPhone; Live Photo
20181127 Quick Pick; Advent Calendar; Mr. Excel; Excel Skills; Garden Cleanup Data Entry; Keyboard Shortcuts; Functions; Conditional Formatting Pick from Drop-down List; CHAR Function; Date Functons; Advent Calendar; Bill Jelen; Excel skills; Boris Karloff
20181120 Recent Birthdays; Data Entry Popup; Functions; Excel Writers; Paper Airplanes Conditional Formatting; Date Formulas; UserForms; Lookup functions WEEKNUM function; Date functions; Listbox; DVMSP; Liam Bastick; LOOKUP function; How-to-Geek site; Reddit; Fold'N'Fly database
20181113 Close All Files; VLOOKUP Trick; Excel Tables; Charts, Power BI; Tidying Up Keyboard shortcuts; Functions; Named Tables; Slicers; Data Flows Single Document Interface; Quick Access Toolbar; Excel Files FAQ; CHOOSE function; Table Array; Fiscal Month; Jan Karel Pieterse; Jeff Lenning; Matt Allington; KonMari method
20181106 Budget Limit; Make it Personal; Reminders; It's Complicated; Excel Tips; Rainy Day Data Validation; Macros; Dashboards; Excel Team; Spreadsheets Data validation custom rules; Error Alert; Error message; User Name; Reddit; Ask Me Anything; Mynda Treacy; Don Tomoff; Complicated spreadsheets; Microsoft site; Mississauga Civic Centre
20181030 ADDRESS Function, Excel Dashboards, Halloween Tricks, Microsoft, Slicers, Charts, Holiday Crafts Functions; Excel Training; Conditional Formatting; Excel team; Slicers; Charts Show cell address; Mynda Treacy; Interactive workbook; Check Box; Spin Button; Excel AMA; Dynamic arrays; Chris Webb; Chandoo; Hui; Animated chart; Melted snowman
20181023 LOOKUP Function, Product Updates, Data, Errors, Tips, Colour Purple LOOKUP examples; Contextures products; Data organization; Excel Error messages; Reddit Excel tips Lookup shift number; Student letter grade; PPP; DVMSP; Karl Broman; Dara Woo; Jon Peltier; Spreadsheet Day wrap up; Jon Acampora; Butterfly Garden
20181016 Spreadsheet Day, Which Work Shift, Passwords, Shortcuts, Macros, Fall Colours Spreadsheet Day; Functions; UserForms; Shortcuts; Excel Training October 17th; VisiCalc; Shift number formula; VLOOKUP; Doug Glancy; Harvard Business Review; Freeze Panes; Jon Acampora
20181009 Missing Arrows, Macro Training, Time Formulas, Automation, On the Wall Data Validation, Programming, Date Functions, Excel Courses Delete shapes; Jon Acampora; Excel VBA; Doug Jenkins; Date formatting; Excel automation; Macramé
20181002 Your Macros, Dynamic Arrays, Solver, VLOOKUP, Keep It Simple Custom Ribbon Tab; Office 2019; Excel Functions; Dynamic Array Formulas; Solver; Lookup Speed My Macros Custom Tab; CONCAT, TEXTJOIN, IFS, SWITCH; Ctrl+Shift+Enter; Kevin Lehrbass; Lookup speed comparison
20180925 New Ways to Automate Excel, Weird Color Button, Microsoft Ignite, Faster VLOOKUP, Soup Chart VBA; Office Extensibility; Formatting; Functions Develop Excel Conference; Cycle Font Color; Custom Number Formatting; Microsoft Ignite Excel sessions; Charles Williams; Lookup formulas; Lentils
20180918 Pivot Table Drilldown, Fill a Cell, Power Query, Macros, In the Country pivot tables; show details; cell format; alignment; Power Query, VBA pivot table show details; pivot table drilldown; cell alignment fill; Power Query challenge; Ken Puls; Jon Acampora; macro shortcuts; apples
20180911 Comment Warning, Formula Challenge, Models, Football, Smart Watch Comments, FV Function, Financial Models, Fantasy Football Threaded Comments; Financial Functions; Brett Whysel; Get & Transform; AmazFit
20180828 Fix Blank Cells, Go Back to Previous Cell, ModelOff, Power Query, New Laptop Data entry, Navigation, Financial Model, Power BI Cells look blank; Text to Columns; Store temporary locations; ModelOff questions; Chandoo, Canna Lily
20180814 Comment Macros, Slicer Setup Tip, Excel Training, Dashboards, Data Model, Paper Weaving Comments, Macros, Slicers, Dashboards, Excel courses, Camera Tool, Power BI Comment resize and move; J. Woolley; Comment numbering; Message button text; Slicer macros; Mynda Treacy; Jeff Lenning; J. Carlton Collins; Rick de Groot
20180731 Currency Format, Build a Timeline, Power BI, Developers, Rainbows Rule Conditional Formatting, Functions, Power BI, Excel Addins Currency conditional formatting; VLOOKUP; INDEX/MATCH; Chicken Dinner planner; Business Applications Summit; Ken Puls; Excel Developer Conference; Christmas in July
20180717 Font Size Magic, Total Score, Macro Training, New Look, Prediction, Weeds Formatting, Functions, Macros, Office UI, Machine Learning Format Cells, Shrink to Fit, SUMPRODUCT, SUMIF, Jon Acampora, Excel Ribbon, Excel with ML, Netflix, Lovage plant
20180703 Flexible Formula Trick, Multiple Dependent Drop Downs, Formulas, Charts, History Functions, Data Validation, Functions, Charts Function argument cell reference; dependent drop downs with tables; Chandoo; bad charts; early spreadsheets; Nathan Yau; BBC Computer Literacy Project, Humanitarian Award
20180619 Quick Tip, Using RAND, Double Lookup, Forecasts, Charts, In the Garden Data Entry, Functions, Modeling, Charts Data Form; John Walkenbach; World Cup; RAND algorithm; Rich Pollock; RANDBETWEEN; INDEX; MATCH; Mileage Lookup; Liam Bastick; Jon Peltier; Cycle Plot; Rhubarb
20180605 Fancy Drop Downs, See the Styles, Data Viz, Budget, Computer Games Data Validation, Pivot Table Styles, Data Viz, Functions, Conditional Formatting, Subtotals Dependent drop down lists; PivotTable Styles macro; Data Viz; Alberto Cairo; Susan Harkins; Tech Republic; Rogue game, Macintosh
20180522 Fill Blank Cells, Split the Date Solutions, Keep Getting Excel News, Slicers, Excel Skills, Summer Weather Data Entry, Formatting, Macros, Functions, Excel News, Slicers, Interview Questions Fill blank cells, Excel Tools Add-in, Split Date and Time challenge, Bill Jelen, Lake Louise
20180508 Split the Date, Highlight Expiry Dates, Data Analysis, Sad News, Power BI, Wind Storm Functions, Conditional Formatting, Data Analysis, Excel, Tips, Power BI Formula Challenge, SUBSTITUTE, LEFT function, TODAY function, Chandoo, Chip Pearson, Mynda Treacy
20180501 Show All the Items, Running Total by City, Charts, Power BI, In the Garden Pivot Tables, Functions, Charts, Power BI Show items with no data, Field Settings, Absolute reference, Ann K. Emery, Mynda Treacy, Dashboards, Rhubarb
20180424 Completed Tasks, Custom Styles, Charts, Data Model, Owl Conditional Formatting, Task List, Pivot Tables, Custom Styles, Charts, Data Model Strikethrough, Copy Custom Style, Interactive Chart, Chandoo, Connect tables, Susan Harkins, Girl Guides, Owl pattern
20180417 Quick Print Tip, Compare Cells, Dashboards, Data, Back in Time Excel table, Printing, Dashboards, Data Analysis, Excel History Print list, Quick Access Toolbar, SUMPRODUCT, INDIRECT, History Navigation, Doug Glancy, Anakic, QueryStorm, Excel 4.0, Excel advertisement
20180410 How Embarrassing, Excel Properties, Charts, Excel Help, Spring Weather Formula Bar, Properties, Excel Ribbon, Charts, Macros Formula bar toggle arrow, Document Location, Comment property, Alex B, Jon Peltier, Gantt chart, Stack Overflow, Joel Spolsky, Jon Acampora, April snow
20180403 Quick Formatting, What Is Hidden?, Data Viz, Macros, Pranks Shortcuts, conditional formatting, functions, data visualization, VBA, Power BI Format Painter, Double-click tricks, CELL function, AGGREGATE function, Ann K Emery, Jon Acampora, April Fool's pranks, Power BI Clippy
20180327 Hide the Details, Guess the Function, Data Model, Education, Office Tools Grouping, Conditional Formatting, Functions, Data Model, Spreadsheets Hide details; Survey questions; REPLACE function; Excel TV; Computer Science education; Alfred Thompson; LexisNexis
20180320 Chart Colours, Missing Data, Dashboards, Planning Charts, Macros, Pivot Tables, Dashboards, Planning Conditional Formatting, Color Scales, Bar Chart, Pie Chart, Chart Color macro, Pivot Table Filters, Field Settings, Audry Loper, Nick Orso, Reversible sequins
20180313 Hyperlink Quick Tips, Dynamic Ranges, Seating Chart Part 2, Excel Sites, Excel Ribbon, MVP Summit Hyperlinks, Functions, Charts, Excel Tips, Excel Add-ins Hyperlink tips, Wrap Text, Dynamic Ranges, OFFSET, INDEX, CHOOSE, INDEX, MATCH, Kevin Lehrbass, Doug Jenkins, Doug Glancy, Sim Choudry, Canadian MVPs
20180306 Quick List, Age and Height Part 2, Seating Chart, Data Entry, Macros Data Entry, Functions, Charts, Data Validation, Macros Quick list of numbers, Age calculations, Hockey player data, Seating plan, Doughnut charts, Oz du Soleil, Jan Karel Pieterse, John Michaloudis, VBA course
20180227 Multiple Filters, Age and Height, Excel Tips, Data Viz Pivot Tables, Filters, Functions, Data Viz Multiple filters per field, Olympic hockey, age calculation, LEFT, RIGHT, Neil Patel, Nathan Yau, SketchNotes
20180220 Easy to Read, What's in That Cell, Budget Reporter, Slicers, Power Query Pivot Table Formatting, Functions, Slicers, Power Query Pivot Table blank row, CellView, Chip Pearson, formula troubleshooting, UNICODE, Budget reporter, Forcast Actual Variance, Ken Puls
20180213 Quick Filters, Lookup Mystery, Charts, Dashboards, Odd Facts Pivot Tables, Filters, Functions, Charts, Dashboards, Excel Tips Pivot Table Filters, VLOOKUP, CODE, CHAR, AscW, Jon Peltier, chart blank cells, Mynda Treacy, Data Rails blog, Mike Alexander
20180206 Is It Sorted, Interactive Dashboards, VLOOKUP Prices, Excel Tips, Power BI Tool, Statistics, Battleship Data Validation, Functions, Dashboards, Power BI, Statistics Drop Down Lists, OFFSET, MATCH, COUNTIF, VLOOKUP, Mynda Treacy, Lookup table, John Michaloudis, Dick Moffat, David Hoppe, XLPublish, Crash Course, Andrew Engwirda
20180130 Quick Symbols, Interactive Dashboards, COUNTIF 255 Limit, Comments, Problem Solving Data Entry, Dashboards, Formulas, Comments, Business Math AutoCorrect, Symbols, Mynda Treacy, COUNTIF, SUMPRODUCT, Ben J. Kusmin, Comments, Mike Girvin, Math problems, knitting
20180123 COUNTIF Confusion, Pivot Grouping, Macros, Forecasting Functions, Pivot Tables, Programming, Resources COUNTIF, 255 character limit, SUMPRODUCT, Data Model, Pivot Power Premium, Jon Acampora, Get started with macros, Andrew Schneider, Forecasting Tool
20180116 Fancy Formatting, SUBSTITUTE and TRIM, Security, Data Viz Number format, Functions, Charts, Security updates Text in custom number format, count items in cell, Woddy Leonhard, Dynamic Data Exchange (DDE), Science Goddess
20180109 Table Filter Spinner, SUBSTITUTE Trick, Advanced Excel Training, Data Viz, Spreadsheets Excel Table, Pivot Table, Spin Button, Functions, Training, Data Visualization Scroll through table filter, count words in cell, Maarten Lambrechts, Manny Medrano, HDR photography, Inca Khipu

20171212

Unique Count, Advanced Formulas, Your Feedback, Excel Art, Dashboards, Formatting

Pivot Tables, Functions, Tables, Excel Art, Dashboards, Conditional Formatting

Distinct Count, Data Model, Ben Collins, Google Sheets, Bloomberg, UserVoice, Jeff Weir, Tatsuo Horiuchi, Andy Pope, Chandoo

20171205

Excel event planner, quick copy shortcut, interactive dashboards, Excel complaints, Excel Viewer

Formulas, Shortcuts, Dashboards, Excel tips, Excel Viewer

Custom Ribbon tab, event calendar, mouse shortcut, Fill without formatting, Mynda Treacy, WSJ

20171128

Hide zeros, HLOOKUP for Rate, Interactive Dashboards, Comparison Charts, Clean Data

Formatting, Functions, Charts, Dashboards, Data, Macros

Mynda Treacy, Kaggle survey, horizontal lookup, messy data

20171121

Find Links, Excel Names, Dashboards, Excel Fonts

Add-ins, Dashboards, Formatting, Functions, Names

Bill Manville, troubleshooting, Kevin Lehrbass, data viz tips

20171114

Shortcuts, Macros, Troubleshooting, Formulas, Games

Shortcuts, Macros, Troubleshooting, Formulas, Games

Sudoku, Andy Pope, Chart Exporter, Bill Jelen, Excel Tools, data validation, data entry, shortcuts

20171107

Drop down Symbols, Never Do This, Weave a Tartan, Excel Macros, Pivot Tables, Dashboards

Data Validation, Excel Tables, Macros, Pivot Tables, Dashboards

Symbols in data validation list, combine data on one sheet, custom Ribbon tab, Excel TV, Many a True Nerd, YouTube, StackOverflow survey, Simon Murphy

20171031

Slice and Dice, Lookup First and Last, Charts, Power BI

Slicers, Formulas, Charts, Power BI

Mike Alexander, Slicer formatting, VLOOKUP, Quartz, Dan Kopf, table instead of chart, free Power BI book, Reza Rad

20171024

Pivot Table Trick, Excel Lookup Formula Challenge, Get Started with Macros, Excel AMA, Date/Time

Pivot Tables, Functions, Macros

Type to add pivot fields, Lookup challenge solutions, LOOKUP, INDEX, MATCH, intro to macros, Jon Acampora, Microsoft Excel team, Ask Me Anything, Mynda Treacy

20171017

Spreadsheet Day, Lookup Challenge, Date Grouping, Excel AMA, Excel Solver

Spreadsheets, Lookup Formula, Grouping, Solver

VisiCalc, formula challenge, pivot table, Redditt, Solver

20171010

Dashboard Tips, Data Bars Tricks, Percent Operator, Excel Tips, Charts

Dashboards, Formatting, Formulas, Tips, Charts

Real-time dashboards, proactive dashboards, Mynda Treacy, conditional formatting, calculation operators, UniMord, Chandoo, Histogram, Pareto chart

20171003

Custom Colours, Show Data Entry Messages, Power BI, Excel Maps

Formatting, Data Validation, Data Entry, Power BI, Maps

Ann Emery, Charts, Custom Theme, Data Validation Message, Carlos Otero, Soccer, Get & Transform, Kevin Lehrbass

20170926

Interactive Dashboards, Show Percentages in Reports, Quick Tip, Excel History, Excel Charts

Dashboards, Pivot Tables, Keyboard Shortcuts, Charts

Mynda Treacy, Karine Lago, Show Values As, Percent of Parent, Excel shortcuts, Satya Nadella, MS Query, Jonathan Schwabish, Waffle Chart

20170919

All Your BASE, Line Breaks, Shortcuts, Last Row, Excel Charts

Functions, Find and Replace, Data Entry, Macros, Chart Add-in

TEXT function, REPT function, UniMord, Koen vT, Mike Girvin, Charles Williams, Jon Peltier

20170905

Data Entry Rules, Check Excel Settings, Excel Tips, Excel Versions

Data Validation, Excel Options, Excel Tips for Attorneys, Excel 1.0

Drop down lists, Data Entry pop up kit, Custom data validation, Manual calculation, Andrew Engwirda, Ben Kusmin, MacUser

20170822

Hide Filter Arrows, Quickly Naming Cells, Power Pivot, Functions, Power Point

AutoFilter, Macros, Excel Names, Power Pivot, Functions

AutoFilter macros, Names Create from Selection, DAX, Matt Allington, TEXTJOIN, Teylyn, Tom Urtis

20170808

On Demand Slicers, CONVERT function, Charts, Quick Tip

Slicers, Macros, Functions, Charts, Protection

Pivot Tables, AlexJ, CONVERT function, recipe calculator, messy chart, Science Goddess, Chandoo, unprotect multiple sheets, Excel Tools add-in

20170725

Make a Pop Up Slicer, Find Last Text Item, Error Checking, UserForms, Charts

Slicers, Functions, Errors, UserForms, Charts

Macros, AlexJ, REPT, VLOOKUP, LOOKUP, error checking, Ken Puls, Jon Peltier, Ann K. Emery

20170711

Build a MIN IF Formula, Interactive Dashboards, Rounding Time, Power Pivot, Math and Sports

Functions, Dashboards, Power BI, Math

MIN, MAX, pivot table, Mynda Treacy, Chandoo, Time formulas, John Michaloudis, Rob Collie, Math With Bad Drawings

20170627

Excel Training, Number a Filtered List, Clean Data, Excel Tables

Dashboards, Functions, Data, Tables

Mynda Treacy, AGGREGATE, Sum functions, SUBTOTAL, Clean data, Carlos Otero, Get & Transform, Excel tables, Mike Alexander

20170620

Paste With No Borders, Excel Products, Sum a Filtered List, Data Science, Power BI, Training

Data Entry, Shortcuts, Pivot Power, Functions

Data Entry shortcuts, Alex B, Quick Access Toolbar, QAT, Paste Special, Pivot Power Premium update, PPP, SUBTOTAL, AGGREGATE, Trello, Matt Allington, Chris Webb, John Michaloudis

20170613

Find Nth Character, Enter Key Shortcuts, Histogram Charts, DAX course, Power BI Webinars

Functions, Shortcuts, Power BI, Charts, Power Query, Training

SUBSTITUTE, FIND, keyboard shortcuts, Nathan Yau, Jon Peltier, Marco Russo, Alberto Ferrari, Power Query, John Michaloudis

20170606

Address Formula Solution, Flash Fill or Formulas, Charts, Cleaning Data in Excel

Functions, Data Entry, Charts, Data Analysis

Split address formula, FIND, SUBSTITUTE, Flash Fill, Science Goddess, Cleaning Data course, Maarten Lambrechts, Ken Puls, MVP Day

20170530

Formula Challenge - Split Address, Quick Backup Tool, Excel Shortcuts, Formulas for Architects

Functions, Add-ins, Shortcuts

Formula challenge, File backup, Tim Berty, FLOOR, CEILING

20170523

Hide Used Items, Slicer Trick, Favourite Functions, Excel Song

Data Validation, Slicer Properties, Functions, Excel Fun

Drop Down List, remove used items, prevent slicer moving, Jon Wittwer, Clint Tuttle

20170516

Create Random Numbers, Excel Resources, Sorting, Power BI

Functions, Excel Resources, Sort, Power BI

Matt Allington, Kevin Lehrbass, UserVoice, Olaf Hubel, Jonnie Thomas, RANDBETWEEN, ROUND, RAND

20170509

Quickly Copy Data, Excel Macros, Date formula, Excel Skills, Excel Experiment

Advanced Filter, Macros Training, Functions, Excel Tips, Excel macros

Filter to different sheet, Allen Wyatt, Jon Acampora, VanV, EOMONTH, Eric Andrews, Economics, Micro:Bit

20170502

End of Month Formulas, Amazing Dashboard Tricks, Price Lookup, Excel Skills, Excel Training

Functions, Dashboards, Excel Training, Macros

EOMONTH, Date Functions, Robert Mundigl, Interactive dashboard, Leonid Koyfman, Formula challenge, Daily Dose of Excel, Dick Kusleika, Nick Larson, Job interviews, Mike Girvin, Excel for Accountants

20170425

Tricky Price Lookups, Personal Macros, Pivot Table Format, Excel Table, Power BI

Functions, Excel Ribbon, Pivot Table, Excel Table, Power BI

VLOOKUP, Formula Challenge, Custom Ribbon Tabs, Don Tomoff, Chandoo, Power BI resources, Excel Table Problem

20170418

7 Ways to Round in Excel, Hidden Hyperlink, SUMIFS feedback, Formulas, Power Query

Functions, Hyperlinks, Troubleshooting, Power BI

Rounding, Hyperlink examples, SUMIFS, Charlie Young, Troubleshoot formulas, Engineering Excel, Power Query pitfalls, Gil Raviv

20170411

SUMIFS With Blank Cells, Pivot Table Fill Colour, Power BI, Charts

Functions, Pivot Tables, Power BI, Charts

SUMIFS, Sum functions, Excel World Champ, Ghazanfar Abidi, Power BI Tips, Ken Puls, Science Goddess, Backwards Bar Chart, 100 Days Project

20170404

Make VLOOKUP Flexible, Data Entry Search Popup, Charts, Office 365

Functions, Excel Tools, Charts, Office 365

VLOOKUP, MATCH, Lookup formulas, Data Entry tools, Ann K. Emery, Plan a chart, Podcasts, Modern JavaScript

20170328

Name Fix Solutions, Pivot on Protected Sheet, Data Analysis, Programming

Functions, pivot tables, Macros, Business Analytics, VBA

Formula challenge solution, PROPER, EXACT, COUNTIF, Pivot Table macro, PASS, Mike Alexander, RubberDuckBA, Organize VBA Code, PPP update

20170321

Excel Name Fix Challenge, Freeze and Zoom, Start/End, Programming

Functions, Macros, Power Query Dates, Pivot Table, Programming

Formula Challenge, Freeze Panes, Zoom setting, Calculated dates in Power Query, Ken Puls, Andrew Wulf, Programmng goals

20170314

Happy Pi Day, Conditional Formatting Mess, Data Viz, Pivot Tables

Functions, Conditional Formatting, Excel Dashboards, Pivot Tables

March 14th, Pi Day, PI function, duplicate rules, Jorge Camoes, Allen Arthur, Social Journalism

20170307

Sheet Lister, RANK IF Formula, Data Analysis, Excel for Engineers

Macros, Worksheets, Functions, Excel Basics, Excel files

Sheet Lister Add-in, COUNTIFS, Count functions, Rank functions, Paul Overberg, Health Data, Doug Jenkins, Engineering

20170228

Calculated Fields, Name Box Tricks, Excel Basics, Excel Tools, Course Closing

Pivot Tables, Data Entry, Excel Books, Excel Add-ins, Excel Training

Calculated Field, Calculated Item, Excel Names, Unhide columns, Power BI training, Frankens Team, Excel Formula Analyzer, Andrew Engwirda, VBE Tools, Mynda Treacy

20170221

Keyboard Shortcut Problem, Favourite Commands, Debt Snowball, Excel Chart

20170214

Why Use Power BI?, VLOOKUP Fix, Excel Code Tools, Excel Dashboards

Power BI; Functions; Programming; Dashboards

Matt Allington; Mynda Treacy; VLOOKUP; VALUE function; Andrew Engwirda; VBE Tools; Chandoo; Dashboard contest

20170207

Filter for Dates, VLOOKUP Problem, Excel Budget, Excel Charts

20170131

Count Items in a Cell, Dashboard Course Giveaway, Excel Charts, Excel Formula, Excel Events

20170124

Save Your Excel Ribbon, Solution Rolling Total Challenge, Power BI, Excel Contest, Excel Events

20170117

Grouped Dates, Rolling Total Challenge, Excel Addins, Shpreadsheet Threats

Filters

20170110

Fix the Footer, Data Viz, VisiCalc History, Conditional Formatting

Spreadsheets

20161213

Excel Marimekko Chart, Column Header Letters, Feedback, Spreadsheet History, Excel Song, Excel Dashboards

Charts

20161206

Rounding Time, Week Grouping Formula Solution, Organizing Files, Excel Memory, Excel Data, Excel Dashboards

MROUND; WEEKDAY function; Charles Williams, FRED Data add-in, Mynda Treacy

20161129

Week Grouping Formula, Excel Dashboards, Hidden Rows, Organizing, Excel Tips, Excel Blooper, Crabapple

Nelly video Excel message; Manage business finances, Organize Excel files; Hidden Rows; Mynda Treacy; WEEKDAY function

20161122

Holiday Planner; Can't Unhide Rows; Hidden Help; Power Pivot Problems; Pivot Table Webinar

Worksheets

Excel holiday planner; hidden rows problem; Freeze Panes; AGGREGATE function; Ken Puls; Matt allington; Pivot Tables

20161115

AutoFilter Shortcuts, Tweaking the Budget, ModelOff Challenge, Square Pie, Pivot Table Webinar, Office Zoo

Filters, Functions, Pivot Tables

Mike Alexander; Annual Cost Calculator

20161108

Excel COUNTIF Challenge

Functions

20161101

Fast Way to Find and Delete Excel Rows

20161025

Quick Copy of Excel File, Volume on Excel Videos, Spreadsheet Tasks, Lookup Function, Leaves are Falling

Functions, Excel Tips

20161018

Get started with Excel macros

20161011

Quickly close all files

20161004

Excel shortcuts

20160927

No need for an IF formula

20160920

Dependent Combo Box in Excel

20160913

How to clean Excel data

20160906

Excel -- Pivot Tables -- Data Fields

20160823

Quick Ways to Unpivot Excel Data

20160809

Number formatting shortcuts

20160726

Annoying hyperlink problems

20160712

Hide Sheets Based on Tab Color

20160628

How to use Excel's hidden calculator

20160621

Create a quick list of months or weekdays

20160614

Select a group of sheets from drop down list

20160607

Numbers Change to Dates in Excel

20160531

Customize your right-click menus

20160524

Count specific codes in a list

20160517

Quick tips for entering formulas; Table formatting; List everything

20160510

A quick way to create and format Excel tables

20160503

A quick way to build complex formulas

20160426

Quick running totals to compare years, fast filter tip

20160419

Quickly change settings to show different data, get the latest product updates

20160412

Avoid pivot table time problems, get my product updates

20160405

Use Slicers to keep people away from your data

20160329

Highlight numbers in a list, store pivot table layouts

20160322

Get Excel Version Number with INFO Function

20160315

Excel Sheet Selector With No Macros

20160308

Get duplicate names, shortcuts

20160301

Excel VLOOKUP Sorting Problem

20160223

Quick Reports With Excel Custom Views

20160216

See how to split dates and times, build hyperlinks

20160209

Split dates and times, worksheet protection

20160202

Remove Macro Warning in Excel

20160126

Get Table Data With Excel HLOOKUP Function

20160119

Get Excel Worksheet Name with CELL Function

20160112

Check Box VBA

20151215

Find Project End Date; MAX IF Calculation; Essential Excel Skills; Data Viz; Holiday Traditions

20151208

Quick Count; Spreadsheet Principles; Dashboards; Football Field Chart; Almond Cookies

Count Duplicates; Pivot Table

20151201

Catch Missing Data; Excel Advent Calendar; Prevetn Errors; Pivot Table Values; Berry Cold

20151124

Excel Fiscal Year Calculations; File List; Create Icons; Office 2016 Review; Snowman

20151117

Create a Rolling Total; Custom Footer Macro; Clean Your Data; Chart Tips; 15 Year Anniversary

Functions; Page Layout; Data Cleansing; Charts; MVP

SUMIF; Excel macros; Footer date; Investintech; Chandoo; Jon Peltier; MVP award

20151110

Hide Results Based on Date; Sample Data for Testing; Lock Slicers; Excel Improvements; Wind and Roses

20151103

Subtotal Problems; Holiday Planner; Build a Dashboard; Formatting Tips; Fall Colour

20151027

Combine data, add pictures, better reports

20151020

Hide Calculated Items With Zero Total

20151013

Compare supplier prices, CHOOSE formula

20151006

Spreadsheet Hall of Fame, quick totals

20150929

Read Office 2016 reviews, build better charts

20150922

Understand circular references, avoid nested IFs

20150915

Quick grand totals, Excel tips from Joel Spolsky

20150901

Dashboard tips, navigation shortcuts

20150818

Chart tricks, time entry, pivot table layouts

20150804

Excel Survey Results, dashboard tips

20150721

Free dashboard webinar, quick Excel survey

20150707

Use Rank in a Pivot Table, Free Excel Add-ins

20150623 Plan your meals, quick print, refer to tables    

20150616

Add custom chart labels, get started with macros, compare worksheets, get info from hyperlinks

20150609

Build a nested IF formula, improve your dashboards, work with dates, change a pivot table layout

20150602

See how to fix a broken drop down list, create an interactive chart, do fancy text tricks

20150526

See how to reverse last and first names, pin a shape to a chart point, learn some Solver history

20150519

Choose a chart type, check formula speed, work with pivot table source data

20150512

Analyze sales with a running total, select a file format, power query training

20150505

Look for formula inconsistencies, save time with keyboard shortcuts, use online Power BI

20150428

Make VLOOKUP faster, use keyboard shortcuts, run macros when Excel is closed

20150421

Create Drop Down List, Understand array formulas, speed up macros

20150414

Attend a free dashboard webinar, find data with VLOOKUP

20150407

More Than One Filter on Pivot Table Field

20150331

Simple Project Planning With Excel Gantt Chart

20150324

Enter Dates and Times in Excel

20150317

Arrange Pivot Table Data Vertically

20150310

To be added

20150303

Get Excel Worksheet Name with CELL Function

20150224

Add and Remove Excel Hyperlinks

20150217

Filter Multiple Pivot Tables With Excel 2010 Slicers

20150210

Excel Drop Down Opens At End

20150203

Create a Waterfall Chart in Excel

20150127

To be added

20150120

Delete Rows Based on Colour; Pivot Table Makeover; Quick Drop Down List

20150113

To be added

20150106

Get Cell Address as With Excel ADDRESS Function

20141216

To be added

20141209

Edit Excel 2010 List Data in Popup Form

20141202

Fix Currency Separators; Extra Items in Pivot Table Grouped Dates

Number Formatting; Pivot Table

20141125

Ignore Blanks When Pasting; Calculated Field; REPT Function

Data Entry Tips; Pivot Tables; Excel Functions

20141118

Pivot Table Fears; Copy Pivot Table Format and Values

Pivot Table

20141111

Fix Numbers That Don't Add; Pivot Table on Protected sheet

Excel Functions; Pivot Table

20141104

Count Cells Greater Than Set Amount; Report Cleanup; New Workbook Based On Old One

Excel Functions; Workbook Tips; Excel Tips

20141028

Excel Slicers; Running Totals, Chart Scores; Painted Pumpkin

Excel Formulas, Excel Charts

20141021

Create a Pivot Table from Multiple Sheets

Troubleshoot Reports, Refresh pivot tables

Braille tool

20141014

Store Multiple Values With Excel Scenarios

20141007

Fix Excel Numbers That Don't Add Correctly

20140930

To be added

20140923

Compare Cells With Excel EXACT Function

20140916

Excel Count Functions for Numbers, Data, Blanks

20140909

Problem VBA Code Debugging; 5 Pivot Table Problems; Split Ties With RANK

20140826

Fix an Excel Time Warp With LEFT RIGHT MID

20140812

To be added

20140729

3 Types of Excel Drop Down Lists Compared

20140715

Conditional Formatting Currency Symbols in Excel 2010

20140624

Excel Advanced Filter Copies Data to New Location

20140617

Pivot Table Date Filters

20140610

To be added

20140603

IFRAME Code; Pivot Table Macros; Audit Excel Formulas; Hide Dups

Baseball Statistics; Excel game 2048

20140527

To be added

20140520

Selecting Sections of an Excel Pivot Table

20140513

Macro Changes Excel Column Headings From Numbers To Letters

20140506

Copy Code to an Excel Workbook

20140429

Quickly Change Results for Excel COUNTIF Function

20140422

Pivot Table Grouping Affects Another Pivot Table

20140415

Excel VBA - Macro Runs When Worksheet Changed

20140408

Highlight Lottery Numbers with Conditional Formatting

20140401

Edit Recorded Excel Pivot Table Macro

20140325

Quickly Hide Selected Items in Excel Pivot Table

20140318

Excel VLOOKUP From Another Workbook

20140311

Allow Changes on a Protected Worksheet

20140304

Ignore Blank Problems in Excel Data Validation

20140225

Combine Cells in Excel Without Concatenate

20140218

To be added

20140211

Insert More Than One Row in Excel

20140204

New Search Feature in Excel 2010 AutoFilter

20140128

To be added

20140121

To be added

20140114

Fast Way to Find and Delete Excel Rows

20140107

Hide Excel VLOOKUP errors with IF and ISNA functions

20131217

Remove Date Grouping in Excel Filter Drop Downs

20131210

To be added

20131203

Count Duplicates in Excel List With Pivot Table

20131126

To be added

20131119

Automatically Add New Items to Data Validation Drop Downs

20131112

Copy Data From Web Browser to Excel

20131105

Select Large Range in Excel

20131029

Highlight Weekend Dates in Excel

20131022

Excel Conditional Formatting - Data Bars

20131015

To be added

20131008

Select Answers with Excel Option Buttons

20131001

How to use the Excel RANK Function

20130924

Excel Pivot Table Filters - Top 10

20130917

Duplicate Items Appear in Pivot Table; Prevent Duplicate Entries in Excel Table; Create Very Hidden Worksheets; Abundant Tomatoes

20130910

Quickly Customize the Excel Window

20130903

Sort With Excel Custom Lists

20130827

Customize the Excel 2007 Status Bar

20130820

Change Number of Sheets in New Excel Files

20130813

Select a Random Name in Excel

20130806

Pivot Table PivotStyles

20130730

Auto Resize Excel Text Boxes

20130723

Change Excel Comment Shape

20130716

Creating Excel Hyperlinks Is a Drag

20130709

Create Secret Hidden Questions in Excel

20130702

Show Developer Tab on the Excel Ribbon

20130625

See how a UserForm works, group text items in a pivot field

Pivot

20130618

Create a simple box plot, block new items in a filtered pivot field

Pivot

20130611

Adjust pivot table field list, interactive functions list

Pivot

20130604

Nested IF functions, find and SUBSTITUTE line breaks

Formula

20130528

Total filtered data with AGGREGATE, change pivot table filter layout

Pivot

20130521

Delete shapes, use Slicers

Pivot

20130514

Move a large pivot table, calculate annual savings

Pivot

20130507

Insert Rows shortcut, GetPivotData problem

Pivot

20130430

Find and prevent errors, problems adding slicers

Formula

20130423

Conditional Formatting in pivot table

Pivot

20130416

Multiple totals in pivot table

Pivot

20130409

Drop down symbols, chart shortcuts

Chart

20130402

Custom sort, divide without formulas

Sort

20130326

Limit dates to a specific range, average based on multiple criteria

Formula

20130319

Running totals in pivot table, prevent invalid entries in combo boxes

Pivot

20130312

Get accurate count in a pivot table, create a dependent combo boxes

Pivot

20130305

Group numbers by tens in a pivot table, create a quick list of dates

Pivot

20130226

Show message at top of sheet, quick grand totals

Macros

20130219

Round to a nickel, print new invoices, paste values shortcut

Formula

20130212

Date picker tool, pivot table Index

Pivot

20130206

New FORMULATEXT function, chart baselines

Formula

20130129

Ugly charts, free Excel audit tool, custom ribbon tab intro

Chart

20130122

Create a custom Ribbon tab, test formula dependencies

Ribbon

20130115

Find records with unmatched amounts, get the basics of big data

Formula

20130108

Keep numbers aligned when Excel is zoomed, quick keyboard shortcuts

Formatting

20121219

Show a picture in a comment, change all pivot charts with one filter

Pivot

20121211

Flexible links to a pivot table, get to the point in a dashboard

Pivot

20121204

Pick dates with a scroll bar, link a pivot chart to another table

Pivot

20121127

Holiday planner, intro to Excel arrays

Formula

20121120

Sum with multiple criteria, change calculation order in a pivot table

Pivot

20121113

Link a chart's title to a pivot filter, highlight high/low values in a chart

Pivot

20121106

Show interactive drop lines in a chart, create pivot table copies automatically

Pivot

20121030

Combo Chart Video, Date Checking

Chart

20121023

5 Excel tips, error when pasting filtered data

Tips

20121016

Find Text With INDEX and MATCH

Formula

20121009

Midnight Times Missing in Excel Worksheet

Formatting

20121002

List All Formulas in Workbook

Formula

20120925

Pivot table add-in, in-cell chart for stock prices

Pivot

20120918

To be added

20120911

To be added

20120904

To be added

20120828

To be added

20120821

To be added

20120814

To be added

20120807

To be added

20120731

To be added

20120723

To be added

20120716

Check Multiple Criteria with INDEX / MATCH; Document VBA Procedures; Creative Pivot Table Subtotal Headings; Auto Outline; Convert with Add-in

Functions; Programming; Pivot Table; Grouping; Add-ins

INDEX function; MATCH function; Lee Townsend; Pivot Table subtotals; Excel Outline; Doug Jenkins

20120709

To be added

20120702

To be added

20120625

To be added

20120618

To be added

20120611

To be added

20120604

To be added

20120528

To be added

20120521

To be added

20120514

To be added

20120507

To be added

20120430

To be added

20120423

Data Validation Arrows Are Missing

20120416

Remove Duplicate Records in Excel 2007

20120409

Copy Code to an Excel Workbook

20120402

Name a Range of Cells in Excel

20120326

Increase Numbers by Set Amount in Excel 2007

20120319

Remove Macro Warning in Excel

20120312

Add a Picture in Excel Comment

20120305

To be added

20120227

To be added

20120220

To be added

20120211

To be added

20120207

To be added

20120131

Time-saving Excel tips, text in PowerPivot measures

Pivot

20120124

Hide pivot table details, Excel exam preparation

Pivot

20120117

Parts Data Entry UserForm Update; Excel Weight Tracker Update; Monster Spreadsheets; Online Programming Course; Excel Humour

UserForms; Functions

Find last row with data; Weight targets; Track food intake; JavaScript; CodeAcademy

NOTE: To find newsletter articles not listed here, use the Site Search box, in the Navigation bar, at the top of the page.

 

;

About Debra

Last updated: August 14, 2022 9:43 PM