Microsoft Office Excel was designed to support accounting functions such as budgeting, preparing financial statements and creating balance sheets. It comes with basic spreadsheet functionality and ...

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. You think you know Excel.

Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing ...

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. Pivot tables in Excel allow ...

Brian Beers is a digital editor, writer, Emmy-nominated producer, and content expert with 15+ years of experience writing about corporate finance & accounting, fundamental analysis, and investing.

SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...

When it comes to producing financial statements and reports in Excel, here are a few formatting rules that may help the reports appear more professional. The days of downloading and installing the ...