Cart Subtotal: $0.00

Welcome Student!

  • Contact Us
  • (888) 840-2378
  • Tech Support: (866) 830-9276
  • Click here to chat!

Microsoft Office 2013 - Excel

SKU# 194005

Availability: In stock

$49.00

$15.00

Secure shopping trustmarks

Quick Overview

Microsoft Office 2013 - Excel

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

Course Description

Our MOS Excel 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software.  When you pass the Excel 2013 Exam 77-420, you achieve Microsoft Certified Application Specialist (MOS) status in Excel 2013.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

We are so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Syllabus

Microsoft Excel 2013 - Course Introduction
Section 1-1 - Create Worksheets and Workbooks
Creating New Blank Workbooks
Creating New Workbooks Using Templates
Importing Files
Opening Non-Native Files Directly in Excel
Adding Worksheets to Existing Workbooks
Copying and Moving Worksheets

Section 1-2 - Navigate Through Worksheets and Workbooks
Searching for Data Within a Workbook
Using Go To and Name Box
Changing Worksheet Order
Inserting Hyperlinks

Section 1-3 - Format Worksheets and Workbooks
Changing Worksheet Tab Color
Modifying Page Setup and Inserting Watermarks
Inserting and Deleting Columns and Rows
Changing Workbook Themes
Adjusting Row Height and Column Width
Inserting Headers and Footers
Setting Data Validation

Section 1-4 - Customize Options and Views for Worksheets and Workbooks
Hiding Columns - Rows - Worksheets
Customizing the Quick Access Toolbar and the Ribbon
Managing Macro Security
Changing Workbook Views
Recording Simple Macros
Adding Values to Workbook Properties
Using Zoom
Displaying Formulas
Freezing Panes
Splitting the Window

Section 1-5 - Configure Worksheets and Workbooks to Print or Save
Setting a Print Area
Saving Workbooks in Alternate File Formats
Printing Individual Worksheets and Scaling
Repeating Headers and Footers
Maintaining Backward Compatibility
Configuring Workbooks to Print
Saving Files to Remote Locations

Section 2-1 - Insert Data in Cells and Ranges
Appending Data to Worksheets
Finding and Replacing Data
Copying and Pasting Data
Using AutoFill Tool
Inserting and Deleting Cells

Section 2-2 - Format Cells and Ranges
Merging Cells
Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
Using Format Painter
Wrapping Text Within Cells
Applying Number Formatting
Applying Highlighting and Cell Styles
Changing Text to WordArt

Section 2-3 - Order and Group Cells and Ranges
Applying Conditional Formatting
Transposing Columns and Rows
Inserting Sparklines
Creating Named Ranges
Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals

Section 3-1 - Create a Table
Creating a Table and Moving Between Tables and Ranges
Adding and Removing Cells Within Tables
Defining Titles

Section 3-2 - Modify a Table
Applying Styles to Tables
Banding Rows and Columns
Inserting Total Rows
Removing Styles From Tables

Section 3-3 - Filter and Sort a Table
Filtering Records
Changing Sort Order
Sorting Data on Multiple Columns
Removing Duplicates

Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions
Utilizing References - Relative - Mixed - Absolute
Defining Order of Operations
Referencing Cell Ranges in Formulas

Section 4-2 - Summarize Data with Functions
Utilizing the SUM Function
Utilizing the MIN and MAX Functions
Utilizing the COUNT Function
Utilizing the AVERAGE Function

Section 4-3 - Utilize Conditional Logic in Functions
Utilizing the SUMIF Function
Utilizing the AVERAGEIF Function
Utilizing the COUNTIF Function

Section 4-4 - Format and Modify Text with Functions
Utilizing the RIGHT - LEFT and MID Functions
Utilizing the TRIM Function
Utilizing the UPPER and LOWER Functions
Utilizing the CONCATENATE Function

Section 5-1 - Create a Chart
Creating Charts and Graphs
Adding Additional Data Series
Switching Between Rows and Columns in Source Data
Using Quick Analysis

Section 5-2 - Format a Chart
Adding Legends
Resizing Charts and Graphs
Modifying Chart and Graph Parameters
Applying Chart Layouts and Styles
Positioning Charts and Graphs

Section 5-3 - Insert and Format an Object
Inserting Text Boxes
Inserting SmartArt
Inserting Images
Adding Borders to Objects
Adding Styles and Effects to Objects
Changing Object Colors
Modifying Object Properties and Positioning Objects
Course Close

Instructor Bio

David Bigger

Reviews
Write Your Own Review

You're reviewing: Microsoft Office 2013 - Excel

  •  
    1 star
    2 stars
    3 stars
    4 stars
    5 stars
    Price
    Value
    Quality

* Required Fields

Free Demo