Search Contextures Sites
Excel Weekly News from Contextures June 4, 2012
Hide AutoFilter arrows, create descriptive stats in Excel, find chart tutorials, and other tips, in this week's Excel news from Contextures.- Debra email@example.com
Hide AutoFilter ArrowsAfter you add an AutoFilter in Excel, you can hide one or more arrows in the AutoFilter headings. For example, if the table has 10 columns, you can leave the heading arrows only on 2 or 3 of the columns that you want people to filter.
Click here to read the article: Hide AutoFilter Arrows
Trouble counting AutoFilters with VBAWhile I was working with Excel AutoFilter last week, I ran into some challenges. It should have been a simple task to count all the AutoFilters on a worksheet, but it wasn't so easy!
Warning -- This article is for Excel nerds only -- I go into detail on my results when trying to count with different programming methods in Excel VBA.
Click here to see the gory details: Trouble counting AutoFilters with VBA
Statistically Speaking with Excel: Basic Descriptive StatsAre you proficient in using Excel for statistical analysis? If not, you can learn some basics from The Science Goddess, who described how to analyze student data, using Excel functions.
Click here to see the details: Basic Descriptive Stats
Copy Unique ValuesDo you have a simple trick for getting a list of unique values in Excel? For example, if you have a list of customers, how can you get a list of the States those customers live in, without any duplicate state names?
In the Daily Dose of Excel, Dick Kusleika wrote a macro to extract a unique list. In the comments, Dave recommends using the Remove Duplicates feature, which was introduced in Excel 2007. That's my preference too, or an Advanced Filter, to copy unique values to a different worksheet.
Click here to see Dick's macro: Copy Unique Values
My instructions for using the Remove Duplicates feature are here, along with a short video: Remove Duplicates in Excel 2007
Excel Chart TutorialsIf you're looking for instructions on creating Excel charts, the Excel development team at Microsoft has compiled a list of their best tutorials: Our eight best tutorials on Excel charts
If you're looking for advanced tutorials on Excel charts, visit Jon Peltier's Peltier Tech blog and website. On my Contextures website, I have a list of articles from Jon's site, which I refer to often: Charting Tutorials on Peltier Tech Site
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
Contextures Inc., Copyright ©2017
All rights reserved.