Course Library
We're sorry, but we couldn't find any results that match your search criteria. Please try again with different keywords or filters.
Loading
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 9 - 12 credits
Description:
The second course in the series builds upon the solid foundation of Volume 1 and explores ways to build efficient formula-based reporting workbooks.Delivery Method:
- QAS Self Study
Location:
- AK
- AL
- American Samoa
- AR
- AS
- AZ
- CA
- CNMI
- CT
- CO
- DC
- DE
- FL
- GA
- GU
- HI
- IA
- ID
- IL
- IN
- KS
- KY
- LA
- MA
- MD
- ME
- MI
- MN
- MO
- MS
- MT
- NC
- ND
- NE
- NH
- NJ
- NM
- NV
- NY
- OH
- OK
- OR
- PA
- PR
- RI
- SC
- SD
- TN
- TX
- UT
- VA
- VI
- VT
- WA
- WI
- WV
- WY
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 13 - 16 credits
Description:
The third course in the series picks up right where Volume 2 leaves off and demonstrates how to replace formula-based reports with PivotTable reports when appropriate. We also consider the Excel repor ...Delivery Method:
- QAS Self Study
Location:
- AK
- AL
- American Samoa
- AR
- AS
- AZ
- CA
- CNMI
- CT
- CO
- DC
- DE
- FL
- GA
- GU
- HI
- IA
- ID
- IL
- IN
- KS
- KY
- LA
- MA
- MD
- ME
- MI
- MN
- MO
- MS
- MT
- NC
- ND
- NE
- NH
- NJ
- NM
- NV
- NY
- OH
- OK
- OR
- PA
- PR
- RI
- SC
- SD
- TN
- TX
- UT
- VA
- VI
- VT
- WA
- WI
- WV
- WY
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 17 - 20 credits
Description:
The fourth installment in the Excel University series covers the Excel features, functions, and techniques that will help you build reliable workpapers. The items covered in this volume will help impr ...Program Level:
BasicDelivery Method:
- QAS Self Study
Location:
- AK
- AL
- American Samoa
- AR
- AS
- AZ
- CA
- CNMI
- CT
- CO
- DC
- DE
- FL
- GA
- GU
- HI
- IA
- ID
- IL
- IN
- KS
- KY
- LA
- MA
- MD
- ME
- MI
- MN
- MO
- MS
- MT
- NC
- ND
- NE
- NH
- NJ
- NM
- NV
- NY
- OH
- OK
- OR
- PA
- PR
- RI
- SC
- SD
- TN
- TX
- UT
- VA
- VT
- WA
- WI
- WV
- WY
-
Field of Study:
- Computer Software and Applications
Description:
In this practical webinar, Excel expert, David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. You will learn what can go awry with the IF function ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Description:
In this practical webinar, Excel expert, David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. You will learn what can go awry with the IF function ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this practical webinar, Excel expert, David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. You will learn what can go awry with the IF function ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Finance
Description:
Excel VBA for Finance Course Overview This course will teach you the fundamentals of Excel VBA and is perfect for finance professionals who are comfortable with Excel and want to expand their knowledg ...Program Level:
IntermediateDelivery Method:
- QAS Self Study
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
This course offers many tips for created well-structured Excel worksheets that are easy to follow, with a minimum of calculation errors. The course provides step-by step-instruction and Excel practice ...Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Remember when you went to update last year’s budget projections and you wondered why certain formulas were there? Have you ever opened up a spreadsheet that someone else created and wondered “What the ...Program Level:
OverviewDelivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- QAS Self Study
-
Credit Hours:
- 1 - 4 credits
Description:
Excel worksheets and workbooks are commonly considered number crunching tools. The primary focus is getting data into a worksheet, performing a few calculations, and arriving at an answer as quickly a ...Program Level:
OverviewDelivery Method:
- QAS Self Study
-
Excel- Power Query - No Code Automation Every User Needs to Know About - Part 1
28-Oct-2022 MY-CPE LLCField of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files, and web pages?Does the phrase "it's taking too long" describe how you feel abou ...Delivery Method:
- QAS Self Study
-
Excel- Power Query - No Code Automation Every User Needs to Know About - Part 2
09-Mar-2023 MY-CPE LLCField of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
This is a follow-on CPE webinar to " Excel - Power Query – No Code Automation Every User Needs – Part 1" and covers the key advanced features of Excel’s Query Editor, designed to help you transform im ...Delivery Method:
- QAS Self Study
-
Credit Hours:
- 1 - 4 credits
Description:
Microsoft Excel includes a number of functions to enhance the budgetary process. Using illustrative examples, instructor Carlton Collins demonstrates how to use Excel as the foundation for developing ...Delivery Method:
- Group Internet Based
-
Field of Study:
- Specialized Knowledge
Description:
This course identifies major problems and solutions specifically related to presenting quantitative information in PowerPoint.Delivery Method:
- QAS Self Study
-
Field of Study:
- Personal Development
Credit Hours:
- 1 - 4 credits
Description:
This course identifies major problems and solutions specifically related to presenting quantitative information in PowerPoint.Delivery Method:
- QAS Self Study
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
This course identifies major problems and solutions specifically related to presenting quantitative information in PowerPoint.Delivery Method:
- QAS Self Study
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
This course identifies major problems and solutions specifically related to presenting quantitative information in PowerPoint.Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this webinar, you’ll learn how to use Power Query and Power Pivot to work with, analyze and generate reports from large datasets. Upon completion of this course, you’ll be able to: Use Power Pivot ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
Location:
- VA
-
Field of Study:
- Computer Software and Applications
Description:
ou will learn how to: Use the SUMIFS function to sum values for a single account or a range of account numbers Explore the nuances of data exported from accounting programs, such as extraneous workshe ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
Location:
- VA
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
This webinar introduces the concept of “Data Visualization” in Microsoft Excel. You’ll learn how to use Excel to present data in the best manner possible. Upon completion of the course you’ll be able ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
This webinar introduces the concept of “Data Visualization” in Microsoft Excel. You’ll learn how to use Excel to present data in the best manner possible. Upon completion of the course you’ll be able ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
This webinar introduces the concept of “Data Visualization” in Microsoft Excel. You’ll learn how to use Excel to present data in the best manner possible. Upon completion of the course you’ll be able ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Description:
You will learn how to: Use dynamic array formulas and resize an amortization table based on changing the loan term. Prevent dynamic arrays from resizing by using wrapper functions. Integrate the SEQUE ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- Group Internet Based
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
Location:
- VA
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
Location:
- VA
-
Field of Study:
- Computer Software and Applications
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems cant generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you ...Delivery Method:
- Group Internet Based
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems cant generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you ...Delivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
beginnerDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
BasicDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
Location:
- VA
-
Field of Study:
- Computer Software and Applications
Description:
Accountants often turn to Excel when their usual accounting systems can’t generate the report they need. But manually preparing a report in Excel can be time-consuming. In this practical webinar, you’ ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this webinar, you’ll learn productivity tips and tricks for Microsoft Excel. This course is designed to put Excel into a productive state (because it's broken) and teach productivity tips and trick ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this webinar, you’ll learn productivity tips and tricks for Microsoft Excel. Upon completion of the course, you’ll be able to: Describe how to setup up a custom Quick Access toolbar Apply the 5 Sup ...Program Level:
BeginnerDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Specialized Knowledge
Credit Hours:
- 1 - 4 credits
Description:
Have you ever asked yourself which chart should you use? column chart? line chart? bar chart? In this Webinar, I will demonstrate how to use the appropriate chart for the data on hand. I will walk you ...Delivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
Delivery Method:
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Description:
In this practical webinar, you will learn techniques from Excel expert, David Ringstrom, CPA that you can use to verify the integrity of even the most complicated Excel spreadsheets. Among other thing ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this webinar, you’ll learn Excel tips and tricks to navigate through large spreadsheets with a high volume of data. Upon completion of the course, you’ll be able to use Excel features and functions ...Program Level:
BasicDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this webinar, you’ll learn Excel tips and tricks to navigate through large spreadsheets with a high volume of data. Upon completion of the course, you’ll be able to use Excel features and functions ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this practical webinar, you will learn the most common and useful formulas in Excel, including: VLookup HLookup Text to Columns Concatenate Remove Duplicates Upon course completion, you will be abl ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
-
Field of Study:
- Computer Software and Applications
Credit Hours:
- 1 - 4 credits
Description:
In this practical webinar, you will learn the most common and useful formulas in Excel, including: VLookup HLookup Text to Columns Concatenate Remove Duplicates Upon course completion, you will be abl ...Program Level:
IntermediateDelivery Method:
- Group Internet Based
- QAS Self Study
27257 Results