Gain insight into applicable Excel® fundamentals that will improve the accuracy and efficiency of your spreadsheets.
In this comprehensive topic, you will learn applicable Excel® fundamentals that will enable accounting professionals to achieve those goals. Step-by-step, this information demonstrates and explains several alternatives to Excel’s® SUM function, including conditional summing; a better alternative to manually hiding/unhiding rows and columns; automating repetitive tasks by way of Excel’s® Table feature, including creating self-expanding charts; contrasting the Table feature with Data Tables and PivotTables; helpful keyboard shortcuts; and ways to repair damaged Excel® workbooks. This topic demonstrates every technique at least twice: first, on a PowerPoint® slide with numbered steps, and second, in the subscription-based Office 365® version of Excel®. Your attention is drawn to any differences in the older versions of Excel® (2019, 2016, 2013, and earlier) during this topic. An Excel® workbook is provided that includes most of the examples used. Office 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel® have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel® 2019, Excel® 2016, and so on.
- You will be able to define the argument within Excel’s® SUBTOTAL function that sums columns or rows.
- You will be able to identify which versions of Excel® permit using slicers with both tables and pivot tables.
- You will be able to discuss the command that you use to active Quick Access Toolbar shortcuts.
- You will be able to describe the steps to take if you can’t open a damaged workbook.