Microsoft Excel 2013 (Voucher Included)

If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need.
• Step-by-step video demonstrations
• Companion eBooks (PDF) with detailed instructions
• Sample presentations and images
• Practice, Quizzes and Skill Test

All materials for this program are available online.
The following resources are available to download throughout the lessons:
• Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
• Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files

In Microsoft Excel Beginning, you’ll cover basic through advanced topics, including:
How to enter data and format cells and apply number formats
Practice how to create formulas and audit the cell references
Learn how to represent data as Charts
Use pictures and graphics

In Microsoft Excel Intermediate you’ll cover basic through advanced topics, including:
Create formulas that use Relative and Absolute values and audit the formulas
Use and modify TEXT formulas to combine cells (Concatenate) and format the data
Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
Understand how to create and use Lookup Tables and use the IF functions
Excel In Print: Use page Layout and Page Set up to modify print settings
Excel Online: Use and modify Sparklines and hyperlinks

In Microsoft Excel Advanced, you’ll learn how to:
Analyze data visually with a PivotChart.
Create a PivotChart and Show the Field List.
Edit the Value Field Settings.
Filter the data in the PivotChart.
Edit the Chart Layouts and Chart Style.
Use Slicers

The Microsoft Excel 2013 Certification Training Program, offered by our accredited school partners, is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics.
This course teaches the objectives for the following certification tests:
Core Certification: Pass any 1 test:
Excel® 2013 Core: Exam 77-420
Expert Certification: Pass either test:
Excel 2013 Expert Part 1: Exam 77-427
Excel 2013 Expert Part 2: Exam 77-428

Enroll through one of our accredited university or college partners today!

1.0 Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks
1.1.1 Create New Blank Workbooks
1.1.2 Create New Workbooks Use Templates
1.1.3 Import Files
1.1.4 Open Non-Native Files Directly in Excel
1.1.5 Add Worksheets to Existing Workbooks
1.1.6 Copy and Move Worksheets
1.2 Navigate Through Worksheets and Workbooks
1.2.1 Search For Data Within A Workbook
1.2.2 Insert Hyperlinks
1.2.3 Change Worksheet Order
1.2.4 Demonstrate How to Use Go to
1.2.5 Demonstrate How to Use Name Box
1.3 Format Worksheets and Workbooks
1.3.1 Change Worksheet Tab Color
1.3.2 Modify Page Setup
1.3.3 Insert and Delete Columns and Rows
1.3.4 Change Workbook Themes
1.3.5 Adjust Row Height and Column Width
1.3.6 Insert Watermarks
1.3.7 Insert Headers and Footers
1.3.8 Set Data Validation
1.4 Customize Options and Views For Worksheets and Workbooks
1.4.1 Hide Worksheets
1.4.2 Hide Columns and Rows
1.4.3 Customize The Quick Access Toolbar
1.4.4 Customize The Ribbon
1.4.5 Manage Macro Security
1.4.6 Change Workbook Views
1.4.7 Record Simple Macros
1.4.8 Add Values to Workbook Properties
1.4.9 Demonstrate How to Use Zoom
1.4.10 Display Formulas
1.4.11 Freeze Panes
1.4.12 Assign Shortcut Keys
1.4.13 Split The Window
1.5 Configure Worksheets and Workbooks to Print Or Save
1.5.1 Set A Print Area
1.5.2 Save Workbooks in Alternate File Formats
1.5.3 Print Individual Worksheets
1.5.4 Set Print Scaling
1.5.5 Repeat Headers and Footers
1.5.6 Maintain Backward Compatibility
1.5.7 Configure Workbooks to Print
1.5.8 Save Files to Remote Locations

2.0 Create Cells and Ranges
2.1 Insert Data in Cells and Ranges
2.1.1 Append Data to Worksheets
2.1.2 Find and Replace Data
2.1.3 Copy and Paste Data
2.1.4 Demonstrate How to Use Autofill Tool
2.1.5 Expand Data Across Columns
2.1.6 Insert and Delete Cells
2.2 Format Cells and Ranges
2.2.1 Merge Cells
2.2.2 Modify Cell Alignment and Indentation
2.2.3 Change Font and Font Styles
2.2.4 Use Format Painter
2.2.5 Wrap Text Within Cells
2.2.6 Apply Number Formats
2.2.7 Apply Highlighting
2.2.8 Apply Cell Styles
2.2.9 Change Text to Wordart
2.3 Order and Group Cells and Ranges
2.3.1 Apply Conditional Formatting
2.3.2 Insert Sparklines
2.3.3 Transpose Columns and Rows
2.3.4 Create Named Ranges
2.3.5 Create Outlines
2.3.6 Collapse Groups Of Data in Outlines
2.3.7 Insert Subtotals
3.0 Create Tables
3.1 Create A Table
3.1.1 Move Between Tables and Ranges
3.1.2 Add and Remove Cells Within Tables
3.1.3 Define Titles
3.2 Modify A Table
3.2.1 Apply Styles to Tables
3.2.2 Band Rows and Columns
3.2.3 Insert Total Rows
3.2.4 Remove Styles From Tables
3.3 Filter and Sort A Table
3.3.1 Filter Records
3.3.2 Sort Data On Multiple Columns
3.3.3 Change Sort Order
3.3.4 Remove Duplicates

4.0 Apply Formulas and Functions
4.1 Apply Cell Ranges and References in Formulas and Functions
4.1.1 Demonstrate How to Use References (Relative, Mixed, Absolute)
4.1.2 Define Order Of Operations
4.1.3 Reference Cell Ranges in Formulas

4.2 Summarize Data With Functions
4.2.1 Demonstrate How to Apply The SUM Function
4.2.2 Demonstrate How to Apply The MIN and MAX Functions
4.2.3 Demonstrate How to Apply The COUNT Function
4.2.4 Demonstrate How to Apply The AVERAGE Function
4.3 Apply Conditional Logic in Functions
4.3.1 Demonstrate How to Apply The SUMIF Function
4.3.2 Demonstrate How to Apply The AVERAGEIF Function
4.3.3 Demonstrate How to Apply The COUNTIF Function
4.4 Format and Modify Text With Functions
4.4.1 Demonstrate How to Use The RIGHT, LEFT and MID Functions
4.4.2 Demonstrate How to Use The TRIM Function
4.4.3 Demonstrate How to Use The UPPER and LOWER Functions
4.4.4 Demonstrate How to Use The CONCATENATE Function

5.1 Create A Chart
5.1.1 Create Charts and Graphs
5.1.2 Add Additional Data Series
5.1.3 Switch Between Rows and Columns in Source Data
5.1.4 Demonstrate How to Use Quick Analysis
5.2 Format A Chart
5.2.1 Add Legends
5.2.2 Resize Charts and Graphs
5.2.3 Modify Chart and Graph Parameters
5.2.4 Apply Chart Layouts and Styles
5.2.5 Position Charts and Graphs
5.3 Insert and Format An Object
5.3.1 Insert Text Boxes
5.3.2 Insert Smartart
5.3.3 Insert Images
5.3.4 Add Borders to Objects
5.3.5 Add Styles and Effects to Objects
5.3.6 Change Object Colors
5.3.7 Modify Object Properties
5.3.8 Position Objects

Expert modules:
1.0 Manage and Share Workbooks
1.1 Manage Multiple Workbooks
1.1.1 Modify Existing Templates
1.1.2 Merge Multiple Workbooks
1.1.3 Manage Versions Of A Workbook
1.1.4 Copy Styles From Template to Template
1.1.5 Copy Macros From Workbook to Workbook
1.1.6 Link to External Data
1.2 Prepare A Workbook For Review
1.2.1 Set Tracking Options
1.2.2 Limit Editors
1.2.3 Create Workspaces
1.2.4 Restrict Editing
1.2.5 Control Recalculation
1.2.6 Protect Worksheet Structure
1.2.7 Mark As Final
1.2.8 Remove Workbook Metadata
1.2.9 Encrypt Workbooks With A Password
1.3 Manage Workbook Changes
1.3.1 Track Changes
1.3.2 Manage Comments
1.3.3 Identify Errors
1.3.4 Troubleshoot With Tracing
1.3.5 Display All Changes
1.3.6 Retain All Changes

2.0 Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats
2.1.1 Create Custom Formats (Number, Time, Date)
2.1.2 Create Custom Accounting Formats
2.1.3 Demonstrate How to Use Advanced Fill Series Options
2.2 Apply Advanced Conditional Formatting and Filtering
2.2.1 Write Custom Conditional Formats
2.2.2 Demonstrate How to Use Functions to Format Cells
2.2.3 Create Advanced Filters
2.2.4 Manage Conditional Format Rules
2.3 Apply Custom Styles and Templates
2.3.1 Create Custom Color Formats
2.3.2 Create and Modify Cell Styles
2.3.3 Create and Modify Custom Templates
2.3.4 Create Form Fields
2.4 Prepare A Workbook For Internationalization and Accessibility
2.4.1 Modify Tab Order Among Workbook Elements and Objects
2.4.2 Display Data in Multiple International Formats
2.4.3 Modify Worksheets For Use With Accessibility Tools
2.4.4 Demonstrate How to Use International Symbols
2.4.5 Manage Multiple Options For +Body and +Heading Fonts

3.0 Create Advanced Formulas
3.1 Apply Functions in Formulas
3.1.1 Demonstrate How to Use The IF Function in Conjunction With Other Functions
3.1.2 Demonstrate How to Use AND/OR Functions
3.1.3 Demonstrate How to Use Nested Functions
3.1.4 Demonstrate How to Use SUMIFS, AVERAGEIFS, and COUNTIFS Functions
3.2 Look Up Data With Functions
3.2.1 Demonstrate How to Use The LOOKUP Function
3.2.2 Demonstrate How to Use The VLOOKUP Function
3.2.3 Demonstrate How to Use The HLOOKUP Function
3.2.4 Demonstrate How to Use The TRANSPOSE Function
3.3 Apply Advanced Date and Time Functions
3.3.1 Demonstrate How to Use The NOW and TODAY Functions
3.3.2 Demonstrate How to Use Functions to Serialize Dates and Times
3.4 Create Scenarios
3.4.1 Demonstrate How to Use The Watch Window
3.4.2 Consolidate Data
3.4.3 Enable Iterative Calculations
3.4.4 Demonstrate How to Use What If Analysis Tools Including Goal Seek
3.4.5 Demonstrate How to Use The Scenario Manager
3.4.6 Demonstrate How to Use Financial Functions

4.0 Create Advanced Charts and Tables
4.1 Create Advanced Chart Elements
4.1.1 Add Trendlines to Charts
4.1.2 Create Dual Axis Charts
4.1.3 Create Custom Chart Templates
4.1.4 View Chart Animations
4.2 Create and Manage Pivot Tables
4.2.1 Create New Pivot Tables
4.2.2 Modify Field Selections and Options
4.2.3 Create A Slicer
4.2.4 Group Records
4.2.5 Utilize Calculated Fields
4.2.6 Format Data
4.2.7 Demonstrate How to Use PowerPivot
4.2.8 Manage Relationships
4.3 Create and Manage Pivot Charts
4.3.1 Create New Pivot Charts
4.3.2 Manipulate Options in Existing Pivot Charts
4.3.3 Apply Styles to Pivot Charts

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.

6 Reasons to Complete Your Training With Us

Flexibility

With our programs, you can learn and study at your own pace with access 24/7/365 for the duration of your program. This means you can learn on your own terms and work around your own schedule.

Support

Our online training comes with access to real, live support personnel that will help you through every step from our admissions adviser who will assist you with selecting the right training for you, to our student adviser who will be there with you during your entire training journey.

Relevancy

We have tailored our programs to provide comprehensive training in the technical and soft skills employers are looking for. With direct input and feedback from industry leaders and hiring managers, our program aligns with exactly what you need to successfully enter the workforce.

Certification

Our career training not only gives you the knowledge you need but preparation for the certification exams relevant to your desired career path. If you are pursuing an exciting new career in a field with a national certification, our program will both prepare you to sit for the exam but will often include a voucher for the exam cost.

Simulations and Case Studies

Our training programs have been developed with real learners and professionals in mind, so our programs incorporate real-world case studies and virtual simulations that will provide examples and interactions with real-life situations you may encounter during your career. These allow you to learn by experience with circumstances similar to what will be your daily responsibilities on the job.

Engaging and Interactive

Our training curriculum was developed with you in mind, looking at modern day learners and their needs. Our curriculum contains a mix of formats including reading, listening, watching, and interacting that will immerse you into a fun and engaging learning experience you will not only enjoy but not want to end.

Program Description

Enroll through one of our accredited university or college partners today!

FAQ

To request more information, you can contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

Online courses are accessible 24/7/365 and self-paced, allowing you to progress at your own pace on your own schedule. They can be taken from anywhere in the world from the comfort of your own home. Classroom courses have a set schedule of the days and times the courses will be held, and you must attend during those specific times.

Find out if online learning is right for you by contacting our team of registration advisers. Our team is available to answer any of your questions about taking an online course before you commit to enrolling. We will walk you through what to expect to ensure you are making the right decision. You can contact a registration adviser today via online chat, our website contact form, or toll free at 1-855-201-6910.

No, you are not required to have a diploma or higher education degree to enroll in an online course. However, some occupations may require minimum educational thresholds for employment or certification. For more information on your desired career requirements, please contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

To take an online course, you will need to have access to an internet connection and an internet ready device such as a laptop, PC, or tablet. For course specific requirements, please visit the course page or contact a registration adviser today.

Our courses are developed with multiple formats including text, audio, video, and interactivity. Our courses also include multiple resources and tools which can include flashcards, games, activities, and more.

No, you can take the online courses from anywhere in the world.

We participate in several financial assistance options including third party funding, both military and non-military. To request more information on the financial assistance options available and check your eligibility, contact us via online chat, our website contact form, or toll free at 1-855-201-6910.

Duration is the amount of time you will receive access to your course. Durations vary by course and range between 1 month and 12 months. If you complete your course before your duration ends you will continue to have access to your course until the duration period ends.

Many of our career training programs include certification vouchers. This means that at the successful completion of your course, at no additional charge, you will receive an exam voucher for the corresponding industry certification. This voucher will allow you to register and sit for the appropriate certification exam to obtain your industry credential.

Our online courses are open enrollment, so you can start immediately. If you are using any third-party funding to cover your course tuition, your start date may be a future date determined by your funding program.

Once enrolled, you will be assigned a client adviser who will provide you with customer and technical support. Your client adviser will supply you with your course access information, any needed materials, and be available to answer any questions you have during your training experience. They will regularly check-in with you to monitor your progress and assist you with staying on track. You will also be assigned to a course mentor who will provide curriculum support throughout your training. Your mentor is available to answer any questions you have on your course curriculum, will monitor your progress and understanding of the curriculum, and may give assignments or quizzes.

If you experience any trouble accessing your course including technical issues or lost login credentials, please contact your client adviser at Austin Peay State University.

Our goal for students is to successfully complete their training course and achieve their career goals. We understand that extenuating circumstances can interfere with your ability to complete your course in the duration given. Because of this we have free or low-cost extensions available for our courses upon request. To discuss or request an extension please contact your client adviser at Austin Peay State University.

Upon successful completion of your course and fulfillment of any outstanding financial obligations, you will receive your certificate of completion. Certificates are provided to you within 30 days of completion. Your certificate will validate the training course you completed with a stamp of completion.

Students that successfully complete our career training programs are assigned a career development adviser who will coordinate placement at a local externship or hands on opportunity. These opportunities are optional and may vary based on availability and occupation. Your career development adviser will also provide job search services such as: resume building, mock interviews, job opportunity resources, and more. Our professional enrichment courses do not come with a career adviser or career services.

6 Reasons to Complete Your Training With Us

Program Description

FAQ

Any Questions?