Microsoft Excel 2013 Introduction Training Course

12/11/2016

Microsoft Excel 2013 Introduction Training Course – Overview

On this Microsoft Excel 2013 introduction training course, attendees will learn how to create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print functional Microsoft Excel  worksheets.

Target Audience: Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course in the new interface.

Microsoft Excel Introduction – ObjectivesMicrosoft Excel

  • Create basic worksheets using Microsoft Excel 2013.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn how to use handy features new in 2013.

Outline

  • Creating a Microsoft Excel Workbook
    • Starting Microsoft Excel
    • Creating a Workbook
    • Saving a Workbook
    • Adding and Deleting Worksheets
    • Copying and Moving Worksheets
    • Changing the Order of Worksheets
  • The Ribbon
    • Tabs
    • Groups
    • Commands
  • The Backstage View (The File Menu)
    • Introduction to the Backstage View
    • Opening a Workbook
    • New Workbooks and Excel Templates
    • Adding Your Name to Microsoft Excel
    • Managing Workbook Versions
  • The Quick Access Toolbar
    • Adding Common Commands
    • Adding Additional Commands with the Customize Dialog Box
    • Adding Ribbon Commands or Groups
  • Entering Data in Microsoft Excel Worksheets
    • Expand Data across Columns
    • Adding and Deleting Cells
    • Adding an Outline
    • Using AutoComplete
    • Entering Numbers and Dates
    • Using the Fill Handle
  • Formatting Microsoft Excel Worksheets
    • Selecting Ranges of Cells
    • Hiding Worksheets
    • Adding Themes to Workbooks
    • Adding a Watermark
    • The Alignment Group
    • The Number Group
  • Using Formulas in Microsoft Excel
    • Math Operators and the Order of Operations
    • Entering Formulas
    • AutoSum (and Other Common Auto-Formulas)
    • Copying Formulas and Functions
    • Relative, Absolute, and Mixed Cell References
  • Working with Rows and Columns
    • Inserting Rows and Columns
    • Deleting Rows and Columns
    • Transposing Rows and Columns
    • Setting Row Height and Column Width
    • Hiding and Unhiding Rows and Columns
    • Freezing Panes
  • Editing Worksheets
    • Find
    • Find and Replace
    • Managing Comments
  • Finalizing Microsoft Excel Worksheets
    • Setting Margins
    • Setting Page Orientation
    • Setting the Print Area
    • Print Scaling (Fit Sheet on One Page)
    • Printing Headings on Each Page/Repeating Headers and Footers
  • Microsoft Excel Features that are new in 2013
    • One Workbook Per Window Feature
    • Using Flash Fill

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh