Microsoft Excel Excel 2013: An Introduction

Excel 2013: An Introduction

10.00 10.00
$10.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Duration: 5 
  • Language: English
  • Difficulty: Beginner
  • Audience: Microsoft Excel users

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

Microsoft Excel 2013 is a powerful spreadsheet application that is perfect for maintaining long lists of data, budgets, sales figures and other data. In this online series of training tutorials, we'll show you how to navigate through the basics of Excel and use some new features including Skycloud -- which allows you to share and store files in a location where you can access them with any computer that has Excel. Additionally, you'll learn how to create tables, move information around with ease, and use formulas that can calculate the totals of everything from a monthly budget to a loan payment. Microsoft 2013 has been redesigned and several common functions are now much easier to use. This training series will make sure you get the most out of the program.
 

Topics Covered

Basics
  • Introducing the Start screen
  • Introducing the new user interface
  • Signing into and using your Microsoft account
  • Introducing and using Apps for Office
  • Introducing the Formatting task pane
  • Using Backstage view
  • Understanding a worksheet and entering information into a cell
  • Changing the default number of worksheets and the cell movement
  • Using Save and Save As
  • Sharing your files
  • Working together on a file
  • Moving with the keyboard

Customization
  • Changing the Office Background and/or Office Theme
  • Using and minimizing the Ribbon
  • Changing the Ribbon display options
  • Using the Quick Access toolbar
  • Customizing the Quick Access toolbar
  • Adding/using the Touch/Mouse Mode
  • Resetting the Quick Access toolbar
  • Customizing the Ribbon
  • Adding a new tab to the Ribbon
  • Resetting Ribbon customizations
  • Importing/exporting ribbon customizations
  • Using Keytips

Controlling the Worksheet View
  • Zooming in and out of a worksheet
  • Viewing a worksheet in multiple windows
  • Viewing workbooks side by side
  • Splitting the worksheet window
  • Freezing and unfreezing panes
  • Monitoring cells with the Watch Window
  • Viewing using full screen
  • Creating custom views

Working with Cells
  • Using AutoComplete
  • Editing a cell
  • Using spell check
  • Selecting cell ranges
  • Entering values in a cell range using AutoFill
  • Using Flash Fill
  • Using Cut, Copy, and Paste
  • Using Paste Preview
  • Using Paste Special
  • Using the clipboard
  • Using Drag and Drop editing
  • Using Undo and Redo
  • Using the Clear command

Sorting and Filtering
  • Sorting data in a worksheet
  • Sorting by columns or multiple criteria
  • Filtering data in a worksheet using AutoFilter
  • Clearing a filter in a worksheet
  • Creating and/or statements using AutoFilter
  • Creating a criteria range
  • Creating and/or statements using the criteria range

Formulas and Functions
  • Using AutoCalculate
  • Using AutoSum
  • Using the Quick Analysis tool
  • Creating formulas
  • Using functions and the Function Wizard
  • Editing formulas
  • Checking formulas for errors
  • Using Relative Cell Referencing
  • Understanding Absolute Cell References
  • Creating an Absolute Cell Reference

Formatting Cells
  • Formatting numbers using the Ribbon
  • Formatting text using the Ribbon
  • Using the Alignment and Indentation commands
  • Rotating information in a cell
  • Wrapping text in a cell
  • Using the Merge and Center command
  • Using the Borders command
  • Drawing cell borders
  • Formatting cells using the Format Cells dialog box
  • Using the Format Painter command

Working with Columns and Rows
  • Selecting columns and rows
  • Changing column width
  • Changing row height
  • Hiding and unhiding columns and rows
  • Inserting columns
  • Inserting rows
  • Deleting columns and rows
  • Inserting and deleting cells

Outlines
  • Creating an outline automatically
  • Creating a manual outline
  • Displaying levels in an outline
  • Hiding the outline symbols
  • Clearing an outline
  • Adding subtotals to a worksheet

Styles, Themes, and Tables
  • Using cell styles
  • Creating a custom cell style by example
  • Creating a custom cell style
  • Deleting a custom cell style
  • Modifying a custom cell style
  • Merging custom cell styles
  • Using themes
  • Customizing themes
  • Formatting as a table
  • Creating a custom table style
  • Deleting a custom table style

Workbook Views and Page Setup
  • Using Normal view
  • Using Page Layout view
  • Using Page Break preview
  • Using the Page Layout tab
  • Changing the margins
  • Changing the page orientation and paper size
  • Setting manual page breaks
  • Setting print titles
  • Creating headers and footers
  • Using the Page Setup dialog box

Printing
  • Using Print and Print Preview
  • Using Share
  • Using Export
  • Setting print areas
  • Adding to and clearing print areas

Custom Number Formats
  • Formatting numbers automatically
  • Understanding custom number formatting
  • Creating a custom number format
  • Creating custom date and time formats
  • Hiding the contents of a cell using a custom format
  • Deleting a custom format

Knowledge Assessments

  • Basics
  • Customization
  • Controlling the Worksheet View
  • Working with Cells
  • Sorting and Filtering
  • Formulas and Functions
  • Formatting Cells
  • Working with Columns and Rows
  • Outlines
  • Styles, Themes, and Tables
  • Workbook Views and Page Setup
  • Printing

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.