Migrating from Excel 2003 to Excel 2010 for Windows
Excel 2010 (Windows)
| Intermediate
- 7 videos | 51m 32s
- Earns a Badge
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 3sExcel 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 27sThe 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
-
3. Copying & moving your data in Excel 2010 for Windows5m 34sThe 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
-
4. Adjusting your print setup in Excel 2010 for Windows8m 15sThe 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
-
5. Using references in formulae in Excel 2010 for Windows8m 13sExcel 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
-
6. Using Excel's problem solving tools in Excel 2010 for Windows7m 33sExcel 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
-
7. Using formulae in Excel 2010 for Windows8m 29sYou 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.
