Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Real-World Excel Cases from Work - Part 1

person icon Lenny Wu

4.6

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.

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Lenny Wu

English [CC]

category icon Office Productivity,Microsoft Excel

Lectures -15

Resources -4

Duration -1 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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.

If you would like Continuing Education Credit (e.g. CPE, CE, CPD, etc.) for this course, it is available if you take this course on the Illumeo dot com platform under course title: EXCEL Challenges (Part I): Real Cases from Work. Illumeo is certified to provide CPE in over two dozen different professional certifications covering finance, accounting, treasury, internal audit, HR, and more. However, in order to receive CPE credit the courses must be taken on an ‘approved-by-the-governing-body’ CPE platform, and for over two dozen corporate professional certifications, that is the Illumeo platform. Go to Illumeo dot com to learn more.

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • No Advanced Preparation or Prerequisites are needed for this course.
  • Experience with Excel is helpful.
Real-World Excel Cases from Work - Part 1

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
13 Lectures
  • play icon Introduction 05:30 05:30
  • play icon Case 1 – Phantom file (Basic) 06:37 06:37
  • play icon Case 2 – Copy a new sheet (Basic) 02:43 02:43
  • play icon Case 3 – Credit card woes (Basic) 03:06 03:06
  • play icon Case 4 – Quickly insert rows (Basic) 02:09 02:09
  • play icon Case 5 – Cursor right in data entry (Basic) 03:25 03:25
  • play icon Case 6 – Repeat top rows on all pages (Basic) 03:51 03:51
  • play icon Case 7 – Quick access toolbar (Intermediate) 04:08 04:08
  • play icon Case 8 – Quicker way to sum (Intermediate) 04:57 04:57
  • play icon Case 9 – Dynamic transpose (Advanced) 08:31 08:31
  • play icon Case 10 – Dynamic Range (Advanced) 08:34 08:34
  • play icon Case 10 – Dynamic Range (Advanced) Continued 11:43 11:43
  • play icon Summary (Slides 16-18) 03:56 03:56
Supporting Materials
1 Lectures
Tutorialspoint

Instructor Details

Lenny Wu

Lenny Wu

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515