Microsoft Excel 2010

This course is training for basic, intermediate, and advanced features of Microsoft Office Excel 2010 software. Excel is a spreadsheet program in the Microsoft Office system.

$25.99

SKU: IT-excel-2010-365 Categories: , ,
Description

This course is training for basic, intermediate, and advanced features of Microsoft Office Excel 2010 software. Excel is a spreadsheet program in the Microsoft Office system.

You can use Excel 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.

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!

Course Outline

Microsoft Excel 2010 Course Content

Download Course Outline

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

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

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 Schofer
Cybersecurity | Cloud Trainer

$25.99

Course features:

5 Hrs 14 Min

34 VIDEOS

1 Year Access

Available on Web