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

Spreadsheet Invasion [INFOGRAPHIC]

Something for you leading into the Thanksgiving weekend. Enjoy this short video (below) by Amy Thornley, which she made for smile for london. It was animated frame-by-frame in Excel. I look forward to when someone makes this an actual ...
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!

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.
Scooped by Roger Fisher
Scoop.it!

MS Excel - Calculations

MS Excel - Calculations | Excel Easy | Scoop.it
Why Excel Calculations Excel calculations, formulae and functions are used to: create essential business spreadsheets, manage income and expenses, manage and automate finances, help with day-to-day assesment of the viability of projects and...
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.
Scooped by Roger Fisher
Scoop.it!

How to Export QuickBooks Reports to Excel with Advanced Excel Options - Accountingweb.com

How to Export QuickBooks Reports to Excel with Advanced Excel Options - Accountingweb.com | Excel Easy | Scoop.it
How to Export QuickBooks Reports to Excel with Advanced Excel Options
Accountingweb.com
If you are like most accountants, you often need to export a report from QuickBooks to Excel to do further analysis.
more...
No comment yet.