0
| Author : | Patricia McCarthy, MBA |
| Course Length : | Pages: 30 ||| Review Questions: 3 ||| Final Exam Questions: 5 |
| CPE Credits : | 1.0 |
| IRS Credits : | 0 |
| Price : | $12.95 |
| Passing Score : | 70% |
| Course Type: | NASBA QAS - Text - NASBA Registry |
| Primary Subject-Field Of Study: | Computer Software & Applications - Computer Software & Applications for Course Id 1794 |
| Description : |
This course overviews some new features and functions that Microsoft offers in Excel 2019 and/or Microsoft 365. The eBook has an accompanying workbook that you can work through along with an answer sheet. Please make sure that you have the proper Excel version or some or all of these functions will not be available to you. If you are not sure, go to Excel and try typing in an equal sign and then one of the new functions listed here. If the function does not start to display then you probably do not have access to it. Even if you do not have access to the new functions the course is worthwhile as you can use it to determine if you should upgrade to a newer Excel version. |
| Usage Rank : | 0 |
| Release : | 2021 |
| Version : | 1.0 |
| Prerequisites : | You need Excel 2019 and/or Office365 to use these functions. Click on Account in Excel and it will show you what version you have. Please read last paragraph of course description. |
| Experience Level : | Overview |
| Additional Contents : | Complete, no additional material needed. |
| Additional Links : |
Excel dynamic arrays, functions and formulas
|
| Advance Preparation : | None. |
| Delivery Method : | QAS Self Study |
| Intended Participants : | Anyone needing Continuing Professional Education (CPE). |
| Revision Date : | 17-Feb-2021 |
| NASBA Course Declaration : | Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam. |
| Approved Audience : | NASBA QAS - Text - NASBA Registry - 1794 |
| Keywords : | Computer Software & Applications, Dynamic, Array, Formulas, Other, New, Excel, Functions, cpe, cpa, online course |
| Learning Objectives : |
Course Learning Objectives Upon completion of this course, you should be able to:
|
| Course Contents : | Chapter 1 - Dynamic Array Formulas and Other New Excel Functions Course Learning Objectives Prerequisites New Features and Functions in Excel Overview of New Functions DYNAMIC ARRAYS SORT() SORTBY() FILTER() Multiple Filters Review Exercise Advanced TRY-IT Exercise (Optional) UNIQUE() UNIQUE() and Hashtag # SEQUENCE () RANDARRAY() XLOOKUP() Conclusion- Dynamic Arrays Review Questions Overview- Text Functions Joining Text Ampersand CONCATENATE() CONCAT() TEXTJOIN() Other New Functions IFs FUNCTION SWITCH THE PLURALS Review Question Link for Spreadsheet Glossary |
Login/Register