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
lebron 12 court vision jordan 7 ftlog for the love of the game 7s foamposites red october jordan 7 marvin the martian jordan 4 oreo lady liberty 10s laster 4s chicago 10s Tom Brady Jersey women's foamposites dark obsidian bulls over broadway 10s Russell Wilson Jersey Tom Brady Jersey women's Tom Brady Jersey women's jordan 10 bulls over broadway metallic silver 5s jordan 4 oreo jordan 7 marvin the martian Patriots Jersey jordan 5 metallic silver lebron 12 all star marvin the martian 7s bulls over broadway 10s jordan 4 oreo Tom Brady Jersey for the love of the game 7s jordan 5 metallic silver chicago 10s jordan 7 for the love of the game foamposites metallic gold New England Patriots Jersey cheap foamposites aqua jordan 4 laster louis vuitton outlet michael kors outlet jordan 7 ftlog foamposites red october lebron 12 all star jordan 7 for the love of the game jordan retro 3 Russell Wilson Jersey foamposites mirror lebron 12 all star for the love of the game 7s jordan 3 foamposites mirror jordan 10 chicago Tom Brady Jersey jordan 10 chicago chicago 10s Russell Wilson Jersey youth foamposites metallic gold jordan 10 lady liberty lebron 12 all star marvin the martian 7s foamposites all star jordan 5 metallic silver lebron 12 court vision jordan 10 bulls over broadway Seattle Seahawks Jerseys ftlog 7s metallic silver 5s lebron 12 court vision oreo 4s nike kd 7 aunt pearl Seahawks Jerseys cheap bulls over broadway 10s michael kors Russell Wilson Jersey foamposites dark obsidian nike kd 7 aunt pearl foamposites red october Russell Wilson Jersey youth nike kd vii aunt pearl jordan 4 teal bulls over broadway 10s jordan 7 marvin the martian marvin the martian 7s New England Patriots jersey sale marvin the martian 7s foamposites aqua jordan 10 chicago marvin the martian 7s for the love of the game 7s Tom Brady Jersey foamposites mirror foamposites dark obsidian foamposites mirror nike kd 7 wings jordan 7 for the love of the game nike kd 7 wings foamposites metallic gold jordan 7 for the love of the game foamposites mirror jordan 3 marvin the martian 7s Russell Wilson Jersey foamposites metallic gold Seahawks Jerseys bulls over broadway 10s New England Patriots Jersey cheap Patriots Jersey chicago 10s jordan 7 marvin the martian Tom Brady Jersey women's jordan 3 nike kd vii aunt pearl ftlog 7s Tom Brady Jersey Tom Brady Jersey ftlog 7s jordan 3 lebron 12 all star lebron 12 all star jordan 7 marvin the martian oreo 4s oreo 4s Tom Brady Jersey ftlog 7s Seahawks Jerseys metallic silver 5s New England Patriots Jersey michael kors laster 4s oreo 4s jordan 10 lady liberty Tom Brady Jersey Tom Brady Jersey teal 4s nike kd 7 aunt pearl lebron 12 court vision Seahawks Jerseys lebron 12 all star jordan 4 laster louis vuitton outlet for the love of the game 7s teal 4s metallic silver 5s foamposites dark obsidian New England Patriots ftlog 7s nike kd 7 wings bulls over broadway 10s louis vuitton outlet foamposites red october jordan retro 3 foamposites mirror louis vuitton outlet jordan 4 oreo jordan 7 ftlog foamposites all star foamposites mirror Seattle Seahawks Jerseys jordan 4 teal Seattle Seahawks michael kors outlet Tom Brady Jersey lebron 12 all star metallic silver 5s jordan 4 oreo jordan 4 oreo lebron 12 court vision ftlog 7s jordan 4 laster marvin the martian 7s jordan 10 lady liberty New England Patriots jersey sale Tom Brady Jersey women's Tom Brady Jersey jordan 5 metallic silver laster 4s laster 4s foamposites mirror nike kd vii wings jordan 7 marvin the martian lebron 12 all star Patriots Jersey lebron 12 court vision for the love of the game 7s for the love of the game 7s michael kors louis vuitton outlet louis vuitton outlet jordan 7 for the love of the game jordan 4 laster patriots super bowl jersey bulls over broadway 10s jordan 3 metallic silver 5s nike kd 7 wings jordan 10 chicago jordan 7 ftlog Tom Brady Jersey michael kors ftlog 7s foamposites dark obsidian chicago 10s marvin the martian 7s nike kd 7 wings jordan 7 ftlog foamposites dark obsidian oreo 4s chicago 10s ftlog 7s jordan 4 oreo Russell Wilson Jersey youth jordan 7 marvin the martian jordan 5 metallic silver jordan 7 marvin the martian jordan 4 oreo nike kd vii wings louis vuitton outlet louis vuitton outlet jordan 10 bulls over broadway metallic silver 5s Seahawks Jerseys cheap louis vuitton outlet foamposites mirror laster 4s bulls over broadway 10s louis vuitton outlet jordan 5 metallic silver jordan 5 metallic silver michael kors jordan 10 chicago jordan 10 chicago jordan 4 teal New England Patriots Jersey lady liberty 10s laster 4s Tom Brady Jersey Russell Wilson Jersey patriots super bowl jersey laster 4s louis vuitton outlet patriots super bowl jersey jordan 4 teal foamposites all star foamposites mirror 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