Tag Archives: Microsoft Excel

Excel for Managing Research: Learn How to Use Microsoft Excel as a Research Management Tool

I have used Excel for managing research since the early 1990s, when I was mentored by a grants administrator who took me under her wing. She showed me how to use abstract deadline grids, grant submission grids, and action item grids to manage research activities. Now, I’ve made these skills available to you through my online course, “MS Excel for Managing Research”!

Excel for Managing Research is a short, practical course that will give you the skills you need to run research teams and activities using this simple, flexible tool!

Convert CSV to RDS When Using R for Easier Data Handling

If you want to use R for a project and the source CSV is very big, it can improve input/output efficiency to convert the file to an RDS.

Convert CSV to RDS is what you want to do if you are working with big data files in R GUI and want to improve efficiency. Read my blog post for an explanation and video demonstrations of this process!

SAS-R Integration Example: Transform in R, Analyze in SAS!

You can use SAS and R together in one project. I show you how to develop an analytic dataset in R and put it in SAS ODA for analysis.

Looking for a SAS-R integration example that uses the best of both worlds? I show you a use-case where I was in a hurry, and did transformation in R with the analysis in SAS!

Data Science of Data Collection: Free Course and Course Series!

“Understanding Research Forms, Surveys and Instruments” is a 6-course online tutorial series aimed at graduate students and new researchers so they learn how to collect data properly, and do not make mistakes that can cost them their degree or job promotion!

Learn the “data science of data collection” through my free introductory course! If you want to learn more, continue with the whole six-course series. Great for graduate students and QA/QI professionals!

Verified by MonsterInsights