Font size:

Description:

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

Course Price
Creating and Customizing Visual Elements in Excel 2013 $74.95
Customizing Options and Views in Excel 2013 $74.95
Manipulating Data in Excel 2013 $74.95
Data Search, Data Validation, and Macros in Excel 2013 $74.95

Bundle Price: $169.00
Total Savings: $130.80


Creating and Customizing Visual Elements in Excel 2013

Excel has more than just charts to offer in the way of visual presentation. Graphic tools such as pictures, shapes, SmartArt, WordArt, and screenshots are all ways to enhance the visual impact of documents that tend to be dominated by numbers and text. The course shows how to insert and edit shapes, text boxes, and pictures. We'll see how to add a SmartArt graphic and we'll demonstrate how to add watermarks to your spreadsheets. We'll also look at how you can use workbook themes to enhance the presentation of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
  • add text boxes and shapes in Excel 2013
  • choose how to add a text box and shape in Excel 2013
  • insert a picture in Excel 2013
  • insert a SmartArt Graphic in Excel 2013
  • decide how to add and edit pictures and SmartArt in Excel 2013
  • apply a watermark in Excel 2013
  • change the workbook theme in Excel 2013
  • decide how to add a watermark and create a theme in Excel 2013

Customizing Options and Views in Excel 2013

Excel 2013 allows you to customize options and views to create a personalized environment. You can change how data displays by hiding and unhiding rows and columns; enable Show options; and also change the zoom level. You can switch workbook views from Normal to Page Layout, to Page Break Preview, or create custom views. This course will also cover the ways to arrange windows including Arrange All, Freeze Panes, Split, and View Side by Side. It will also show you how to change the defaults for creating new workbooks and personalize the Ribbon and Quick Access Toolbar. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
  • hide and show worksheet data and elements in Excel 2013
  • change how worksheet data displays in Excel 2013
  • create a custom worksheet view
  • create appropriate worksheet views in Excel 2013
  • change how worksheet windows display in Excel 2013
  • arrange worksheet windows in Excel 2013
  • change default options for new workbooks in Excel 2013
  • personalize the ribbon and quick access toolbar in Excel 2013
  • customize your default options in Excel 2013

Manipulating Data in Excel 2013

Excel 2013 provides multiple features for organizing and managing data, including sorting and filtering tools that are essential 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 Data tab allows you to present your data in a logical and easy to understand manner. This course explores organizing data in Excel 2013 using the built-in features. It also covers converting text to columns for easy of splitting text. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
  • sort data in Excel 2013
  • group data in Excel 2013
  • decide how to sort and group data in Excel 2013
  • filter data in Excel 2013
  • choose how to filter data in Excel 2013
  • convert text to columns in Excel 2013
  • decide how to convert text to columns in Excel 2013

Data Search, Data Validation, and Macros in Excel 2013

Excel 2013 provides time-saving tools to manage data, validate data, and automate repetitive tasks. You can import files, and add and adjust columns and rows, as well as edit workbook properties. Find and replace allows users to find and replace data, in a specific format, or within the worksheet or workbook. It also allows you to use wildcard characters to customize the search. Data validation can be applied to a cell or range to restrict the data being entered. You can put upper and lower limits, restrict the number of characters, put items in a list, or validate against other cells. You can also add error alerts and identify invalid data. This course will also introduce you to macros in Excel and show you how to automate repetitive tasks to make working in Excel easier. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
  • edit workbook properties in Excel 2013
  • change the row height and column width in Excel 2013
  • find and replace data in Excel 2013
  • decide how to find and replace data in Excel 2013
  • add basic data validation to a worksheet in Excel 2013
  • use advanced data validation in Excel 2013
  • decide how to use data validation in Excel 2013
  • run a macro in Excel 2013
  • create a macro in Excel 2013
  • decide how to record a macro in Excel 2013 and make it available on Quick Access Toolbar and the ribbon
Register Now
Microsoft Office 2013: Advanced Excel e-learning bundle
  • Course ID:
    252373
  • Duration:
    4 hours
  • Price:
    $169