Microsoft

Excel 2013 Level 2

(77-420-L2-30bird)
Lessons
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction

2

Managing workbooks

  • Managing worksheets
  • Customizing Excel
  • Summary: Managing workbooks
3

Named ranges

  • Using names in formulas
  • Summary: Named Ranges
4

Tables

  • Sorting
  • Filtering tables
  • Validation
  • Transposing data
  • Summary: Tables
5

Summarizing data

  • Consolidation
  • Subtotals
  • Summary: Summarizing data
6

PivotTables

  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts
  • Relationships
  • Summary: PivotTables
7

Presentation features

  • Conditional formats
  • Custom Formats
  • Graphics
  • Summary: Presentation features
8

Advanced charts

  • Special chart types
  • Sparklines
  • Quick Analysis
  • Summary: Advanced charts
9

Collaboration

  • Permissions
  • Shared workbooks
  • Summary: Collaboration

1

Managing workbooks

  • Insert, rename, and hide a worksheet
  • Moving a worksheet
  • Inserting a hyperlink
  • Organizing worksheets
2

Tables

  • Sorting a table
  • Filtering data
  • Deleting duplicate rows and sorting the table
  • Implementing data validation
  • Transposing a cell range
3

PivotTables

  • Creating a pivot table
  • Putting a pivot table on a certain location
  • Adding a column to a pivot table
  • Creating a pivot chart and a pivot table
4

Presentation features

  • Applying conditional formatting
  • Using icons in conditional formatting
  • Applying conditional formatting on the cells
  • Banding rows by conditional formatting
  • Applying a custom date format
  • Customizing date format
5

Advanced charts

  • Adding an exponential trendline to a chart
  • Using Sparklines to illustrate data trends
  • Changing the Sparkline type to Sparkline Style Colorful #6
6

Collaboration

  • Password protecting a workbook
  • Allowing editing on limited cells in a protected workbook
  • Password protecting a workbook structure and worksheet
  • You need to see all the comments on a worksheet one-by-one.
  • Editing a comment
  • Enabling Track Changes
  • Viewing all changes made in a workbook
  • Tracking the changes made by other users
  • Listing tracked changes in a separate list

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Excel 2013 Level 2

$139.99

Buy Now

Related Courses

All Courses