Dear Noorian, Thanks for the precious information...... Regards, Gawli Anil
On Wed, Jul 25, 2012 at 5:36 PM, NOORAIN ANSARI <> wrote: > FYI > > ---------- Forwarded message ---------- > From: ExcelUser <k...@exceluser.com> > Date: Wed, Jul 25, 2012 at 5:30 PM > Subject: Office 2013 + YOY Reporting + 5 Useful Shortcuts + Cluttered Data > To: Noorain Ansari <noorain.ans...@gmail.com> > > > ** > [image: Excel for Businessnewsletter] > *Published Now and Again for Business Users of Microsoft Excel. * > ------------------------------ > > Office 2013 + YOY Reporting > + 5 Useful Shortcuts + Cluttered Data > > *Charley Kyd* <http://exceluser.com/contact/kyd.htm> > > Wednesday, July 25, 2012 > ------------------------------ > *If you like this newsletter, please forward it to other Excel users.* > ------------------------------ > > Microsoft announced Office 2013 several days ago. You can learn more about > it and download a trial version here: > > http://www.microsoft.com/office/preview/en > > In future newsletters, I'll explore Excel 2013's new features in detail. > But here's a quick overview: > > Excel 2013 has made life easier for people with dual monitors, because you > now can have any workbook open on either monitor. To make this work, > however, the developers changed from a Multi-Document Interface (MDI) to a > Single-Document Interface (SDI). > > To better understand what SDI is about, look at Word for 2007 or 2010. In > those products, every Word document is in its own window. Excel 2013 now > uses the same approach. > > In other words, Excel no longer is a container for multiple workbooks. > Instead, every workbook stands alone. Every workbook has its own Ribbon. > And every open workbook will show its information in your Taskbar. > > The other major change in Office 2013 is that Office programs are in the > cloud by default. This is what the "Office 365" discussion is about in the > link above. > > There's a lot more to talk about, and a lot of unanswered questions. So > watch for my updates. > > Year-Over-Year Reporting & Analysis > > Until several years ago, when I read Ahead of the Curve: A Commonsense > Guide to Forecasting Business and Market > Cycles<http://www.amazon.com/gp/product/1591396913/ref=as_li_qf_sp_asin_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=1591396913&linkCode=as2&tag=excelusercom-20>, > by Joseph H. Ellis, I hadn't appreciated how powerful year-over-year (YOY) > analysis can be. Ellis attributes much of his ability to forecast industry > performance accurately to his reliance on charts of YOY ratios. > > In my post, Introducing the Power of Year-Over-Year Performance Charts in > Excel <http://exceluser.com/blog/?p=1186>, I compare two charts of the > same underlying data. One uses the standard approach and the other displays > the YOY ratio. > > When you compare the two charts, you'll see how the YOY approach reveals > trends that the standard approach hides. > > You might want to give YOY reporting & analysis a try. > > Useful Keyboard Shorts > > Excel offers at least 250 keyboard shortcuts for workbooks, most of which > aren't worth remembering. Everyone uses a few of them all the time, like > Ctrl+C and Ctrl+V. But there are some others that you probably don't use, > but should. > > In Five Really Useful Excel Keyboard > Shortcuts<http://exceluser.com/blog/?p=1218>, > I discuss five shortcuts like that...shortcuts you probably don't use but > should. > > After you read the post, please send me other shortcuts you'd like me to > add to that don't-but-should list. > > Managing Cluttered Data > > I need your help. > > If you've seen my dashboard reports, you know that data flows to the > reports along a path like this: > > *Source Data –> Excel Database –> Excel Templates –> Reports* > > This design offers at least two significant benefits. > > First, it saves a massive amount of time because once the data is in your > Excel database, you only need to change the report date to update your > dashboard report. > > Second, it also reduces errors significantly, because all reports use the > same data; the report template stays the same from period to period; and > it's easy to create error-finding reports and calculations. > > I'm now working on a training program that takes my Excel data-management > methods to the next level. I'm going to show how to use an enhanced version > of this method with ANY Excel report or analysis, not just with dashboards. > That is, in most cases, Excel users should be able to... > > 1. Bring in data from any available source -- PivotTables, CSV files, > Excel queries, the Web, etc. > > 2. Recalculate Excel (press F9, if needed) to update the report. > > 3. Publish the updated report, analysis, or dashboard. (That is, print it, > save it as a PDF, save its images to the Web, whatever.) > > 4. If your data has several categories—departments, products, regions, > SKUs, spoken languages, whatever—you choose another category then > recalculate and publish that information. > > In all cases, you generate your reports without touching the original > source data after it first hits Excel, and without modifying your Excel > reports. > > Let me be clear... > > First, you should be able to update most reports and analyses without > MANUALLY sorting, summarizing, or correcting your data, and without > MANUALLY modifying your report. You just bring your new data into Excel, > choose a data category if necessary, recalculate, and publish. > > Second, you don't need to use macros after your data hits Excel. Excel > formulas can do all the work. > > "NOT IN MY REPORTS!"...you might be thinking. > > That is, you might be thinking about how your data must be adjusted, > rearranged, enhanced, corrected, sorted, and summarized in too many ways. > And you're thinking that your reports and analyses need to be changed too > much when you add new data or change data categories. > > So that's where I need your help... > > ...If you need to manually transform or summarize your data in Excel > before you can use it in reports or analyses... > > ...Or, if you need to manually adjust your reports each period... > > ...I REALLY would like to see examples or descriptions of the changes you > make. > > If you tell me about the hard work you do when you update your Excel > reports and analyses each period, I think I'll be able to find solutions > and add them to my training program. > > There'll certainly be some exceptions, but I think I can show you how to > eliminate a lot your manual reporting effort...even if you're fairly new to > Excel. > > When you write, send me what examples you can. I'll definitely keep your > material private. > > Also, please concentrate on the Excel process you go through, not your > subject matter. That way, I won't need to become an expert in raising > chickens, or refining oil, or jailing criminals, or whatever else your > organization does. I'll just need to understand your Excel reporting and > analytical process. > More later, > > Charley > > > This is a Test > > ExcelUser.com > > PO Box 1996 > Ocean Shores, WA > 98569 > US > > > If you no longer wish to receive communication from us: > Cancel <http://exceluser.net/o?r=9767adb009394e55829319032ad7250b> > > To update your contact information: > Update <http://exceluser.net/o?c=1&r=9767adb009394e55829319032ad7250b> > > > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> > http:// <http://www.excelvbaclinic.blogspot.com/> > excelvbaclinic.blogspot.com <http://www.excelvbaclinic.blogspot.com/> > http://accesssqclinic.blogspot.in/ > > > > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
