Mastering Microsoft Excel 2010 Made Easy Training Tutorial
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
93 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Microsoft Excel 2010 Made Easy Training Tutorial to your Wishlist.

Add to Wishlist

Mastering Microsoft Excel 2010 Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete Excel course. Video lessons & manuals included.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
93 students enrolled
Created by TeachUcomp, Inc.
Last updated 6/2013
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 6.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Formulas
  • Formatting Worksheets
  • Creating Spreadsheet Charts
  • PivotTables
  • Advanced Filtering of Data
  • Making Macros
  • Much More!
View Curriculum
  • Excel software recommended for practice.

Learn Microsoft Excel 2010 with this comprehensive course from TeachUcomp, Inc. Mastering Excel Made Easy features 143 video lessons with over 12 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.

Whether you are completely new to Excel or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch a video lesson or open one of the manuals and you’re on your way to mastering Excel.

Who is the target audience?
  • Anyone wanting to learn Microsoft Excel.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 146 Lectures Collapse All 146 Lectures 11:49:52
Getting Acquainted with Excel
14 Lectures 28:34

Scroll Bars

The Quick Access Toolbar

The Formula Bar

The Workbook Window

The Status Bar

The Workbook View Buttons

The Zoom Slider

The Mini Toolbar

Keyboard Shortcuts
Creating Basic Workbooks
12 Lectures 28:52

Opening Workbooks

Selecting Cells

Entering Text Into Cells

Entering Numbers Into Cells


Pick From Drop-Down List

Using the "Window" Command Group

Switching to Full Screen View

Working with Excel File Formats
Using Ranges
3 Lectures 09:11
Creating Formulas
8 Lectures 18:59

Using AutoSum

Inserting Functions

Editing a Range

Formula and AutoCorrect

Copying and Pasting Formulas
5 Lectures 11:54
Absolute References and Relative References

Cutting, Copying and Pasting

AutoFilling Cells

The Undo Button

The Redo Button
Columns and Rows
4 Lectures 09:54
Selecting Columns and Rows

Adjusting Column Width and Row Height

Hiding/Unhiding Columns and Rows

Inserting and Deleting Columns and Rows
Formatting Worksheets
4 Lectures 13:13
Formatting Cells

The Format Cells Dialog Box

Clearing All Formatting from Cells

Copying All Formatting from Cells to Another Area
Worksheet Tools
6 Lectures 09:17
Moving Between Worksheets

Selecting Multiple Worksheets

Inserting and Deleting Worksheets

Renaming Worksheets

Coloring Worksheet Tabs

Copying or Moving Worksheets
Setting Worksheet Layout
3 Lectures 12:48
Using Page Break Preview

Using the Page Layout View

The Page Setup Dialog Box
Printing Worksheets
1 Lecture 04:10
Previewing and Printing Worksheets - 2010
20 More Sections
About the Instructor
TeachUcomp, Inc.
4.2 Average rating
2,398 Reviews
99,358 Students
67 Courses
Quality Software Training

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.