Course Syllabus


 
 

Course Description

Microsoft Excel 2013 is a spreadsheet program that comes packaged with the Microsoft Office family of software products.  Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating address books, mailing lists, grocery lists, tracking expenses, creating invoices and bills, doing financial accounting, balancing checkbooks, as well as any other purpose that requires a spreadsheet or table. 

This course will teach you the skills you'll need to successfully use Excel 2013.   Each lesson contains step-by-step instructions and explanations to show you how to use all the features, and also provides video tutorials on how everything is done.   You don't need previous experience with Excel to be able to complete this course.  This course will start with basic skills, then move forward to more advanced features and techniques.

In our Excel 2013 course, you'll learn how to:

·    Create a spreadsheet

·    Format cells, rows, columns, and entire worksheets so they fit and match your data

·    Enter data into a spreadsheet

·    Use formulas and functions for math, accounting, and totaling

·    Create formulas and functions

·    Create charts and diagrams for your data

·    Create data lists and forms

·    Create and use pivot tables and pivot charts

·    Work with Excel templates

·    Share and protect your worksheets and workbooks

·    Use What-If Analysis to determine possible outcomes

·    And much, much more

This course breaks up the most complex features of Excel into easy-to-understand blocks of information.   Each lesson is a building block that moves you one step closer to using Excel like a pro – which you will be by the end of this course.  Even if you're new to Excel, you're just 20 lessons away from having the advanced skills you need to use this amazing program.

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what a spreadsheet is and what Excel 2013 can do.
  • Demonstrate navigation, creating workbooks and worksheets, and entering information into Excel 2013
  • Demonstrate working with cells, rows, and columns in Excel.
  • Demonstrate formatting data in cells and how to format rows and columns.
  • Demonstrate editing cells, rows, columns, and worksheets.
  • Demonstrate creating and using formulas and calculations.
  • Demonstrate using the What-If Analysis.
  • Demonstrate adding images, graphics, charts and diagrams.
  • Demonstrate creating data lists and managing data.
  • Demonstrate Pivot Table and chart usage.
  • Summarize creating and using templates in Excel 2013.
  • Demonstrate printing, protecting, saving, and sharing workbooks in Excel.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
Motives for Taking this Course 2 points
Lesson 1 Exam 10 points
Lesson 2 Exam 9 points
Lesson 3 Exam 10 points
Lesson 4 Exam 10 points
Lesson 5 Exam 10 points
Lesson 6 Exam 10 points
Lesson 7 Exam 9 points
Lesson 8 Exam 8 points
Lesson 9 Exam 10 points
Lesson 10 Exam 9 points
Lesson 11 Exam 10 points
Lesson 12 Exam 10 points
Lesson 13 Exam 10 points
Lesson 14 Exam 10 points
Lesson 15 Exam 10 points
Lesson 16 Exam 10 points
Lesson 17 Exam 10 points
Lesson 18 Exam 10 points
Lesson 19 Exam 10 points
Lesson 20 Exam 10 points
The Final Exam 44 points
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Adobe After Effects: Getting Started
Adobe After Effects: Getting Started
How to Import Images into Organizer in Photoshop Elements 15
How to Import Images into Organizer in Photoshop Elements 15 
Microsoft Word Courses
Microsoft Word Courses
Adobe Premiere: Creating Titles and Closed Captioning
Adobe Premiere: Creating Titles and Closed Captioning
Microsoft Word Level 1
Microsoft Word Level 1
Operations Management Courses
Operations Management Courses
QuickBooks Courses
QuickBooks Courses
Communications Courses
Communications Courses
Adobe Premiere: How to do Color Correction
Adobe Premiere: How to do Color Correction
Microsoft Office: Word, Excel, PowerPoint and Outlook
Microsoft Office: Word, Excel, PowerPoint and Outlook
QuickBooks 101
QuickBooks 101
Business Writing Courses
Business Writing Courses
Adobe Premiere: Importing and Using Media
Adobe Premiere: Importing and Using Media
Adobe Photoshop
Adobe Photoshop
Navigating the Adobe Photoshop Lightroom Workspace
Navigating the Adobe Photoshop Lightroom Workspace
Microsoft Excel Courses
Microsoft Excel Courses
Slack
Slack