Questions? Feedback? powered by Olark live chat software

Excel 2013 Combo Training Courses

About the Excel 2013 Combo

Duration: 3 days (24 hours)

Get trained in Microsoft Office Excel 2013 and gain the skills needed to express your ideas, solve problems, and connect with people. This course will go over foundational topics and build upon those to learn more intermediate and advanced skills needed to become a true professional in Excel 2013.

This Excel 2013 Combo prepares you for MOS: Microsoft Office Excel 2013 Expert Certification by taking 77-427 and 77-428 exams.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

This training consists of the following courses:

Excel 2013: Level 1   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Get started with Microsoft Office Excel 2013
  • » Learn to navigate and to create and use Excel worksheets
  • » Learn to perform calculations, modify and format a worksheet, and manage and print workbooks
  • » Learn to organize rows and columns, and edit content of cells for managing information presentation
  • » Learn to use view features to determine worksheet layout, and change page setup

Back to Top

arrow Course Outline

  • Lesson 1: Getting Started with Microsoft Office Excel 2013
    1. Topic A: Navigate the Excel User Interface
    2. Topic B: Use Excel Commands
    3. Topic C: Create and Save a Basic Workbook
    4. Topic D: Enter Cell Data
    5. Topic E: Use Excel Help
  • Lesson 2: Performing Calculations
    1. Topic A: Create Worksheet Formulas
    2. Topic B: Insert Functions
    3. Topic C: Reuse Formulas
  • Lesson 3: Modifying a Worksheet
    1. Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
    2. Topic B: Search for and Replace Data
    3. Topic C: Use Proofing and Research Tools
  • Lesson 4: Formatting a Worksheet
    1. Topic A: Modify Fonts
    2. Topic B: Add Borders and Colors to Worksheets
    3. Topic C: Apply Number Formats
    4. Topic D: Align Cell Contents
    5. Topic E: Apply Styles and Themes
    6. Topic F: Apply Basic Conditional Formatting
    7. Topic G: Create and Use Templates
  • Lesson 5: Printing Workbooks
    1. Topic A: Preview and Print a Workbook
    2. Topic B: Define the Page Layout
  • Lesson 6: Managing Workbooks
    1. Topic A: Manage Worksheets
    2. Topic B: Manage Workbook and Worksheet Views
    3. Topic C: Manage Workbook Properties

Back to Top

Excel 2013 Level 2   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Learn to customize the Excel environment
  • » Organize and analyze datasets and tables, use functions and conditional formatting
  • » Learn to generate advanced formulas
  • » Understand visualizing data through basic charts
  • » Learn to use slicers, PivotTables, and PivotCharts to analyze data
  • » Learn to search and sort data, use multiple worksheets and cell selection techniques

Back to Top

arrow Course Outline

  • Lesson 1: Customizing the Excel Environment
    1. Topic A: Configure Excel Options
    2. Topic B: Customize the Ribbon and the Quick Access Toolbar
    3. Topic C: Enable Excel Add-Ins
  • Lesson 2: Creating Advanced Formulas
    1. Topic A: Use Range Names in Formulas
    2. Topic B: Use Specialized Functions
    3. Topic C: Use Array Formulas
  • Lesson 3: Analyzing Data with Functions and Conditional Formatting
    1. Topic A: Analyze Data by Using Text and Logical Functions
    2. Topic B: Apply Advanced Conditional Formatting
  • Lesson 4: Organizing and Analyzing Datasets and Tables
    1. Topic A: Create and Modify Tables
    2. Topic B: Sort Data
    3. Topic C: Filter Data
    4. Topic D: Use SUBTOTAL and Database Functions
  • Lesson 5: Visualizing Data with Basic Charts
    1. Topic A: Create Charts
    2. Topic B: Modify and Format Charts
  • Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
    1. Topic A: Create a PivotTable
    2. Topic B: Analyze PivotTable Data
    3. Topic C: Present Data with PivotCharts
    4. Topic D: Filter Data by Using Slicers

Back to Top

Excel 2013: Level 3   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Learn to manage multiple worksheets and workbooks and collaborate with colleagues
  • » Learn to automate workbook functionalities and tasks
  • » Learn to apply conditional logic, and audit worksheets
  • » Learn to use automated analysis tools
  • » Learn to share and protect workbooks
  • » Learn to visually present large amounts of complex data

Back to Top

arrow Course Outline

  • Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
    1. Topic A: Use 3-D References
    2. Topic B: Use Links and External References
    3. Topic C: Consolidate Data
  • Lesson 2: Sharing and Protecting Workbooks
    1. Topic A: Collaborate on a Workbook
    2. Topic B: Protect Worksheets and Workbooks
  • Lesson 3: Automating Workbook Functionality
    1. Topic A: Apply Data Validation
    2. Topic B: Work with Forms and Controls
    3. Topic C: Work with Macros
  • Lesson 4: Applying Conditional Logic
    1. Topic A: Use Lookup Functions
    2. Topic B: Combine Functions
    3. Topic C: Use Formulas and Functions to Apply Conditional Formatting
  • Lesson 5: Auditing Worksheets
    1. Topic A: Trace Cells
    2. Topic B: Search for Invalid Data and Formulas with Errors
    3. Topic C: Watch and Evaluate Formulas
  • Lesson 6: Using Automated Analysis Tools
    1. Topic A: Determine Potential Outcomes Using Data Tables
    2. Topic B: Determine Potential Outcomes Using Scenarios
    3. Topic C: Use the Goal Seek Feature
    4. Topic D: Activate and Use the Solver Tool
    5. Topic E: Analyze Data with Analysis ToolPak Tools
  • Lesson 7: Presenting Your Data Visually
    1. Topic A: Use Advanced Chart Features
    2. Topic B: Create Sparklines

Back to Top

This training prepares students for the following exam(s):

  • » 77-420: Microsoft Office Excel 2013

Back to Top

Recent Client Testimonials & Reviews

The instructor is very knowledgeable on the material. She was very fun and friendly. Kept me engaged.

- Jeanette S.

Course(s) Taken

» Excel 2016 Combo

The instructor was great and very knowledgeable. Great class!

- Amanda D.

Course(s) Taken

» Excel 2016 Combo

I really enjoyed the class. The instructor did a great job.

- Lisa M.

Course(s) Taken

» Excel 2016 Combo

  More testimonials »  

Back to Top