Blog Search

Excel Hacks for Accountants from Millennial Pros: Volume 6

Need help understanding the conditional formatting tool in Excel? Thankfully, Ben has given us a step-by-step guide on how to manipulate our data easily.
By Ben Cotlar, Audit Supervisor If you deal with Excel regularly, then you are probably searching for a quick and easy way to add immediate visual clarity to your spreadsheets.… https://www.weinsteinspira.com/blog/2018/11/excel-hacks-accountants-millennial-pros-volume-6/

Excel Hacks for Accountants from Millennial Pros: Volume 5

You’ve probably heard a lot about pivot tables, but why and how do you use them? Ben is here to show you the ropes in our new Excel Hacks blog post.
By Ben Cotlar, Audit Supervisor Frequent users of Excel are routinely looking for ways to condense an enormous volume of data into useful information. Proficiency with… https://www.weinsteinspira.com/blog/2018/10/excel-hacks-accountants-millennial-pros-volume-5/

Excel Hacks for Accountants from Millennial Pros: Volume 4

Are you tired of switching between tabs on your single Excel workbook? Want the ability to calculate backward? Fortunately, Microsoft Excel now has functions to solve these demands. In our newest addition to the Excel Hacks series, Travis will be showcasi…
by Travis Aguirre, Audit Senior Are you tired of switching between tabs on your single Excel workbook? Want the ability to calculate backward? Fortunately, Microsoft Excel now… https://www.weinsteinspira.com/blog/2018/09/excel-hacks-accountants-millennial-pros-volume-4/

Excel Hacks for Accountants from Millennial Pros: Volume 3

This month, after fielding questions from clients who were hoping to better understand data, Betsy Calvillo brings you “IsNumber” and “Text to Columns.”
How often do you receive Excel spreadsheets from coworkers, clients or partners that have your head spinning? Incomplete or confusing spreadsheets often can result in incomplete… https://www.weinsteinspira.com/blog/2017/12/excel-hacks-accountants-millennial-pros-volume-3/

Excel Hacks for Accountants from Millennial Pros: Volume 2

Excel isn’t simply a tool for accountants. We hope you’ll find these hacks helpful within your own industries, roles and workplaces.
With an office full of accounting professionals that spend more time in Excel than we’d like to admit to ourselves, we’ve racked up quite the toolbox of best practices in the… https://www.weinsteinspira.com/blog/2017/10/excel-hacks-accountants-millennial-pros-volume-2/

Excel Hacks for Accountants from Millennial Pros

It’s true what they say about accountants. We practically live in Microsoft Excel. In our new series, we will be bringing you, easy-to-learn “hacks” based on questions our clients often ask or positions we often find ourselves in during our work days.
It’s true what they say about accountants. We practically live in Microsoft Excel. We learned the basics as part of our collegiate and post-graduate training, but it’s in the… https://www.weinsteinspira.com/blog/2017/09/excel-hacks-accountants-millennial-pros/