Microsoft Excel 2010 Training

$9.00

In this 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.

5  Training Hours
34 Videos
3  Topics
45 Practice Questions
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. To see more Microsoft related training, click here.

Microsoft Excel 2010 Course Outline

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
excel-2010.jpg
Microsoft Excel 2010 Training

$9.00

In this 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.

Related Courses

$49.00

In this course you will learn how to evaluate, plan, deploy, and operate the Office 365 services, including its dependencies, requirements, and supporting technologies. This course prepares you for the MS-346 certification exam.

$9.00

Microsoft Outlook 2013 provides its more than 500 million Office users with an amazing collection of business and personal email management tools. With the introduction of Outlook 2013, these global individuals now have access to a range of experiences that better cover their needs in life – whether at work, home or school.

$9.00

Through this 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

In this course you will learn the tasks required to maintain a Windows Server 2012 infrastructure, such as user and group management, network access, and data security.

UNLOCK

25% OFF

Sign up for updates, discounts, and more.