Syllabus Excel 2013 Advance

Excel 2013 Advance
Duration : 1 Days
Description
This course introduces Microsoft Excel 2013 users to the advanced features of the software
application. Participants will learn how to sort and manage data in lists, filter data, use outlines
on worksheets, use text and conditional functions, use lookup and database functions, and work
with PivotTables. In-class exercises will involve use of data tables and scenarios to make
projections about data and use Goal Seek and Solver to analyze data. Students will also learn how
to audit worksheets, protect worksheets and workbooks, create and use macros and templates,
import and export information and documents, and use Excel workgroup features.
Prerequisites
• Excel 2013 Introduction
• Excel 2013 Intermediate
Performance-Based Objectives
Lesson objectives help students become comfortable with the course, and also provide a means
to evaluate learning. Upon successful completion of this course, students will be able to:
• Sort and manage data in lists.
• Filter data.
• Use outlines on worksheets.
• Use Text and Conditional Functions.
• Use lookup and database functions.
• Use PivotTables to display and chart data.
• Use data tables and scenarios to make projections about data.
• Use Goal Seek and Solver to analyze data.
• Audit worksheets.
• Protect worksheets and workbooks.
• Create and use macros.
• Use and create templates.
• Import and export information and documents.
• Use workgroup features.
Outline
Working with Data in Lists Displaying an Input Message
Understanding Data Lists Displaying an Error Alert
Sorting Data Locating Invalid Data
Creating Subtotals Filtering Data
Using Data Validation Filtering Data
Restricting Cells to Numbers, Dates, or Using Filter and Removing Filter
Times Creating a Custom Filter
Restricting Cells to a List of Values Filter Data by Color
Excel 2013 Advance
Using Search Box Creating and Managing Scenarios

Working with the Advanced Filter Creating Scenarios
Setting Up the Criteria Range Displaying Scenarios
Examples of Criteria Ranges Editing and Deleting a Scenario
Filtering Data with the Advanced Filter Creating a Summary of Scenario Results
Displaying All Data Analyzing Data
Removing Duplicate Data Working with the Goal Seek Feature
Using Outlines Working with Solver
Creating an Outline Auditing Worksheets
Hiding and Displaying Outline Levels Finding Referenced Cells
Hiding & Displaying Outline Symbols Finding Formulas that Refer to a Cell
Using Text and Conditional Functions Watching Formula
Using Text Functions Evaluating Formula
Using Conditional Functions Protecting Worksheets and Workbooks
Using Lookup and Database Functions Protecting Workbook Access and Contents
Looking Up Values in a Table Working with Macros
Working with Database Functions Working with Macros
Counting the Occurrences of a Value Recording and Running Macros
Finding the Sum, Average of Specific Managing Macros
Records Editing, Renaming, and Deleting Macros
Working with PivotTables Assigning Macros
Creating PivotTables Working with Templates
Adding Fields to a PivotTable Using, Creating, and Editing Templates
Removing Fields from a PivotTable Importing and Exporting Information
Editing PivotTables Importing and Exporting Documents
Updating Information in a PivotTable Importing Text Files
Changing the Layout of a PivotTable Exporting Workbooks
Selecting PivotTable Data Pasting Information from Other Programs
Modifying PivotTables Using Excel in a Workgroup
Grouping PivotTable Data Working with Cell Comments
Hiding and Showing Source Details Adding Comments to Cells
Understanding Calculated Fields Reading, Editing, Formatting and Deleting
Using Slicers Comments
Adding Report Filter/Page Fields Sharing Workbooks
Displaying a Specific Page Distributing Shared Workbooks
Displaying Page Fields on Separate Sheets Merging Multiple Copies of a Shared
Creating PivotCharts Workbook
Making Projections About Data Tracking Changes to Workbooks
Solving What-If Problems Accepting or Rejecting Changes
Using Data Tables Turning Off Workbook Sharing
Working with One-Input Data Tables
Working with Two-Input Data Tables

Syllabus Excel 2013 Advance

Uploaded by

Copyright:

Available Formats

Syllabus Excel 2013 Advance

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Syllabus Excel 2013 Advance

Uploaded by

Copyright:

Available Formats

Excel 2013 Advance

Using Search Box Creating and Managing Scenarios

You might also like