Devlin

25 Flips | 2 Magazines | 3 Likes | 5 Following | 2 Followers | @dgphlip | Keep up with Devlin on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Devlin”

5 conditional formatting top tips – Excel basics

Time for another round of unconditional love. Today, let’s <b>learn about conditional formatting top tips</b>. It is one of the most useful and powerful …

OmniFocus 3 for Mac to Ship in September

The Omni Group makes awesome productivity software for OS X and iOS in the beautiful Pacific Northwest.enCopyright 2018

Popup List of Excel Sheets

If you’re working in an Excel file with lots of worksheets, it can take a while to scroll to the ones that you need. Sometimes you can’t even …

Analytics

Hide Used Items

Don’t let Excel yell at us, if we accidentally enter a duplicate value in a column. Okay, maybe Excel isn’t really yelling, but it seems like that …

Employment

Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

I was recently asked, What is my most recommended Excel Tip?My quick response was to regularly press <b>Ctrl+S</b>, Yes simply Save.I have been caught out a …

Analytics

Quickly filter a table by combination of selected cell values using VBA

<b>Filtering is one of the most used feature in Excel.</b> It is a quick way to take lots of data and narrow down to the subset we want.Naturally, there are …

Databases

Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers

<b>Slicers</b> are one of my favorite feature in Excel. And here is a quick demo to show why they are my favorite.Slicers – what are they?Slicers are <i>visual</i> …

Analytics

Tables, PivotTables, and Macros: music to your ears » Chandoo.org - Learn Excel, Power BI & Charting Online

Posts by Jeff , VBA Macros - 35 comments<p>Howdy folks. Jeff Weir here again. You may remember me from posts such as What would James Bond have in his …

Free 2015 Calendar, daily planner templates [download]

Here is a New year gift to all our readers –<b> free 2015 Excel Calendar & daily planner Template.</b><b>This calender has,</b>• One page full calendar with notes, …

Compare 2 sets of data by letter or word & highlight mismatches [vba] » Chandoo.org - Learn Excel, Power BI & Charting Online

VBA Macros - 27 comments<p>We analysts like to compare. If you ever want to keep an analyst busy, just give her 2-3 options. She won’t return to your …

The ultimate VLOOKUP trick - Multi-condition Lookup » Chandoo.org - Learn Excel, Power BI & Charting Online

The ultimate VLOOKUP trick – Multi-condition Lookup<p>Learn Excel - 159 comments<p><i>This is a guest post by Sohail Anwar.</i><p>Let’s not bore you with an intro. …

Excel Templates by Vertex42

Excel templates are a great way to increase your productivity. They allow you to do awesome things with Excel even if you only have a basic …

Software

CP021: How to quickly compare 2 lists in Excel

In the 21st session of Chandoo.org podcast, lets <b>compare lists</b>. <i>Quickly</i>What is in this session?<b>Comparing things is a favorite pastime for analysts all</b> …

Excel Tools for Complex Workbooks

Today, we’ll look at Excel tools for complex workbooks. These tools can help you manage links to other files, track formulas, and do other helpful …

Implementing Modular Spreadsheet Development - a walkthrough » Chandoo.org - Learn Excel, Power BI & Charting Online

Implementing Modular Spreadsheet Development – a walkthrough<p>Financial Modeling , VBA Macros - 6 comments<p><i>This article is written by Michael Hutchens</i> …

Quickly combine text in multiple cells using this trick! [Formulas] » Chandoo.org - Learn Excel, Power BI & Charting Online

Excel Howtos - 176 comments<p><i>Ever wondered how to go from a bunch of cells with text to one big combined text?</i> Like this:<p>Well, there is a simple trick, …

FREE 2014 Calendar - Download and Print Year 2014 Calendar, Daily Planner & Event tracker today - Excel Calendar Template [2014]

Free 2014 Calendar, daily planner templates [download]<p>Learn Excel - 41 comments<p>Here is a New year gift to all our readers – <b>free 2014 Excel Calendar &</b> …

What is Power Pivot - an Introduction [video] » Chandoo.org - Learn Excel, Power BI & Charting Online

What is Power Pivot – an Introduction [video]<p>Learn Excel , Power Pivot - 60 comments<p>Today, lets talk about Power Pivot & understand it.<p>What is Power …

Visualizing KPI Distributions thru Box Plots - KPI Dashboards using Excel

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]<p>Analytics , Charts and Graphs , Learn Excel - 27 comments<p>This is a Guest Post …

Comparing 2 Key Performance Indicators - KPI Dashboards [Part 5 of 6]

KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]<p>Analytics , Charts and Graphs , Learn Excel - 27 comments<p>This is a Guest Post by <i>Robert</i> on …

Adding Microcharts & Graphs to KPI Dashboards - [Part 4 or 6]

Prepare the workbook for the new features (5 extra columns on the dashboard for the bar charts, additional rows on the data worksheet to define the …

KPI Dashboards in Microsoft Excel - Highlighting KPIs based on Percentiles [Part 3 of 6]

KPI Dashboards – Highlight KPIs Based on Percentile [Part 3 or 6]<p>Charts and Graphs , Featured , Learn Excel - 39 comments<p><b>Creating KPI Dashboards in</b> …

Creating Key Performance Indicator (KPI) Dashboards in Microsoft Excel [Part 2 or 6] - Adding Sort Feature

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort<p><b>Creating KPI Dashboards in Microsoft Excel is a series of 6 posts</b> by</b> …

KPI (Key Performance Indicator) Dashboards in Excel - Tutorial [Part 1 of 6]

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]<p><i>Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert.</i><p>This 6 Part …