Contextures

Contextures Newsletter Article Index

Find newsletter articles in the interactive list of articles, shown below. Sort, filter, or search the list, to find specific articles.

NOTE: This list is under construction, and details for older articles will be added as soon as possible.

Interactive Excel Newsletter Index

Issue

Articles

Topics

Notes

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

To be added

20170606

To be added

20170530

To be added

20170523

Hide Used Items in Drop Down List

20170516

To be added

20170509

To be added

20170502

To be added

20170425

To be added

20170418

Excel Rounding Functions

Functions

20170411

To be added

20170404

To be added

20170328

Excel Name Fix Challenge

Functions

20170321

Freeze and Zoom Macros

Macros

20170314

To be added

20170307

To be added

20170228

To be added

20170221

To be added

20170214

To be added

20170207

To be added

20170131

To be added

20170124

To be added

20170117

Remove Date Grouping in Filters

Filters

20170110

VisiCalc Anniversary 2017

Spreadsheets

20161213

Excel Marimekko Chart

Charts

20161206

To be added

20161129

To be added

20161122

Lock Heading Rows in Place

Worksheets

20161115

Calculate Annual Costs and Savings

Functions

20161108

Excel COUNTIF Challenge

Functions

20161101

Fast Way to Find and Delete Excel Rows

20161025

To be added

20161018

To be added

20161011

To be added

20161004

To be added

20160927

To be added

20160920

Dependent Combo Box in Excel

20160913

To be added

20160906

Excel -- Pivot Tables -- Data Fields

20160823

Quick Ways to Unpivot Excel Data

20160809

To be added

20160726

To be added

20160712

Hide Sheets Based on Tab Color

20160628

To be added

20160621

To be added

20160614

To be added

20160607

Numbers Change to Dates in Excel

20160531

To be added

20160524

To be added

20160517

To be added

20160510

To be added

20160503

To be added

20160426

To be added

20160419

To be added

20160412

To be added

20160405

To be added

20160329

To be added

20160322

Get Excel Version Number with INFO Function

20160315

Excel Sheet Selector With No Macros

20160308

To be added

20160301

Excel VLOOKUP Sorting Problem

20160223

Quick Reports With Excel Custom Views

20160216

To be added

20160209

To be added

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

To be added

20151208

Count Duplicates in Excel List With Pivot Table

20151201

To be added

20151124

Excel Fiscal Year Calculations

20151117

To be added

20151110

Excel -- Sample Data

20151103

To be added

20151027

To be added

20151020

Hide Calculated Items With Zero Total

20151013

To be added

20151006

To be added

20150929

To be added

20150922

To be added

20150915

To be added

20150901

To be added

20150818

To be added

20150804

To be added

20150721

To be added

20150707

To be added

20150616

To be added

20150609

To be added

20150602

To be added

20150526

To be added

20150519

To be added

20150512

To be added

20150505

To be added

20150428

To be added

20150421

Create Drop Down List in Excel Worksheet Cell

20150414

To be added

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

Shortcuts to Create Drop Down List in Excel

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

Repeat Text with Excel 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

Manually Group Pivot Table Items

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

To be added

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

Go Undercover With Hidden Excel Worksheets

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

To be added

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

UserForm example, weight tracker, javascript course

UserForms

 

 

NOTE: To find newsletter articles not listed here, do a Google search, and add the site info.
For example: vlookup site:contextures.com/newsletter

 

 

Last updated: December 15, 2017 2:37 PM
Contextures RSS Feed