Instructor for this course
more

This course serves as a refresher for all professionals who need to sharpen their Excel skills for professional use. It presents 10 cases which have been collected directly from real working environments. These cases will teach you how to leverage Excel in “the real world”.

For these cases to be relevant and organized, the course first provides a unique view of the Body of Knowledge (BOK) of Excel created by the instructor, which is a first in Excel training and publications. The BOK illustrates the usual learning path of an Excel learner, naturally from basic to intermediate, and then on to advanced to expert levels. The BOK documents the essential components of Excel, such as cells, sheets, files, tables, formulas, commands, macros, pivot tables, and power suite, and is open ended with the top level embracing more esoteric skills and future developments in Excel.

Under the guidance of the BOK, all cases are tailored to the corresponding knowledge level so that the learner may ascertain which areas they are good at and which require a bit more work. For each case, the course illustrates what the issues are, why the issues exist, and how to solve them. The course also encourages contributions from the audience who believe there may be better ways of resolving these issues. Those suggestions from the audience will be shared and acknowledged in future parts of the series.

This course covers the following:

  • Identify key components in the EXCEL body of knowledge (BOK) created by the instructor
  • Explore features of TEXT functions in EXCEL
  • Explore the means of getting file names and sheet names
  • Explore how to make simple Visual Basic for Applications (VBAs) by using the Macro Recorder
  • Discover examples to deploy batch processing when working in EXCEL
  • Explore ways to synchronize charts in dashboard reporting.

Course Series

This course is included in the following series:

2 CoursesExcel Challenges

  1. EXCEL Challenges (Part I): Real Cases from Work
  2. EXCEL Challenges (Part II): Real Cases from Work

Learning Objectives

  • Identify key components in the EXCEL body of knowledge (BOK) created by the instructor
  • Explore features of TEXT functions in EXCEL
  • Explore the means of getting file names and sheet names
  • Explore how to make simple Visual Basic for Applications (VBAs) by using the Macro Recorder
  • Discover examples to deploy batch processing when working in EXCEL
  • Explore ways to synchronize charts in dashboard reporting.
Last updated/reviewed: August 14, 2017

6 Reviews (30 ratings)Reviews

5
Anonymous Author
I enjoyed this course. It was presented in a way that was easy to follow and it touched on a lot of good points.
4
Member's Profile
Good variety of Excel tips. Dark colors in background of slides sometimes interfered with legibility of text.
5
Anonymous Author
Lots of good content. Well-designed and organized presentation with walk-through examples.
5
Member's Profile
Another great course! Very useful even for advanced users.
5
Member's Profile
Some good real life examples of Excel.
5
Member's Profile
great course. very useful info

Prerequisites

Course Complexity: Intermediate

No advanced preparation or prerequisites are required for this course, but completion of the other courses in this series will be helpful.

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
INTRODUCTION AND OVERVIEW
  5:37Introduction to EXCEL Challenges (Part II): Real Cases from Work
Basic
  1:38Case 1 – Rename a sheet (Basic)
  4:02Case 2 – Summary and detail views(Basic)
  4:04Case 3 – Add a line in a cell (Basic)
  4:53Case 4 – Change non-adjacent words (Basic)
  3:26Case 5 – Delete non-adjacent rows (Basic)
  9:04Case 6 – Text functions (Basic)
Intermediate
  7:44Case 7 – Tab name and file name (Intermediate)
  9:22Case 8 – Macro and macro recorder (Intermediate)
Advanced
  6:30Case 9 – Dropdown list (Advanced)
  8:31Case 10 – Synched charts (Advanced)
  9:45Case 10 – Synched charts (Advanced) Continued
  3:59Summary
Continuous Play
  1:18:35EXCEL Challenges (Part II): Real Cases from Work
SUPPORTING MATERIALS
  PDFSlides: (Part II) Real Cases from Work
  PDFReal Cases from Work Glossary/Index
  XLSMExcel challenges - Part 2
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM