Contextures Newsletter Article Index

Don't miss my latest Excel tips and videos! Sign up for my weekly newsletter with Excel tips, and links to other Excel news and resources.

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
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, Sumit Bansal, 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	To be added
20141125	Ignore Blanks When Pasting; Calculated Field; REPT Function
20141118	Copy Pivot Table Format and Values
20141111	Allow Excel Pivot Table on Protected Sheet
20141104	Count Cells Greater Than Set Amount With Excel COUNTIF Function
20141028	Excel Slicers for Halloween Horror Films
20141021	Create a Pivot Table from Multiple Sheets
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.

Don't Miss Our Excel Tips

Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.

;

Last updated: October 19, 2021 11:20 AM
Contextures RSS Feed