Excel-user - excel-user.com - Excel-User.com
General Information:
Latest News:
MS Excel 2013 Quick Start Guide (“Cheat Sheet”) 4 Mar 2013 | 02:43 pm
You can download the Microsoft Excel 2013 Quick Start Guide (aka “Cheat Sheet”) here: http://officeimg.vo.msecnd.net/en-us/files/514/375/AF103733534.pdf This is a great tool to help you get started ...
Install Excel 2013 side-by-side with Excel 2010 3 Mar 2013 | 09:54 pm
First of all, if you want to install Office 2013, you will need either Windows 7 or Windows 8. Previous versions of Windows are not support. When you install Office 2013, you can either do a side-by-s...
“Your top 10 favorite Excel posts of 2012” from Microsoft Excel Blog 6 Feb 2013 | 03:19 pm
My article written for Microsoft Office Blog in 2012 about “Using multiple criteria in Excel Lookup formulas” was recognized as the number one on the “Top 5 posts about the current Excel” category. I’...
uCertify–Online Version 29 Oct 2012 | 03:49 pm
I’ve tested the new online version of the uCertify PrepKits that I’ve used before and that I’ve reviewed here. This new online platform means that you don’t need to install anything on your computer t...
Lookup with multiple criteria's 5 Jul 2012 | 06:56 pm
This article was originally written for the Microsoft Excel Blog. The purpose of this article is to show Excel users some technique’s, and Excel functions, that they can use to lookup up a value on a ...
AutoSum 16 Jun 2012 | 12:53 am
Excel has an AutoSum feature that can save us lots of time when we are working with data tables. Let’s see a practical example. We have a monthly store sales table, like this: Now we want to put mont...
Conditional Formatting bar chart 22 May 2012 | 10:36 pm
I’ve a table of data with target values and actual values, by month, like this: I want to create a bar chart with this data, something like this: But I would like, for better understand the data, to...
Add new data to an existing chart 18 May 2012 | 05:09 am
This is a common task on Excel. We have a chart and we need to update the data displayed by adding more data. For instance, we have a chart that displays data from January to March and we need to add ...
Add automatic subtotals 9 May 2012 | 10:15 pm
This is a very handy trick. We have a table, like this: We now want to get the subtotals of the Value column, for each Store. First thing that we need to do, is to sort the table by the Store column....
Copy visible cells only 7 May 2012 | 09:52 pm
You have a table of data and you hide some rows and columns and you want to copy only the visible cells into another sheet? I’m going to show you some techniques that you can use to do that. Let’s see...
