Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Acquainted with Excel|
The Excel EnvironmentPreview
The Title BarPreview
The "File" Tab and Backstage ViewPreview
The Quick Access Toolbar
The Formula Bar
The Workbook Window
The Status Bar
The Workbook View Buttons
The Zoom Slider
The Mini Toolbar
|Section 2: Creating Basic Workbooks|
Creating New WorkbooksPreview
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
|Section 3: Using Ranges|
Ranged Data EntryPreview
|Section 4: Creating Formulas|
Ranged Formula SyntaxPreview
Simple Formual SyntaxPreview
Editing a Range
Formula and AutoCorrect
|Section 5: Copying and Pasting Formulas|
Absolute References and Relative References
Cutting, Copying and Pasting
The Undo Button
The Redo Button
|Section 6: Columns and Rows|
Selecting Columns and Rows
Adjusting Column Width and Row Height
Hiding/Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
|Section 7: Formatting Worksheets|
The Format Cells Dialog Box
Clearing All Formatting from Cells
Copying All Formatting from Cells to Another Area
|Section 8: Worksheet Tools|
Moving Between Worksheets
Selecting Multiple Worksheets
Inserting and Deleting Worksheets
Coloring Worksheet Tabs
Copying or Moving Worksheets
|Section 9: Setting Worksheet Layout|
Using Page Break Preview
Using the Page Layout View
The Page Setup Dialog Box
|Section 10: Printing Worksheets|
Previewing and Printing Worksheets - 2010
|Section 11: Helping Yourself|
Using Excel Help
|Section 12: 3D Formulas|
Creating 3D Formulas
3D Formula Syntax
Creating 3D Range Preferences
|Section 13: Named Ranges|
Creating Names from Headings
Moving to a Named Range
Using Named Ranges in Formulas
Naming 3D Ranges
Managing Named Ranges
|Section 14: Conditional Formatting and Cell Styles|
Finding Cells with Conditional Formatting
Clearing Conditional Formatting
Using Table and Cell Styles
|Section 15: Paste Special|
Using Paste Special
Pasting Linked Formulas
|Section 16: Sharing Workbooks|
Compare and Merge Workbooks
|Section 17: Auditing Worksheets|
Tracing Precedent and Dependent Cells
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.