MicrosoftExcel
24.5K views | +21 today
Follow
 
Scooped by Raymon
onto MicrosoftExcel
Scoop.it!

Format Pivot Table Labels Based on Date Range

Format Pivot Table Labels Based on Date Range | MicrosoftExcel | Scoop.it
Thank you for subscribing to the RSS feed for Excel Pivot Tables .
Please visit the Pivot Tables page on Facebook
In a pivot table that contains a long list of dates, you can use conditional formatting to highlight a specific date range.
more...
No comment yet.
MicrosoftExcel
Information about Microsoft Excel
Curated by Raymon
Your new post is loading...
Your new post is loading...
Suggested by Kawser Ahmed
Scoop.it!

Excel Conditional Formatting-Complete Video Guide-17 Problems

Excel Conditional Formatting-Complete Video Guide-17 Problems | MicrosoftExcel | Scoop.it
Do you want to master in Excel Conditional Formatting feature? Total 14 ultimate video tutorials will guide you to do that with several practice problems :)
more...
No comment yet.
Scooped by Raymon
Scoop.it!

The Missing Link in Excel BI | XLCubed Blog

The Missing Link in Excel BI | XLCubed Blog | MicrosoftExcel | Scoop.it
When viewing a high level summary report or dashboard, users often want to delve into more detail on a specific area. In some cases that may be a drill down, in many others it may be to a different view of the data or to an entirely different report. In the XLCubed example below, users … Continue reading The Missing Link in Excel BI →
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.
Suggested by Andy Duncan
Scoop.it!

Easy, visual how-to guide and downloadable template for building a Gantt chart in Excel 2013

Easy, visual how-to guide and downloadable template for building a Gantt chart in Excel 2013 | MicrosoftExcel | Scoop.it

Step-by-step, Gantt chart Excel tutorial for creating Gantt charts in Excel.

more...
No comment yet.
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.