Instructor for this course
more

Microsoft Excel is considered one of the most useful tools in the workplace. However, if Excel is used incorrectly, it can seriously drag down productivity. This guides you through Excel and enables you to boost your productivity and save your most valuable resource: time. We start by exploring the top 5 productivity boosting shortcuts. Next, we'll look at how we can improve spreadsheet design, boost our proficiency with additional shortcuts, master the fundamental functions, and finally we'll make sure our spreadsheets are error free. This course is the primer to Excel you didn't know you needed!

Learning Objectives

  • Identify 5 top productivity shortcuts in MS Excel
  • Utilize Excel data tables and named ranges in excel
  • Demonstrate the use of conditional formatting and explore alternatives to the SUM function
  • Be able to hide and unhide worksheets
  • Improve your workbook organization for better, faster use
  • Demonstrate the basics of nested functions and better workbook design
  • Increase your Excel speed with selected shortcuts
  • Remove duplicates from lists and tables
  • Look up values in a table using VLOOKUP
  • Utilize multiple lookup functions such as VLOOKUP, MATCH, and INDEX
  • Be able to trap errors with IFERROR function and create indented report labels
  • Demonstrate multiple uses for the IF function
  • Enact multi-column comparisons with COUNTIFS
  • Be able to create indented report labels
  • Articulate tactics for Excel data validation and reporting
  • Improve error checking
  • Implement concatenation basics
  • Build your own Date with the Date function

2 Reviews (9 ratings)Reviews

5
Member's Profile
A treasure trove. I'm an advanced Excel user (pivots, macros, and VB) and I learned stuff... so you will too. One of the best courses that I've taken (for CPA CPE) on Illumeo.
5
Member's Profile
More time should be allocated to this course if the individual is attempting to complete the exercises as part of their training.

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
  45:25Excel Training: 5 Top Productivity Boosting Shortcuts
  1:03:46Excel Training: Skills for Better Workbook Design
  1:01:07Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  49:56Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and more
  1:01:42Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
Supporting Materials
  ZIPExcellence in Excel Training Combined Supporting Materials
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM