TechRepublic

How to calculate conditional rank in Excel

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...
Houston Chronicle

How to Make an Inventory Using Excel

Just about everyone knows Microsoft Excel is a great tool for doing fast calculations in a worksheet. What small business owners don't know is that Excel can also count. Regardless of what kind of ...
TechRepublic

How to generate random text using the RANDARRAY() function in Excel

How to generate random text using the RANDARRAY() function in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems ...
Investopedia

How Do I Calculate Fixed Asset Depreciation Using Excel?

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...