EXCEL Challenges: Real Cases from Work (Part I)

Course

Online

£ 10 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About 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

Anyone Interested in Excel

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Excel
  • Access
  • Credit
  • MS Excel

Course programme

Introduction 13 lectures 01:09:10 Introduction to Real Cases from Work Part I Case 1 – Phantom file (Basic) Case 2 – Copy a new sheet (Basic) Case 3 – Credit card woes (Basic) Case 4 – Quickly insert rows (Basic) Case 5 – Cursor right in data entry (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 7 – Quick access toolbar (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 9 – Dynamic transpose (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Continued Summary (Slides 16-18) Introduction 13 lectures 01:09:10 Introduction to Real Cases from Work Part I Case 1 – Phantom file (Basic) Case 2 – Copy a new sheet (Basic) Case 3 – Credit card woes (Basic) Case 4 – Quickly insert rows (Basic) Case 5 – Cursor right in data entry (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 7 – Quick access toolbar (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 9 – Dynamic transpose (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Continued Summary (Slides 16-18) Introduction to Real Cases from Work Part I Introduction to Real Cases from Work Part I Introduction to Real Cases from Work Part I Introduction to Real Cases from Work Part I Case 1 – Phantom file (Basic) Case 1 – Phantom file (Basic) Case 1 – Phantom file (Basic) Case 1 – Phantom file (Basic) Case 2 – Copy a new sheet (Basic) Case 2 – Copy a new sheet (Basic) Case 2 – Copy a new sheet (Basic) Case 2 – Copy a new sheet (Basic) Case 3 – Credit card woes (Basic) Case 3 – Credit card woes (Basic) Case 3 – Credit card woes (Basic) Case 3 – Credit card woes (Basic) Case 4 – Quickly insert rows (Basic) Case 4 – Quickly insert rows (Basic) Case 4 – Quickly insert rows (Basic) Case 4 – Quickly insert rows (Basic) Case 5 – Cursor right in data entry (Basic) Case 5 – Cursor right in data entry (Basic) Case 5 – Cursor right in data entry (Basic) Case 5 – Cursor right in data entry (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 6 – Repeat top rows on all pages (Basic) Case 7 – Quick access toolbar (Intermediate) Case 7 – Quick access toolbar (Intermediate) Case 7 – Quick access toolbar (Intermediate) Case 7 – Quick access toolbar (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 8 – Quicker way to sum (Intermediate) Case 9 – Dynamic transpose (Advanced) Case 9 – Dynamic transpose (Advanced) Case 9 – Dynamic transpose (Advanced) Case 9 – Dynamic transpose (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Case 10 – Dynamic Range (Advanced) Continued Case 10 – Dynamic Range (Advanced) Continued Case 10 – Dynamic Range (Advanced) Continued Case 10 – Dynamic Range (Advanced) Continued Summary (Slides 16-18) Summary (Slides 16-18) Summary (Slides 16-18) Summary (Slides 16-18) Supporting Materials 2 lectures 00:00 Slides: Real Cases from Work Excel challenges - Part I - Final Supporting Materials 2 lectures 00:00 Slides: Real Cases from Work Excel challenges - Part I - Final Slides: Real Cases from Work Slides: Real Cases from Work Slides: Real Cases from Work Slides: Real Cases from Work Excel challenges - Part I - Final Excel challenges - Part I - Final Excel challenges - Part I - Final Excel challenges - Part I - Final

Additional information

No Advanced Preparation or Prerequisites are needed for this course Experience with Excel is helpful

EXCEL Challenges: Real Cases from Work (Part I)

£ 10 VAT inc.