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
$19
$50
62% off
Take This Course
  • Lectures 146
  • Length 12 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2012 English

Course 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.

What are the requirements?

  • Excel software recommended for practice.

What am I going to get from this course?

  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Formulas
  • Formatting Worksheets
  • Creating Spreadsheet Charts
  • PivotTables
  • Advanced Filtering of Data
  • Making Macros
  • Much More!

What is the target audience?

  • Anyone wanting to learn Microsoft Excel.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Acquainted with Excel
About Excel
Preview
02:27
The Excel Environment
Preview
01:57
The Title Bar
Preview
01:26
The Ribbon
Preview
02:41
The "File" Tab and Backstage View
Preview
02:49
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
Section 2: Creating Basic Workbooks
Creating New Workbooks
Preview
00:41
Saving Workbooks
Preview
02:03
Closing Workbooks
Preview
00:32
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
Section 3: Using Ranges
Selecting Ranges
Preview
04:54
Ranged Data Entry
Preview
01:05
Using AutoFill
03:12
Section 4: Creating Formulas
Ranged Formula Syntax
Preview
01:53
Simple Formual Syntax
Preview
01:28
Writing Formulas
Preview
05:26
Using AutoSum
02:35
Inserting Functions
04:20
Editing a Range
01:23
Formula and AutoCorrect
00:40
AutoCalculate
01:14
Section 5: Copying and Pasting Formulas
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
Section 6: Columns and Rows
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
Section 7: Formatting Worksheets
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
Section 8: Worksheet Tools
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
Section 9: Setting Worksheet Layout
Using Page Break Preview
01:43
Using the Page Layout View
01:00
The Page Setup Dialog Box
10:05
Section 10: Printing Worksheets
Previewing and Printing Worksheets - 2010
04:10
Section 11: Helping Yourself
Using Excel Help
03:00
Section 12: 3D Formulas
Creating 3D Formulas
01:11
3D Formula Syntax
01:08
Creating 3D Range Preferences
01:06
Section 13: Named Ranges
Naming Ranges
03:27
Creating Names from Headings
01:10
Moving to a Named Range
00:41
Using Named Ranges in Formulas
02:11
Naming 3D Ranges
02:39
Managing Named Ranges
00:51
Section 14: Conditional Formatting and Cell Styles
Conditional Formatting
06:35
Finding Cells with Conditional Formatting
00:52
Clearing Conditional Formatting
00:56
Using Table and Cell Styles
01:45
Section 15: Paste Special
Using Paste Special
06:16
Pasting Linked Formulas
02:57
Section 16: Sharing Workbooks
Sharing Workbooks
05:13
Highlighting Changes
02:56
Reviewing Changes
02:06
Using Comments
07:53
Compare and Merge Workbooks
03:00
Section 17: Auditing Worksheets
Auditing Worksheets
01:18
Tracing Precedent and Dependent Cells
03:09

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

TeachUcomp, Inc., 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.

Ready to start learning?
Take This Course