Excel 2013 eLearning Bundle Course



Course Details:

Length: 3 courses

Access Length: 6 months

Price: $250/person (USD)

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: Yes

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location

Free Demo: Would you like to try our eLearning Training? Get a Free eLearning Demo Class

 

Course Overview

This eLearning Bundle includes these 3 courses: Microsoft Excel 2013: Getting Started (Level 1), Microsoft Excel 2013: Intermediate (Level 2) and Microsoft Excel 2013: Advanced (Level 3).


How it Works

This course is a self-paced learning solution to fit your own schedule. Certstaffix Training eLearning courses you take on your own schedule in a web browser.


  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

 

Course Notes

Not Appropriate For: Macintosh versions of Microsoft Office

 

Course Topics

Microsoft Excel 2013: Getting Started (Level 1) - 6:00 hours

This Microsoft Excel 2013: Getting Started (Level 1) takes you through the fundamentals tools and processes that allow you to create professional and effective spreadsheets. You'll explore the Excel 2013 user interface, create and modify a worksheet, and perform basic calculations. Learn how format the look of your worksheet, and find out how to print the entire contents of your workbook. The course also shows you how to manage large workbooks more efficiently and how to customize the Excel environment to suit your preferences.This comprehensive 6-hour course is divided into 7 lessons that that you through the basics of this powerful spreadsheet program. The video course features engaging narration, step-by-step instructions, practice files, and post-assessment quizzes to help you discover time-saving tricks for managing workbooks and worksheets. Follow up with Level 2 intermediate Microsoft product training courses to continue to increase your knowledge and improve your skills.

Microsoft Excel 2013: Intermediate (Level 2) - 5:00 hours

Now that you've learned the basics and are comfortable using Microsoft Excel 2013, upgrade your skills with this intermediate course to get the most out of this powerful spreadsheet program. It takes you through more advanced formulas and lookup functions, allowing you to perform more complex calculations. You'll learn to use tables, charts and graphics to visually display information. The course also demonstrates how to use Pivot Tables, Slicers and Pivot Charts to analyze your data.Using engaging narration, step-by-step instructions, in-line quizzes, practice files and a post-assessment quiz, this 5-hour video course teaches you some of the more advanced capabilities of Excel 2013 to give you a competitive edge in managing data. It is divided into 7 lessons for easy viewing. Follow up with Level 3 Microsoft product training courses to continue to increase your knowledge and improve your skills.

Microsoft Excel 2013: Advanced (Level 3) - 5:00 hours

This Microsoft Excel 2013: Advanced (Level 3) course will build on your basic knowledge of Excel by teaching you some of the more specialized capabilities in Excel 2013. The comprehensive course begins by looking at ways of streamlining your workflow by automating repetitive tasks using macros and applying conditional formatting. Next, you’ll learn how to audit your workbooks to ensure complete accuracy and avoid mistakes from human error. Excel 2013 offers powerful means of analyzing your data, and in this course you’ll learn how to perform complex statistical analyses using sparklines and scenarios. You’ll also learn how to work effectively with multiple workbooks at the same time, as well as how to import and export your Excel data. This 5-hour course is broken down into 5 lessons. Each section features engaging narration with easy-to-understand instructions and includes summaries and short quizzes to ensure comprehension.

Introduction
Designing Tables for Better Data Entry
  • Reviewing Table Design Principles
  • Setting Field Size, Formats, and Captions
  • Setting Default Values and Required Fields
  • Restricting Data Entry - Validation Rules
  • Restricting Data Entry - Input Masks
  • Sharing Data with Other Applications
    • Exporting Tables and Queries to Excel
    • Exporting Data to a Sharepoint List
    • Importing Data from Excel
    • Importing Data from a Sharepoint List
    • Linking External Data Sources
    • Using Word Merge
Working with Action Queries
  • What Are Action Queries
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query
  • Creating a Make Table Query
  • Changing Start Number of an Auto Number Field
Advanced Query Technique
  • Modifying Query Joins
  • Using Self Joins to Combine Data
  • Creating Find Unmatched and Find Duplicate Queries
  • Creating Parameter Queries
  • Creating a Top X Query
  • Reviewing Calculated Query Fields
  • Summarizing Query Data with Totals
  • Creating a Crosstab Query
Automating Processes with Macros
  • Understanding Macro Basics
  • Creating Macros to Open Forms by Record
  • Validating Data Entry with Macros
  • Creating a Macro to Automate Data Entry
  • Advanced Data Entry Using Macros and Dlookup Functions
Advanced Form Techniques
  • Using Conditional Formatting
  • Working with the New Label Name Property
  • Organizing Form Fields with Tab Controls
  • Creating an Option Group Control
  • Creating a Combo Box Control
  • Configuring a Combo Box Control to Show Search Results
  • Using a Subform to Show Data from a Related Table
Advanced Report Techniques
  • Inserting a Chart on a Report
  • Showing Data in Columns
  • Inserting a Subreport
  • Configuring Reports with Parameter Queries
  • Sending Reports
Conclusion
<grammarly-desktop-integration data-grammarly-shadow-root="true"></grammarly-desktop-integration>

Registration:

Have a Group?
Request Private Training


Online Class

Self-Paced eLearning

Start your training today!