Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
5 Hrs 14 Min
34 On-demand Videos
Closed Captions
3 Topics
45 Prep Questions
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Your Training Instructor
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.
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 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
Master Microsoft Office 365 with our 70-347: Enabling Office 365 Services course and advance your career in cloud computing today!
This Microsoft 70-347: Enabling Office 365 Services course is the perfect choice for IT professionals seeking to assess, plan, deploy and manage Office 365 services and their corresponding dependencies, needs and technical resources.
$49.00
Master Microsoft PowerPoint with our online course. Learn how to create engaging presentations that leave an impact. Enroll now!
Through this Powerpoint 2013 Training course, you will garner knowledge on essential, intermediate and advanced functions of the Microsoft Office PowerPoint 2013 software. This program is an illustrative application principally employed to build presentations.
$49.00
Learn Microsoft Word with our comprehensive online course! Boost your productivity and efficiency in creating professional documents. Enroll now.
Learn the power of Word in this Word 2010 Training. Microsoft Word 2010 is your one-stop shop for crafting polished documents. With its impressive array of features, including formatting and collaboration tools, it can help you create professional quality materials in no time!
I’ve enjoyed the training so far. Wish it was more focused on Linux like other training, but still good.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.