MicrosoftExcel
17.6K views | +2 today
Follow
MicrosoftExcel
Information about Microsoft Excel
Curated by Raymon
Your new post is loading...
Your new post is loading...
Rescooped by Raymon from Techy Stuff
Scoop.it!

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.

To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resource...

Via Patty Ball
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Lower Your Cost Of Living The Geeky Way

Lower Your Cost Of Living The Geeky Way | MicrosoftExcel | Scoop.it
It seems like whenever I write about expense control, I have the tendency to get all geeky. Let's be serious, how many people would actually use the Pareto
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Paste and Transpose icon in QAT crash Excel 2013

Hi all
I add a new page on my site with a workaround for this problem. I hope that there are no more of this problem icons for the QAT.
Not easy find the problem with bugs like this, you not think that an Excel icon in the QAT can crash Excel.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Edit Excel 2010 List Data in Popup Form

Edit Excel 2010 List Data in Popup Form | MicrosoftExcel | Scoop.it
If you're working with a list of data in Excel, you can use the built-in Data Form to view and edit the data.
Displaying up to 32 fields, it lets you view and edit one record at a time. You can also find and edit records, or add and delete them.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

How to use Drop down menus to make Interactive Charts and Dashboards in Excel

How to use Drop down menus to make Interactive Charts and Dashboards in Excel | MicrosoftExcel | Scoop.it
Are you looking for ways to make your Excel spreadsheets interactive but you don’t want to use VBA?
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2010 and Create Several Charts from One Pivot Table

Learn Excel 2010 and Create Several Charts from One Pivot Table | MicrosoftExcel | Scoop.it
Is it possible to Create and Refresh Several Charts from just One Pivot Table?
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2013 – “Excel 2013 For Rookies”: Podcast #1589 Part II of V

Learn Excel 2013 – “Excel 2013 For Rookies”: Podcast #1589 Part II of V | MicrosoftExcel | Scoop.it
Is Excel 2013 easier for First Time Excel Users? Heads up students, it just may be.
Today Bill moves along with his Excel 2013 Preview by addressing Users New to Excel and Excel 2013.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Growing a Money Mustache using Excel [for fun]

Growing a Money Mustache using Excel [for fun] | MicrosoftExcel | Scoop.it
Mustache and Excel?!? Sounds as unlikely as 3D pie charts & Peltier. But I have a story to tell. So grab a cup of coffee and follow me.
Few months ago, I chanced up on a highly entertaining blog on money, retirement & living a kick-ass life.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Sales And Marketing Templates-Microsoft Excel Templates ...

Sales And Marketing Templates-Microsoft Excel Templates ... Sales Seasonality templates. Mthly Sales Seasonality templates,microsoft excel templates,microsoft office templates ... Microsoft Office 2003 2007 2010.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Excel Magic Trick 966: Conditional Format Row When Item Is In List

Excel Magic Trick 966: Conditional Format Row When Item Is In List
Download Excel File: people.highline.edu This video: 1.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Introduction to the Data Model and Relationships in Excel 2013

Introduction to the Data Model and Relationships in Excel 2013 | MicrosoftExcel | Scoop.it
This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team.
I am very happy to be writing this blog post today.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Substitute New Text for Old in Excel

Substitute New Text for Old in Excel | MicrosoftExcel | Scoop.it
Excel SUBSTITUTE Function © Ted French
Excel SUBSTITUTE function lets you replace existing text data in one or more worksheet cells with new words, blank spaces, or other text.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2013 because It Has Its Own App Store

Learn Excel 2013 because It Has Its Own App Store | MicrosoftExcel | Scoop.it
Yes Excel 2013 comes with an App Store and Much More!
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Announcing the release of Service Pack 1 for Office 2013 and ...

We're delighted to announce that Service Pack 1 (SP1) for the Office 2013 and SharePoint 2013 family of products is available today! In this post, we'll talk about how to get SP1 and the improvements you can expect in the ...
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Hui’s Calendar Tool (as Borrowed from Chandoo)

Hui’s Calendar Tool (as Borrowed from Chandoo) | MicrosoftExcel | Scoop.it
In January a friend asked me to assist with a small Excel assignment.
Her company wanted to add a Calendar control to a worksheet so that people could interactively select a date.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Highlighting row differences in Excel | lynda.com tutorial | lynda.blog

Highlighting row differences in Excel | lynda.com tutorial | lynda.blog | MicrosoftExcel | Scoop.it
Featured Five free videos: A first look at Microsoft Windows 8 and Office 13 ... In Excel 2007 and 2010, you can quickly check for differences between these two inventory numbers. First, you select the numbers in your ...
more...
swap-conseil.com's curator insight, February 17, 2014 10:31 AM

Useful tip when comparing data. @SWAP_Conseil #SWAP_Tips

Scooped by Raymon
Scoop.it!

Replacing Bad Stuff with Good in Excel

Replacing Bad Stuff with Good in Excel | MicrosoftExcel | Scoop.it
When importing data into Excel extra characters can sometimes be brought along with good data, and these extra characters can cause problems if the data is to be used in formulas or other calculations....Read Full Post...
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Combine Cells of Data in Excel

Combine Cells of Data in Excel | MicrosoftExcel | Scoop.it
Excel CONCATENATE Function© Ted French
Names, addresses, and other data are often split between two or more cells in an Excel database file.
If you need to combine such data into a single cell, try using the CONCATENATE function.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2010 – “Many Charts but One Pivot Table”: Podcast #1596

Learn Excel 2010 – “Many Charts but One Pivot Table”: Podcast #1596 | MicrosoftExcel | Scoop.it
Today, Tim wants to know if he can produce several Charts based on one Pivot Table, so that on ‘Refresh’ all of his Charts will be refreshed. Bill says the key is having only One Pivot Cache.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Tips for turning your Excel data into PowerPoint charts

Tips for turning your Excel data into PowerPoint charts | MicrosoftExcel | Scoop.it
Incorporating  a well-constructed chart within your PowerPoint presentation can be a powerful tool to help deliver your message. In this post, guest blogger Ellen Finkelstein provides useful tips on how to turn data from Excel into into an easy-to-understand,...
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2013 – “Pivot Tables”: Podcast #1590 Part III of V

Learn Excel 2013 – “Pivot Tables”: Podcast #1590 Part III of V | MicrosoftExcel | Scoop.it
Wow…well we all know that Bill’s favorite bit in Microsoft Excel is the Pivot Table. Today, in Episode #1590, Bill highlights the changes and increased utility of Pivot Tables in Microsoft Excel 2013!
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus

Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus
Download Excel File: people.highline.edu This video: 1. Custom Number Format Show Positive With Plus and Negative With Minus 2.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

How to Create a Panel Chart in Excel

How to Create a Panel Chart in Excel | MicrosoftExcel | Scoop.it
To show a concise, clear summary of data for several departments or cities, you can create a panel chart in Excel. It shows all the data in a single chart, with vertical lines separating the groups.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Formula Forensics No. 027 – Remove Leading Zeroes

Formula Forensics No. 027 – Remove Leading Zeroes | MicrosoftExcel | Scoop.it
A few weeks ago Chandoo received an email from a reader, Chandu:
“I am in search of a formula for the below scenario, please suggest:
 I am trying to delete the zeros before the numbers.
more...
No comment yet.
Scooped by Raymon
Scoop.it!

Learn Excel 2013 to see Message Boxes with Attitude

Learn Excel 2013 to see Message Boxes with Attitude | MicrosoftExcel | Scoop.it
Today a review of New Message Boxes in Excel 2013 AND A Contest!
more...
No comment yet.