Help Yourself: Tech Tips

Course by: Dan Gookin
Help Yourself: Tech Tips Watch preview
  • Course details

    For basic IT issues, most users prefer to help themselves. If you are interested in troubleshooting your own computer issues, this series is the answer. The tips are equally useful to end users, small businesses that perform their own IT, and enterprise IT help desks that want to reduce Level 1 service tickets. Instructor Dan Gookin focuses on the Windows PC, covering topics related to hardware, networking, security, and the operating system itself. No pre-existing knowledge is required.

    Instructor

    • Dan Gookin

      Dan Gookin

      Mad Genius
      View on LinkedIn

      Dan Gookin is the author of more than 120 titles. He has been writing about technology for over 20 years.

      Dan combines his love of writing with his gizmo fascination to create books that are informative, entertaining, and not boring. Because his 120 titles have 12 million copies in print that have been translated into over 30 languages, Dan can attest that his method of crafting computer tomes seems to work.

      Perhaps his most famous title is the original DOS For Dummies, published in 1991. It became the world's fastest-selling computer book, at one time moving more copies per week than the New York Times #1 bestseller (though as a reference, it could not be listed on the NYT Bestseller list). From that book spawned the entire line of For Dummies books, which remains a publishing phenomena to this day.

      Dan's most popular titles include PCs For Dummies, Word For Dummies, Laptops For Dummies, and Droid X For Dummies. He also maintains the vast and helpful website, www.wambooli.com.

      Dan holds a degree in communications/visual arts from the University of California, San Diego. Presently, he lives in the Pacific Northwest, where he enjoys spending time with his sons playing video games inside while they watch the gentle woods of Idaho.

      View all courses by Dan Gookin

    Skills covered in this course

  • Excel: Freezing rows or columns

    - [Instructor] For monster size worksheets, you might want to keep the top row and left column visible for reference purposes. The technique is to freeze these items, which prevents them from scrolling with the rest of the worksheet. To make it happen click the view tab, and in the window group choose freeze panes. And then to keep the top row from scrolling, choose freeze top row. Now as you scroll the document that top row stays in place. To undo choose freeze panes, unfreeze panes. Likewise for the left column choose freeze panes, freeze first column. And as you scroll that worksheet left and right, that first column stays in place. To freeze both choose the top left cell of the worksheet you don't want to scroll. In this case it would be cell B2, so everything above there and to the left of there would scroll. Choose freeze panes, freeze panes. Now we've locked the top row and left column, so we can scroll, and…

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents

Start learning today.

Learn the most in-demand business, tech and creative skills from industry experts. Start my free month