Microsoft Excel 2013 Power User - 10 pack - Online

Overview

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. 

Objectives

• 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
• Organise and modify worksheets in Excel 2013
• Choose the best way to organise and modify worksheets in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

Objectives

• Add text boxes and shapes in Excel 2013
• Add a text box and shape in Excel 2013
• Insert a picture in Excel 2013
• Insert a SmartArt Graphic in Excel 2013
• Add and edit pictures and SmartArt in Excel 2013
• Apply a watermark in Excel 2013
• Change the workbook theme in Excel 2013
• Add a watermark and create a theme in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

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. 

Objectives

• 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
• Personalise the ribbon and quick access toolbar in Excel 2013
• Customise your default options in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

Objectives

• Create a table in Excel 2013
• Format a table and customise 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

Audience

Overview

Objectives

• Consolidate data and merge workbooks in Excel 2013
• Decide how to consolidate data in Excel 2013
• Choose how to merge workbooks in Excel 2013
• Use Track Changes in Excel 2013
• Add and edit comments in Excel 2013
• Spell check a workbook in Excel 2013
• Decide how to use comments and track changes in Excel 2013
• Protect sheets and workbooks in Excel 2013
• Choose how to protect workbooks in Excel 2013

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Expert level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

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.

Objectives

• 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

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

Objectives

• 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

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

Objectives

• 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

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.

Overview

Objectives

Audience

Overview

Objectives

• 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

Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification.