Search

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

Data Management Blogs RSS feed