Microsoft Excel 2013

×

Status message

Finding your location...
Microsoft Excel 2013

Course Hours: 
25
Instructor: 
Course Type: 
Instructor Led - 4 Weeks Long
  • Description
  • Objectives
  • Outline
  • Materials
  • Approvals
  • System Requirements

Microsoft Office Excel 2013 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. You will learn how to print spreadsheets, add hyperlinks, save worksheets as web pages, and more!

* You have 4 weeks to complete this course from date of your enrollment.

** Course Subject to Change.

After completing this course, you should be able to:

  • Recall the basic features of Microsoft Excel 2013
  • Recognize how to manage and organize worksheets, data and reports
  • Identify easy solutions for creating professional looking charts and working with media and data lists
  • Recognize Excel features that will increase productivity

Microsoft Excel 2013 Module 1
Excel Basics

Module one introduces you to the basic features that Microsoft Excel 2013 provides. You’ll become familiar with user Ribbon interface, commonly used tabs and command buttons, as well as how to customize the Quick Access toolbar. Creating a basic spreadsheet, how to enter data and create cells will also be covered. You’ll also learn the importance of creating custom headers and footers to keep information organized.

  • Ribbon User Interface
  • Creating a Spreadsheet
  • Cell Formatting
  • Page Setup
  • Headers and Footers

Microsoft Excel 2013 Module 2
Managing Worksheets and Data

Module two focuses on organization and managing worksheets, data and reports. You will learn how to name your cells and formulas, attach comments and control when you recalculate a worksheet. Filtering and data analysis tools are also introduced as an easy way to keep your information organized.  

  • Maintaining the Worksheet
  • Naming Formulas
  • Summary Reports
  • Formatting Tables
  • Filtering Reports, Columns and Rows

Microsoft Excel 2013 Module 3
Working with Media and Data Lists

Module three provides you with easy solutions for creating professional looking charts with just a few clicks. You will be introduced to the steps for adding graphics, inserting clip art, WordArt and SmartArt and how to represent data visually. Learning how to move and embed charts, as well as applying filters and various styles will enhance your data lists and help with organization.

  • Creating Charts
  • Adding Graphics
  • Using Custom Filters
  • Sorting on Multiple Fields
  • Moving and Resizing Charts

Microsoft Excel 2013 Module 4
Excel Features

Module four addresses add-ins for automating Excel 2013 to increase productivity, as well as tips and tricks for formatting worksheets efficiently. You will become familiar with how to add hyperlinks to workbooks, Office documents or e-mail and how to automate frequently-used formulas with macros. Various ways of sharing your worksheets on the internet and through web applications is also covered.

  • Excel Add-Ins
  • Linking Spreadsheets
  • Top Ten Beginner Basics
  • Ten Commandments of Excel 2013
  • Adding Hyperlinks

Ed4Career is committed to being both environmentally conscious and making it easier for you to study! We’re making your education mobile! All of our textbooks are now provided as eTextbooks. You can access them on your laptop, tablet, or mobile device and can study anytime, anywhere.

The move away from physical books to eTextbooks means you get the latest, most up-to-date version available. This also makes your training more accessible, so you can study anywhere you have your phone or tablet. The best part is that all materials are included in your training cost so there are NO extra fees for books!

 International Association for Continuing Education and Training (IACET)

Ed4Career has been approved as an Accredited Provider by the International Association for Continuing Education and Training (IACET). In obtaining this accreditation, Ed4Career has demonstrated that it complies with the ANSI/IACET Standard which is recognized internationally as a standard of good practice. As a result of the Accredited Provider status, Ed4Career is authorized to offer IACET CEUs for courses and programs that qualify under the ANSI/IACET Standard.

The Continuing Education Unit (CEU) was created by IACET as a measurement of continuing education. One (1) IACET CEU is equal to ten (10) contact hours of participation in an organized continuing education experience under responsible sponsorship, capable direction, and qualified instruction. Under IACET's care, the IACET CEU has evolved from a quantitative measure to a hallmark of quality training and instruction. For more information on IACET, visit www.iacet.org.

Internet Connection

  • Broadband or High-Speed - DSL, Cable, and Wireless Connections

*Dial-Up internet connections will result in a diminished online experience. Classroom pages may load slowly and viewing large audio and video files may not be possible.

Hardware Requirements

  • Processor - 2GHz Processor or Higher
  • Memory - 1 GB RAM Minimum Recommended

 

PC Software Requirements

  • Operating Systems - Windows 7 or higher
  • Microsoft Office 2013 or higher. Also, you could use a general Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers - Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • QuickTime, Windows Media Player &/or Real Player

 

MAC Software Requirements

  • Operating Systems - Mac OS x 10 or higher with Windows
  • Mac office programs or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers- Google Chrome is highly recommended
    • Cookies MUST be enabled
    • Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • Apple QuickTime Media Player

 


Click on the school name below for purchasing info:

1400 Robinwood Drive
Hagerstown, MD 21742
United States
Phone: 240-500-2553

This course is also available at the following school:

Online School Finder
(Virtual Location)


To perform a search for schools based on a custom location please click here.