Phone: 855.637.1434 Cart
0item(s)

You do not have any courses in your Wish List. Choose from popular suggestions below or continue with Subject or Grade

POPULAR SUGGESTIONS

Product was successfully added to your Cart.

Microsoft

Microsoft

Add to WishList

Quick Overview

Using a project based approach, students are introduced to Microsoft
Teacher-Led Course (one-time payment)   $450.00

Monthly Fees: Due Today:

Price as configured: $0.00

Details

Using a project based approach, students are introduced to Microsoft® Excel® 2016. This course walks students through basic to advanced features by experimenting with spreadsheet creation. Types of activities include, creating worksheets, charts, formulas, functions, what-if analysis, and financial functions. Students work through these hands on projects to master skills in commonly used features of spreadsheets. 

Course Outline

  • Creating a Worksheet and a Chart  

  • Formulas, Functions, and Formatting  

  • Working with Large Worksheets, Charting, and What-If Analysis  

  • Financial Functions, Data Tables, and Amortization Schedules  

  • Working with Multiple Worksheets and Workbooks  

  • Creating, Sorting, and Querying a Table  

  • Creating Templates, Importing Data, and Working with SmartArt, Images and Screenshots  

  • Working with Trendlines, PivotTables, PivotCharts, and Slicers  

  • Formula Auditing, Data Validation, and Complex Problem Solving  

  • Data Analysis with Power Tools and Creating Macros  

  • User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel  

Additional Information

Course Length 4 Months
Prerequisites

Software Requirements

  • Microsoft® Windows 7® or higher, or Mac® OS 1
Course Materials No
Course Start Date

Courses Taught by a K12 Teacher

Courses with a teacher have designated start dates throughout Fall, Spring, and Summer. Full-year courses last 10 months and semester courses last 4 months. Courses are taught by teachers in K12 International Academy. For details on start dates, click here.

Teacher Assisted Yes, this course is taught by a K12 International Academy teacher. If you are looking for a teacher-supported option with additional flexibility and year-round start dates, click here to learn about the Keystone School, another K12 online private schooling option.
  1. Be the first to review this product

To use this course, you'll need a computer with an Internet connection.  Some courses require additional free software programs, which you can download from the Internet.

Hardware and Browsers (Minimum Recommendations)

Windows OS

  • CPU: 1.8 GHz or faster processor (or equivalent)

  • RAM: 1GB of RAM

  • Browser: Microsoft Internet Explorer 9.0 or higher, Mozilla Firefox 10.0 versions or higher, Chrome 17.0 or higher

  • At this time our users are encouraged not to upgrade to Windows 10 or Edge (the new browser)

 

Mac OS

  • CPU: PowerPC G4 1 GHz or faster processor; Intel Core Duo 1.83 GHz or faster processor

  • RAM: 1GB of RAM

  • Browser: Firefox 10.0 versions or higher, Chrome 17.0 or higher (Safari is not supported!)

Internet Connections

It is highly recommended that a broadband connection be used instead of dial up.