Excel Primer: Data Analytics Show Me How Office 365 Horizontal Analysis Completing this activity will help you learn to: Evaluate a company's performance using horizontal analysis. Extract information from a data set using Excel formulas, functions, and/or pivot tables. Scenario: Company A has three divisions: 1,2 , and 3 . Each division prepares its own financial reports using the same financial statement templates. The Data worksheet contains a list of 2023 and 2022 account balances that relate to these divisions. Each row provides information about one account in one of the two years and in one of three divisions. Other information includes account type, financial statement where the account is reported, and account balance