Font size:

Description:

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

Course Price
Customizing Visual Elements in Excel 2010 $74.95
Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010 $74.95
Organizing Data and Objects in Excel 2010 $74.95
Verifying Excel 2010 Data and Formulas $74.95

Bundle Price: $169.00
Total Savings: $130.80


Customizing Visual Elements in Excel 2010

Adding visual elements to Excel worksheets can help to enhance what can sometimes be dry facts and figures, making it easier to hold the attention of the intended audience. A balance needs to be struck, however, between enhancing and overwhelming when it comes to adding graphics and colors to your Excel workbooks. Excel 2010 provides you with a number of basic and advanced techniques for customizing common elements such as charts, themes, cell styles, and graphics. This course describes many of these techniques and shows you how to implement them to their best effect.
  • manually adjust a chart's layout and formatting
  • save and apply a chart template
  • manually format illustrations using the Format object dialog box
  • customize and save Excel themes and styles
  • save an Excel template and apply to a new workbook
  • adjust individual chart elements
  • format Excel illustrations
  • create a new cell style
  • create an Excel theme

Workbook Settings, Conditional Formatting, and Number Formats in Excel 2010

You can customize the look and feel of workbooks and the program's functionality and efficiency using Excel 2010's numerous features and tools. You can modify existing themes and styles to meet business needs, or you can create custom themes and styles to further enhance data presentation. Custom number formats allow you even more control over the presentation and usefulness of your workbooks and conditional formatting gives you the power to apply individual formatting based on custom rules that meet your specific needs. This course explores some of the more advanced ways that you can enhance your workbooks and data using Excel 2010's powerful customization features.
  • customize workbook settings using Excel Options
  • change workbook properties
  • create a custom number format
  • recognize how to alter code strings to create custom number formats
  • create a conditional format based on a new formatting rule
  • manage conditional formatting rules
  • customize workbook settings and the Quick Access Toolbar
  • create and apply a custom number format
  • create a new conditional formatting rule

Organizing Data and Objects in Excel 2010

Excel 2010 provides multiple features for organizing and managing data, including sorting and filtering tools that are integral to data analysis. Using data organization features, you can sort, filter, and group and outline data so that you can focus on its key parts. Properly arranged data using the commands in the Arrange group allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2010 using the built-in features. It also covers arranging objects for better viewing as well as the use of hyperlinks to organize data.
  • sort data in more than one column or row
  • create a custom filter
  • outline data using the Subtotal, Auto Outline, or Group commands
  • arrange objects on a worksheet page
  • recognize how you can arrange data to fit a specified page layout for printing
  • create a hyperlink
  • modify hyperlinks
  • sort and filter data
  • create an outline so you can group and summarize data
  • arrange objects on a page
  • create a hyperlink from a worksheet to a web page

Verifying Excel 2010 Data and Formulas

Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excel's data validation tools you can restrict the types of data that can be input to your workbooks – preventing data entry errors that could otherwise occur. This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.
  • use Excel's formula auditing tools to evaluate and correct formulas
  • use the Watch Window to inspect, audit, or confirm formula calculations and results
  • use data tools to convert text to columns and remove duplicates
  • add data validation to worksheet cells
  • list the different things you can use data validation for
  • use error checking to identify a formula error
  • separate text in one column into two columns
  • restrict data entry in specific cells
Register Now
Microsoft Office 2010: Advanced Excel Part 1 e-learning bundle
  • Course ID:
    252390
  • Duration:
    4 hours
  • Price:
    $169