Skip to main content
 This program is not active.
Classroom

Excel Skills - The Complete Package


Total Credits: 32.2

Average Rating:
   17
Categories:
Technology
Faculty:
Bryan L Smith, CPA.CITP, CISA |  John H Higgins, CPA.CITP
Course Levels:
Intermediate
Duration:
27 Hours 54 minutes
License:
Access for 90 day(s) after purchase.



Description

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

Faculty

Bryan L Smith, CPA.CITP, CISA's Profile

Bryan L Smith, CPA.CITP, CISA Related Seminars and Products

Virtual CIO

CPA Crossings, LLC


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 H Higgins, CPA.CITP's Profile

John H Higgins, CPA.CITP Related Seminars and Products

Strategic Technology Advisor

CPA Crossings, LLC


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.


Reviews

5
4
3
2
1

Overall:      4

Total Reviews: 17