Font size:

Description:

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

Course Price
Creating Workbooks, Worksheets, and Data in Excel 2013 $74.95
Saving and Printing Data in Excel 2013 $74.95
Formatting Cells and Worksheets in Excel 2013 $74.95
Formatting Data in Excel 2013 $74.95
Presenting Data using Conditional Formatting and Sparklines in Excel 2013 $74.95
Performing Calculations Using Functions in Excel 2013 $74.95
Presenting Data in Tables and Charts in Excel 2013 $74.95

Bundle Price: $239.00
Total Savings: $285.65


Creating Workbooks, Worksheets, and Data in Excel 2013

Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. 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.
  • create a new workbook and open a workbook in Excel 2013
  • decide how to create a new workbook in Excel 2013
  • move around Excel and enter data
  • cut, copy, and paste in Excel 2013
  • edit data in Excel 2013
  • delete or hide a worksheet
  • organize and modify worksheets in Excel 2013
  • choose the best way to organize and modify worksheets in Excel 2013

Saving and Printing Data in Excel 2013

Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. 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
  • save a workbook in Excel 2013
  • change the default save options in Excel 2013
  • recover a workbook in Excel 2013
  • choose how to save a file and recover an unsaved file
  • print a workbook
  • configure the page layout in Excel 2013
  • decide how to print a workbook in Excel 2013

Formatting Cells and Worksheets in Excel 2013

Excel 2013 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 formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. 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.
  • change font formatting in Excel 2013
  • apply borders and fills and create a cell style
  • copy formatting with Format Painter in Excel 2013
  • choose how to format data in Excel 2013
  • change the alignment, indentation, and orientation of data in Excel 2013
  • merge cells and wrap text in Excel 2013
  • decide how to align data in Excel 2013

Formatting Data in Excel 2013

Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. 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.
  • format numbers in Excel 2013
  • decide how to format numbers in Excel 2013.
  • use Auto Fill to copy and fill a series in Excel 2013
  • extract or add data using Flash Fill in Excel 2013
  • choose how to automatically populate cells in Excel 2013
  • create and modify a hyperlink in an Excel 2013 workbook
  • decide how to add hyperlinks to a worksheet in Excel 2013

Presenting Data using Conditional Formatting and Sparklines in Excel 2013

Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. 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 are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. 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.
  • apply conditional formatting to a worksheet in Excel 2013
  • decide how to apply conditional formatting to a worksheet in Excel 2013
  • create custom conditional formatting rules in Excel 2013
  • choose the best way to customize conditional formatting rules in Excel 2013
  • create a basic sparkline in Excel 2013
  • create an advanced sparkline in Excel 2013
  • decide how to create and edit sparklines in Excel 2013

Performing Calculations Using Functions in Excel 2013

Excel 2013 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 basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. 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.
  • create a basic formula in Excel 2013
  • reference cells in formulas in Excel 2013
  • create a named range in Excel 2013
  • reference cells and create a named range in Excel 2013
  • use basic functions in Excel 2013
  • decide the best way to use basic formulas and functions in Excel 2013
  • create formulas using basic logical functions in Excel 2013
  • create an IF-type formula in Excel 2013
  • decide how to create IF-type functions and nested formulas in Excel 2013

Presenting Data in Tables and Charts in Excel 2013

Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization 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.
  • create a table in Excel 2013
  • format a table and customize a table style in Excel 2013
  • decide how to create a table in Excel 2013
  • create a chart in Excel 2013
  • add elements to a chart in Excel 2013
  • change the appearance of a chart in Excel 2013
  • decide how to create a chart in Excel 2013
Register Now
Microsoft Office 2013: Beginning Excel e-learning bundle
  • Course ID:
    252376
  • Duration:
    7 hours
  • Price:
    $239