Excel University Volume 4 Course (20 CPE, 1 Year)

(EUV4OD1)

Overview

The fourth installment in the Excel University series covers the Excel features, functions, and techniques that will help you build reliable workpapers. The items covered in this volume will help improve your productivity so you can get your work done faster!

 

 

  • Opening Information

    • • Chapter 1: Overview
    • • Chapter 2: Selected Shortcuts
  • Features

    • • Chapter 3: Sorting and Filtering
    • • Chapter 4: Outlining
    • • Chapter 5: Formatting
    • • Chapter 6: Printing
    • • Chapter 7: Protecting
    • • Chapter 8: Hyperlink Feature
  • Functions

    • • Chapter 9: HYPERLINK Function
    • • Chapter 10: IF Alternatives
    • • Chapter 11: Lookup Functions
    • • Chapter 12: Text Functions
    • • Chapter 13: Date Functions
    • • Chapter 14: Insert Function
  • Techniques

    • • Chapter 15: Ribbon Review
    • • Chapter 16: Conditional Formatting Revisited
    • • Chapter 17: Names Revisited
    • • Chapter 18: Wildcards Revisited
    • • Chapter 19: Tables Revisited
    • • Chapter 20: Start Here Revisited
  • Applications

    • • Chapter 21: JE Preparation
    • • Chapter 22: Budget Ideas
    • • Chapter 23: Common Workpapers
  • Author

    Jeff Lenning CPA CITP
  • Subject

    Excel University Volume 4
  • Benefits

    Begin Now: begin training immediately
    Moderated: ask questions in the moderated forums
    Certificate: download and print your certificate instantly upon completion
    Pause and Resume: pause and resume training as needed
    Exam: unlimited exam attempts
  • Software

    Featuring Microsoft Excel for Windows Versions 2010 and later
  • Format

    On-Demand
  • Access Begins

    Immediately
  • Duration

    Work at your own pace during the one-year enrollment period.
  • Certificate of Completion

    Download instantly once a passing score on the final exam is achieved. You may re-attempt the final exam as many times as necessary.
  • Enrollment Period

    Your enrollment is valid for one year.

  • Lesson 1

  • Lecture Videos
  • • Administration (1:07)
  • • Ch 1 Overview (2:43)
  • • Ch 2 Selected Shortcuts (6:48)
  • • Ch 3 Sorting and Filtering (15:15)
  • • Ch 4 Outlining (11:34)
  • • Ch 5 Formatting (27:58)
  • Homework Activities
  • • Excel Version Poll
  • • Introductions Forum Post
  • • Exercise Workbooks
  • • Lesson 1 Forum Post
  • Quiz
  • • Lesson 1 Quiz
  • Additional Resources
  • • Answer Files
  • • Shortcut Reference
  • • Solutions Videos
  • • Homework and content related questions forum
  • • Shortcut Reference / Index / Glossary
  • Lesson 2

  • Lecture Videos
  • • Ch 6 Printing (12:47)
  • • Ch 7 Protecting (11:28)
  • • Ch 8 Hyperlink Feature (13:27)
  • • Ch 9 HYPERLINK Function (10:41)
  • • Ch 10 IF Alternatives - Part 1 (17:01)
  • • Ch 10 IF Alternatives - Part 2 (15:45)
  • Homework Activities
  • • Lesson 2 Poll
  • • Exercise Workbooks
  • • Lesson 2 Forum Post
  • Quiz
  • • Lesson 2 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Related Blog Post
  • • Homework and content related questions forum
  • Lesson 3

  • Lecture Videos
  • • Ch 11 Lookup Functions - Part 1 (19:02)
  • • Ch 11 Lookup Functions - Part 2 (12:25)
  • • Ch 12 Text Functions (10:54)
  • • Ch 13 Date Functions (10:43)
  • • Ch 14 Insert Function (12:05)
  • Homework Activities
  • • Lesson 3 Poll
  • • Exercise Workbooks
  • • Lesson 3 Forum Post
  • Quiz
  • • Lesson 3 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Homework and content related questions forum
  • • Related Blog Post
  • Lesson 4

  • Lecture Videos
  • • Ch 15 Ribbon Review - Part 1 (14:14)
  • • Ch 15 Ribbon Review - Part 2 (12:34)
  • • Ch 16 Conditional Formatting Revisited - Part 1 (17:21)
  • • Ch 16 Conditional Formatting Revisited - Part 2 (14:01)
  • • Ch 17 Names Revisited - Part 1 (11:34)
  • • Ch 17 Names Revisited - Part 2 (12:53)
  • Homework Activities
  • • Lesson 4 Poll
  • • Exercise Workbook
  • • Lesson 4 Forum Post
  • Quiz
  • • Lesson 4 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Homework and content related questions forum
  • • Related Blog Post
  • Lesson 5

  • Lecture Videos
  • • Ch 18 Wildcards Revisited (17:19)
  • • Ch 19 Tables Revisited (26:47)
  • • Ch 20 Start Here Revisited (24:35)
  • Homework Activities
  • • Lesson 5 Poll
  • • Exercise Workbooks
  • • Lesson 5 Forum Post
  • Quiz
  • • Lesson 5 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Related Blog Post
  • • Homework and content related questions forum
  • Lesson 6

  • Lecture Videos
  • • Ch 21 JE Preparation - Part 1 (22:41)
  • • Ch 21 JE Preparation - Part 2 (13:18)
  • • Ch 22 Budget Ideas - Part 1 (14:03)
  • • Ch 22 Budget Ideas - Part 2 (10:45)
  • Homework Activities
  • • Lesson 6 Poll
  • • Exercise Workbooks
  • • Lesson 6 Forum Post
  • Quiz
  • • Lesson 6 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Related Blog Post
  • • Homework and content related questions forum
  • Lesson 7

  • Lecture Videos
  • • Ch 23 Common Workpapers Mission 1 (5:27)
  • • Ch 23 Common Workpapers Mission 2 (2:05)
  • • Ch 23 Common Workpapers Mission 3 (1:32)
  • • Ch 23 Common Workpapers Mission 4 (0:57)
  • • Ch 23 Common Workpapers Mission 5 (1:28)
  • • Ch 23 Common Workpapers Mission 6 (2:02)
  • • Ch 23 Common Workpapers Mission 7 (2:06)
  • • Ch 23 Common Workpapers Mission Conclusion (1:46)
  • Homework Activities
  • • Lesson 7 Poll
  • • Exercise Workbooks
  • • Lesson 7 Forum Post
  • Quiz
  • • Lesson 7 Quiz
  • Additional Resources
  • • Answer Files
  • • Solutions Videos
  • • Related Blog Post
  • • Homework and content related questions forum
  • Lesson 8

  • Lecture Videos
  • • Graduation (6:29)
  • Exam and Certificate
  • • Final Exam
  • • Certificate of Completion
  • Homework Activities
  • • Course Recap Forum Post
  • • Spread the Word
  • • Keep in Touch
  • • Success Stories
  • • Course Evaluation
  • Additional Resources
  • • Shortcut Reference
  • • Contents at a Glance

Materials

This course teaches the content of the Excel University Volume 4 book. The book chapters are available digitally inside the course during the 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 optional, you may do so through Amazon.


 

Comments from participants

  • • "Very engaging, fun class!"

  • • "Valuable resource to increase personal organization and productivity."

  • • "Enthusiastic and engaging!"

  • • "Excellent presenter, would recommend."

  • • "Very good training, would recommend to other professionals."

  • • "Being exposed to new formulas and functions was valuable."

  • • "Book is great for my future reference."

  • • "Great course, really going to try to implement new things learned."

  • • "Thank you goes to Jeff for great training- very helpful and useful."

  • • "Really enjoyed Jeff. Very knowledgeable and great presenter. Exercises were also very helpful."

NASBA QAS CPE Microsoft Excel LogoObjectives

  • • State which Excel feature can help us organize workpapers and related electronic documents
  • • Identify which Excel feature can help graphically identify entries that are out of balance
  • • Recall three ways to simulate various properties of tables when we are precluded from using them

Program Level

Intermediate

Prerequisites

Excel University Volumes 1, 2, & 3

Advance Preparation Needed

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

Delivery Method

QAS Self-study

Recommended CPE Credits

20

Field of Study

Computer Software & Applications

Expiration

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

Registration

To register, add this course to your cart by clicking the Buy Now button and then complete the checkout process.

Refund Policy

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

Complaint Resolution

For information regarding adminstrative policies such as complaint resolution, please contact Jeff Lenning CPA CITP at 949-200-7688 or via email info@excel-university.com

Official Registry Statement

Excel University, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

 

Price: $247.00
Buy 2 or more for $197.60 each
Buy 20 or more for $123.50 each
Quantity: