Excel Easy
Follow
Find
9.8K views | +0 today
 
Scooped by Roger Fisher
onto Excel Easy
Scoop.it!

Microsoft Excel: The Bumblebee's 6 most useful add-ins - The ...

Microsoft Excel: The Bumblebee's 6 most useful add-ins - The ... | Excel Easy | Scoop.it
Microsoft Excel: The Bumblebee's 6 most useful add-ins. August 24, 2012 | article by Ken Thompson in Visualization/Analytics (9). There are a plethora of excel add-Ins out there , many of which perform a function which excel already performs ...
more...
No comment yet.

From around the web

Excel Easy
Promote Excel as an easy-to-use useful tool.
Curated by Roger Fisher
Your new post is loading...
Your new post is loading...
Scooped by Roger Fisher
Scoop.it!

Pro tip: Use Excel's conditional formatting to highlight invalid dates - TechRepublic

Pro tip: Use Excel's conditional formatting to highlight invalid dates - TechRepublic | Excel Easy | Scoop.it
Susan Harkins shows you how to visually identify invalid dates using Excel's conditional formatting feature.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Download free PDF course tutorial on Excel Analytics and Programming

Download free PDF course tutorial on Excel Analytics and Programming | Excel Easy | Scoop.it
Download free Excel Analytics and Programming course material, tutorial training, a PDF file by George Zhao.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

5 easy and powerful Excel features you may not know about

5 easy and powerful Excel features you may not know about | Excel Easy | Scoop.it
Today’s post on Excel was written by Purna Duggirala president of chandoo.org.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Your Excel formulas cheat sheet: 15 tips for calculations and common tasks

Your Excel formulas cheat sheet: 15 tips for calculations and common tasks | Excel Easy | Scoop.it
Save this for the spreadsheet jocks in your office--we'd bet even the experts don't know all of these formula tips.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel VBA Tips n Tricks #3 | Create and save all your macros in a Personal workbook - YouTube

http://LLTtutorials.com In this excel vba programming tips and tricks tutorial # 3, we will be create and save all of your macros in a single workbook called...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

CP032: Rules for making legendary column charts

CP032: Rules for making legendary column charts | Excel Easy | Scoop.it
In the 32nd session of Chandoo.org podcast, let’s make legendary column charts.
What is in this session?
Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful & insightful column charts all the time.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How to Build Sparkline Charts in Excel - MS Excel Tutorials - Excel.TV

How to Build Sparkline Charts in Excel - MS Excel Tutorials - Excel.TV | Excel Easy | Scoop.it
 Have you used Sparklines? They have been around since 2009 (Excel 2010).  But many people haven't used them. Sparklines are those charts that show up in one cell.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

MS Releases Word, Excel And Powerpoint On Andro...

MS Releases Word, Excel And Powerpoint On Andro... | Excel Easy | Scoop.it
It’s finally here! Microsoft has released Word, Excel and Powerpoint for Android tablets – for free! In April 2014, Microsoft released Word, Excel and Powerpoint on iOS with previews for Android tablets released the following November.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

VLOOKUP: V is for Volatile.

VLOOKUP: V is for Volatile. | Excel Easy | Scoop.it
Well THAT sure got your attention.
I was doing a bit of research for the book (the only bit, mind), and I came across this great old thread on VLOOKUP vs INDEX/MATCH.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Formula Arguments and Intellisense

Formula Arguments and Intellisense | Excel Easy | Scoop.it
Even though you’ve seen Excel’s Formula Intellisense a million times, I bet there’s a few things that you don’t know about it that can make your life even easier.
Let’s first look at an example for one of Excel’s in-built functions.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Tom’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells

Tom’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells | Excel Easy | Scoop.it
RT @TomUrtis: Tom’s Tutorials For #Excel: Conditionally Formatting Locked and Unlocked Cells
http://t.co/nUS1i43wth #MSExcel #analytics
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How to Create an Excel Spreadsheet from a PDF File

How to Create an Excel Spreadsheet from a PDF File | Excel Easy | Scoop.it
You ask your coworker for some data from a recent project. Your coworker is a well-meaning person, and so the data is placed into a PDF file so that it can be easily transferred to you. What your coworker didn't realize however, is that...
more...
No comment yet.
Rescooped by Roger Fisher from MarketingHits
Scoop.it!

9 Free Microsoft Excel Templates to Make Marketing Easier

9 Free Microsoft Excel Templates to Make Marketing Easier | Excel Easy | Scoop.it
Many of us can recall a time in high school when we were sitting in math class and thinking, "When am I ever going to use this stuff in the real world?"

And then we suddenly find ourselves in the real world, only to realize that numbers actually do play a pivotal role in what we do -- especially in digital marketing.

Via Brian Yanish - MarketingHits.com
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Spreadsheet Roundup 20150408

Spreadsheet Roundup 20150408 | Excel Easy | Scoop.it
Here is a roundup of selected spreadsheet articles that I've read in the past month. You'll find interesting tips, useful sample files, and new ideas for your own spreadsheets.
If you have suggestions for next month's roundup, please let me know.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Guerrilla Data Analysis Using Microsoft Excel: 2nd Edition Covering Excel 2010/2013: Oz du Soleil, Bill Jelen: 9781615470334: Amazon.com: Books

Guerrilla Data Analysis Using Microsoft Excel: 2nd Edition Covering Excel 2010/2013

~ Bill Jelen (author) More about this product
List Price: $24.95
Price: $23.70
You Save: $1.25 (5%)
Guerrilla Data Analysis Using Microsoft Excel: 2nd Edition Covering Excel 2010/2013 [Oz du Soleil, Bill Jelen] on Amazon.com. *FREE* shipping on qualifying offers.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Why learn Excel?

Why learn Excel? | Excel Easy | Scoop.it
You may not be an accountant or be using excel for your business, but there are many reasons why you should become proficient at excel. While there ar...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

The 7 Characters You Can't Use in Excel Worksheet Tab Names - Accountingweb.com

The 7 Characters You Can't Use in Excel Worksheet Tab Names - Accountingweb.com | Excel Easy | Scoop.it
Also, there is one word that cannot be assigned to an Excel worksheet. Find out what that word is and its backstory.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

ActiveX Controls in Microsoft Excel 2010 / 2013 | Tips

ActiveX Controls in Microsoft Excel 2010 / 2013 | Tips | Excel Easy | Scoop.it
ActiveX controls can be used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. ActiveX controls provide more flexible design
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

5 tips for creating macros perfectly in Office applications - PCWorld

5 tips for creating macros perfectly in Office applications - PCWorld | Excel Easy | Scoop.it
Shrink hours of labor to minutes with these easy time-saving techniques.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Conditionally Format Chart Backgrounds

Conditionally Format Chart Backgrounds | Excel Easy | Scoop.it
Recently, Paul, a reader, of the Chandoo Blog Post: Colors-in-excel-chart-labels-trick asked a question:
“Hi Chandoo,
Is it possible to change the background label color on chart depending on the value?
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Here is How You Can Find Circular References in Microsoft Excel - Accountingweb.com

Here is How You Can Find Circular References in Microsoft Excel - Accountingweb.com | Excel Easy | Scoop.it
Tracking down circular references scattered across numerous worksheets can be tricky. But there's a way to do it.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Tatsuo Horiuchi | the 73-year old Excel spreadsheet artist

Tatsuo Horiuchi | the 73-year old Excel spreadsheet artist | Excel Easy | Scoop.it
"Cherry Blossoms of Historical Castle site" (2006) | click to enlarge.

“I never used Excel at work but I saw other people making pretty graphs and thought, ‘I could probably draw with that,’” says 73-year old Tatsuo Horiuchi.
more...
No comment yet.