s

On-Demand Webinar

Excel: Master Powerful Data Management Tools

$197.00 $97.00

On-Demand Webinar

Excel: Master Powerful Data Management Tools

$197.00 $97.00

Choose Your Format
  • The integrity of the data you produce is essential to the success of your research. The more data you must manage the harder it can be. One wrong move can affect the reliability of your findings, and possibly impede your ability to get or maintain your funding.

    You just need to know the correct tools and techniques to use, and that’s where Excel expert, Dennis Taylor, can help. In just 60 minutes on he’ll walk you through EXACTLY how to better manage your large scientific data files so you can increase your productivity and decrease your headaches. 

    You’re missing out if you’re not using Excel to manage your large research data files. Sure, working with large amounts of data in Excel can make you feel like you want to pull your hair out… but it doesn’t have to.

    Don’t risk the negative effects that a poorly managed data file can lead to. Take advantage of this step-by-step 60-minute online training and get the tools you need to design, organize, format, validate and analyze your large data files more effectively for more accurate outcomes. Don’t wait, register today.


    100% Satisfaction Guaranteed or a Full Refund.

    You take no risk whatsoever. If you find this essential session doesn't meet your expectations or you are not satisfied for any reason, simply let us know.

  • Here are just a few of the step-by-step Excel tactics you’ll learn by utilizing this 60-minute online training:

    • Add easy-to-use drop-down lists to improve data entry accuracy and consistency
    • Incorporate validation controls to ensure clean data
    • Learn the fastest, most efficient ways to sort data (by content, color, random or data order)
    • Use filtering options to display just the data you need at any given time
    • Use slicers to gain easier data-handling, enhanced visual features, and better filtering
    • Rapidly correct erratic date and time entries with simple database design changes
    • Easily eliminate duplicate records from large data files
    • Insert a subtotal row without tediously creating new rows and formulas
    • Restructure improperly grouped columnar data with Text to Columns and Flash Fill features
    • Analyze your data with the COUNTIF/SUMIF family of functions
    • Convert lists into tables for easier data manipulation
    • And so much more…
    Who should attend this training? Nearly all Excel users who manage large research data files will benefit from this online training session (research scientists, students, postdocs, lab managers, lab staff, anyone collecting data for a research project, etc.). 

    SAVE $300 Now on an Institutional Site License!

    For only $947 $647, every single person in your institution or facility will have the same access to this training perpetually, saving you hundreds of dollars compared to purchasing individual access. $300 savings end in the next 2 days. ORDER TODAY!


    100% Satisfaction Guaranteed or a Full Refund.

    You take no risk whatsoever. If you find this essential session doesn't meet your expectations or you are not satisfied for any reason, simply let us know.

  • Meet Your Expert: Dennis Taylor

    Dennis TaylorDennis Taylor is a master at Excel and a skilled educator. He can take the most complicated aspects of Excel and make them easy to understand. He has taught over 5,000 excel seminars and classes, and is the author of Teach Yourself Microsoft Excel 2000 and a co-author of four other books on spreadsheet software. Dennis has developed customized Excel courses for specific clients, and has recorded over 180 hours of Excel training courses for Lynda.com. Since 2006 he has presented over 600 public webinars on a variety of Excel topics, and has led numerous training sessions with Apple, IBM, Lexmark, Texaco, Raytheon, Northrop-Grumman, and various federal and state agencies.

  • Reviews:

    “The information he provided today will help tremendously as we verify and clean our data. I was sorry that the webinar was only 1 hr long. The speaker did a great job and was funny but did not waste our time with small things and lengthy explanations. I appreciated him showing us some of the features that are not earth shattering but would make our lives considerably easier.”
    - Carly Ranson, Assistant Professor, University of the Pacific, Stockton, CA

    “Liked all of it.”
    - David Wood, Principal Analyst, Frontier Technology Inc., Waxhaw ,NC

    “Good pace, clearly explained, screen sharing worked well. Could be longer!”
    - Ellen McDonell, Clinician Scientist, Ottawa Integrative Cancer Centre, Ottawa, ON

    “Easy to watch!”
    - Julie Heiland, Senior Administrative Associate, The University of Texas at Austin, Austin, TX