Excel 2013 Complete

Chapter 1: Fundamentals

   Module A: Getting around

   Module B: Workbook basics

Chapter 2: Creating worksheets

   Module A: Entering data

   Module B: Formulas

   Module C: Functions

   Module D: Moving and copying data

   Module E: Reference types

Chapter 3: Formatting

   Module A: Text formatting

   Module B: Number formatting

   Module C: Alignment

   Module D: Borders and highlighting

   Module E: Styles and themes

Chapter 4: Manipulating data

   Module A: Data entry shortcuts

   Module B: Paste options

   Module C: Inserting, deleting, and hiding

Chapter 5: Charts

   Module A: Creating charts

   Module B: Chart types and elements

Chapter 6: Output

   Module A: Managing worksheet windows

   Module B: Printing worksheets

   Module C: Sharing workbooks

Chapter 7: Settings and templates

   Module A: Workbook options and properties

   Module B: Templates

Chapter 8: Managing workbooks

   Module A: Managing worksheets

   Module B: Customizing Excel

Chapter 9: Named ranges

   Module A: Using names in formulas

Chapter 10: Tables

   Module A: Sorting

   Module B: Filtering tables

   Module C: Validation

   Module D: Transposing data

Chapter 11: Summarizing data

   Module A: Consolidation

   Module B: Subtotals

Chapter 12: PivotTables

   Module A: Creating and formatting PivotTables

   Module B: Manipulating PivotTables

   Module C: PivotCharts

   Module D: Relationships

Chapter 13: Presentation features

   Module A: Conditional formats

   Module B: Custom Formats

   Module C: Graphics

Chapter 14: Advanced charts

   Module A: Special chart types

   Module B: Sparklines

   Module C: Quick Analysis

Chapter 15: Collaboration

   Module A: Permissions

   Module B: Shared workbooks

Chapter 16: Logical and Lookup Functions

   Module A: Decision-making functions

   Module B: Lookup and reference functions

Chapter 17: Advanced Formulas

   Module A: Auditing and error-trapping

   Module B: Formula options

   Module C: Arrays

Chapter 18: Special functions

   Module A: Date and time functions

   Module B: Text functions

   Module C: Other functions

Chapter 19: Importing and Exporting

   Module A: External data

   Module B: Exporting data

Chapter 20: Analysis

   Module A: What-if analysis

   Module B: The Analysis Toolpak

Chapter 21: Macros and Forms

   Module A: Recording macros

   Module B: Running macros

   Module C: Forms

Appendix: Internationalization and Accessibility

   Preparing workbooks for internationalization and accessibility

Excel 2013 Complete provides the concepts and skills to be productive with Microsoft Excel 2013, starting with fundamentals and working up to advanced tools and techniques. This course maps to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2013. Objective coverage is marked throughout the course, and you can download an objective map from the downloads section of the product page.

Students will benefit most from this course if they want to use Excel 2013 to perform real-world tasks, from common workplace tasks to complex operations with large amounts of data. If students intend to take a Microsoft Office Specialist or Expert exam for Excel, this course offers complete coverage of all the objectives for both exams.

The course assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.

To request the PowerPoints for this course, please e-mail sales@30bird.com.

Excel 2013 Complete

  • Product Code: EXEL2013-A1-R10-
  • Availability: In Stock
  • Days of Training: 3
  • $44.00

Build Your Solution

Tags: Excel, 2013, data, formulas, functions, moving, copying, references, formatting, styles, fill, autofill, inserting, deleting, charts, windows, printing, sharing, settings, templates, named range, table, PivotTable, PivotChart, conditional format, graphics, sparklines, permissions, sharing, comments, student, instructor, logical functions, lookup, conditional functions, auditing, error-trapping, errors, arrays, dates, date functions, time, time functions, text functions, statistics, finance, importing, exporting, external data, data connections, what-if, analysis, goal seek, scenarios, macros, VBA, forms