Microsoft Excel 2010 Course - ITU Online Old Site

Microsoft Excel 2010 Course

In this Excel 2010 Course you will learn the basic, intermediate, and advanced features with Microsoft Office’s Excel 2010 training. You will learn how to use this spreadsheet program to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts.

Included In This Course

Included In This Course

Total Hours
5 Hrs 14 Min
Microsoft Excel 2010 Course
34 On-demand Videos
Closed Caption

Closed Captions

Course Topics
3  Topics
Prep Questions
45 Prep Questions
Microsoft Excel 2010 Course

Certificate of Completion

Course Description

Note: Even though this course is based on an older version, it is still a worthwhile resource for online learning and training.

ITU proudly presents their comprehensive guide to the latest version of Microsoft’s Excel 2010 spreadsheet software. In this video course, you will be thoroughly educated in how to use and navigate from within the application.

About our online training course

In this comprehensive Excel training program, you will learn by example as the author demonstrates each step and explains them in detail. No matter your level of expertise, this course provides a thorough exploration of Microsoft Excel 2010 from the very beginning—you’ll be creating worksheets like a pro in no time! ITU’s instructor methodically and expertly takes you from the basics through advanced topics such as formulas, functions, Microsoft Web Apps connectivity, SkyDrive utilization for storing and sharing projects; all with the option to follow along using downloadable working files. Join him on this journey of discovering how to utilize Microsoft Excel 2010!

What you will learn

Are you ready to unlock the power of Microsoft Office Excel 2010? This incredible learning opportunity will teach you all the basics, intermediate and advanced features that Excel has to offer. You’ll be able to use this amazing software program for tracking data, building models, writing formulas and presenting your findings in beautiful charts! With Excel’s powerful capabilities at your fingertips, analyzing data and making informed business decisions has never been easier. Now is your chance – enroll today!

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft Excel 2010 Course Content

Excel 2010 Basic

  •    Intro to Excel Basic

  •    Interface and Functions

  •    Cells

  •    Entering Data Into Cells

  •    Basic Formatting in Excel

  •    Creating a Worksheet

  •    The Intelligence Of Excel

  •    Customizing Rows and Columns

  •    Creating Formulas

  •    Summary Pages and Moving Workbook to Workbook

  •    The Function Builder

  •    Conditional Formatting

  •    Sorting and Filtering Data

  •    Printing with Excel

  •    Conclusion

  •    Excel Basic Flashcards

Excel 2010 Intermediate

  •    Intro to Excel Intermediate

  •    Charts

  •    Headers Footers and Layout Options

  •    What If

  •    Basic Tables in Excel

  •    Pivot Tables

  •    Manipulating Data Within the Pivot Tables

  •    Pivot Table Charts

  •    Data Validation

  •    Conclusion

  •    Excel Intermediate Flashcards

Excel 2010 Advanced

  •    Intro to Excel Advanced

  •    Customizing the Ribbon and Cells

  •    Creating and Managing Ranges

  •    More Formulas

  •    Data Analysis

  •    Data From an Outside Source

  •    Spark Lines

  •    Macros

  •    Conclusion

  •    Excel Advanced Flashcards

Add a review
Currently, we are not accepting new reviews
4.8
Based on 82 reviews
1-5 of 67 reviews
  1. AM

    Mary Beth helped me. She was wonderful.

  2. NM
  3. AA
  4. K
  5. BO

Your Training Instructor

Josh Schofer

Josh Schofer

Cybersecurity | Cloud Trainer

Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.

Microsoft Excel 2010 Course
 

Subscribe To All-Access
Lock In $14.99 / Month Forever

Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.

$49.00 $14.99 Monthly
OR

$49.00

Microsoft Excel 2010 Course

Microsoft Excel 2010 Training
Microsoft Excel 2010 Course
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Become an Outlook expert with our Microsoft Outlook Online Course. Learn valuable skills and boost your productivity today!

With this Microsoft Outlook 2016 training course, you will learn the four major components of Outlook including contacts, email, calendars, and tasks. You will also learn about the OneNote application that provides a cross-platform and cross-application note taking tool. This course covers all the bases, including Basic Outlook 2016, Intermediate Outlook 2016 and Advanced Outlook 2016.

Add To Cart
ON SALE 40% OFF
ON SALE 40% OFF
Microsoft Office 2016

$47.40

Gain expertise in Microsoft Office 2016 with our Certification Training Bundle. Enroll now to enhance your skills and boost your career prospects!

Master PowerPoint 2016 with this comprehensive course covering the three main sections: Basic, Intermediate and Advanced. Get an in-depth review of the software while learning to navigate its interface effectively and insert a variety of objects. Create dynamic presentations that will leave your viewers impressed as you learn about design, customization, and presentation techniques!

Add To Cart

$49.00

Learn Microsoft Excel with our online course. Master Excel with ease and improve your skills in data analysis, calculation, and organization.

In this Excel 2013 course, you will learn Excel is an unrivaled instrument for managing and interpreting large datasets. Moreover, it can be used to run simple calculations and organize almost any kind of information. Specifically, Excel enables you to track data, devise models for analyzing the same data, compose formulas that perform computations with such info, pivot the aforementioned data in many different ways and create a variety of elegant-looking charts.

Add To Cart