(800)364-8610
Welcome to Aperion Global Institute.
Empty table document, colorful template in a flat design, vector illustration

Microsoft Excel 2013 Core Essentials Course Bundle

$405.00

Course Length: 12 Weeks

Course Hours: 24

Get the “Aperion Global Institute” Course Bundle and SAVE 

A full comprehensive overview of Microsoft Excel 2013 Core Essentials Course Bundle

Outline

Module 1: The Basics

Getting Started

Signing In

Creating a New Workbook

Parts of a Workbook

Saving a Workbook

Opening a Workbook

Review Questions

Module 2: Your First Workbook

Selecting Data

Entering and Deleting Data

Using Undo and Redo

Using Cut, Copy, and Paste

Review Questions

Module 3: Working with Data

Inserting Rows and Columns

Merging and Splitting Cells

Moving Cells

Using Paste Special

Using Find and Replace

Hiding and Unhiding Cells

Review Questions

Module 4: Using Basic Excel Tools

Understanding Cell References and Formulas

Using Basic Formulas

Using Basic Functions

Using Advanced Functions

Using Spell Check

Using Sort and Filter

Review Questions

Module 5: Using Timesaving Tools

Using AutoFill

Using Flash Fill

Using AutoSum

Using AutoComplete

Using AutoCalculate

Review Questions

Module 6: Formatting Text

Changing the Font Face, Size, and Color

Applying Text Effects

Applying Borders and Fill

Using the Font Tab of the Format Cells Dialog

Clearing Formatting

Review Questions

Module 7: Formatting Data

Wrapping Text

Changing the Size of Rows and Columns

Adjusting Cell Alignment

Changing Text Direction

Changing Number Format

Review Questions

Module 8: Formatting the Workbook

Using Cell Styles

Formatting Data as a Table

Changing the Theme

Inserting Page Breaks

Adding a Background

Review Questions

Module 9: Inserting Art and Objects

Inserting SmartArt

Inserting Text Boxes

Inserting Pictures

Inserting Equations

Drawing Shapes

Review Questions

Module 10: Charting Data

Creating Sparklines

Inserting Charts

Inserting PivotTables

Inserting PivotCharts

Using Slicers

Creating Timelines

Review Questions

Module 11: Viewing, Printing, and Sharing Your Workbook

Using Views

Saving a Workbook as PDF or XPS

Printing a Workbook

E-Mailing a Workbook

Sharing Your Workbook on SkyDrive

Review Questions

Module 12: Customizing the Interface

Changing Ribbon Display Options

Customizing the Quick Access Toolbar

Hiding and Showing Ribbon Tabs

Creating Custom Ribbon Tabs

Resetting Interface Changes

Review Questions

Course Length

12 Weeks

Course Effort

2-3 Hours per Week

Total Course Hours

24

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.