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
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: $379.00
Total Savings: $445.45


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

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 e-learning bundle
  • Course ID:
    271419
  • Duration:
    n/a
  • Price:
    $379