Total Credits: 32.2
Tags: Classroom CPAX Excel
This classroom is contains a full package of courses on Excel at a bulk discount available exclusively to TXCPA members. If you're looking to improve your Excel skills this is the complete package for you. Beginning with the planning stages, working through formulas and troubleshooting, and finally into best practices and review, this package offers everything you need to know become an expert with Excel.
SKU | Title | RunTime | Credits |
CXOXLS111S2 | Excel 111 - Designing Your Spreadsheets for Maximum Efficiency | 01:41 | 2 |
CXOXLS112S2 | Excel 112 - Format Your Spreadsheets for Maximum Impact | 01:46 | 2 |
CXOXLS121S2 | Excel 121 - Two Must Know Features: Defined Names and Tables | 01:49 | 2 |
CXOXLS122S2 | Excel 122 - Working with Text: Date Time Functions and Formulas | 01:45 | 2 |
CXOXLS123S2 | Excel 123 - Building Powerful Lookup and Reference Formulas | 01:45 | 2 |
CXOXLS124S2 | Excel 124 - Advanced Financial and Statistical Calculations | 01:45 | 2 |
CXOXLS125S2 | Excel 125 - Advanced Spreadsheet Troubleshooting Techniques | 01:51 | 2.2 |
CXOXLS126S2 | Excel 126 - Auditing Your Spreadsheets for Maximum Accuracy | 01:42 | 2 |
CXOXLS133S4 | Excel 133 - Using Pivot Tables for Data Analysis | 03:21 | 4 |
CXOXLS141S2 | Excel 141 - Using Charts for Non-Financial Audience | 01:45 | 2 |
CXOXLS142S2 | Excel 142 - Create KPI Dashboards for Maximum Impact | 01:47 | 2 |
CXOXLS143S2 | Excel 143 - Best Practices Before Final Save | 01:43 | 2 |
CXOXLS201S2 | Excel 201 - Functions and Formula Shootout | 01:43 | 2 |
CXOXLS202S2 | Excel 202 - From a Blank Sheet to a Finished Workbook | 01:44 | 2 |
CXOXLS203S2 | Excel 203 - Feature Review in 100 Minutes | 01:47 | 2 |
27:54 | 32.2 |
Bryan is the co-founder of CPA Crossings, LLC, (est. 2001), which specializes in helping accounting, tax and financial professionals leverage technology to increase the quality and efficiency of their services.
He has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), Bryan has spent considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and provides coaching services to various organizations to train and coach staff on proper data analysis techniques.
Bryan, who has a Master of Science in Information Assurance, is a member of the Information System Audit and Control Association and is a past chair of task forces for the Michigan Association of CPAs
John is the co-founder of CPA Crossings, LLC, established in 2001, which specializes in helping accounting, tax and financial professionals leverage technology to increase the quality and efficiency of their services. John delivers over 100 presentations annually on a wide range of accounting industry related technology topics including Blockchain, big data, data analytics, cloud computing and all things Office 365.
Some of John’s key accomplishments include induction into the AICPA Business & Industry Hall of Fame and selection as a top 25 thought leader for the accounting profession by CPA Practice Advisor magazine from 2011 through 2019. John was a former national technology consulting partner with BDO, LLP and past chair of the Michigan Association of CPAs. John also co-authored the book 10 Steps to a Digital Practice published by the AICPA.
5 |
|
4 |
|
3 |
|
2 |
|
1 |
|
Availability | Module Title | Credits | Course Type | Duration | Course Details | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
At the time of purchase |
Excel 111 - Designing Your Spreadsheets for Maximum Efficiency
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 41 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 112 - Format Your Spreadsheets for Maximum Impact
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 46 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 121 - Two Must Know Features: Defined Names and Tables
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 49 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 122 - Working with Text: Date Time Functions and Formulas
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 45 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 123 - Building Powerful Lookup and Reference Formulas
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 45 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 124 - Advanced Financial and Statistical Calculations
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 45 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 125 - Advanced Spreadsheet Troubleshooting Techniques
|
Total Credits: 2.2 including 2.2 Computer Software & Applications - Non-technical | On Demand | 1 Hour 51 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 126 - Auditing Your Spreadsheets for Maximum Accuracy
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 42 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 133 - Using Pivot Tables for Data Analysis
|
Total Credits: 4.0 including 4.0 Computer Software & Applications - Non-technical | On Demand | 3 Hours 21 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 141 - Using Charts for Non-Financial Audience
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 45 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 142 - Create KPI Dashboards for Maximum Impact
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 47 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 143 - Best Practices Before Final Save
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 43 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 201 - Functions and Formula Shootout
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 43 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 202 - From a Blank Sheet to a Finished Workbook
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 44 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
At the time of purchase |
Excel 203 - Feature Review in 100 Minutes
|
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical | On Demand | 1 Hour 47 minutes | More info » | ||||||||||||||||||||||||||||||||||||||||||||
Total Classroom CE Credits Information |