Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Computer Applications Microsoft Introduction to Microsoft Excel 2010
Return to Microsoft
introduction-to-excel-courses-2010

Introduction to Microsoft Excel 2010

Do you work with numbers? Then you need to learn Excel 2010 — and this is the place to do it. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently.

You'll learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons. At the end of this six-week course, you’ll be able to confidently use Microsoft Excel 2010!

6 Weeks / 24 Course Hrs
Starting October 18, 2017

Offered in Partnership with your Preferred School

De Anza College Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Microsoft Excel 2010

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Microsoft Excel 2010 Reviews

Introduction to Microsoft Excel 2010 Details + Objective

Course Code: ixt

You Will Learn
  • Learn shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently
  • Discover how to quickly and automatically calculate statistics, loan payments, future value, and more
  • Learn how to best sort and analyze date, create charts and graphs, and automate often repeated tasks
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Learn to use Excel 2010 and become a more productive member of your organization
  • Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
  • Learn to use the power of Microsoft Excel 2010 to save time, money and frustration
  • Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally
Introduction to Microsoft Excel 2010 Outline
Expand All
Week 1

Develop a solid understanding of the Excel interface, discover the best way to correct just about any mistake you might make in Excel, and learn to move from cell to cell while leaving behind expertly written labels, numbers, and formulas. Then, learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Week 2

Learn a wide variety of useful shortcuts and the art of file management, so you'll have no trouble saving, retrieving, printing, and emailing your worksheets, or copying, renaming, and even deleting files. Then, focus on writing sophisticated formulas that can help ease you through some rather sticky scenarios.

Week 3

Gain hands-on experience in the construction of three-dimensional workbooks that goes beyond just rows and columns. Then, you'll not only learn how to build a database in Excel, you'll also learn how to subtotal, sort, and filter.

Week 4

Build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Then, find out how to personalize your charts with photographs, text labels, and drawings, and discover the best ways to print or otherwise display the truly impressive charts that you'll be creating.

Week 5

Find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Then, learn to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation as well as how to calculate the monthly payment on just about any type of loan, and how long it will take to pay off your credit cards. You'll even create an amortization table just like lenders use to track a loan's payoff amount over time.

Week 6

Learn how to automate just about any task you find tedious or time-consuming. Finally, you'll teach Excel not only how to make decisions, but also how to act upon those decisions.

View All Sections
Introduction to Microsoft Excel 2010 Instructors
Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales ranging from $500 million to $3 billion. Through the course of his career, Chad has become an expert user of Microsoft Excel. His knowledge of Excel's capabilities has helped organizations streamline processes and save countless hours of labor. Chad has taught Excel to students of varying skill levels since 1997.

Introduction to Microsoft Excel 2010 Requirements / Prerequisites

There are no prerequisites for this course.

Microsoft Windows 8, Microsoft Windows 7, Vista, or XP

Microsoft Excel 2010 or Microsoft Office 2010 (the Home and Student Edition, Home and Business Edition, or Professional Edition) of Microsoft Office 2010 are all acceptable.

This course is not suitable for Macintosh users, users of older versions of Microsoft Excel, or users of OpenOffice.

Note: "Starter Version" and "Web App" versions of Microsoft Excel 2010 will not work with the full version of Excel taught in this course.

Introduction to Microsoft Excel 2010 Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All