Which tools does this course teach for summarizing spreadsheet data?

This course teaches how to create and use data vortices to summarize and analyze spreadsheet data.

Which tool does this course teach for simplifying complex formulas?

This course teaches how to build decision matrices to simplify complex spreadsheet formulas.

Which functions does this course cover for LibreOffice Calc?

This course covers user defined functions and array functions in LibreOffice Calc.

How many CPE credits does this Advanced Spreadsheet Techniques video course provide?

This Advanced Spreadsheet Techniques in LibreOffice Calc video course carries 6.0 CPE credits in Computer Software and Applications as a NonTechnical, self study course, requiring a 30 question final exam preceded by 18 review questions (optional) with a 70% passing score. CPEthink is approved by NASBA as a CPE sponsor and lists this course on the NASBA site as a courtesy for CPAs to search https://nasba.org.

Empty |

Search Courses List > Course Details

Use Landscape to see Search/Filter

Item Types:

Course Type:

Field of Study:

Authors:

CPE Hours:

Keyword:

Course Details

Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) (Video) (Course Id 2277)

QAS / Registry

Author:	L. Keith Jordan, CPA
Course Length:	Pages: 30 \|\|\| Review Questions: 18 \|\|\| Final Exam Questions: 30
CPE Credits:	6.0
IRS Credits:	0
Price:	$89.95
Passing Score:	70%
Course Type:	Video - Text

Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) (Video) - CPE course for CPAs

Technical Designation:	NonTechnical
Field Of Study:	Computer Software & Applications
Approved Audience:	NASBA QAS - NASBA Registry
Key Takeaways:	This video course teaches advanced LibreOffice Calc techniques including data vortices, decision matrices, array functions, and user defined functions. Teaches how to create and use data vortices for analysis and summarization. Explains how to build decision matrices to simplify complex formulas. Covers how array functions work and how to create user defined functions and arrays using code script. Shows how to return an entire array to the spreadsheet in a single statement. Worth 6.0 CPE credits in Computer Software and Applications as a self study video course on advanced spreadsheet techniques in LibreOffice Calc, requiring a 30 question final exam preceded by 18 review questions (optional) and a 70% passing score.
Frequently Asked Questions:	Which tools does this course teach for summarizing spreadsheet data? This course teaches how to create and use data vortices to summarize and analyze spreadsheet data. Which tool does this course teach for simplifying complex formulas? This course teaches how to build decision matrices to simplify complex spreadsheet formulas. Which functions does this course cover for LibreOffice Calc? This course covers user defined functions and array functions in LibreOffice Calc. How many CPE credits does this Advanced Spreadsheet Techniques video course provide? This Advanced Spreadsheet Techniques in LibreOffice Calc video course carries 6.0 CPE credits in Computer Software and Applications as a NonTechnical, self study course, requiring a 30 question final exam preceded by 18 review questions (optional) with a 70% passing score. CPEthink is approved by NASBA as a CPE sponsor and lists this course on the NASBA site as a courtesy for CPAs to search https://nasba.org.
Description:	Part 1 Learn to create and use data vortices for analysis and summarization,;and Learn to create and use decision matrices to simplify complex formulas. Part 2 Learn how LibreOffice Calc array functions work and how to create and use them to enhance your calculations; Learn how to create and use user-defined functions and arrays in code script to gain additional functionality and perform complex operations; and Learn how to return an entire array to the spreadsheet in one statement. In this course we will use LibreOffice Calc for our discussion and demonstrations. The code script language used will be LibreOffice Basic.
Usage Rank:	10000
Release:	2024
Version:	1.0
Prerequisites:	Intermediate knowledge of spreadsheets such as Microsoft Excel, LibreOffice Calc, or Google Sheets Basic knowledge of computer programming is helpful
Experience Level:	Overview
Additional Contents:	Complete, no additional material needed.
Additional Links:	External: The Importance of Excel in Business Internal: Newest Offerings CPE courses page Internal: Updated CPE Courses page External: IRS Continuing Education FAQs for Enrolled Agents
Advance Preparation:	Access to a computer with speakers or headset. Alternatively, access to a computer and a telephone (for audio reception).
Delivery Method:	QAS Self Study
Intended Participants:	Anyone needing Continuing Professional Education (CPE).
Revision Date:	17-Jul-2026
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.
Keywords:	Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) (Video) - CPE course for CPAs
Learning Objectives:	Course Learning Objectives Part 1 Describe the purpose of data vortices and decision matrices, and use them to manipulate spreadsheet data. Part 2 Describe the purpose of user-defined functions and arrays, and use them to manipulate spreadsheet data. Topics Covered: Part 1 Data Vortices Decision Matrices Part 2 User-defined Functions Arrays in spreadsheets Arrays in code script
Course Contents:	Chapter 1 - Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) Chapter 1 Review Questions Glossary of Terms

Click to go to: Computer Software & Applications CPE Courses for CPAs

Click to verify BBB accreditation and to see a BBB report.

Dominic S. from TX bought 1 subscription 12 hours ago. ||| Want A Discount? - Click Here ||| Jenifer M. from TX bought 1 subscription 13 hours ago. ||| Want A Discount? - Click Here ||| Jaimie R. from FL bought 1 course 15 hours ago. ||| Want A Discount? - Click Here ||| Kathie J. from TX bought 1 course 20 hours ago. ||| Want A Discount? - Click Here ||| Zehra Z. from TX bought 1 course 1 day ago. ||| Want A Discount? - Click Here ||| James S. from CO bought 1 course 1 day ago. ||| Want A Discount? - Click Here ||| Jordan T. from IN bought 1 course 1 day ago. ||| Want A Discount? - Click Here ||| Kathie J. from TX bought 1 course 1 day ago. ||| Want A Discount? - Click Here ||| SHIHAO L. from NY bought 1 subscription 1 day ago. ||| Want A Discount? - Click Here ||| Francesca S. from MA bought 3 courses 1 day ago. ||| Want A Discount? - Click Here |||

Advanced Spreadsheet Techniques in LibreOffice Calc (ASTLOC) (Video) (Course Id 2277)

Author:

Course Length:

CPE Credits:

IRS Credits:

Price:

Passing Score:

Course Type:

Technical Designation:

Field Of Study:

Approved Audience:

Key Takeaways:

Frequently Asked Questions:

Which tools does this course teach for summarizing spreadsheet data?

Which tool does this course teach for simplifying complex formulas?

Which functions does this course cover for LibreOffice Calc?

How many CPE credits does this Advanced Spreadsheet Techniques video course provide?

Description:

Usage Rank:

Release:

Version:

Prerequisites:

Experience Level:

Additional Contents:

Additional Links:

Advance Preparation:

Delivery Method:

Intended Participants:

Revision Date:

NASBA Course Declaration:

Keywords:

Learning Objectives:

Course Contents: