How to visualize data product sales? [Challenges Excel # 2]

Published on 30 May 2011 in charts and graphs, challenges Excel-1 comment

We have people challenge Excel again!

I know our friends in the United States was away celebrating Memorial Day weekend. It should not leave the rest of us fun. Therefore, we have a new "challenge" in Excel. This time, you need to planningprocedure to view product sales data.

Is this,

Download Excel file using this data.

1) make one (you can also group schemes, but not dashboard or multiple layouts) depicting the collapse of our product sales. Should help planning your answer to any of these questions:

What is the composition of income, how it changes over time? products in more $ s? sales trend from January to may

2) you are free to make additional plans to answer questions. I think just like the owner of the company that sells these products (think like me, because these sales of some products) and attempt to understand the data.

3) you can use Excel or your preferred visualization tool to make your chart.

Prepare your chart and save workboxind an e-mail message to chandoo.d @ gmail.com with subject "resolved-2 EC" or upload your work to skydrive.com and share it with the public and post URL here via comments.Note: submit your work before 6 June, 2011

I will post all entries on your readers to see Chandoo.org. You will also choose one random winner of best charts.

The winner will get a random "Amazon Kindle reading device"-WiFi version

Note: submit your work before 6 June, 2011you can send multiple antrisor upload your work to skydrive.com and share it with the public and post URL here via comments. your workbook in an e-mail to chandoo.d @ gmail.com with subject "resolved-2 EC" Please do not use Add-ins or macros to generate graphs. Please send the files unlocked only. You also agree that Chandoo.org can publish your files for others to learn.

So go ahead, and visualize data product sales. Enjoy!

Charting one of my favorite areas. Very good graphs and communication patterns discovery. We run contests draw all the time. Browse some previous competitions

RSS feed for comments on this post. TrackBack URI

View the original article here

3 day VBA Training

I'm very excited to apply all the thing I've learn from our 3 day VBA training.

I'm sharing with you my VBA code for our day 2 assignment. Creating a workbook that require a password to open, if password is incorrect the file / workbook will close.



If you have not done yours let this be your guide. Looking forward to working with different project on VBA.

Professional NURSING UNIFORMS

Now a days, spending time in the hospital has become a more relaxing experience, with the advances in medical technology use in medical equipment the hospital facilities has also improve to a 5 star grade hotels. Rooms are very comfy & cozy you would not bother spending time at the hospital while you're being treated, your guest or visitor might visit you more frequently due to the ambiance. For sure they would like to spend more time with you on your room.

Of course it will not be complete if you don't have lovely professional nurses to assist you on your needs medically, with their professional looking nursing uniform you'll be coming back for more. And where else can you get top of the line nursing uniforms, blue sky scrubs the source of all you nurse uniform needs. More details about nurse uniform from their website here http://www.blueskyscrubs.com/categories/Scrubs/Scrubs-for-Women/Original-Scrubs/.

 

As we celebrate the National Nurses Week this May 6 - 12, let's give our nurses more reasons to smile, get them their nursing uniforms from blue sky scrubs and this National Nurses Week you can get 20% off any purchases through May 12, visit blue sky scrubs for choices and details of your nurse uniforms.

Microsoft Excel rounds: defect or hidden truth?

Excel formatting issue

My frequent contacts for client, Microsoft Excel issues from each one similar question ", but either the hotfix or update Excel. When the e-mail message I receive to manually calculate the same values get different answers for some seems to be wrong in my formula. ?

Is to update the "bug" before modifying or Microsoft Excel, service packs, first they are not required. Is the acronym WYSIWYG (pronounced nifty wig) or have heard.

WYSIWYG what = what you get to see

However in some Excel worksheets, is not WYSIWYG to see meaning in what you get. Start a frustration to replicate Excel answer to manually calculate the visible values can not.

See for yourself.

Values are "true" to examples of changes to set the Excel format rather than the value that you can try to.

Open Microsoft Excel (any version). New worksheet, select cells: 1. 987654this number in a cell repeatedly, click the decrease decimal toolbar icon (number of Excel 2010 and Excel 2007: Home tab groups; Excel 2003: located on the formatting toolbar) and 2. See changes to the display until the value is displayed as 0. Look in the formula bar to verify that the original value has not been modified; this value is used in Excel formulas. The number 2. Likely readers display 0 to audit your work if you use.

Of Tip # 1: results like commas or currency and to choose a popular number formatting options in Excel, Excel is displayed rounded decimal number, such as 2 or 0. Value and obstacles change the formatting of these operations or not behind the result of the same number of decimal places to round is. Maintains a full value that is passed instead of formulas in other worksheets in Excel.
?
Not the solution of the disclaimer.

See disclaimer or "due to rounding error may or may? "And uses it in the States worksheet. Like these statements how the accuracy and reliability of results is based on this information decision reviews of Excel data can we trust?

This problem occurs if you have the number only whole number you use in Excel or limited to dollars and cents (replaced the currency of your country). Many applications, however in the accounting and finance, percentage, constituting might include other values might compute shares to see many more decimal places. The problem of these calculations is to quantify the volume, lease ownership, pricing, and other factors appear immediately-3, 6, 12 or more decimal digits is common, for example, oil and gas industry is other.

Can how important this issue to give an idea, he was hired by oil analysts, "urgent consultation" when shareholders threatened numbers on the property expenses worksheet literally "adding not so. Companies to sue

What is the answer?

To change the Excel formula to match the value behind your answers show formula adds ROUND function. To view worksheets in the same number of decimal places using the ROUND function to use, you can calculate the value.

Is the basic structure of the ROUND function.

= ROUND (formula, # of decimal places)

Is the official Excel term = (number, precision) rounds.

ROUND function is a very complex formula can apply easily. As a function of the outermost expression, such as ROUND (S5 * (H5+J5), 2) = adds.

Some Excel functions and calculations, the ROUND function can be nested in other functions also. Here, the result is an example of the round function to guarantee calculation to correct number of decimal places contained in the argument of the IF function (parts).

= IF ((W5 * 100) > 0, ROUND ((W5 * 100), 0), ROUND ((-W5 * 100), 0))

Of Tip # 2: The number of decimal places in the ROUND function always scale cell formatting choices to match. This way you can create formulas in spreadsheet and WYSIWYG in fact.

Of Tip # 3: problems when to audit a worksheet automatically creating a correct formulas that result in the ROUND function rounding is consistent, so you can dominate.

ROUND functions are important values are hidden in your work to reveal, so add Excel trick.

Dawn Bjork Busby Microsoft Office Specialist (MOS) master certified instructor and certified expert certified instructors, Microsoft application professionals (paid), Microsoft Office and as the software Pro ? and Microsoft Certified Trainer (MCT) is. Dawn software speakers share smart ways to use software effectively through her work as a trainer, consultant, and author of six books. Software for more tips, tricks, strategy and technology the found at http://www. SoftwarePro.com.

If and only if (video)

This post is all about if-Rudyard Kipling's poem, or song from 1971, but bread. If the function is used in many applications, but most of us know from Microsoft Excel:

IF (logical_test, [value_if_true], [value_if_false])

If it is one of the most sought after for words on Office.com, so we thought we would compile some of our resources, so if you can find them more easily.

If you're just looking for basic information about the function, as the syntax, arguments, and examples, check if function reference topic. If you prefer to watch a video, take a look at the Video: introduction to the IF function in Excel 2010:

We also have assembled a new training course on Excel if function, complete with a quick reference card that you can print out and keep handy.

Microsoft Access and Microsoft Project use a variant of se, known as IIF, to perform conditional logic. For the basics, here is the reference on the topic IIF function. In the Macro Builder, Access logic if it can be built using the if ...Then ...Else Block Macro. In Visual Basic for Applications (VBA), you would use the sePoi ...Else statement.

The same basic syntax appears in other Office programs, so now that you have studied in these materials, you should be good to go. There is more you'd like to know if? Do you have any favorite examples of use in your work? Please let us know.

-Chris Downs

View the original article here

Microsoft to create Excel - charts

Many people can dress up the spreadsheet chaos and impenetrable wall of information! Is an easy access way to display graphs and viewing this data. You can create for a wide variety of charts and graphs different!

Is best in a pie chart in the chart, especially of the English speaking world's most popular will be applied to describe the percentage of the pie slices form rendering. Is a bar graph used to display the value of any other major chart frequency or another category. A histogram that numbers in the range, a line that scatter observation of 2-D observation that this order is connected point amount. Using coordinates in the scatter, shows the relationship between two or more variables.

The other chart, bubble chart, scatter in the 3-dimensional fundamentally is. Polar region is legendary nurse Florence Nightingale, developed and expanded form of a pie chart is figure. Information about the distribution (i.e. minimum, maximum, average, average) can also pick the box plot chart axis only. May have gathered that shows an incredible array of, any information that can be deployed according to diagram. All options, to display information one!

When you create a chart, Excel Chart Wizard very great advantage. The wizard, select data from cells in the workbook in a nice graph of your choice you can! Highlight the need to do everything, which represented workbook data [insert chart, or click the Chart Wizard button.

Hold and press and hold, so you can preview the graph showing how sample button represented as a type of chart to select the next step in the data as it is. The selected data is displayed in the data range box. Whether the data is represented by the row or column, select from a series of options.

From this point, you can change, such as chart titles, gridlines, axes, chart options. In most charts, contains both the chart and axis titles. Must be used to compare the data in the pie chart one date range if you are using a pie chart. It is only a percentage of the total amount of data each.

It's many great tips and lessons only one of the search for information contained in the computer MS Office Online courses at http://www. MyITCourses.com.

Hidden power of Microsoft Excel:

Hear the most frequent one Excel questions is how to add the same header and footer (page layouts) one or more worksheets at the same time? In some variations it is. The answer is simple, but procedure is intuitive and most Microsoft Excel workbook or the web site is also not covered. Spreadsheet Solutions Group is a select multiple sheets in a workbook. If you group the worksheets.

Select sheet to print at the same time. Enter or edit data on multiple worksheets at the same time. Page setup options, apply formatting, such as the selection of all the worksheets at the same time. What is not necessary to repeat the same steps repeat. Delete a group of move, copy, or a worksheet.

To select two or more adjacent sheets: click the first sheet in the group header. While holding down the [Shift] key, click the sheet tabs to select the last sheet.

Two or to select multiple nonadjacent sheets: click the first sheet in the group header. Click then hold down Ctrl while selecting the sheet tab. The selected worksheet tab is displayed as active or white.

All worksheets in that workbook selection: right-click any sheet tab, and then click select all sheets .

To select one or more worksheets, and in the title bar of the Excel workbook, see [group] should be.

Worksheet to group and any action or a worksheet command also applies to all other worksheets in the group. This is to duplicate the same headers, footers, or page layout group of worksheets trick. Excel 2010 and Excel 2007 to choose Insert] tab of [header and footer. Excel 2003 or 2002, select the file > page setup and click the header/footer tab. In addition, each worksheet you select changes, including any text or formatting, add the column heading follows. To enter data in cell B5, and when Group, for example, all the selected worksheets now new data cell B5.

Attention! Is intended only one worksheet worksheet formatting and data changes are complete, add the selected worksheet contains the certainly un-group editing group of worksheets to prevent unwanted changes, the.

UN deceases toggle-group of worksheet you select.

Left mouse button or any sheet tab right-click any sheet tab, click the Group release sheet from the shortcut menu.

Grouped worksheets for each worksheet individually work continue to determine, verify the book title bar.

Dawn Bjork Busby Microsoft Office Specialist (MOS) master certified instructor and certified expert certified instructors, Microsoft application professionals (paid), Microsoft Office and as the software Pro ? and Microsoft Certified Trainer (MCT) is. Dawn software speakers share smart ways to use software effectively through her work as a trainer, consultant, and author of six books. Software for more tips, tricks, strategy and technology the found at http://www. SoftwarePro.com.