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 2007 $74.95
Manipulating and Formatting Data and Worksheets in Excel 2007 $74.95
Reviewing and Printing in Excel 2007 $74.95
Excel 2007 Formulas and Functions $74.95
Excel 2007 Charts, Pictures, Themes, and Styles $74.95

Bundle Price: $199.00
Total Savings: $175.75


Getting Started with Excel 2007

With the introduction of Office Excel 2007, Microsoft has made substantial changes to the user interface of its spreadsheet application. This course will help get you up-to-speed on the new features, and will introduce you to the basic features and functionality of Excel 2007. This will be accomplished through the demonstration of workbook creation and navigation, and worksheet data entry at a user-friendly beginner level.
  • match basic Excel 2007 features with their functions
  • recognize how to use the Help feature in a given scenario
  • create a new Excel workbook in a given scenario
  • open an existing Excel workbook in a given scenario
  • navigate through an Excel workbook
  • enter data in an Excel worksheet in given scenario
  • save a new workbook
  • distinguish between the common file formats used to save work in Excel 2007
  • launch Excel and open an existing workbook
  • enter data in an Excel 2007 workbook in a given scenario
  • save the workbook in a given scenario
  • open a recently used workbook and locate specific values, in a given scenario

Manipulating and Formatting Data and Worksheets in Excel 2007

Excel 2007 provides a number of improved tools and new features that allow you to visually enhance the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores the processing of copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and modifying workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered.
  • copy or move data in given scenarios
  • add, delete, or resize rows and columns in a given scenario
  • modify rows and columns to view specific sections of the worksheet
  • format workbooks in given scenarios
  • insert and delete a worksheet
  • rename a worksheet and format the tab color
  • copy or move worksheets
  • modify cells and workbooks in a given scenario
  • modify worksheets to view specified data
  • copy and move data and worksheets in a given scenario
  • apply basic data formatting
  • format a data range as a table
  • change the position of data in a cell in a given scenario
  • identify the functions of Alignment commands
  • work with tables in Excel 2007
  • format a data range as a table
  • modify an Excel table
  • apply number formats in a given scenario
  • identify the number formatting options available in Excel 2007
  • apply basic conditional formatting rules in a given scenario
  • recognize situations when conditional formatting is suitable
  • format data and apply conditional formatting in given scenarios
  • move data between workbooks and apply formats in a given scenario

Reviewing and Printing in Excel 2007

Excel 2007 simplifies the reviewing and printing processes by centralizing all related features within the various tabs of the Ribbon. The Review tab enables you to quickly access tools for proofing content and adding comments. Using the Page Layout view, you can preview how your worksheets will look when they are printed, and adjust them as needed to achieve professional results. This course explores Excel 2007 reviewing features, such as spellchecking, translating, and using comments. Configuring entire workbooks, spreadsheets, and spreadsheet selections for printing, using the Page Layout view, and printing using the Office button are also covered.
  • use Excel 2007 review tools in a given situation
  • work with comments
  • use the track changes tool
  • review a workbook in a given scenario
  • customize page setup using the Page Layout View
  • adjust page breaks using the Page Break Preview
  • print a worksheet in a given scenario
  • specify page set up options before printing a workbook in a given scenario

Excel 2007 Formulas and Functions

Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.
  • identify the elements of a formula
  • identify the default order in which calculations occur
  • match absolute, relative, mixed, and 3-D references with examples
  • insert an Excel 2007 formula
  • use names to clarify formulas
  • edit formulas
  • work with Excel 2007 formulas in given scenarios
  • use the AutoCalculate feature to perform basic functions
  • use a logical function
  • use a financial function
  • use a date function
  • use functions to perform calculations in Excel 2007
  • use formulas and functions to calculate data in a given scenario

Excel 2007 Charts, Pictures, Themes, and Styles

Enhancements to charting, themes, and styles in Excel 2007 enable you to create attractive and well-organized representations of spreadsheet and workbook data. Charts, themes, styles, and pictures can all be easily inserted and customized from the Ribbon bar. This course demonstrates how to effectively use and customize charts in Excel 2007, and explores available chart types and styles. Using themes and styles to improve presentation, and adding visual elements to workbooks, are also covered.
  • insert an Excel 2007 chart
  • identify the main elements of a chart
  • change Excel 2007 charts
  • change the data range included in the chart
  • move a chart to a new worksheet
  • work with charts in Excel 2007
  • insert illustrations in Excel 2007
  • apply a theme
  • apply a cell style
  • use illustrations to enhance a worksheet
  • use a predefined theme and style to create a professional-looking worksheet
  • use charts, illustrations, themes, and styles to improve the visual impact of your workbook
Register Now
Microsoft Office 2007: Beginning Excel e-learning bundle
  • Course ID:
    252411
  • Duration:
    10 hours
  • Price:
    $199