Excel 2013 Complete

(77-420-30Bird-All) / ISBN : 978-1-64459-095-9
Lessons
Lab
Get A Free Trial

Skills You’ll Get

The MOS: Excel 2013 is a standalone certification from Microsoft with the exam code 77-420. This certification is targeted at professionals who can create and manage worksheets & workbooks with Microsoft Office Excel 2013 and may have experience with previous versions of Microsoft Office Excel. They can also perform tasks like creating tables, applying formulas and functions, creating charts & objects. This exam is an upgrade of Microsoft Office Excel 2010.
Download Course Outline

1

Introduction

2

Fundamentals

  • Getting around
  • Workbook basics
  • Summary: Fundamentals
3

Creating worksheets

  • Entering data
  • Formulas
  • Functions
  • Moving and copying data
  • Reference types
  • Summary: Creating worksheets
4

Formatting

  • Text formatting
  • Number formatting
  • Alignment
  • Borders and highlighting
  • Styles and themes
  • Summary: Formatting
5

Manipulating Data

  • Data entry shortcuts
  • Paste options
  • Inserting, deleting, and hiding
  • Summary: Manipulating data
6

Charts

  • Creating charts
  • Chart types and elements
  • Summary: Charts
7

Output

  • Managing worksheet windows
  • Printing worksheets
  • Sharing workbooks
  • Summary: Output
8

Settings and templates

  • Workbook options and properties
  • Templates
  • Summary: Settings and templates
9

Introduction

10

Managing workbooks

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

Named ranges

  • Using names in formulas
  • Summary: Named Ranges
12

Tables

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

Summarizing data

  • Consolidation
  • Subtotals
  • Summary: Summarizing data
14

PivotTables

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

Presentation features

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

Advanced charts

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

Collaboration

  • Permissions
  • Shared workbooks
  • Summary: Collaboration
18

Introduction

19

Logical and Lookup Functions

  • Module A: Decision-making functions
  • Module B: Lookup and reference functions
  • Summary: Logical and lookup functions
20

Advanced Formulas

  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays
  • Summary: Advanced formulas
21

Special Functions

  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions
  • Summary: Special functions
22

Importing and Exporting

  • Module A: External data
  • Module B: Exporting data
  • Summary: Importing and exporting
23

Analysis

  • Module A: What-if analysis
  • Module B: The Analysis Toolpak
  • Summary: Analysis
24

Macros and Forms

  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms
  • Summary: Macros and forms
25

Internationalization and Accessibility

  • Preparing workbooks for internationalization and accessibility
  • Summary: Internationalization and accessibility

1

Fundamentals

  • Using the Go To feature
  • Finding information in a workbook
  • Entering data in a cell
  • Saving and closing a workbook
2

Creating worksheets

  • Creating a new workbook and entering text
  • Entering numbers in a workbook
  • Performing calculations with formulas
  • Using the AVERAGE function
  • Using functions to calculate sums and averages
  • Inserting a function
  • Using AutoSum to enter SUM() and AVERAGE()
  • Using the Cut and Paste functions
  • Moving data in a worksheet
  • Copying data in a worksheet
  • Copying a formula in a worksheet
  • Changing a relative reference to an absolute reference
  • Experimenting with the limitations of relative references
  • Using an absolute reference in a formula
  • Using a mixed reference in a formula
3

Formatting

  • Formatting labels in a worksheet
  • Formatting currency and percentages
  • Experimenting with date formats
  • Unmerging previously merged cells
  • Merging and centering cell text
  • Aligning text in a worksheet
  • Wrapping text in a notes column
  • Merging headings and note cells
  • Formatting a worksheet
  • Applying borders and highlighting to a worksheet
  • Applying a cell style to a cell range
  • Applying a Table Style
  • Applying a theme to a table
  • Applying cell and table styles to a worksheet
4

Manipulating Data

  • Adding a custom series for the Fill Series option
  • Using Fill to quickly complete a worksheet
  • Replacing a name with another name
  • Copying format of one range to another
  • Painting a format from one range onto another
  • Pasting only formats or values
  • Pasting links to data on another worksheet
  • Adding and hiding a column and a row
  • Inserting and deleting rows, columns, and ranges
  • Hiding and unhiding sensitive information
5

Charts

  • Increasing chart length and breadth
  • Creating a simple line chart
  • Creating a pie chart and changing style and layout
  • Creating a column chart and switching rows and columns
  • Controlling the elements of a line chart
  • Applying a built-in style on a chart
6

Output

  • Split a worksheet horizontally
  • Freezing panes in a worksheet
  • Printing an individual worksheet
  • Setting margins for printing
  • Configuring Page Setup for printing
  • Printing repeated header rows
  • Specifying a print area and checking its layout
  • Adding a header and footer
  • Inserting a watermark
  • Saving a file in PDF format
7

Settings and templates

  • Changing default display options
  • Setting Excel options
  • Setting properties for a workbook
  • Removing document properties and personal information from a workbook
  • Creating a workbook using a template
  • Saving a template file
8

Managing workbooks

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

Tables

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

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
11

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
12

Advanced charts

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

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
14

Logical and Lookup Functions

  • Using a nested function
  • Using the SUMIF function
  • Using multiple criteria with the SUMIFS function
  • Using the VLOOKUP function
  • Using the HLOOKUP function
15

Advanced Formulas

  • Showing cell dependency
  • Evaluating and correcting a formula
  • Enabling the error checking rules for formulas
16

Special Functions

  • Printing the current date and time
  • Printing the current date
  • Concatenating text
  • Using the MIN and MAX functions
17

Analysis

  • Adding watch options for cell values
  • Using the Goal Seek feature
18

Internationalization and Accessibility

  • Checking accessibility issues

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Microsoft certifications have no expiration. The certification holder is certified for life unless the vendor changes its policy.

USD 100

Pricing and taxes may vary from country to country.

Certiport

Active Screen, Best Answer, Build List, Hot Area, Multiple Choice, Drag-and Drop, and so on

The exam contains 40-60 questions.

50 minutes

700

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  • A two-day waiting period will be imposed for each subsequent exam retake.
  • There is no annual limit on the number of attempts on the same exam.
  • If a candidate achieves a passing score on an Office exam, the candidate may take it again.

There are no defined pre-requisites for this certification.

Know more about the 77-420

Excel 2013 Complete

$139.99

Buy Now