Tools in Excel 2010 for Windows

Excel 2010 (Windows)    |    Beginner
  • 7 videos | 55m 45s
  • Earns a Badge
Likes 86 Likes 86
Excel 2010 offers a number of powerful tools for working with styles, themes, charts, and PivotTables. Explore the various tools found in Excel 2010.

WHAT YOU WILL LEARN

  • Creating quick tables
    Using quick cell styles
    Using document themes
    Sorting & filtering using colors
  • Inserting charts
    Creating a PivotTable
    Sorting & filtering your PivotTable

IN THIS COURSE

  • 8m 44s
    One of the key differences between Excel 2003 and Excel 2010 is the quick table tool. You can now create and format new tables in a matter of clicks. These tables are extremely useful for manipulating and sorting your table entries, changing their overall appearance, and even performing calculations. FREE ACCESS
  • 7m 50s
    Excel 2003 had cell styles, but Excel 2010 has really improved their utility, usability, and accessibility. You will also find that Excel 2010 offers far more powerful conditional formatting rules and presets. FREE ACCESS
  • Locked
    3.  Using document themes in Excel 2010 (Windows)
    5m 30s
    If you have only ever used Excel 2003, then document themes in Excel 2010 will be a completely new feature to you. You can use themes to change the overall appearance of your workbook. Each element - font set, color scheme, and effects - can also be customized individually. FREE ACCESS
  • Locked
    4.  Using advanced sorting & filtering tools in Excel 2010 (Windows)
    8m 18s
    The sort and filter tools have been greatly improved in Excel 2010. Tools such as the AutoFilter, while present in Excel 2003, are now much more powerful, and allow you to create advanced sorted and filtered views. You can even filter your data using colors that have been applied to your table. FREE ACCESS
  • Locked
    5.  Inserting charts in Excel 2010 for Windows
    8m 32s
    Compared to Excel 2003, charts are far easier to insert, format, and manipulate in Excel 2010. You can quickly change the chart type without losing your data modifications, and the labeling options are now much more accessible. FREE ACCESS
  • Locked
    6.  Creating PivotTables in Excel 2010 (Windows)
    9m 45s
    The PivotTable options in Excel 2003 have been greatly improved in Excel 2010. There are fewer menus to navigate, and it is now much easier to manipulate the different fields in your table. FREE ACCESS
  • Locked
    7.  Sorting & filtering your PivotTable in Excel 2010 for Windows
    7m 6s
    Sorting and filtering the data in your PivotTable is much easier in Excel 2010 than it was in Excel 2003. What's more, the new Slicer tool makes it simple to visualize the filters that you have applied, no matter how many there are active. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Customizing charts in Excel 365
Course Ten common tools in PowerPoint 365
Course PL-300: Creating & Formatting Charts In Power BI

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Excel Tables in Excel 2019 for Windows
Likes 351 Likes 351  
Course Inserting PivotTables in Excel 2019 for Windows
Likes 231 Likes 231  
Course Getting Started in Excel 2010 for Windows
Likes 125 Likes 125