Excel University Volume 1 Course Lite (No CPE, 1 Year)

(EUV1OD2)

Overview

Excel University Volume 1 focuses on the Excel features, functions and techniques that enable you to get your tasks done more quickly. It is designed to establish a firm foundation for your workbooks, and to help reduce errors and improve efficiency in your recurring-use workbooks. The knowledge in this volume is used throughout the entire Excel University series.

 

 

  • Opening Information

    • • Chapter 1: Overview
    • • Chapter 2: Book Conventions
    • • Chapter 3: Excel Conventions
    • • Chapter 4: How to Make the Most
  • Foundations

    • • Chapter 5: Foundations Overview
    • • Chapter 6: Selected Shortcuts
    • • Chapter 7: Named References
    • • Chapter 8: Tables
    • • Chapter 9: Data Validation
    • • Chapter 10: Conditional Formatting Basics
    • • Chapter 11: Better Summing
    • • Chapter 12: Skinny Row
    • • Chapter 13: Hide Worksheets
    • • Chapter 14: Highlight Input Cells
    • • Chapter 15: Workbook Organization
    • • Chapter 16: Worksheet Organization
    • • Chapter 17: Nested Functions
    • • Chapter 18: Selection Groups
    • • Chapter 19: Workbook Design Principles
  • Author

    Jeff Lenning CPA CITP
  • Subject

    Excel University Volume 1: Complete
  • Benefits

    Begin Now: begin training immediately
    On-Demand: train at your own pace
    Pause and Resume: pause and resume training as needed
  • Software

    Featuring Microsoft Excel for Windows Versions 2010 and later
  • Format

    On-Demand
  • Access Begins

    Immediately
  • Duration

    Designed around an 8 week schedule; typical participants spend 1-2 hours per week. You may work at your own speed, either faster or slower than the suggested eight week schedule.
  • Certificate of Achievement

    Download instantly upon reaching the final module. No final exam required since this course doesn not qualify under NASBA standards for continuing education CPE credit and can't be claimed as such.
  • Enrollment Period

    Your enrollment is valid for one year.

  • Week 1

  • Lecture Videos
  • • Introduction (1:39)
  • • Course Administration (7:46)
  • • Chapters 1-5 (13:08)
  • • Chapter 6: Selected Shortcuts (8:52)
  • Homework Activities
  • • Excel Version Poll
  • • Introductions Forum Post
  • • Exercise Workbooks
  • • PMT Blog Post
  • Additional Resources
  • • Answer Files
  • • Shortcut Reference
  • • Chapter 6 Solutions Video
  • • Conditional Sum Blog Post
  • Week 2

  • Lecture Videos
  • • Chapter 7: Named References (7:43)
  • • Chapter 8: Tables (10:36)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbooks
  • Additional Resources
  • • Go To Special Blog Post
  • • Answer Files
  • • Chapter 7 Solutions Video
  • • Chapter 8 Solutions Video
  • Week 3

  • Lecture Videos
  • • Chapter 9: Data Validation (11:59)
  • • Chapter 10: Conditional Formatting Basics (6:13)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbooks
  • Additional Resources
  • • DV Alert Styles Blog Post
  • • Answer Files
  • • Chapter 9 Solutions Video
  • • Chapter 10 Solutions Video
  • Week 4

  • Lecture Videos
  • • Chapter 11: Better Summing (7:57)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbook
  • Additional Resources
  • • 25 Years of Excel Video
  • • Answer File
  • • Chapter 11 Solutions Video
  • Week 5

  • Lecture Videos
  • • Chapter 12: Skinny Row (7:33)
  • • Chapter 13: Hide Worksheets (4:09)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbooks
  • Additional Resources
  • • Answer Files
  • • Chapter 12 Solutions Video
  • • Chapter 13 Solutions Video
  • • Outline Groups Blog Post
  • • Very Hidden Worksheets Blog Post
  • Week 6

  • Lecture Videos
  • • Chapter 14: Highlight Input Cells (6:20)
  • • Chapter 15: Workbook Organization (9:26)
  • • Chapter 16: Worksheet Organization (10:31)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbooks
  • • Cell Style Blog Post
  • Additional Resources
  • • Answer Files
  • • Chapter 14 Solutions Video
  • • Index Sheet Blog Post
  • • External Data Blog Post
  • Week 7

  • Lecture Videos
  • • Chapter 17: Nested Functions (5:13)
  • • Chapter 18: Selection Groups (5:26)
  • • Chapter 19: Workbook Design Principles (7:08)
  • Homework Activities
  • • Quick Poll
  • • Exercise Workbooks
  • Additional Resources
  • • Answer Files
  • • Chapter 17 Solutions Video
  • • Chapter 18 Solutions video
  • • Last day of the month blog post
  • Week 8

  • Lecture Videos
  • • Graduation (7:06)
  • Homework Activities
  • • Recommend
  • • Course Recap Forum Post
  • • Keep in Touch!
  • • Course Evaluation
  • Additional Resources
  • • Shortcut Reference
  • • Contents at a Glance

Materials

This course teaches the content of the Excel University Volume 1 book. The book chapters are available digitally inside the course during your enrollment period. Obtaining a printed/bound copy of the book is not required.


If you'd like to purchase a printed/bound copy of the book, which is totally optional, you can do so through Amazon. 


Use the related products link below to obtain a hard copy of the book if desired.

Comments from course participants

  • • "This course is well organized, user focused, and interactive. I would recommend it to anyone who creates worksheets in Excel or works in Excel frequently."

  • • "I thoroughly enjoyed this course."

  • • "This course is very useful to accountants because it gives some insights on how to be efficient on the job. Also, gives many keyboard shortcuts that are not usually known to common users like me."

  • • "The class is highly recommended to Finance and Accounting personnel. The webinars are short, and very informative. The quiz allows you to absorb the materials better. The book is very helpful as well."

  • • "Well designed. Broken down to smaller sections, it's easier to follow and practice the newly learnt tips during the homework section."

  • • Clean & clear demonstration. Jeff really nailed this one. It's very easy to follow and he also made it interactive in the forum section.

  • • Good combination of videos/book/homework/blog. Videos are easy to follow, book makes it easier to refer later, homework reinforces and blog appeals to those working better with words than videos.

  • • This course is excellent. Excellent. Excellent. I really like the combination of different media (videos/books/blogs/forum). I also like the smaller sections so you can learn one function at a time. You really understand how we learn and help us get there.

  • • The strength of this course is the instructor himself. He is an accountant who happens to be an Excel expert. He understands what accountants need from the program and what the program can do for accountants. This course and the following series will teach accountants how to use the MS Excel to improve productivity and efficiency.

  • • The one chapter that I appreciate the most is the last chapter "Workbook Design Principles". In my opinion, that chapter and chapters on worksheet/workbook organization should be placed at the beginning of the course material.

  • • It's a GREAT course and it's organized in a format leagues above the usual online learning styles of other e-learning.

  • • I can't wait to try your other advanced courses.

  • • The course was very easy to follow.

  • • It really was one of the best in format I’ve done... I wish all were as well done as that one was!

Objectives

  • • Recall at least 3 shortcuts to improve your speed
  • • Identify the dialog box used to change or remove a named reference
  • • Recognize which feature allows us to control what a user can type into a cell

Program Level

Basic

Prerequisites

None

Advance Preparation Needed

Ensure you have access to Excel for Windows, preferably versions 2010 or 2013, so that you may work through the required homework exercises. Excel for Mac is not officially supported.

Recommended CPE Credits

This version does not qualify for CPE credit...please enroll into the full course version if CPE is desired

Field of Study

Computer Science

Expiration Date

Program enrollment is valid for one year and participant must complete the final exam within this time period.

Refund Policy

Full 30-day refund; full refund for any course cancellations or registration into upcoming session if preferred.

Complaint Resolution

For additional information regarding administrative policies such as complaint and refund, and cancellation please contact Jeff Lenning at 949-200-7688 or via email at info@excel-university.com

 

Price: $179.00
Buy 2 or more for $143.20 each
Quantity: