(800)364-8610
Welcome to Aperion Global Institute.

In this course a comprehensive, students will learn how to identify the elements of the Excel interface and (7) sections of Part 1 2016 Excel.

Outline

Course Outline

About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with Microsoft Excel 2016
TOPIC A: Identify the Elements of the Excel Interface
Microsoft Excel 2016
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
The Excel Interface
Navigation Options
Creating a New Blank Workbook
Creating a New Workbook from a Template
Activity 1-1
TOPIC B: Create a Basic Worksheet
The Ribbon
The Backstage View
Data Types
Excel 2016 File Formats
The Save and Save As Commands
Saving to Microsoft OneDrive
Compatibility Mode
The Convert Option
The Compatibility Checker
Checking for Accessibility Issues
Activity 1-2
TOPIC C: Use the Help System
Using Tell Me
Accessing Advanced Help Options
Activity 1-3
Summary
Review Questions
Lesson 2: Performing Calculations
TOPIC A: Create Formulas in a Worksheet
Excel Formulas
The Formula Bar
Elements of an Excel Formula
Common Mathematical Operators
The Order of Operations
Activity 2-1
TOPIC B: Insert Functions in a Worksheet
Functions
The Function Library
Common Functions in Excel
The Formula AutoComplete Feature
Activity 2-2
TOPIC C: Reuse Formulas
The Cut, Copy, and Paste Commands
Paste Special Options
Relative References
Absolute References
Mixed References
Activity 2-3
Summary
Review Questions
Lesson 3: Modifying a Worksheet
TOPIC A: Manipulate Data
The Undo and Redo Commands
The AutoFill Feature
AutoFill Options
The Transpose Option
Live Preview
The Clear Button
Activity 3-1
TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
The Insert and Delete Options
Column Width and Row Height Alternation Methods
The Hide and Unhide Options
Activity 3-2
TOPIC C: Search For and Replace Data
Cell Names and Range Names
The Find Command
The Replace Command
The Go To Command
Activity 3-3
TOPIC D: Spell Check a Worksheet
The Spelling Dialog Box
Activity 3-4
Summary
Review Questions
Lesson 4: Formatting a Worksheet
TOPIC A: Modify Fonts
Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Galleries
Live Preview and Formatting
The Mini Toolbar
Activity 4-1
TOPIC B: Add Borders and Colors to Cells
Border Options
Fill Options
Sheet Backgrounds
Paste Options
Activity 4-2
TOPIC C: Apply Number Formats
Number Formats
Number Formats in Excel
Custom Number Formats
Activity 4-3
TOPIC D: Align Cell Contents
Alignment Options
The Indent Commands
The Wrap Text Command
Orientation Options
The Merge & Center Options
Activity 4-4
TOPIC E: Apply Cell Styles
Cell Styles
The Style Dialog Box
Activity 4-5
Summary
Review Questions
Lesson 5: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
The Print Options in Backstage View
The Page Setup Dialog Box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
Activity 5-1
TOPIC B: Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Titles
Scaling Options
Activity 5-2
Summary
Review Questions
Lesson 6: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
Renaming Worksheet Tabs
Changing Tab Color
Activity 6-1
TOPIC B: Manage Worksheets
Grouped Worksheets
Repositioning Worksheets
Inserting or Deleting Worksheets
Hiding and Unhiding Worksheets
Worksheet References in Formulas
Activity 6-2
TOPIC C: Manage the View of Worksheets and Workbooks
The Split Command
The Freeze Panes Options
The Arrange All Command
The Arrange Windows Dialog Box
The View Side by Side Command
The Switch Windows Command
The New Window Command
Activity 6-3
Summary
Review Questions
Lesson 7: Customizing the Excel Environment
TOPIC A: Customize General and Language Options
The Excel Options Dialog Box
The General Category
The Language Category
Activity 7-1
TOPIC B: Customize Formula Options
The Formulas Category
Activity 7-2
TOPIC C: Customize Proofing and Save Options
The Proofing Category
The Save Category
Version Control
Activity 7-3
TOPIC D: Customize the Ribbon and Quick Access Toolbar
The Customize Ribbon Category
The Quick Access Toolbar Category
Activity 7-4
TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
What Are Add-ins?
The Add-Ins Category
The Developer Tab
Activity 7-5
TOPIC F: Customize Advanced and Trust Center Options
The Advanced Category
The Trust Center Category
Activity 7-6
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson 2
Lesson Lab 2-1
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson Lab 4-2
Lesson 5
Lesson Lab 5-1
Lesson 6
Lesson Lab 6-1
Lesson Lab 6-2
Lesson 7
Lesson Lab 7-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Next Steps
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary

Course Length

8 Weeks

Course Effort

2-3 Hours per Week

Total Course Hours

14

Languages

English

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

While our courses are accessible through multiple mobile learning platforms, some courses may include a CD or DVD with the Textbook, so you may need access to a computer with CD-ROM or DVD Drive.

 

PC Software Requirements

  • Operating Systems – Windows 7 or higher
  • Microsoft Office 2007 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)
  • Kindle Reader App is 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)
  • Kindle Reader App is 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
  • Courses that include a CD-ROM or DVD may require an external drive and Parallels software to view.

How long does it take to complete a course?

When you register for a course(s), you will receive a start date and the time frame it takes to complete the program.  Once the course begins, each course is self-paced, so you can start and stop each learning module at your own pace. However, you must complete the course within the time frame to receive a certification.

What happens if I do not have enough time to complete the course within the time frame provided?

If you don’t finish the course in the time frame, you will not receive a certification. The time frame allotted to complete each course has been based on each learner giving a concerted effort to complete the course, plus the number of hours it takes to learn the information and obtain the certification.  Therefore, the time frame for each course has been calculated to ensure successful completion of the course. However, if for some reason a learner is unable to complete the course, you will have to re-enroll in the course and you will be required to pay the course price in effect at the time of re-enrollment.

Once enrolled in the course, and I realize that I can’t complete the course can I get a refund?

There are NO REFUNDS once you enroll in a course. However, if you are suddenly deployed while pursuing a certification course, we will work with you to ensure you complete your studies.  Learners who need to delay their course for medical reasons, may be eligible to transfer their course(s) to a future term.  A medical withdrawal will be considered only if accompanied by:

A written verification and phone verification from a medical doctor stating the student cannot complete the course due to illness or disability.  Please not the doctor’s note must be in English to be considered.

You can contact our office at: info@aperionglobalinstitute.com

Are there any additional materials and/or books I am required to buy for a course?

No, everything you need is included in the course.  Some courses will suggest additional materials/books that can help you grasp the information better, or expand your knowledge about a topic. However, you are not required to purchase the additional information.

 Are there exams I will have to take in a course?

Yes, there are exams in each course to access your knowledge of the material. You will be required to pass those exams to successful complete the course. The type of exams you will take vary. They can range from multiple choice questions, essays, short answers, and/or video/audio submissions. If you diligently study and complete the assignments for each course, you will be prepared to pass the exams in the course(s).

Can I get financial assistance?

Aperion Global Institute (AGI) courses are non-credit courses, so they do not qualify for federal assistance in the United States, and AGI does not provide financial assistance.  In some states, a vocational program, military program, or workforce development program will pay for qualified learners to take courses. You will be responsible for qualifying for financial assistance through those agencies and/or programs.  For international students, you will also have to follow the guidelines and requirements regarding financial assistance at your institution or program.

What happens when I complete a course?

Upon successful completion of a course, within three (3) days you will receive a certification by email. You are free to save and print the certification for your educational and career needs. If for some reason you do not receive the certification, or can’t save or print the certification please contact our office at:  info@aperionglobalinstitute.com

Once I provide an employer with the certification, am I guaranteed a job?

AGI does not provide direct job placement services after successfully completing a course. However, the certification you receive informs a potential employer that you have acquired the skills and knowledge to obtain employment, in most cases.  We recommend that learners conduct research on the job market to make sure you have the required job skills and expertise.

What software or hardware do I need, and what are the system requirements to take courses?

To take our courses, you must have access to a computer and the internet.  You can use a Mac and/or PC., tablet, phone.  You don’t have to use the same device to log-in for the course(s).  We recommend that you have a word-processing program (Microsoft Word is the best), Abode Player, and the latest version of a free web browser such as Chrome, Firefox, Internet Explorer, Microsoft Edge, etc.

When can I start the courses?

You can start the courses on the start date only. Once the course starts, you are free to access the course anytime, anywhere, and as many times as you want with an internet connection. Please note: There are no refunds once you enroll in a course(s).

Can I receive CEU credit for courses that I successfully complete?

Please do not assume that all courses that you take and successfully complete are eligible for CEU certification. If you are seeking CEU certification for a course, we strongly recommend that you contact your institution and establish eligibility for the courses you plan to take BEFORE you enroll in a course.  Although we provide you with a certificate for successfully completing a course, it is solely your responsibility to ensure that the course you enroll in and the certificate meets CEU requirements for your profession.