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
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Excel software recommended for practice.
Description

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
00:30

The Quick Access Toolbar
03:06

The Formula Bar
00:56

The Workbook Window
03:10

The Status Bar
02:12

The Workbook View Buttons
01:22

The Zoom Slider
01:45

The Mini Toolbar
00:35

Keyboard Shortcuts
03:38
+
Creating Basic Workbooks
12 Lectures 28:52



Opening Workbooks
02:46

Selecting Cells
01:54

Entering Text Into Cells
02:13

Entering Numbers Into Cells
02:42

AutoComplete
01:02

Pick From Drop-Down List
00:51

Using the "Window" Command Group
09:12

Switching to Full Screen View
00:48

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



Using AutoSum
02:35

Inserting Functions
04:20

Editing a Range
01:23

Formula and AutoCorrect
00:40

AutoCalculate
01:14
+
Copying and Pasting Formulas
5 Lectures 11:54
Absolute References and Relative References
04:30

Cutting, Copying and Pasting
04:11

AutoFilling Cells
01:15

The Undo Button
01:04

The Redo Button
00:54
+
Columns and Rows
4 Lectures 09:54
Selecting Columns and Rows
01:45

Adjusting Column Width and Row Height
02:43

Hiding/Unhiding Columns and Rows
01:37

Inserting and Deleting Columns and Rows
03:49
+
Formatting Worksheets
4 Lectures 13:13
Formatting Cells
03:12

The Format Cells Dialog Box
07:54

Clearing All Formatting from Cells
00:34

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

Selecting Multiple Worksheets
01:25

Inserting and Deleting Worksheets
01:22

Renaming Worksheets
01:08

Coloring Worksheet Tabs
01:20

Copying or Moving Worksheets
02:30
+
Setting Worksheet Layout
3 Lectures 12:48
Using Page Break Preview
01:43

Using the Page Layout View
01:00

The Page Setup Dialog Box
10:05
+
Printing Worksheets
1 Lecture 04:10
Previewing and Printing Worksheets - 2010
04:10
20 More Sections
About the Instructor
TeachUcomp, Inc.
4.2 Average rating
2,269 Reviews
97,836 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.