Zack Deasy

45 Flips | 1 Magazine | 1 Following | 20 Followers | @zackdeasy1 | Keep up with Zack Deasy 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 “Zack Deasy”

Excel is the go-to tool for finance professionals and these courses can give you an expert-level understanding

<i>The Insider Picks team writes about stuff we think you'll like. Business Insider has affiliate partnerships so we may get a share of the revenue from your purchase.</i><p>Shutterstock Microsoft Excel can be one of the most powerful tools on your computer if you know how to use it. For the lay person, a …

10 steps to creating a scrolling Excel chart

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data.<p>Sometimes a chart's …

Automatic Updating of Excel Tables in PowerPoint Slides

You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you …

OFFSET formula – Explained

Posted on September 17th, 2012 in Learn Excel - 83 comments<p><b>Today, lets learn OFFSET formula.</b><p>What is OFFSET and why bother using it?<p>OFFSET formula …

Five Minute Lessons

Hi Kristin<p>What I love about Excel is that there are many ways to skin this cat. Here's one which doesn't even use any IF functions (and stays …

What are best Excel interview questions? [survey]

Posted on September 27th, 2013 in interviews , Learn Excel - 55 comments<p>Hello folks…<p>Time for a fun & useful survey. This time lets talk about <b>Excel</b> …

20 Tricks That Can Make Anyone An Excel Expert

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore …

Smile for Excel’s Camera

There are many more or less unknown tools in Excel. One of those is definitely the Camera Tool. Imagine the following scenario. You have two sheets …

Sum Values In A Month

Sometimes we get data in Excel that makes it somewhat difficult to look at the big picture. For example, you might get a list of transactions with a …

Microsoft Excel for iPhone

In today’s increasingly mobile world, it seems like the productivity we have grown to associate with our desktop environments should start to migrate …

Three ways to hide zero values in an Excel sheet

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.<p>Zeroes are valid data, …

11 basic Excel tricks that will change your life

Microsoft Excel is an amazing piece of software, and even regular users might not be getting as much out of it as they can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know.<p>Of course you can move from cell to cell with …

Top 10 Formulas for Aspiring Analysts

Learn Excel - 155 comments<p>Few weeks ago, someone asked me “What are the top 10 formulas?” That got me thinking.<p>While each of us have our own list of …

10 Tips to Make Better and Boss-proof Excel Spreadsheets

Excel Howtos , Featured , Learn Excel - 64 comments<p>We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined …

Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]

Excel Howtos - 53 comments<p>Here is a quick Excel tip to kick start your week.<p><b>Sometimes, we want to enter same data in to several cells</b>. You can <b>use</b> …

Right-click from the keyboard, not the mouse.

Learn Excel , Posts by Jeff - 74 comments<p>Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube …

Calculate CAGR (Compounded Annual Growth Rate) using Excel [Formulas]

Financial Modeling - 34 comments<p><b>Here is a story we all are familiar with,</b><p>Jack learns about compound interest in school. He quickly forgets about it …

Quickly combine text in multiple cells using this trick! [Formulas]

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, …

Add pictures to a chart axis

<i>Article updated on February 05, 2018</i><p>This picture below shows you a column chart with pictures (flags) below each column.<p>Watch this video to learn how …

Excel PowerPivot PivotTable Named Sets

Excel PivotTable Named Sets enable you to pick and choose which columns or rows you want included in your PivotTable report, <b>but there's a catch</b>. They …

Excel Chart Makeover • My Online Training Hub

Getting the formatting in your chart right can make the difference between clear, concise information and just a pretty picture.<p>Take a look at this …

Slaying Excel Dragons Book #12: How Excel Formulas Are Evaluated Order of Operations Excel Formulas

Analytics

Analyze data instantly with Excel 2013's Quick Analysis

Excel 2013's new Quick Analysis tool gives quick access and contextual choices for analyzing your data.<p>Analyzing data in Excel has never been easier …

Analytics

Twenty-Five Ways to Use Excel's Name Box

It's pretty much impossible to use Excel and not notice the Name Box, which appears just above the upper-left-hand corner of the worksheet frame. …

42 tips for Excel time travelers

Excel Howtos - 73 comments<p><b>Today, let’s travel in time</b>. Pack your photon ray guns, extra underwear, buckle your seat belts and open Excel!<p>Of course, …

What is Excel SUBTOTAL formula and 5 reasons why you should use it

Learn Excel - 68 comments<p><b>Today we will learn Excel SUBTOTAL formula and 5 beautiful reasons why you should give it a try.</b><p>SUBTOTAL formula is used to …

PowerPivot: A Game Changer for Excel Pivot Table Users

Microsoft, with the release of Excel 2013, has introduced a new functionality titled “PowerPivot.” As a fan of pivot tables, my interest was piqued …

How to build a search box to highlight data

In this video, we'll look at a way to create a search box that highlights rows in a table, by using conditional formatting, and a formula that checks …

Changing the Look of Embedded Objects – Bacon Bits

Click Insert->Object to open the Object dialog box.<p>In the Object dialog box, go the Create from File tab and click the Browse button to find the file …