This course is designed for those interested to learn the basics of accounting and bookkeeping as well as initiating commands, understanding features, and applying appropriate cell format and page layout. Read more.
Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Accountants
- Bookkeepers
What you’ll learn:
- Identify key components in Excel body of knowledge or BOK
- List 4 major ways of initiating a command in Excel
- Understand 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
Requirements:
- Microsoft Excel
This course is one of a video series that documents common issues met in working with Microsoft Excel. Each part tends to present 10 cases which have been collected directly from real working environment and are intended to share with professionals using Excel
For these cases to be relevant and organized, the course first provides a unique view of the Body of Knowledge or BOK of Excel created by the instructor, which is a first in the Excel training and publications. The BOK illustrates the usual learning path of an Excel learner, naturally from basic to intermediate, and from advanced to expert levels. The BOK is open ended with the top level embracing all miscellaneous skills and future developments in Excel.
Under the guidance of the BOK, all cases are tallied to the corresponding knowledge level so that our viewers may learn 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, and how to solve them. Also the course encourages contributions from audience who believes 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 will serve as a refresher for all professionals who need to sharpen their Excel skills in their professions.
Learning Objectives:
- Identify key components in Excel body of knowledge or BOK
- List 4 major ways of initiating a command in Excel
- Understand 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
Our Promise to You
By the end of this course, you will have learned accounting and bookkeeping.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.Â
Get started today and learn more about accounting and bookkeeping for professionals.
Course Curriculum
| Section 1 - Excel Challenges | |||
| Introduction And Excel Body Of Knowledge | 00:00:00 | ||
| Phantom File | 00:00:00 | ||
| Copy A Whole Sheet | 00:00:00 | ||
| Credit Card Woes | 00:00:00 | ||
| Quickly Insert Rows | 00:00:00 | ||
| Cursor Right In Data Entry | 00:00:00 | ||
| Repeat Top Rows On All Pages | 00:00:00 | ||
| Quick Access Toolbar | 00:00:00 | ||
| Quicker Way To Sum | 00:00:00 | ||
| Transpose | 00:00:00 | ||
| Dynamic Range Part 1 | 00:00:00 | ||
| Dynamic Range Part 2 | 00:00:00 | ||
| Summary | 00:00:00 | ||
About This Course
Who this course is for:
- Accountants
- Bookkeepers
What you’ll learn:
- Identify key components in Excel body of knowledge or BOK
- List 4 major ways of initiating a command in Excel
- Understand 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
Requirements:
- Microsoft Excel
This course is one of a video series that documents common issues met in working with Microsoft Excel. Each part tends to present 10 cases which have been collected directly from real working environment and are intended to share with professionals using Excel
For these cases to be relevant and organized, the course first provides a unique view of the Body of Knowledge or BOK of Excel created by the instructor, which is a first in the Excel training and publications. The BOK illustrates the usual learning path of an Excel learner, naturally from basic to intermediate, and from advanced to expert levels. The BOK is open ended with the top level embracing all miscellaneous skills and future developments in Excel.
Under the guidance of the BOK, all cases are tallied to the corresponding knowledge level so that our viewers may learn 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, and how to solve them. Also the course encourages contributions from audience who believes 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 will serve as a refresher for all professionals who need to sharpen their Excel skills in their professions.
Learning Objectives:
- Identify key components in Excel body of knowledge or BOK
- List 4 major ways of initiating a command in Excel
- Understand 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
Our Promise to You
By the end of this course, you will have learned accounting and bookkeeping.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.Â
Get started today and learn more about accounting and bookkeeping for professionals.
Course Curriculum
| Section 1 - Excel Challenges | |||
| Introduction And Excel Body Of Knowledge | 00:00:00 | ||
| Phantom File | 00:00:00 | ||
| Copy A Whole Sheet | 00:00:00 | ||
| Credit Card Woes | 00:00:00 | ||
| Quickly Insert Rows | 00:00:00 | ||
| Cursor Right In Data Entry | 00:00:00 | ||
| Repeat Top Rows On All Pages | 00:00:00 | ||
| Quick Access Toolbar | 00:00:00 | ||
| Quicker Way To Sum | 00:00:00 | ||
| Transpose | 00:00:00 | ||
| Dynamic Range Part 1 | 00:00:00 | ||
| Dynamic Range Part 2 | 00:00:00 | ||
| Summary | 00:00:00 | ||
Course Review
4.0
1 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
HELPFUL
Very easy to follow the only part I personally was finding a slight issue using was the Dynamic sections. I learned some shortcuts I didn’t know! Thanks!