steve yoss: an accountant’s detailed guide on databases, integration, and data sharing | quick tech talk

data integration allows you to offer clients a 360 view of their businesses.

quick tech talk
with steve yoss
cpe today

what’s the primary purpose of accounting? it’s decision usefulness. we’re in the business of interpreting information in a way to help business leaders make decisions.

more steve yoss
more tech
goprocpa.comexclusively for pro members. log in here or 2022世界杯足球排名 today.

in today’s complex business environment, we’ve got data coming from all over the place: inventory, accounting, hr, payroll, and more. depending on your business, you can have upwards of 10 different systems inside your organization.

read more →

steve yoss: advanced data visualization techniques in excel | quick tech talk

bring complex financial data to life with advanced visualization techniques.

subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: applegooglespotifyiheartdeezer, amazon music and audibleplayer fmaudacygaana (india), and boomplay (africa).

quick tech talk
with steve yoss
cpe today

have you ever checked out microsoft power bi? it’s microsoft’s business intelligence and visualization tool. it can take any type of structured and digital data and turn it into beautiful interactive dashboards.

more steve vossmore techmore podcasts

goprocpa.comexclusively for pro members. log in here or 2022世界杯足球排名 today.

it’s difficult for most non-accounting folks to read a balance sheet or make sense of a cash flow statement. what’s beautiful about tools like power bi or tableau is that they can take your financial data, bring it to life, and allow decision-makers to get the information they need in the way that they want to receive it.

read more →

steve yoss: charting, graphing, and mapping data made easy | quick tech talk

depending on the information you’re sharing, you’ll want to select the right imagery. 

quick tech talk
with steve yoss
cpe today

tools like microsoft excel, power bi, tableau, and others are loaded with different visualizations that you can use: charts, bar graphs, maps, just to name a few. in fact, excel probably has at least two dozen different types of charting and graphing formats.

more steve yoss
more tech
goprocpa.comexclusively for pro members. log in here or 2022世界杯足球排名 today.

did you know different charts tell different stories? for example, a pie chart compares parts against the whole. it’s important that we choose the right chart for the analysis we’re doing. if we wanted, for example, to analyze revenue by different business units, that pie chart would be really effective, but something like a scatterplot might not be.

read more →

steve yoss: connect, transform, and analyze data like a pro with power query basic | quick tech talk

integrate information systems, but don’t ignore your gut.

quick tech talk
with steve yoss
cpe today

how do you ensure data integrity when you’re working with multiple disparate systems that you want to ultimately pull together and have talked to each other?

you’ll always want to make sure that you have a system of record: one system inside your organization that’s kind of the master control over everything else inside your company. it could be quickbooks, your erp platform, a custom database, or something else. but ideally, all other systems inside your company take their cues from that one master system.

read more →

steve yoss: advanced techniques in powerpoint for financial presentations | quick tech talk

save time and reduce errors by linking data across applications.

quick tech talk
with steve yoss
cpe today

did you know that you can link data from excel into powerpoint, word, and other microsoft office applications?

more steve yoss
more tech
goprocpa.comexclusively for pro members. log in here or 2022世界杯足球排名 today.

you can prepare your financial information, balance sheet, income statement, or whatever else inside excel. you could then paste it directly into your next powerpoint presentation, word document, or anything else. but the trick is not to paste and leave it there but to paste and link it.

read more →

predicting the future with forecasts.ets statistical analytics in microsoft excel

quick tech talk: financial forecasting the fun and easy way.

subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: applegooglespotifyiheartdeezer, amazon music and audibleplayer fmaudacygaana (india), and boomplay (africa).

quick tech talk
with steve yoss
cpe today

one of my favorite tools is microsoft excel, the swiss army knife of any financial professional. did you know that you can easily do budgeting and forecasting inside excel?

more steve yoss here

in fact, forecasting has never been easier than using the forecast ets function.

read more →

steve yoss, quick tech talk: creating powerful and effective presentations using microsoft powerpoint

knock your next presentation out of the park with powerpoint tools and tricks.

subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: applegooglespotifyiheartdeezer, amazon music and audibleplayer fmaudacygaana (india), and boomplay (africa).


quick tech talk
with steve yoss
cpe today

powerpoint is incredibly useful for crafting a message and getting that point across to your audience. i use powerpoint all the time to design and curate content to present to audiences to help them understand how to better use accounting and technology in their day-to-day work.

read more →

steve yoss: it’s time for a.i. to do the heavy lifting

the robots are here. put them to work.

subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: applegooglespotifyiheartdeezer, amazon music and audibleplayer fmaudacygaana (india), and boomplay (africa).

quick tech talk
with steve yoss
cpe today

there are so many incredible artificial intelligence (ai) tools out there. some of the leading companies in this space will be openai, microsoft, google, facebook, et.al. you know, the normal big technology firms. however, several really interesting and useful niche ai applications are popping up, many of which are inside the accounting space and other financial sectors.

click here for more steve yoss

now, these tools can be awesome because they can take tremendous quantities of data, process them in a meaningful way, almost in the blink of an eye, and give you the key insights you can use to know what’s happening inside your business. i like to say it helps you find hidden nuggets of wisdom, those little needles in the haystack that are not observable when you’re just looking at one or a week’s transaction. rather, we will see certain trends emerge when you look at potentially 1000s or even millions or more transactions. frankly, that’s not possible for a human to do. we can’t keep it all in our heads. but guess what, these ai tools can leverage large language models, generative ai, machine learning and more. they can do the heavy lifting for you. so you’re still in the driver’s seat interpreting that information, making it useful and meaningful for your client. but you’ve got these robot workers that can do the heavy lifting to save you a bunch of time.