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 |
|---|---|---|---|
| 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; Excl 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 |
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 | |
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 | |
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 | |
Find Links, Excel Names, Dashboards, Excel Fonts | Add-ins, Dashboards, Formatting, Functions, Names | Bill Manville, troubleshooting, Kevin Lehrbass, data viz tips | |
Shortcuts, Macros, Troubleshooting, Formulas, Games | Shortcuts, Macros, Troubleshooting, Formulas, Games | Sudoku, Andy Pope, Chart Exporter, Bill Jelen, Excel Tools, data validation, data entry, shortcuts | |
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 | |
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 | |
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 | |
Spreadsheet Day, Lookup Challenge, Date Grouping, Excel AMA, Excel Solver | Spreadsheets, Lookup Formula, Grouping, Solver | VisiCalc, formula challenge, pivot table, Redditt, Solver | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
Formula Challenge - Split Address, Quick Backup Tool, Excel Shortcuts, Formulas for Architects | Functions, Add-ins, Shortcuts | Formula challenge, File backup, Tim Berty, FLOOR, CEILING | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
Keyboard Shortcut Problem, Favourite Commands, Debt Snowball, Excel Chart |
|
| |
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 | |
Filter for Dates, VLOOKUP Problem, Excel Budget, Excel Charts |
|
| |
Count Items in a Cell, Dashboard Course Giveaway, Excel Charts, Excel Formula, Excel Events |
|
| |
Save Your Excel Ribbon, Solution Rolling Total Challenge, Power BI, Excel Contest, Excel Events |
|
| |
Grouped Dates, Rolling Total Challenge, Excel Addins, Shpreadsheet Threats | Filters |
| |
Fix the Footer, Data Viz, VisiCalc History, Conditional Formatting | Spreadsheets |
| |
Excel Marimekko Chart, Column Header Letters, Feedback, Spreadsheet History, Excel Song, Excel Dashboards | Charts |
| |
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 | |
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 | |
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 | |
AutoFilter Shortcuts, Tweaking the Budget, ModelOff Challenge, Square Pie, Pivot Table Webinar, Office Zoo | Filters, Functions, Pivot Tables | Mike Alexander; Annual Cost Calculator | |
Excel COUNTIF Challenge | Functions |
| |
Fast Way to Find and Delete Excel Rows |
|
| |
Quick Copy of Excel File, Volume on Excel Videos, Spreadsheet Tasks, Lookup Function, Leaves are Falling | Functions, Excel Tips |
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Dependent Combo Box in Excel |
|
| |
To be added |
|
| |
Excel -- Pivot Tables -- Data Fields |
|
| |
Quick Ways to Unpivot Excel Data |
|
| |
To be added |
|
| |
To be added |
|
| |
Hide Sheets Based on Tab Color |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Numbers Change to Dates in Excel |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Get Excel Version Number with INFO Function |
|
| |
Excel Sheet Selector With No Macros |
|
| |
To be added |
|
| |
Excel VLOOKUP Sorting Problem |
|
| |
Quick Reports With Excel Custom Views |
|
| |
To be added |
|
| |
To be added |
|
| |
Remove Macro Warning in Excel |
|
| |
Get Table Data With Excel HLOOKUP Function |
|
| |
Get Excel Worksheet Name with CELL Function |
|
| |
Check Box VBA |
|
| |
To be added |
|
| |
Count Duplicates in Excel List With Pivot Table |
|
| |
To be added |
|
| |
Excel Fiscal Year Calculations |
|
| |
To be added |
|
| |
Excel -- Sample Data |
|
| |
To be added |
|
| |
To be added |
|
| |
Hide Calculated Items With Zero Total |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Create Drop Down List in Excel Worksheet Cell |
|
| |
To be added |
|
| |
More Than One Filter on Pivot Table Field |
|
| |
Simple Project Planning With Excel Gantt Chart |
|
| |
Enter Dates and Times in Excel |
|
| |
Arrange Pivot Table Data Vertically |
|
| |
To be added |
|
| |
Get Excel Worksheet Name with CELL Function |
|
| |
Add and Remove Excel Hyperlinks |
|
| |
Filter Multiple Pivot Tables With Excel 2010 Slicers |
|
| |
Excel Drop Down Opens At End |
|
| |
Create a Waterfall Chart in Excel |
|
| |
To be added |
|
| |
Shortcuts to Create Drop Down List in Excel |
|
| |
To be added |
|
| |
Get Cell Address as With Excel ADDRESS Function |
|
| |
To be added |
|
| |
Edit Excel 2010 List Data in Popup Form |
|
| |
To be added |
|
| |
Repeat Text with Excel REPT Function |
|
| |
Copy Pivot Table Format and Values |
|
| |
Allow Excel Pivot Table on Protected Sheet |
|
| |
Count Cells Greater Than Set Amount With Excel COUNTIF Function |
|
| |
Excel Slicers for Halloween Horror Films |
|
| |
Create a Pivot Table from Multiple Sheets |
|
| |
Store Multiple Values With Excel Scenarios |
|
| |
Fix Excel Numbers That Don't Add Correctly |
|
| |
To be added |
|
| |
Compare Cells With Excel EXACT Function |
|
| |
Excel Count Functions for Numbers, Data, Blanks |
|
| |
Manually Group Pivot Table Items |
|
| |
Fix an Excel Time Warp With LEFT RIGHT MID |
|
| |
To be added |
|
| |
3 Types of Excel Drop Down Lists Compared |
|
| |
Conditional Formatting Currency Symbols in Excel 2010 |
|
| |
Excel Advanced Filter Copies Data to New Location |
|
| |
Pivot Table Date Filters |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Selecting Sections of an Excel Pivot Table |
|
| |
Macro Changes Excel Column Headings From Numbers To Letters |
|
| |
Copy Code to an Excel Workbook |
|
| |
Quickly Change Results for Excel COUNTIF Function |
|
| |
Pivot Table Grouping Affects Another Pivot Table |
|
| |
Excel VBA - Macro Runs When Worksheet Changed |
|
| |
Highlight Lottery Numbers with Conditional Formatting |
|
| |
Edit Recorded Excel Pivot Table Macro |
|
| |
Quickly Hide Selected Items in Excel Pivot Table |
|
| |
Excel VLOOKUP From Another Workbook |
|
| |
Allow Changes on a Protected Worksheet |
|
| |
Ignore Blank Problems in Excel Data Validation |
|
| |
Combine Cells in Excel Without Concatenate |
|
| |
To be added |
|
| |
Insert More Than One Row in Excel |
|
| |
New Search Feature in Excel 2010 AutoFilter |
|
| |
To be added |
|
| |
To be added |
|
| |
Fast Way to Find and Delete Excel Rows |
|
| |
Hide Excel VLOOKUP errors with IF and ISNA functions |
|
| |
Remove Date Grouping in Excel Filter Drop Downs |
|
| |
To be added |
|
| |
Count Duplicates in Excel List With Pivot Table |
|
| |
To be added |
|
| |
Automatically Add New Items to Data Validation Drop Downs |
|
| |
Copy Data From Web Browser to Excel |
|
| |
Select Large Range in Excel |
|
| |
Highlight Weekend Dates in Excel |
|
| |
Excel Conditional Formatting - Data Bars |
|
| |
To be added |
|
| |
Select Answers with Excel Option Buttons |
|
| |
How to use the Excel RANK Function |
|
| |
Excel Pivot Table Filters - Top 10 |
|
| |
Go Undercover With Hidden Excel Worksheets |
|
| |
Quickly Customize the Excel Window |
|
| |
Sort With Excel Custom Lists |
|
| |
Customize the Excel 2007 Status Bar |
|
| |
Change Number of Sheets in New Excel Files |
|
| |
Select a Random Name in Excel |
|
| |
Pivot Table PivotStyles |
|
| |
Auto Resize Excel Text Boxes |
|
| |
Change Excel Comment Shape |
|
| |
Creating Excel Hyperlinks Is a Drag |
|
| |
Create Secret Hidden Questions in Excel |
|
| |
Show Developer Tab on the Excel Ribbon |
|
| |
See how a UserForm works, group text items in a pivot field | Pivot |
| |
Create a simple box plot, block new items in a filtered pivot field | Pivot |
| |
Adjust pivot table field list, interactive functions list | Pivot |
| |
Nested IF functions, find and SUBSTITUTE line breaks | Formula |
| |
Total filtered data with AGGREGATE, change pivot table filter layout | Pivot |
| |
Delete shapes, use Slicers | Pivot |
| |
Move a large pivot table, calculate annual savings | Pivot |
| |
Insert Rows shortcut, GetPivotData problem | Pivot |
| |
Find and prevent errors, problems adding slicers | Formula |
| |
Conditional Formatting in pivot table | Pivot |
| |
Multiple totals in pivot table | Pivot |
| |
Drop down symbols, chart shortcuts | Chart |
| |
Custom sort, divide without formulas | Sort |
| |
Limit dates to a specific range, average based on multiple criteria | Formula |
| |
Running totals in pivot table, prevent invalid entries in combo boxes | Pivot |
| |
Get accurate count in a pivot table, create a dependent combo boxes | Pivot |
| |
Group numbers by tens in a pivot table, create a quick list of dates | Pivot |
| |
Show message at top of sheet, quick grand totals | Macros |
| |
Round to a nickel, print new invoices, paste values shortcut | Formula |
| |
Date picker tool, pivot table Index | Pivot |
| |
New FORMULATEXT function, chart baselines | Formula |
| |
Ugly charts, free Excel audit tool, custom ribbon tab intro | Chart |
| |
Create a custom Ribbon tab, test formula dependencies | Ribbon |
| |
Find records with unmatched amounts, get the basics of big data | Formula |
| |
Keep numbers aligned when Excel is zoomed, quick keyboard shortcuts | Formatting |
| |
Show a picture in a comment, change all pivot charts with one filter | Pivot |
| |
Flexible links to a pivot table, get to the point in a dashboard | Pivot |
| |
Pick dates with a scroll bar, link a pivot chart to another table | Pivot |
| |
Holiday planner, intro to Excel arrays | Formula |
| |
Sum with multiple criteria, change calculation order in a pivot table | Pivot |
| |
Link a chart's title to a pivot filter, highlight high/low values in a chart | Pivot |
| |
Show interactive drop lines in a chart, create pivot table copies automatically | Pivot |
| |
Combo Chart Video, Date Checking | Chart |
| |
5 Excel tips, error when pasting filtered data | Tips |
| |
Find Text With INDEX and MATCH | Formula |
| |
Midnight Times Missing in Excel Worksheet | Formatting |
| |
List All Formulas in Workbook | Formula |
| |
Pivot table add-in, in-cell chart for stock prices | Pivot |
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Data Validation Arrows Are Missing |
|
| |
Remove Duplicate Records in Excel 2007 |
|
| |
Copy Code to an Excel Workbook |
|
| |
Name a Range of Cells in Excel |
|
| |
Increase Numbers by Set Amount in Excel 2007 |
|
| |
Remove Macro Warning in Excel |
|
| |
Add a Picture in Excel Comment |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
To be added |
|
| |
Time-saving Excel tips, text in PowerPivot measures | Pivot |
| |
Hide pivot table details, Excel exam preparation | Pivot |
| |
UserForm example, weight tracker, javascript course | UserForms |
|
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: June 18, 2019 10:34 AM
Contextures RSS Feed