Real-World Excel Cases from Work - Part 1
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Real-World Excel Cases from Work - Part 1 to your Wishlist.

Add to Wishlist

Real-World Excel Cases from Work - Part 1

This course serves as a refresher for all professionals who need to sharpen their EXCEL skills for professional use.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Last updated 8/2017
English
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 3 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Identify key components in the EXCEL body of knowledge (BOK) created by the instructor
  • Discover 4 major ways of initiating a command in EXCEL
  • Explore the features of cells, rows, columns, sheets, and files in EXCEL
  • Recognize means of achieving dynamic features by using certain formulas and functions
  • Discover ways of deploying commands by using keyboard short-cuts
  • Explore methods to apply appropriate cell format and page layout
View Curriculum
Requirements
  • No Advanced Preparation or Prerequisites are needed for this course.
  • Experience with Excel is helpful.
Description

This course is one of a video series that documents common issues met in working with Microsoft EXCEL. This course presents 10 cases which have been collected directly from real working environments and are intended to share with professionals using EXCEL so that they can learn how to leverage the tool 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 and expert levels. The BOK 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 serves as a refresher for all professionals who need to sharpen their EXCEL skills for professional use.

Who is the target audience?
  • Anyone interested in Excel for b
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
02:18:29
+
Introduction
14 Lectures 02:18:25


Case 2 – Copy a new sheet (Basic)
02:43

Case 3 – Credit card woes (Basic)
03:06

Case 4 – Quickly insert rows (Basic)
02:09

Case 5 – Cursor right in data entry (Basic)
03:25

Case 6 – Repeat top rows on all pages (Basic)
03:51

Case 7 – Quick access toolbar (Intermediate)
04:08

Case 8 – Quicker way to sum (Intermediate)
04:57

Case 9 – Dynamic transpose (Advanced)
08:31

Case 10 – Dynamic Range (Advanced)
08:34

Case 10 – Dynamic Range (Advanced) Continued
11:43

Summary (Slides 16-18)
03:56

EXCEL Challenges (Part I): Real Cases from Work Continuous Play
01:09:10
+
Supporting Materials
3 Lectures 00:04
Slides: Real Cases from Work
00:01

Real Cases from Work Glossary/Index
00:01

Excel challenges - Part I - Final
00:01
+
Review and Test
0 Lectures 00:00
Review Questions
3 questions

FINAL EXAM
5 questions
About the Instructor
Illumeo Learning
4.4 Average rating
291 Reviews
1,303 Students
234 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

Lenny Wu (Illumeo)
0.0 Average rating
0 Reviews
3 Students
2 Courses

Lenny is Management Reporting Analyst at Seaspan Ship Management Ltd., subsidiary of Seaspan Corporation (NYSE:SSW). Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.

Lenny supervises Adaptive Insights system budgeting, and is a CPA, CGA, and a Certified Xero Partner.

Lenny is a proponent for "One-click Reporting" for analysts and "Self-service Reporting" for executives. He has strong belief that reporting and closing should be hours rather than days or even weeks.

Lenny also acts as local CPA chapter board officer and volunteers for Canada Revenue Agency as a Community Volunteer Income Tax Program consultant.

Experience

Management Reproting Analyst : Seaspan Ship Management Ltd - [2008 to Current]

 

Education

MBA, Finance : George Washington University - SBPM (School of Business and Public Management) - [1998 to 2000]