Excel 111 - Designing Your Spreadsheets for Maximum Efficiency
Total Credits: 2.0 including 2.0 Computer Software & Applications - Non-technical
- Average Rating:
- 3
- Categories:
- Partner Produced | Technology
- Faculty:
- Bryan L Smith, CPA.CITP, CISA | John H Higgins, CPA.CITP
- Course Levels:
- Basic
- Duration:
- 1 Hour 41 minutes
- License:
- Access for 90 day(s) after purchase.
Tags: CPAX CPAX Excel
Description
This course is designed to help you get up and running with Excel quickly and efficiently. Even if you have used Excel for years but never learned the fundamentals of good spreadsheet design, this course will get you on track in that direction. Microsoft Excel is one of the most powerful programs available. It includes many time-saving techniques that most business professionals haven’t put into practice. We will move at a methodical pace so that you can try out your new skills during the session. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.
Learning Objectives:
- Use Excel more efficiently and effectively
- Design spreadsheets having greater meaning
- Create accurate calculations
Program Content:
- Excel and its user interface
- Basic tasks (fill command, range selection, quick entry)
- Creating formulas (absolute/relative reference, copying and pasting, auto-complete)
Who should attend: Anyone using Excel or anyone who wants to learn the key concepts and benefits of using Excel
Course Code: CXOXLS111S2
Course Name: Excel -Designing Your Spreadsheets for Maximum Efficiency
Developed By: CPA Crossings, LLC
Instructor: Bryan L. Smith, CPA.CITP, CISA
Prerequisites: None
Advanced Preparation: None
Program Level: Basic
CPE Credit: 2.0
Course Materials
| Designing Spreadsheets Glossary (481.9 KB) | Available after Purchase | ||
| Designing Spreadsheets Practice Materials v1.3 (98.4 KB) | Available after Purchase | ||
| Course Description (106.7 KB) | Available after Purchase | ||
| Designing Spreadsheets Handout V1.42 (1.4 MB) | Available after Purchase | ||
Faculty
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 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 |
|