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 pass good for 2 years from your sign-up date for only $21.95. After purchase, you will see a new window on your browser that will allow you to register your userid and password. Finally, check your email for a link for a final confirmation. If you need any support, please use this contact form.
 

 



Sample Videos

The F11 Trick
Freeze Panes

 

Purchase a 2 year pass for only $21.95
 
 
 
 
Sabella & Associates, LLC 2014
jordan retro 7 retro jordans beats by dre cheap jordan retro 11 jordan 7 coach outlet canada goose outlet coach outlet canada goose legend blue 11s Michael Kors outlet jordan retro 7 canada goose outlet canada goose nike Michael Kors outlet canada goose outlet nike jordan retro 7 canada goose outlet louis vuitton sac moncler jackets jordan retro 12 nike air max beats by dre cheap beats by dre cheap beats by dre cheap coach outlet louis vuitton outlet louis vuitton outlet moncler jackets louis vuitton outlet louis vuitton outlet beats by dre cheap beats by dre cheap coach outlet nike air max uggs outlet louis vuitton jordan retro 12 nike jordan retro 7 Michael Kors outlet canada goose outlet canada goose outlet nike jordan retro 7 coach outlet coach factory Michael Kors outlet canada goose outlet legend blue 11s air jordans nike Michael Kors outlet jordan retro 11 jordan retro 11 legend blue 11s Michael Kors outlet retro jordans nike air max beats by dre cheap uggs nike air max nike air max nike free run beats by dre cheap beats by dre cheap nike air max jordan 12 nike air max moncler jackets moncler jackets coach outlet nike air max jordan retro 12 coach outlet nike air max nike free run uggs outlet coach outlet jordan retro 7 canada goose outlet retro jordans legend blue 11s nike retro jordans Michael Kors outlet canada goose retro jordans nike canada goose outlet Michael Kors outlet beats by dre beats by dre cheap canada goose outlet beats by dre cheap retro jordans jordan 7 retro jordans jordan retro 12 moncler jackets moncler jackets moncler jackets louis vuitton sac beats by dre cheap nike free run jordan retro 12 coach outlet coach outlet moncler jackets moncler jackets moncler jackets uggs outlet nike air max nike free run beats by dre cheap uggs uggs outlet louis vuitton outlet retro jordans jordan 7 Michael Kors outlet legend blue 11s canada goose outlet nike legend blue 11s jordan 7 Michael Kors outlet canada goose outlet beats by dre canada goose outlet jordan retro 7 Michael Kors outlet retro jordans canada goose outlet coach outlet canada goose outlet air jordans retro jordans moncler jackets jordan 12 moncler jackets coach outlet louis vuitton sac jordan retro 12 louis vuitton sac louis vuitton outlet louis vuitton sac beats by dre cheap louis vuitton sac nike free run nike air max louis vuitton sac beats by dre cheap louis vuitton outlet sac louis vuitton nike air max coach outlet louis vuitton outlet jordan retro 7 canada goose outlet jordan retro 7 canada goose outlet coach outlet retro jordans Michael Kors outlet retro jordans nike Michael Kors outlet nike coach factory legend blue 11s beats by dre jordan 7 air jordans retro jordans canada goose outlet retro jordans Michael Kors outlet nike air max nike free run nike free run louis vuitton sac moncler jackets jordan retro 12 jordan retro 12 moncler jackets louis vuitton outlet coach outlet moncler jackets jordan retro 12 moncler jackets nike air max louis vuitton outlet uggs uggs outlet beats by dre cheap moncler jackets moncler jackets retro jordans jordan retro 7 Michael Kors outlet canada goose outlet jordan retro 7 Michael Kors outlet jordan retro 7 legend blue 11s canada goose outlet jordan retro 7 nike coach outlet Michael Kors outlet jordan retro 7 canada goose outlet Michael Kors outlet Michael Kors outlet canada goose jordan retro 11 Michael Kors outlet louis vuitton outlet louis vuitton outlet jordan retro 12 moncler jackets louis vuitton outlet nike free run louis vuitton sac nike free run louis vuitton outlet beats by dre cheap jordan retro 12 beats by dre cheap beats by dre cheap nike free run coach outlet louis vuitton sac jordan retro 12 moncler jackets louis vuitton sac moncler jackets jordan retro 4 michael kors outlet jordan 4 jordan retro 11 michael kors outlet oreo 4s jordan 4 retro jordans jordan 4 jordan 4 jordan 11 jordan retro 11 michael kors outlet jordan retro 11 louis vuitton outlet jordan 11 oreo 4s uggs on sale oreo 4s jordan retro 11 michael kors outlet air jordans canada goose outlet louis vuitton outlet michael kors outlet canada goose sale air jordan 4 jordan retro 4 michael kors outlet canada goose outlet jordan 11 jordan retro 4 louis vuitton michael kors outlet michael kors outlet louis vuitton outlet louis vuitton outlet michael kors outlet jordan 4 oreo michael kors outlet michael kors outlet legend blue 11s jordan retro 11 jordan retro 7 jordan retro 11 jordan 11 legend blue louis vuitton outlet jordan 4 air jordan 4 louis vuitton pas cher louis vuitton outlet michael kors outlet jordan 11 michael kors outlet air jordans louis vuitton outlet jordan retro 11 air jordans jordan retro 11 jordan retro 11 jordan 4 louis vuitton outlet michael kors outlet jordan retro 4 michael kors outlet french blue 7s jordan 11 louis vuitton outlet jordan 13 jordan retro 7 air jordans michael kors outlet canada goose sale air jordan 4 louis vuitton outlet jordan 11 michael kors outlet jordan retro 4 louis vuitton outlet canada goose outlet jordan 4 louis vuitton outlet jordan 10 red cements michael kors outlet jordan retro 11 red cements 10s jordan retro 11 michael kors outlet michael kors outlet uggs on sale jordan retro 11 legend blue 11s air jordans jordan 11 air jordans michael kors outlet jordan 11 air jordans michael kors outlet jordan 11 louis vuitton outlet jordan retro 4 louis vuitton outlet michael kors outlet jordan 7 french blue jordan retro 4 louis vuitton outlet michael kors outlet jordan 10 red cements michael kors outlet michael kors outlet jordan 7 french blue retro jordans jordan 11 jordan 4 michael kors outlet louis vuitton outlet michael kors outlet jordan retro 11 michael kors outlet jordan retro 11 Legend blue 11s jordan 11 louis vuitton outlet jordan 11 air jordan 4 michael kors outlet legend blue 11s jordan 7 french blue air jordan 11 michael kors outlet jordan retro 11 jordan 11 jordan 11 louis vuitton outlet Legend blue 11s jordan retro 4 legend blue 11s jordan retro 4 louis vuitton outlet legend blue 11s louis vuitton outlet louis vuitton outlet canada goose sale french blue 7s louis vuitton outlet louis vuitton outlet air jordan 4 michael kors outlet jordan retro 4 jordan 4 oreo canada goose sale air jordan 4 michael kors outlet jordan retro 4 jordan retro 4 louis vuitton outlet michael kors outlet jordan retro 4 oreo 4s jordan 11 jordan 11 jordan 4 jordan retro 11 air jordans louis vuitton outlet michael kors outlet jordan 11 michael kors outlet legend blue 11s jordan retro 11 jordan retro 11 air jordans jordan 11 louis vuitton outlet french blue 7s louis vuitton outlet jordan 7 french blue louis vuitton outlet jordan retro 11 louis vuitton outlet jordan 11 legend blue louis vuitton outlet michael kors outlet air jordans french blue 7s jordan 4 jordan 10 red cements uggs outlet legend blue 11s uggs outlet jordan retro 11 jordan retro 4 french blue 7s jordan 13 french blue 7s michael kors outlet louis vuitton outlet jordan 4 michael kors outlet jordan 11 louis vuitton outlet oreo 4s jordan 4 air jordan 11 jordan retro 13 jordan 11 jordan retro 11 uggs on sale jordan retro 11 jordan 11 uggs on sale air jordan 4 louis vuitton outlet jordan retro 11 jordan retro 4 jordan retro 11 louis vuitton outlet red cements 10s michael kors outlet michael kors outlet uggs outlet red cements 10s french blue 7s louis vuitton outlet canada goose sale oreo 4s michael kors outlet jordan 4 jordan 11 jordan retro 4 french blue 7s jordan retro 11 michael kors outlet air jordans jordan 7 french blue jordan 11 oreo 4s legend blue 11s jordan 11