Font size:

Description:

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

Course Price
Using Conditional Formatting, Tables, and Sparklines in Excel 2010 $74.95
Reviewing and Protecting Content in Excel 2010 $74.95
Using Basic Formulas in Excel 2010 $74.95
Using Basic Functions with Excel 2010 $74.95
Inserting Basic Charts in Excel 2010 $74.95
Adding Visuals, Themes, and Styles to Excel 2010 Workbooks $74.95

Bundle Price: $219.00
Total Savings: $230.70


Using Conditional Formatting, Tables, and Sparklines in Excel 2010

Excel 2010 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Tables can be used to logically present data in an easy to read fashion and table styles provide a way to make your workbooks more attractive and professional looking. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines, a new feature of Excel 2010 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. These features – tables, styles, conditional formatting, and sparklines – how to access them and how to use them, are covered in this course.
  • format data as a table
  • sort and filter table data in a given scenario
  • apply conditional formatting rules
  • use sparklines to show data trends
  • format sparklines
  • sort and filter table data
  • use conditional formats to highlight data
  • use sparklines to highlight trends in data

Reviewing and Protecting Content in Excel 2010

Excel 2010 provides easy to use and access tools that allow you to review, proof, and protect the workbooks you create and share. The tools for performing these tasks are grouped conveniently on the Ribbon and include the Spelling, Research, and Thesaurus tools; a Translate tool; tools to insert, edit, and review Comments in a worksheet; and tools for tracking changes and protecting workbooks. The various tasks you can perform with these features are covered in this course, along with how and when you would use these tools.
  • use Excel's proofing tools
  • use the Excel comments feature
  • use track changes in Excel 2010
  • select statements that describe Excel's track changes tool
  • apply worksheet and workbook protection
  • check spelling in worksheet and add notes using comments
  • use Excel's track changes feature
  • protect elements of a worksheet

Using Basic Formulas in Excel 2010

Excel 2010 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the concepts and terminology associated with formulas, and demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise.
  • identify elements of a formula
  • recognize how Excel calculates precedence in a formula
  • recognize examples of reference types used in Excel formulas
  • create and insert formulas
  • use names in formulas
  • correct common error values
  • edit formulas
  • create a formula
  • define a name reference and use it in a formula
  • copy and paste a formula between cells

Using Basic Functions with Excel 2010

One of the great features of Excel 2010 is its ability to perform a wide variety of functions to make your use of Excel 2010 easier and more fun. Functions are inbuilt formulas that save you time by allowing you to choose one that suits your needs rather than having to create a complex formula from scratch. This course introduces you to the changes made to functions in Excel 2010, including improved function accuracy and consistency as well as the changes made to some function names that make them more intuitive. It describes the useful feature of Excel's status bar that automatically displays basic calculations as well as the Function Library, which groups useful functions. The most common use of functions, calculating basic financial, logical, date and time data is also covered.
  • identify the characteristics of functions in Excel
  • perform basic calculations using Excel's most commonly used functions
  • use financial functions
  • use date and time functions
  • use logical functions to help perform calculations on worksheet data
  • perform basic calculations
  • use a financial function to determine the monthly repayment of a loan
  • use a date function and a logical function

Inserting Basic Charts in Excel 2010

Using the charts feature in Excel 2010, you can create attractive and well-organized representations of worksheet and workbook data. Charts can be easily inserted and customized from the Charts group on the Insert tab of the Ribbon. This course demonstrates how to effectively use and customize charts in Excel 2010; it explores available chart types and the best use of each type; and shows how to change the different elements of a chart to provide an effective visualization of your data.
  • recognize when to use different Excel charts
  • insert a chart
  • identify the elements of an Excel chart
  • update an existing Excel chart's style, layout, or location
  • change the data range on which a chart is based
  • insert a chart
  • update a chart's type, layout, and style
  • update the chart's source data and change chart's location

Adding Visuals, Themes, and Styles to Excel 2010 Workbooks

Excel has more than just charts to offer in the way of visual presentation. Nonchart-related graphic tools such as Shapes, SmartArt, WordArt, ClipArt, and Screenshots are all ways to enhance the visual impact of documents that tend to be dominated by dry numbers and text. This course focuses on these and other graphic elements that can be added to Excel 2010 spreadsheets. This course also introduces ways to change the themes and styles offered by Excel 2010.
  • insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
  • use Excel's image editing tools to format illustrations
  • insert a screenshot into a workbook
  • add text features to a worksheet
  • use cell styles to apply consistent formatting
  • apply an Excel theme to a worksheet
  • add a picture and clip art to a worksheet
  • add a screenshot to a worksheet
  • apply a theme and a cell style
Register Now
Microsoft Office 2010: Beginning Excel Part 2 e-learning bundle
  • Course ID:
    252386
  • Duration:
    6 hours
  • Price:
    $219