Microsoft

Excel 2013 Level 1

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

Skills You’ll Get

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

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

Excel 2013 Level 1

$139.99

Buy Now

Related Courses

All Courses