Tools in Excel 2010 for Windows
Excel 2010 (Windows)
| Beginner
- 7 videos | 55m 45s
- Earns a Badge
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 44sOne 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 50sExcel 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
-
3. Using document themes in Excel 2010 (Windows)5m 30sIf 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
-
4. Using advanced sorting & filtering tools in Excel 2010 (Windows)8m 18sThe 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
-
5. Inserting charts in Excel 2010 for Windows8m 32sCompared 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
-
6. Creating PivotTables in Excel 2010 (Windows)9m 45sThe 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
-
7. Sorting & filtering your PivotTable in Excel 2010 for Windows7m 6sSorting 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.
