- All Lessons
- Staff Picks
- Pocket Perfect
- Sunset Magazine
- Curious 52
- Art & Photo
- Game On
- Green Thumb
- Smarty Pants
- Fit & Active
- Tasty Treats
- Song & Dance
- Health & Beauty
- Kids Only
- Business Savvy
- Party Time
- Great Outdoors
- Learn to Code
- Around the House
- Fancy Free
- Under 5 Minutes
Begin wrapping your head around Excel with this tutorial on basic workbook skills! Follow along with Motion Training as he demonstrates how to create a new spreadsheet, enter and edit data, format and resize your data cells, and how to save your changes - all the while cluing you in on handy keyboard shortcuts. Although this tutorial is specific to Excel 2010, most of the skills taught here can be applied to earlier versions of Microsoft Office.
Improve your Microsoft Excel skills by learning how to use common functions. In this lesson, Motion Training will walk you through a sample workbook and commonly used Excel functions: sum (adding), average, maximum, minimum, and count. Learn how to set the range of a function manually, how to use the Excel AutoSum feature, and how to choose standard functions from the function wizard or the formula library.
In this lesson, Motion Training demonstrates how to do calculations in spreadsheets in Microsoft Excel 2010. From where important keys are located on the keyboard to the sequence in which formulas are written, Guy equips you to do basic calculations. By the end of the tutorial, you will understand the benefits of using cell references instead of numbers, and be able to apply formulas quickly to lists of calculations.
Show off your slideshow skills with this tutorial in the basics of PowerPoint! In this beginner lesson from Motion Training, learn to create professional and engaging slideshows. See how to: add slides; create bullet points; write and edit text make custom slide layouts; format your presentation with themes; add images, animate your presentation; and much more. Although this lesson is specific to PowerPoint 2010, the concepts presented here can be applied to any edition of PowerPoint.
Are you hungering for new Microsoft Excel skills? Learn how to make a pie chart! This lesson from Motion Training teaches you to make and modify a pie chart, which tracks the distribution or percentage of data across multiple categories. Learn how to select your numbers, create your chart, and format it by moving individual pie slices (for an 'exploded pie chart'). Give the chart a 3D effect, and see how to label your pie slices with numbers or percentage values and format your legend box.
Knowing your way around a sewing machine opens up a whole new world of creativity! From clothing to home décor to customized gifts, sewing provides you with a range of opportunities to use your skills, save money, and bring your artistic designs to life. In this sewing lesson, Mimi G shows you around a sewing machine, explaining the most basic functions that most machines are equipped to do, describes the most necessary tools you’ll need to begin, and teaches you how to read a pattern.
Knitting is an excellent way to make your own clothing or craft elegant gifts for loved ones. It allows you to express yourself artistically through the stitches and designs you use in your piece. In this lesson from Fabin BC, watch and learn how to knit a cable cast on. Start by learning how to do a slip stitch and how to hold your needles. Lynne shows you how to knit the cast on stitch and then demonstrates what to do when you get to the last stitch, to create a lovely cabled edge.
Lost in the woods? No need to resort to trails of bread crumbs! This lesson from Roadside Nature shows you the correct way to hold, use, and read a compass to scout your way home. Point the compass forward, keeping it level with the ground. Ensure that there are no metallic objects or electricity sources nearby, as these can interfere with your compass. Learn about the Quadrant and Azimuth methods of finding a specific direction.
Interested in learning how to use Microsoft Excel 2010? The first in a series, this Excel tutorial covers how to edit and format spreadsheets, enter data, and create basic charts. Motion Training will also teach you simple tips and tricks to help you get started with this powerful software. Although the lesson focuses on Microsoft Excel 2010, the concepts covered can be applied to earlier versions of Excel.
Whether you have a home business and need to keep track of inventory, or you have to organize data for a report, spreadsheets are a great organizational tool and can help you manage information efficiently. In this lesson, learn how to get started in Microsoft Excel 2003. Guy Badger shows you the basics of data entry and formatting, and teaches you about auto complete and general navigation in the spreadsheet.
Breakfast is almost over and the boys are ready to start their day. Review the Spanish words and phrases you’ve already learned and pick up a few new ones along the way with this scene from Foreign Languages for Kids by Kids. Simple graphics, demonstrations, and quizzes will help you memorize everything in minutes. Perfect for kids (and kids at heart)!
New to Microsoft Excel 2003? Unfamiliar with the program and its basic functions and applications, or intimidated by this complex software? This tutorial demystifies the program and teaches you the basics of creating a spreadsheet and chart from a series of data, while demonstrating the advantages of using Microsoft Excel to manage information.
Disappointed by your doodles, and wish you could draw better? Drawing well is about your hand being able to do what your brain tells it to do. And if your hand doesn’t have much practice at creating certain shapes or lines, the end result of your sketching may not look at all like it did in your mind’s eye. But drawing is a skill and the old saying “practice makes perfect” still applies—learn how to improve your drawing skills with this lesson from Drawing Teachers. Michael shows you a beautiful and interesting way to practice drawing shapes and lines.
Take the confusion out of calculations with this Excel 2003 tutorial from Motion Training. In this third lesson in the training series for Excel users, learn how to create and format a table to compute equations using division, multiplication, addition, and subtraction. Become familiar with keyboard shortcuts, and learn what cell references are and how using them will make updating data much simpler. Finally, learn tips and tricks to make your calculations quicker and easier.
Learning how to write a good essay isn’t just a requirement for many exams or a prerequisite for many college classes—it is an integral life skill. By learning how to articulate your thoughts clearly and concisely, you’ll improve your ability to reason and your powers of persuasion. In this writing lesson, learn how to craft a great 5-paragraph essay, from introduction to conclusion! As a bonus, learn how to add, introduce, and explain a quotation, for a first rate paper.
Fashion magazines can provide wonderful ideas for your wardrobe. But these fashions often cost more than you can spend. Learn how to make them for yourself, at home! You’ll save on cash, and each time someone compliments you on your good taste, you’ll have the personal satisfaction of knowing you designed and created your one-of-a-kind jewelry. In this lesson, get the hang of making wirework jewelry— familiarize yourself with the tools, materials, and learn how to design your own pieces.
Some people like sports, some people like reading books. What do you like? In this lesson from Foreign Languages for Kids by Kids, follow along with Eli, Andy, Parker as they talk about their hobbies in Spanish. With the help of fun graphics and examples, you’ll learn how to talk about a few of your own favorite things and pick up a few new words and phrases along the way! Perfect for kids (and kids at heart)!
Learn how to bead a necklace with this jewelry making tutorial. This lesson teaches you which tools you'll need, how to create your own necklace design, and how to successfully complete your beading project. Take what you've learned here to design your own handmade bracelet and necklace set!
Learn to make a classic fashion accessory - the bow tie! Hone your sewing skills with this easy lesson, and make this easy and customizable tie. Professor Pincushion explains the necessary materials, how to prepare your fabric, and finally how to pin and sew your tie together. Whether the tie is for Dad on Father’s Day, groomsmen in a wedding party, or your prom date - your sartorial creation will lend class and distinction to whoever is wearing it, wherever they go. Free pattern included!