Search this site:
Custom Search

This online tutorial is designed to provide you with step-by-step instructions for learning tips, tricks, and shortcuts when dealing with data in your work as a school counselor, administrator, or other educator. Particular attention is given to using a popular spreadsheet program, Microsoft Excel™, which is designed to analyze, share, and manage information so that you can make more informed decisions in your work. As a result of learning more about data, you will also be better able to monitor student progress and communicate to other stake holders about how your school counseling program is making a positive difference in the lives of students.

Here you will find both written and detailed video instruction demonstrating data skills in a user-friendly manner. What you see is what you learn. Also throughout this program, I’ve included many bonus articles, links, and tips.

watsnewThings have certainly changed during the first version of Data Boot Camp. In this major revision, all the videos have been updated using more recent versions of Microsoft Excel and PowerPoint (2010). In addition to the many descriptive pages, you’ll have access to 39 videos covering 206 minutes (almost 3.5 hours) of tutorial footage. Also, there is a more content in this second edition as compared to the first including:

  • Demonstration of various ways to quickly access your data.
  • More on how to format your data.
  • How to get basic descriptive data in Excel just by highlighting the data you want.
  • Using the powerful Pivot Table/Charts and Data Analysis functions in Excel.
  • Identifying and removing duplicate data.
  • Printing tricks (e.g., headers, footers, and margining).
  • Converting data tables in PDF documents to Excel.
  • Filling in multiple cells with a common value.
  • More on how to merge data from two sources using a unique identifier.
  • More up-to-date supporting websites.
  • A whole lot more about charts now including:
    • How to choose the right chart for your data;
    • An overview of chart guidelines and recommendations;
    • More on customizing charts;
    • Saving and re-using your customized charts as templates;
    • Using the Switch Row-Column feature;
    • Creating other charts such as thermometer and waffle charts;
    • Including a goal line in your charts for all students;
    • Creating charts of your Time and Task Analysis; and
    • Creating Charts in Google Docs.
  Click here to see a checklist of all the lessons in this tutorial.
 
Get started by purchasing a subscription good for 2 years from your sign-up date for only $21.95. After purchase, you will receive an email with your new userid and password.
 

 



Sample Videos

The F11 Trick
Freeze Panes

 

Purchase a 2 year subscription for only $21.95
 
 
 
 
Sabella & Associates, LLC 2014