Migrating from Excel 2003 to Excel 2010 for Windows

Excel 2010 (Windows)    |    Intermediate
  • 7 videos | 51m 32s
  • Earns a Badge
Rating 4.6 of 107 users Rating 4.6 of 107 users (107)
Migrating from a previous version of Microsoft Excel can be made easier by understanding the similarities and differences between versions. Explore Excel's data manipulation, printing, formulas, and problem solving tools.

WHAT YOU WILL LEARN

  • Using the data editing & proofing tools
    Formatting your data
    Copying & moving your data
    Adjusting your print setup
  • Using references in formulae
    Using excel's problem solving tools
    Using formulae

IN THIS COURSE

  • 6m 3s
    Excel 2010 features all of the data editing and proofing tools available in Excel 2003. You can, for example, still clear the values or formatting from a data selection, but in Excel 2010 these tools have been reorganized to fit the new ribbon interface. The proofing tools are also present and correct, but you will need to know how to access the Excel 2010 options, which have been moved to the File backstage area. FREE ACCESS
  • 7m 27s
    The data formatting tools in Excel 2003 have been greatly improved in Excel 2010. As well as the standard font, alignment, and text effect tools, you now have additional underline, fill, and outline effects. You can also create and easily reuse your own custom colors for all your fill and text effects. FREE ACCESS
  • Locked
    3.  Copying & moving your data in Excel 2010 for Windows
    5m 34s
    The Excel 2003 cut, copy, and paste tools are now much easier to find and manipulate in Excel 2010. The standard tools have been added to the Home tab for easy access, and you can use the advanced paste tools to quickly change how you insert your data into your worksheet. FREE ACCESS
  • Locked
    4.  Adjusting your print setup in Excel 2010 for Windows
    8m 15s
    The page layout and print setup tools available in Excel 2003 are all available in Excel 2010. They have, however, been reorganized to fit with the new ribbon interface. This reorganization is highly logical, however, and you will find the ability to edit your page layout and print setup at the same time, from the same view, extremely useful. FREE ACCESS
  • Locked
    5.  Using references in formulae in Excel 2010 for Windows
    8m 13s
    Excel 2003 features a number of very useful tools for referencing, tracking, and keeping an eye on your workbook data. These tools have been improved in Excel 2010. It is now easier to manage your named data ranges or freeze rows and columns in your worksheet. The Watch Window tool can now be found in the more logical View tab, with all the other window tools. FREE ACCESS
  • Locked
    6.  Using Excel's problem solving tools in Excel 2010 for Windows
    7m 33s
    Excel 2003's problem solving tools, including the Goal Seek and the Solver, are completely unchanged in Excel 2010. To use them again, all you need to know is how to activate them and where to find them in the Office ribbon. FREE ACCESS
  • Locked
    7.  Using formulae in Excel 2010 for Windows
    8m 29s
    You have probably used the Function Library to insert a formula into your Excel 2003 worksheet. This same Function Library is available in Excel 2010, but there is now a whole tab dedicated to inserting & using formulae. You will also find all the tools for analyzing, auditing, and recalculating your formulae in the same tab. 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

Rating 4.9 of 31 users Rating 4.9 of 31 users (31)
Rating 4.4 of 163 users Rating 4.4 of 163 users (163)
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Rating 4.5 of 7114 users Rating 4.5 of 7114 users (7114)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)