Get the Newest CompTIA A+ 2025 Course for Only $12.99

For a limited time, check out some of our most popular courses for free on Udemy.  View Free Courses.

Microsoft Excel 2010 Course

Course Level: Beginner
Duration: 5 Hrs 14 Min
Total Videos: 34 On-demand Videos

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.

Course Description

This course is ideal for professionals who manage data in spreadsheets and want to master Excel 2010’s core capabilities to deliver accurate reports and persuasive visuals. By the end, you’ll navigate the workbook with confidence and use it to build reliable models that support business decisions.

In this comprehensive online training, you’ll learn by example as the instructor demonstrates each step and explains the reasoning behind it. From the basics to advanced topics, you’ll create worksheets like a pro, master formulas and functions, and explore how Microsoft Web Apps and SkyDrive sharing can help you store and collaborate on projects. With downloadable working files, you can follow along and practice at your own pace.

What you will learn ranges from foundational skills to intermediate techniques and beyond. You’ll track data accurately, apply formulas and functions to solve real problems, build and interpret charts for data visualization, and manage workbooks and worksheet navigation efficiently. This training helps you turn raw data into clear insights and professional reports.

  • Apply Excel 2010 formulas and functions to automate calculations and analyses
  • Create and interpret charts and pivot tables to visualize data effectively
  • Manage workbooks, worksheets, and cell references for robust data organization
  • Use sorting, filtering, and data analysis tools to derive actionable insights
  • Collaborate with Microsoft Web Apps and SkyDrive sharing for team projects

Ready to unlock the power of Excel 2010 for everyday work and advanced data tasks? Enroll today to start building spreadsheet proficiency that translates into tangible business results.

Who Benefits From This Course

Included In This Course

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