Microsoft Excel Microsoft Excel 2013 Value Bundle

Microsoft Excel 2013 Value Bundle

297.00 99.95
$297.00 $99.95
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
This Package Contains Courses - See More
  • Course Delivery: On Demand
  • Language: English
  • Difficulty: Beginner
  • Audience: Microsoft Excel users

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

The most comprehensive instruction bundle for Microsoft Excel 2013 is here! Containing over 12 hours of content and spanning Foundations, Advanced, and Mastery levels of Excel, this package provides everything you need to know about Microsoft Excel with a savings of almost $200 over purchasing each course individually. Our Excel 2013 Value Bundle also arms you with the knowledge you need to prepare for the Microsoft Excel MOS certification.

 

Course Objectives

In Excel 2013 Foundations, you will learn basic functions and features of Excel 2013, work with calculations, modifying and formatting a worksheet, customize the Excel environment, and how to manage and print workbooks. Continuing your learning path to Excel 2013 Advanced, you will learn strategies for analyzing data, advanced formulas and functions, tables, charts, PivotTables, and PivotCharts. Rounding out your knowledge in Excel 2013 Mastery, you will work with advanced features of Excel, macros, manage data and aggregate calculations in multiple worksheets, audit workbooks to avoid errors, share your data, and use Excel effectively with other Microsoft Office applications.

The Following Courses Are Included In This Package:

Course Name Industry Course Delivery
Microsoft Office Excel 2013 Foundations: Module 07 - Customizing the Excel Environment NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 04 - Formatting a Worksheet NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 01 - Getting Started with Microsoft Excel 2013 NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 06 - Managing Large Workbooks NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 03 - Modifying a Worksheet NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 02 - Performing Calculations NewPage SCORM
Microsoft Office Excel 2013 Foundations: Module 05 - Printing Workbook Contents NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 02 - Analyzing Data with Logical and Lookup Functions NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 06 - Inserting Graphics NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 07 - Enhancing Workbooks NewPage SCORM
Microsoft Office Excel 2013 Mastery: Module 04 - Working with Multiple Workbooks NewPage SCORM
Microsoft Office Excel 2013 Mastery: Module 05 - Exporting Excel Data NewPage SCORM
Microsoft Office Excel 2013 Mastery: Module 01 - Automating Worksheet Functionality NewPage SCORM
Microsoft Office Excel 2013 Mastery: Module 02 - Auditing Worksheets NewPage SCORM
Microsoft Office Excel 2013 Mastery: Module 03 - Analyzing and Presenting Data NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 03 - Organizing Worksheet Data with Tables NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 05 - Analyzing Data with PivotTables Slicers and PivotCharts NewPage SCORM
Microsoft Office Excel 2013 Advanced: Module 01 - Creating Advanced Formulas NewPage SCORM
 

Topics Covered


Lesson 01 - Getting Started with Microsoft Excel 2013 - Duration: 32m

Topic A: Identify the Elements of the Excel Interface
  •    Microsoft Excel 2013
  •    Spreadsheets, Worksheets, and Workbooks
  •    The Excel Interface
  •    Cell References and the Formula Bar
  •    The Go To Feature
  •    ScreenTips and Key Tips
  •    Demo 1-1: Excel Elements

Topic B: Create a Basic Worksheet
  •    The Ribbon
  •    The Backstage View
  •    Data Types
  •    Excel 2013 File Formats
  •    SkyDrive
  •    The Convert Option
  •    The Compatibility Checker
  •    Demo 1-2: Creating a Spreadsheet

Topic C: Use the Help System
  •    The Excel Help Window
  •    Demo 1-3: Using Help System
  •    Lesson 01 Review

Lesson 02 - Performing Calculations - Duration: 42m

Topic A: Create Formulas in a Worksheet
  •    Formulas
  •    The Formula Bar
  •    Elements of an Excel Formula
  •    Common Mathematical Operators
  •    The Order of Operations
  •    Demo 2-1: Creating Formulas

Topic B: Insert Functions in a Worksheet
  •    Functions
  •    The Function Library
  •    Using the AutoSum Button
  •    The Formula AutoComplete Feature
  •    Demo 2-2: Insert Functions in a Worksheet

Topic C: Reuse Formulas
  •    The Cut, Copy, and Paste Commands
  •    Relative References
  •    Absolute References
  •    Mixed References
  •    Demo 2-3: Reusing Formulas
  •    Lesson 02 Review

Lesson 03 - Modifying a Worksheet - Duration: 36m

Topic A: Manipulate Data
  •    The Undo and Redo Commands
  •    Auto Fill
  •    Live Preview
  •    The Clear Button
  •    Demo 3-1: Manipulating Data

Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  •    The Insert and Delete Options
  •    The Hide and Unhide Options
  •    Demo 3-2: Adjust Display of Columns

Topic C: Search for and Replace Data
  •    Cell Names and Range Names
  •    The Find Command
  •    The Replace Command
  •    Demo 3-3: Searching for and Replacing Data

Topic D: Spell Check a Worksheet
  •    The Spelling Dialog Box
  •    Demo 3-4: Spell Checking a Worksheet
  •    Lesson 03 Review

Lesson 04 - Formatting a Worksheet - Duration: 46m

Topic A: Modify Fonts
  •    Fonts
  •    The Font Group
  •    The Format Cells Dialog Box
  •    Galleries
  •    Live Preview and Formatting
  •    The Mini Toolbar
  •    Demo 4-1: Modifying Fonts

Topic B: Add Borders and Color to Cells
  •    Border Options
  •    Sheet Backgrounds
  •    Demo 4-2: Adding Borders and Color to Cells

Topic C: Apply Number Formats
  •    Number Formats
  •    Number Formats in Excel
  •    Demo 4-3: Applying Number Formats

Topic D: Align Cell Contents
  •    The Indent Commands
  •    The Wrap Text Command
  •    Orientation Options
  •    Demo 4-4: Aligning Cell Contents

Topic E: Apply Cell Styles
  •    Cell Styles
  •    Demo 4-5: Applying Cell Styles
  •    Lesson 04 Review

Lesson 05 - Printing Workbook Contents - Duration: 28m

Topic A: Define the Basic Page Layout for a Workbook
  •    The Page Setup Dialog Box
  •    Workbook Views
  •    Headers and Footers
  •    Header and Footer Settings
  •    Page Margins
  •    Page Orientation
  •    Demo 5-1: Previewing a Workbook Before Print
  •    Demo 5-2: Applying Print Changes

Topic B: Refine the Page Layout and Apply Print Options
  •    Zoom Options
  •    Page Breaks
  •    The Print Area
  •    Printing Titles
  •    Scaling Options
  •    Demo 5-3: Refine Print Layout
  •    Lesson 05 Review

Lesson 06 - Managing Large Workbooks - Duration: 21m

Topic A: Format Worksheet Tabs
  •    Tab Formatting Options
  •    Demo 6-1: Formatting Worksheet Tabs

Topic B: Manage Worksheets
  •    Insertion and Deletion Options for Worksheets
  •    Hide and Unhide Options
  •    Worksheet References in Formulas
  •    Demo 6-2: Managing Worksheets

Topic C: Manage the View of Worksheets and Workbooks
  •    The Split Command
  •    The Freeze Panes Options
  •    The Arrange All Command
  •    The View Side by Side Command
  •    Demo 6-3: Managing the View of Worksheets and Workbooks
  •    Lesson 06 Review

Lesson 07 - Customizing the Excel Environment - Duration: 28m

Topic A: Customize General and Language Options
  •    The Excel Options Dialog Box
  •    The General Options
  •    The Language Options
  •    Demo 7-1: Customizing General and Language Options

Topic B: Customize Formula Options
  •    The Formulas Options
  •    Demo 7-2: Formula Options

Topic C: Customize Proofing and Save Options
  •    The Proofing Options
  •    The Save Options
  •    Demo 7-3: Customizing Proofing and Save Options

Topic D: Customize the Ribbon and Quick Access Toolbar
  •    The Customize Ribbon Options
  •    The Quick Access Toolbar Options
  •    Demo 7-4: Customizing the Quick Access Toolbar

Topic E: Customize the Functionality of Excel by Enabling
  •    Add-Ins
  •    What Are Add-Ins?
  •    The DEVELOPER Tab
  •    The Add-Ins Dialog Box
  •    Demo 7-5: Customizing the Functionality of Excel

Topic F: Customize Advanced and Trust Center Options
  •    The Advanced Options
  •    The Trust Center Options
  •    Demo 7-6: Customizing Advanced and Trust Center Options
  •    Lesson 07 Review

Excel 2013 Advanced

Lesson 01 - Creating Advanced Formulas - Duration: 30m

Topic A: Apply Range Names
  •    Worksheet without Range Names
  •    Worksheet with Range Names
  •    Excel 2013 Save Options
  •    Where to Access Saved Versions
  •    Demo 1-1: Adding Range Names
  •    Demo 1-2 & 1-3: Editing and Deleting a Range Name
  •    Demo 1-4: Using Range Names in a Formula

Topic B: Use Specialized Functions
  •    The Function Library
  •    Logical Functions
  •    Statistical Functions
  •    Syntax of the AVERAGE Function
  •    The Insert Function Dialog Box
  •    The Function Arguments Dialog Box
  •    Demo 1-5: Locating Functions by Using the Function Reference
  •    Demo 1-6: Using Functions
  •    Lesson 01 Review

Lesson 02 - Analyzing Data with Logical and Lookup Functions - Duration: 26m

Topic A: Leverage Questions and Testing to Write Formulas

Topic B: Use Logical and Lookup Functions to Find Answers to Questions
  •    Logical Functions
  •    Demo 2-1: Working with Logical Functions
  •    Demo 2-2: Combining IF and AND Functions
  •    The VLOOKUP Function
  •    The HLOOKUP Function
  •    Demo 2-3: Working with Lookup Functions
  •    Lesson 02 Review

Lesson 03 - Organizing Worksheet Data with Tables - Duration: 1h 1m

Topic A: Create and Modify Tables
  •    A Sample Table
  •    The Create Table Dialog Box
  •    The TABLE TOOLS DESIGN Contextual Tab
  •    Demo 3-1: Converting a Range to a Table

Topic B: Sort and Filter Data
  •    Data Sorted on a Single Column
  •    Data Sorted on Multiple Columns
  •    Filtered and Sorted Data
  •    Advanced Filter with Three Criteria
  •    Demo 3-2: Sorting Data and Removing Duplicate Records
  •    Demo 3-3: Filtering Records

Topic C: Use Summary and Database Functions to Calculate Data
  •    The SUBTOTAL Function
  •    Demo 3-4: Using Subtotals with Range Data
  •    Summary Functions in Table Total Row: Example 1
  •    Summary Functions in Table Total Row: Example 2
  •    Compare SUM to DSUM
  •    Demo 3-5: Using Summary Functions in Tables
  •    Demo 3-6: Using Database Functions
  •    Lesson 03 Review

Lesson 04 - Visualizing Data with Charts - Duration: 50m

Topic A: Create Charts
  •    Data in a Table
  •    Data in a Chart
  •    The Insert Chart Dialog Box
  •    Demo 4-1: Creating Charts

Topic B: Modify and Format Charts
  •    Demo 4-2: Modifying Charts
  •    Demo 4-3: Formatting Charts

Topic C: Create a Trendline
  •    Trendlines Forecasting Out Two Years
  •    The Format Trendline Dialog Box
  •    Demo 4-4: Creating a Trendline

Topic D: Create Advanced Charts
  •    A Dual-Axes Chart
  •    Demo 4-5: Creating a Dual-Axes Chart
  •    Lesson 04 Review

Lesson 05 - Analyzing Data with PivotTables, Slicers, and PivotCharts - Duration: 40m

Topic A: Create a PivotTable
  •    A Standard Table
  •    A PivotTable
  •    The PivotTable Field List Pane
  •    The Summarize Values By Options
  •    Summarizing Values by Using the MIN Function
  •    The Show Values As Options
  •    Showing Values As a Percent of the Grand Total
  •    Combining Summarize and Show (Example 1)
  •    Combining Summarize and Show (Example 2)
  •    Demo 5-1: Creating PivotTables

Topic B: Filter Data by Using Slicers
  •    Slicers and a PivotTable
  •    Demo 5-2: Adding Slicers

Topic C: Analyze Data by Using PivotCharts
  •    Slicers and a PivotChart
  •    Demo 5-3: Creating a PivotChart
  •    Lesson 05 Review

Lesson 06 - Inserting Graphics - Duration: 27m

Topic A: Insert and Modify Graphic Objects
  •    The INSERT Tab'sIllustration Group
  •    Types of Shapes
  •    Demo 6-1: Inserting Pictures and Clip Art

Topic B: Layer and Group Graphic Objects
  •    Layers
  •    A Hidden Layer
  •    The Same Layers in a New Stacking Order
  •    Three Graphic Objects, No Grouping
  •    Three Graphic Objects in One Group of Three
  •    Demo 6-2: Inserting and Grouping Shapes

Topic C: Incorporate SmartArt
  •    The Choose a SmartArt Graphic Dialog Box
  •    Demo 6-3: Incorporating SmartArt
  •    Lesson 06 Review

Lesson 07 - Enhancing Workbooks - Duration: 29m

Topic A: Customizing Workbooks
  •    A Comment
  •    Demo 7-1: Inserting Comments and Hyperlinks

Topic B: Manage Themes
  •    Built-in Themes
  •    Demo 7-2: Applying and Editing a Theme

Topic C: Create and Use Templates
  •    An Expense Report Template
  •    Demo 7-3: Creating a Template

Topic D: Protect Files
  •    File Protection Options
  •    The REVIEW Tab's Changes Group
  •    The Protect Sheet Dialog Box
  •    The Protect Structure and Windows Dialog Box
  •    Demo 7-4: Protecting a Worksheet and a Workbook
  •    Lesson 07 Review

Excel 2013 Mastery

Lesson 01 - Automating Worksheet Functionality - Duration: 42m

Topic A: Update Workbook Properties
  •    Workbook Properties
  •    Demo 1-1: Updating Workbook Properties
  •    Demo 1-2: Modifying the Default Settings in Excel

Topic B: Create and Edit a Macro
  •    Macros Icon
  •    Record Macro Dialog Box
  •    Naming Macros
  •    Visual Basic for Applications
  •    Demo 1-3: Creating a Macro
  •    Demo 1-4: Editing a Macro

Topic C: Apply Conditional Formatting
  •    Conditional Formatting
  •    Conditional Formatting Rules Manager
  •    Demo 1-5: Applying Conditional Formatting
  •    Demo 1-6: Editing a Conditional Formatting Rule

Topic D: Add Data Validation Criteria
  •    Data Validation
  •    The Data Validation Dialog Box
  •    Demo 1-7: Adding Data Validation Criteria
  •    Lesson 01 Review

Lesson 02 - Auditing Worksheets - Duration: 37m

Topic A: Trace Cells
  •    Trace Cells
  •    Tracer Arrows
  •    Demo 2-1: Tracing Cell Precedents and Dependents

Topic B: Troubleshoot Invalid Data and Formula Errors
  •    The Error Checking Command
  •    Data Validation
  •    Demo 2-2: Troubleshooting Invalid Data
  •    Demo 2-3: Troubleshooting Invalid Formulas

Topic C: Watch and Evaluate Formulas
  •    Watch Window
  •    The Evaluate Formula Icon
  •    Demo 2-4: Evaluating a Formula

Topic D: Create a Data List Outline
  •    Outlines
  •    Demo 2-5: Creating a Data List Outline
  •    Demo 2-6: Adding Subtotals to Grouped Data
  •    Lesson 02 Review

Lesson 03 - Analyzing and Presenting Data - Duration: 1h 2m

Topic A: Create Sparklines
  •    Sparkline
  •    The SPARKLINE TOOLS DESIGN Tab
  •    Demo 3-1: Adding Sparklines to Your Worksheet
  •    Demo 3-2: Editing Sparkline Data

Topic B: Create Scenarios
  •    Scenarios
  •    The Scenario Manager Dialog Box
  •    Demo 3-3: Adding a Scenario
  •    Demo 3-4: Editing Scenario Data

Topic C: Perform a What-If Analysis
  •    Goal Seek Dialog Box
  •    Solver Tool Parameters
  •    Demo 3-5: Using Goal Seek
  •    Demo 3-6: Installing the Solver Tool Add-In
  •    Demo 3-7: Using Solver to Perform a What-If Analysis

Topic D: Perform a Statistical Analysis with the Analysis
  •    ToolPak
  •    Analysis ToolPak
  •    Demo 3-8: Performing a Data Analysis with Analysis ToolPak-Descriptive Statistics

Topic E: Create Interactive Data with Power View
  •    A Power View Worksheet
  •    Demo 3-9: Creating a Power View Worksheet
  •    Lesson 03 Review

Lesson 04 - Working With Multiple Workbooks - Duration: 29m

Topic A: Consolidate Data
  •    Data Consolidation
  •    Demo 4-1: Consolidating Data

Topic B: Link Cells in Different Workbooks
  •    Link Cells in Different Workbooks
  •    Demo 4-2: Linking Cells in Different Workbooks
  •    Demo 4-3: Editing Links

Topic C: Merge Workbooks
  •    The Compare and Merge Workbooks Feature
  •    Demo 4-4: Merging Workbooks
  •    Lesson 04 Review

Lesson 05 - Exporting Excel Data - Duration: 36m

Topic A: Export Excel Data
  •    Export
  •    Demo 5-1: Exporting Excel Data

Topic B: Import a Delimited Text File
  •    Text Import Wizard
  •    Get External Data Group
  •    Delimited Text Files
  •    Demo 5-2: Importing a Delimited Text File

Topic C: Integrate Excel Data with the Web
  •    File Publish
  •    Publish as a Web Page Dialog Box
  •    Demo 5-3: Publishing a Worksheet to the Web
  •    Demo 5-4: Importing Data from the Web

Topic D: Create a Web Query
  •    Web Queries
  •    The New Web Query Dialog Box
  •    Demo 5-5: Creating a Web Query
  •    Lesson 05 Review

 

Quiz Information

Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.
 

Additional Information

Our online, ondemand training courses give you the ability to train wherever, whenever you want! The value continues through:

Expert Lectures
Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.

Certificates of Completion
Upon completion of a series of courses you can earn a certificate of completion from Career Academy and American Business and Technology University. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.

PowerPoint Visuals
Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed PowerPoint slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.

Demonstrations
The immersive demonstrations in our training are a way for the instructor to present how to perform a task on-screen in front of the student. This feature gives the student the power to see tasks performed by a professional in the intended environment as many times as they would like, without purchasing expensive software.

Review Quizzes
Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.

Mobile Access
With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!

Related Courses

Microsoft Excel Microsoft Excel for Data Analyst

Microsoft Excel for Data Analyst

$120.00 $99.00

Learn More

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.

Related Courses

Microsoft Excel Microsoft Excel for Data Analyst

Microsoft Excel for Data Analyst

$120.00 $99.00

Learn More