Blogs Blogs

Data Management Blogs

Newest Most Active

OK, so you’ve been asked to do a Pivot Table for the first time? And just like everyone else, you feel somewhat intimidated; “what’s going to happen to my data if I screw up my Pivot Table?”; “Can I undo my changes?”; “Can I delete my Pivot Table?”; “How long does it take to create a Pivot Table?”; “What is a Pivot Table in the first place?” Let’s give the short answers first: “Nothing”, “Yes”, “Yes”, “30 seconds to an hour or more”, “A summarized view of your data grouped by selected fields”.   And yes, as mentioned in other posts, most job interviews for admin, accounting or office positions where Excel is used heavily will include a question on Pivot Tables – so be prepared! The first thing you need prior to creating a Pivot Table is a data set in rows and columns, and preferably a normalized data set; by normalized, I mean a clean data set where individual records are populated in rows and unique field headers are in columns. Once you start working... read more

Whether you are a student looking for practice questions for an upcoming exam, a parent seeking a math tutor for his/her 5th grade child, or a tutor who is searching for resources to help students improve their SAT vocabulary, you would be relieved to find that relevant information is readily available to you every step of the way. And all of this is made possible because of dedicated individuals who have built powerful search engines, highly-accessible websites, and well-architected databases; filled them with data collected from various sources; and organized them into the useful pieces of information that can be provided to all of the users.   While data has been around us every second of our daily lives, organizing them into useful information is as much of a science as any chemical combustions that you may have pondered over. Whether you are a student looking for practice questions for an upcoming exam, a parent seeking a math tutor for his/her... read more

The following VBA code can help you to get data from all worksheets of active workbook together into a new single worksheet at the same time.  IMPORTANT:  All of the worksheets must have the same field structure, same column headings and same column order. Here are the steps: 1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window. Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add Sheets(1).Name = "Combined" Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy Destination:=Sheets(1).Range("A1") For J = 2 To Sheets.Count Sheets(J).Activate Range("A1").Select Selection.CurrentRegion.Select Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select Selection.Copy Destination:=Sheets(1).Range("A65536")... read more

Data Management Blogs RSS feed