SCACPA Login

Specialized Knowledge

Technology – Excel (SMTE10/20)

By |2019-12-06T00:18:01-05:00June 18th, 2020||

Microsoft Excel offers a wide range of solutions for your common data input requirements, and now tech guru and SCACPA CEO Chris Jenkins gives you the keys in this very applicable course.
Become familiar with these powerful features:

  • Auto Fill (a command smart enough to figure out almost any series of data you want to continue)
  • Quick Analysis (adds graphical elements to better describe your data)
  • Flash Fill (allows you to take two adjoining cells and combine them in a third)
  • Text to Columns (used to split data into multiple columns)

This is a must-attend for anyone looking to excel in Excel!

Comments Off on Technology – Excel (SMTE10/20)

Technology – Excel (LITE10/20)

By |2019-12-05T23:17:13-05:00June 18th, 2020||

Microsoft Excel offers a wide range of solutions for your common data input requirements, and now tech guru and SCACPA CEO Chris Jenkins gives you the keys in this very applicable course.
Become familiar with these powerful features:

  • Auto Fill (a command smart enough to figure out almost any series of data you want to continue)
  • Quick Analysis (adds graphical elements to better describe your data)
  • Flash Fill (allows you to take two adjoining cells and combine them in a third)
  • Text to Columns (used to split data into multiple columns)

This is a must-attend for anyone looking to excel in Excel!

Comments Off on Technology – Excel (LITE10/20)

Technology – Excel (LITE11R/20)

By |2019-12-05T23:17:14-05:00December 23rd, 2019||

Microsoft Excel offers a wide range of solutions for your common data input requirements, and now tech guru and SCACPA CEO Chris Jenkins gives you the keys in this very applicable course.
Become familiar with these powerful features:

  • Auto Fill (a command smart enough to figure out almost any series of data you want to continue)
  • Quick Analysis (adds graphical elements to better describe your data)
  • Flash Fill (allows you to take two adjoining cells and combine them in a third)
  • Text to Columns (used to split data into multiple columns)

This is a must-attend for anyone looking to excel in Excel!

Comments Off on Technology – Excel (LITE11R/20)

Introduction to Data Analytics with Excel and Power BI (LITE03R/20)

By |2019-12-05T23:22:20-05:00December 23rd, 2019||

In the accounting profession, dealing with data is life. Doing it efficiently and effectively are skill differentiators. Power Query, part of Microsoft Power BI suite, is indispensable for extracting, transforming and loading data (the “ETL” of the commonly referred to ETLR). In this session, we will explore the basics of the Power Query add-in - extracting, transforming and preparing data for analysis

Comments Off on Introduction to Data Analytics with Excel and Power BI (LITE03R/20)