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

Macro to copy data X number of times into a column - ExcelBanter

Macro to copy data X number of times into a column Excel Discussion (Misc queries) ... A Microsoft Excel forum. ExcelBanter ...
more...
No comment yet.
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...
Rescooped by Roger Fisher from FrankensTeam's Excel Collection
Scoop.it!

Excel Advanced Filters

Excel Advanced Filters | Excel Easy | Scoop.it
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.

Via Kris
more...
Kris's curator insight, April 18, 2013 11:44 AM

Formulas in criteria - Great!

Progressive training's curator insight, February 9, 11:07 AM

Excel Advanced Filters

 

Scooped by Roger Fisher
Scoop.it!

How Do You Stay Productive in this Social Media World? - Using MS Excel Of Course! - Nerd Enterprises, Inc.

How Do You Stay Productive in this Social Media World? - Using MS Excel Of Course! - Nerd Enterprises, Inc. | Excel Easy | Scoop.it
For those of us who bill by the hour it comes down to billable time. Then there are those of us whose job it is to bring in new business. So we set our goals a little differently. How much in new business are you bringing in?
more...
Progressive training's curator insight, August 13, 12:08 AM

How Do You Stay Productive in this Social Media World? - Using MS Excel Of Course!

Scooped by Roger Fisher
Scoop.it!

3 Project Management Excel Sheets to Help You Stay Organized - Search Engine People (blog)

3 Project Management Excel Sheets to Help You Stay Organized - Search Engine People (blog) | Excel Easy | Scoop.it
3 Project Management Excel Sheets to Help You Stay Organized
Search Engine People (blog)
Create an excel spreadsheet and simply jot down in one column all the projects you're currently working on.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

One of these things is not like the other…

Sometimes when I copy code from the web and paste it into VBA, I get something like this:
 
 
…and I’m damned if I know why. It’s not the usual culprit of incorrect quote marks. It’ something else, and I don’t know what.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Exploring the Nuances of Excel's SUM Function - Accountingweb.com

Exploring the Nuances of Excel's SUM Function - Accountingweb.com | Excel Easy | Scoop.it
Accountingweb.com
Exploring the Nuances of Excel's SUM Function
Accountingweb.com
... services nationwide. Contact David at david@acctadv.com or follow him on Twitter.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Free Excel Tables Webinar | Microsoft Excel and Access Experts Blog

Free Excel Tables Webinar | Microsoft Excel and Access Experts Blog | Excel Easy | Scoop.it
In them I will be covering the basics of Excel tables, some of their key features, some of their downfalls, as well as working with them with VBA. Registration links: Excel ...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Maximizing Excel's Alt-Down Arrow Keyboard Shortcut - Accountingweb.com

Maximizing Excel's Alt-Down Arrow Keyboard Shortcut - Accountingweb.com | Excel Easy | Scoop.it
Accountingweb.com
Maximizing Excel's Alt-Down Arrow Keyboard Shortcut
Accountingweb.com
Alt-Down Arrow is one of my favorite keyboard shortcuts in Excel. First off, it gives me an easy means to speed through repetitive data entry within a column.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel VBA Macro Adds IfError() Functions To Every Formula | Excel ...

Excel VBA Macro Adds IfError() Functions To Every Formula | Excel ... | Excel Easy | Scoop.it
Tips to use MS Excel · An alternative Excel ave. ... A macro to automatically add an IfError() function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Mathematical Workout Formulas You Need - Good Works Wellness Research, LLC

Mathematical Workout Formulas You Need - Good Works Wellness Research, LLC | Excel Easy | Scoop.it
Articles shares important mathematical workout formulas you can use to improve your performance and to gauge the safety of your workout.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Free Personal Cashflow Money Tracking Spreadsheet

Free Personal Cashflow Money Tracking Spreadsheet | Excel Easy | Scoop.it
I’ve read my fair share of personal finance books over … (Snag a free money tracking spreadsheet and enter to win one of three Amazon gift cards from @kristinaQ #moneymatters http://t.co/jyq6O1ZaUL)...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Become awesome in data analytics, charting & Power Pivot with Houston Masterclass [reminder]

Become awesome in data analytics, charting & Power Pivot with Houston Masterclass [reminder] | Excel Easy | Scoop.it
Hello friends,
Let me stop our broadcast of Excel tips to bring an announcement.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Quickly changing or deleting Named Ranges Redux

Quickly changing or deleting Named Ranges Redux | Excel Easy | Scoop.it
I know a good thing when I see it. Dick’s use of the word Redux in yesterday’s post for one. Dick’s nifty CreateDynamicNames() sub for another. Put them together, and you’ve got a winning combination.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Microsoft unveils Word, Excel and PowerPoint for iPad 1.1, adds ...

Microsoft unveils Word, Excel and PowerPoint for iPad 1.1, adds ... | Excel Easy | Scoop.it
Microsoft has unveiled the first major update to its stable of iPad Office apps with the release of Word for iPad 1.1, Excel for iPad 1.1 and PowerPoint for iPad 1.1.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

High Impact Excel: Dashboard Edition - Accountingweb.com

High Impact Excel: Dashboard Edition - Accountingweb.com | Excel Easy | Scoop.it
High Impact Excel: Dashboard Edition
Accountingweb.com
In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records - YouTube

See how to use SUMPRODUCT and the Join Symbol (& Ampersand) to group duplicates and then see how to use Advanced Filter Unique Records to extract unique list...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Mr Excel & excelisfun Trick 163: Monthly Expense Given End Date & Expense Name: Formula or Pivot? - YouTube

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Bill Mr Excel Jelen and Mike excelisfun Girvin show how to calculate total expense for t...
more...
Progressive training's curator insight, August 12, 12:01 AM

Mr Excel & excelisfun Trick 163: Monthly Expense Given End Date & Expense Name: Formula or Pivot? 

Scooped by Roger Fisher
Scoop.it!

Microsoft Excel Programming | Platforms.net

Microsoft Excel Programming | Platforms.net | Excel Easy | Scoop.it
Microsoft Excel, an essential standard part of the Microsoft Office suite, is a versatile spreadsheet program oriented toward business and productivity.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How to create relational databases in Excel 2013 - PCWorld (blog)

How to create relational databases in Excel 2013 - PCWorld (blog) | Excel Easy | Scoop.it
How to create relational databases in Excel 2013
PCWorld (blog)
Excel used to be the poor schmuck's database, with spreadsheets that just sort of sat there.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel extras – PowerPivot – time intelligence

Excel extras – PowerPivot – time intelligence | Excel Easy | Scoop.it
MS Excel extras >>€“ PowerPivot: time intelligence http://t.co/g2JEbtlwkS
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

CP016: 3 Must have books for aspiring analysts

CP016: 3 Must have books for aspiring analysts | Excel Easy | Scoop.it
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Autofill Formulas - ExcelBanter

Autofill Formulas - ExcelBanter | Excel Easy | Scoop.it
Autofill Formulas Excel Worksheet Functions. ... A Microsoft Excel forum. ExcelBanter ... It's really simpler and faster to compute using a calculator, however, with excel formulas, errors in calculation are massively minimised.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

#ICreatedThis: Speed painting with Excel - The Fire Hose

#ICreatedThis: Speed painting with Excel - The Fire Hose | Excel Easy | Scoop.it
Operating under the name of Shukei, artist Felipe Velásquez has a unique hobby: he creates amazing artwork in Microsoft Excel. Though unexpected, Excel gives Shukei [ ...] (Hi, I’m  Shukei, and I speed paint with Excel.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

How to Print Only a Selected Area of An Excel Spreadsheet

How to Print Only a Selected Area of An Excel Spreadsheet | Excel Easy | Scoop.it
At the office or home office, there will be many times when you need to print out Excel spreadsheets. But often times you really don't need to print out the entire report which wastes paper, ink, and time.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

GCFLearnFree Launches Excel Formulas Tutorial - NCTechNews (press release)

GCFLearnFree Launches Excel Formulas Tutorial - NCTechNews (press release) | Excel Easy | Scoop.it
GCFLearnFree Launches Excel Formulas Tutorial
NCTechNews (press release)
Excel Formulas expands upon the organization's popular Microsoft Office online tutorials, which give users a more in-depth look into how these programs work.
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Understanding the Excel Data Model (Office 15-Minute Webinar)

The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, guest host Owen Duncan teaches us how Excel Data Models provide...
more...
No comment yet.
Scooped by Roger Fisher
Scoop.it!

Excel London | Spreadsheet Solutions, Beckenham | Excel, Beckenham

Excel London | Spreadsheet Solutions, Beckenham | Excel, Beckenham | Excel Easy | Scoop.it
RT @RichardGSumner: #Excel is still the best spreadsheet-creator, but which one do you use? Read this and vote - http://t.co/yPxYLPKlKf - #…
more...
No comment yet.