Heather Davis

86 Flips | 3 Magazines | 1 Like | 3 Following | 1 Follower | @HeatherDavi1d1p | Keep up with Heather Davis 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 “Heather Davis”

Mexico forced to rescue drowning oil giant Pemex

Mexico's state-owned oil company is drowning in a sea of cheap oil.<p>Pemex, as the oil giant is known, is suffering from a steep decline in production that has been exacerbated by the crash in crude. Years of losses have left Pemex with huge unfunded pension liabilities and on the hook for billions …

Ten Counterintuitive Pieces of Advice About Marriage

<i>This question originally appeared on Quora: What is the best marriage advice you would give?</i><p>I’m experienced. One divorce, a thousand bad …

How To Create A Simple Sales Evaluation Dashboard In Excel

By onFebruary 15, 2016 in Dashboard, INDEX and MATCH, VLOOKUP<p>In this tutorial we’ll take a look at how to create a simple dashboard using a combo …

How to Send a Single Excel Worksheet as Email Attachment

We often create and work on multiple Excel worksheets. These could be separate sheets in the same workbook (for example different worksheets for …

Cash Flow Forecasting Best Practices

<b>It is time to demystify existing misconceptions and practices</b><p>Earlier this year I participated in a discussion on the Proformative.com site, titled: …

Webinar on Demand - The Seven Sins of Using Spreadsheets for Analytics & How to Stop Right Now

<b>The Seven Sins of Using Spreadsheets for Analytics & How to Stop Right Now</b><p>Stop the bleed and your ship from sinking by gaining key Analytics …

How to Split Date and Time in Excel

If you download data into Excel, one column might have a combined date and time value. If you're going to create reports from that data, it's usually …

Analytics

Macro Toolbox

When storing utility macros, Excel users often elect to save them in the Personal Macro Workbook. The advantage is that the macros are available …

Shortcuts to hide/unhide rows and columns

In this video, we'll cover shortcuts for hiding and unhiding rows and columns.To hide columns, use Control + 0.When you do this, you'll see the …

How To Use VLOOKUP To Search A Segment Of A Listed Item In Excel

By onFebruary 19, 2016 in VLOOKUP<p>In this tutorial we’ll take a look at how to do a VLOOKUP when you are only searching for a segment of the …

Office Space

Welcome to Office Space, the new column that offers tips and tricks for scripting Microsoft® Office applications. We’ll post new tips every Tuesday …

Clean up your dirty accounts data fast with Power Query | Find your files and folders fast | The Excel Expert

Excel Novice 5 min tip – Quickly access frequently used files and folders<p>If you need to quickly access frequently used files and folders, use the <b>File</b> …

6 new Excel functions that simplify your formula editing experience

The Excel team is happy to announce six new functions that simplify some of your common calculations and help you avoid the tedious work of building …

Please join 50 ways to analyze data course to become an awesome analyst

Hi friends & readers of Chandoo.org,I am very happy to invite you to our newest online class, <b>50 ways to analyze your data.</b> This program makes you an …

Canceling a Command

Need to cancel a command you've already started? It is as easy as pressing a single keystroke.Read this ExcelTip: Canceling a Command <br>Microsoft Excel …

Four Fascinating Uses of Microsoft Excel: Artistic, Uber-Geeky, Life-Saving, and Paranoid

For scientists and researchers, the information age has radically improved academic productivity. The Internet has exponentially increased the …

Count Unique in Excel Pivot Table

In a previous article, Roger Govier showed us a couple of different ways to get a Unique count with a Pivot Table.• Create a Pivot of a Pivot Tables …

Analytics

How to Spell Check Worksheets in Excel

Excel’s spell check feature doesn’t have all the bells and whistles that Word’s does, but it does provide basic spell-checking functionality. You can …

Autosum many ranges quickly with Multi-select & ALT= [quick tip]

<i>Let’s say you have data in a worksheet in various ranges, and you want sum up each range at the bottom.</i>Something like this:<i>How to do all this one</i> …

Formula Friday- Speed Up Your VLOOKUPS in Larger Data Sets

Friday Formula Fun Time….. Do you find that your VLOOKUPS are sluggish sometimes when you are dealing with larger data sets?. Here is a way to speed …

Finding All Selected Items In A Slicer In Excel 2016 Using TextJoin()

When you are using slicers with an Excel PivotTable it’s often useful to be able to get a comma-delimited list of the items selected in that slicer …

How to Create a Position Cheat Sheet in Excel

Step-by-Step Instructions<p>1.<p>Visit the Auction Calculator and download a set of dollar values specific to your league’s settings. When you’ve completed …

Create an Awesome Excel Splash Screen For Your Spreadsheet

Introduction | Design Splash Screen | Animate Splash Screen | Hide Title Bar <i>(Optional)</i> | Display Splash Screen | Final Thoughts<b>Introduction</b>Give your …

Microsoft recaps all of the Office 365 updates from February

Microsoft issued quite a few updates to all of the Office apps throughout the month of February. Today, they recapped those updates, including both …

VBA Tips: Build an Excel Add-In

Build an Excel Add-In<p>About Add-Ins<p>An Excel Add-In is a file (usually with an <b>.xla</b> or <b>.xll</b> extension) that Excel can load when it starts up. The file …

Interactive Excel Functions List

There are lots of Excel function tips and tutorials on my Contextures website, and here on the Contextures blog. To help me keep track of everything, …

5 Keyboard shortcuts for writing better formulas

Posted on June 27th, 2013 in Learn Excel - 56 comments<p>As an analyst (or manager), I bet a good portion of your Excel time is spent writing formulas …

Dependent Drop Down Lists in Excel

In Excel, you can set up drop down lists that are dependent on the selection made in another cell. In this example, you select a region in column B, …

How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any …