Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Getting Started with Excel 2010 $74.95
Applying Basic Data Formatting in Excel 2010 $74.95
Moving and Getting Around in Excel 2010 $74.95
Moving Data and Modifying Worksheets in Excel 2010 $74.95
Saving, Sending, and Printing Excel 2010 Workbooks $74.95

Bundle Price: $199.00
Total Savings: $175.75


Getting Started with Excel 2010

Excel 2010 is the newest version of Microsoft's comprehensive spreadsheet tool that offers features that support a wide range of functions. The Ribbon menu is unique to Microsoft Office and stacks the many features of Excel into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all file-level tools, such as those used for saving, printing, and sharing your files. This course explores these topics and many other basics of Excel 2010, including opening the application, creating new spreadsheets, entering data and, AutoFill features. It also provides an introduction to the many tools that will help you create and use your spreadsheets productively.
  • start Excel 2010 and open an existing workbook
  • identify the features of spreadsheets
  • recognize the functions of key Excel 2010 interface elements
  • create a new workbook
  • enter data in a given scenario
  • open a workbook based on an existing template
  • open an Excel workbook
  • enter data into an Excel workbook

Applying Basic Data Formatting in Excel 2010

Excel 2010 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores the processing of formatting cells and text, using tools such as the format painter and changing the way text is presented in order for it to be more visually appealing. This course also explains the various options for formatting numbers in Excel 2010.
  • apply basic text formatting
  • apply and copy cell formatting
  • recognize how alignment commands change the position of text
  • apply and modify number formats
  • match number formats with examples
  • format text and cells
  • align text in a cell
  • modify and apply a number format

Moving and Getting Around in Excel 2010

While it can look complicated and daunting, navigating the Excel interface isn't as difficult as it first appears. This course will show you how to move around the Excel interface using the various keys on the keyboard, such as the Home and End keys, and Ribbon commands. The course also covers the ways in which you can view and arrange workbooks and worksheets to be the most useful and shows you how you can access Excel's many Help features.
  • move around a worksheet
  • recognize how to navigate around Excel in a given scenario
  • get Help on Excel tasks or commands
  • alter your view of the worksheet
  • recognize how Workbook Views alter the appearance of a worksheet
  • recognize how to zoom in or out of a worksheet
  • work with different windows in Excel 2010
  • work with panes in Excel workbooks
  • move around a worksheet
  • alter your view of a worksheet
  • arrange and view workbook data

Moving Data and Modifying Worksheets in Excel 2010

The ability to easily manipulate data is probably the biggest benefit of using productivity applications, such as Excel 2010. For instance, if you have to copy the same data multiple times or move large amounts of data from one place to another within a worksheet or between workbooks, you can see this is much more easily accomplished through software than through the use of pen and paper. For example, Excel 2010 features such as Live Preview let you see how copied data will look before you copy it, even if it's copied between Office applications, and the Paste Special option allows you to further define how your data is copied or moved. This course is designed to show you many of the ways that Excel 2010 allows you to manipulate data and the worksheets that contain them and describes features that let you do this quickly and efficiently.
  • copy and move data
  • use paste options to preview and control how data displays
  • insert and delete rows and columns
  • format rows and columns
  • insert and delete worksheets
  • copy or move worksheets
  • copy and paste data
  • modify rows and columns
  • copy and modify worksheets

Saving, Sending, and Printing Excel 2010 Workbooks

Excel 2010 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it to save a hard copy or share with someone else. New features of Excel 2010 also allow you to easily collaborate with others by using the Sharing option in Backstage view. All of these options – saving, printing, and sharing – are grouped together on the File tab for convenience. This course describes these Excel features and explains how to use them to increase your efficiency and productivity.
  • save a workbook in a different format
  • save an Excel workbook
  • change the default save options in Excel 2010
  • share and send a workbook
  • use the Page Setup settings to prepare a worksheet for printing
  • print an Excel 2010 workbook
  • save a workbook
  • share a workbook
  • prepare and print a workbook
Register Now
Microsoft Office 2010: Beginning Excel Part 1 e-learning bundle
  • Course ID:
    252385
  • Duration:
    5 hours
  • Price:
    $199