Managing Inventory for Small Business

Instructions for Enabling Macros in Excel Workbook

Step 1: Downloading the Workbook

1. Clone or download the entire repository containing the Excel workbook to your local machine.
2. Locate the file named [Name of Your Excel Workbook].
3. Save the file to a folder of your choice.

Step 2: Enabling Macros

1. Open Microsoft Excel on your computer.
2. Click on the "File" tab in the Excel ribbon menu.
3. Select "Options" from the left-hand sidebar to open the Excel Options window.
4. Within the Excel Options window, click on "Trust Center" in the left-hand sidebar.
5. Click on the "Trust Center Settings" button on the right side of the window.

Step 3: Adjusting Macro Security Settings

1. In the Trust Center window, select "Macro Settings" from the left-hand sidebar.
2. Choose the option that enables macros. We recommend selecting either "Enable all macros" or "Disable all macros with notification." The latter option will display a warning each time you open the workbook but still allow you to enable macros.
3. Ensure that the "Trust access to the VBA project object model" option is also enabled.

Step 4: Opening the Excel Workbook

1. Locate the folder where you saved the downloaded Excel workbook.
2. Double-click on the file [Name of Your Excel Workbook] to open it in Excel.
3. You may see a security warning stating that macros have been disabled. Please proceed to the next step to enable macros.

Step 5: Enabling Macros in the Workbook

1. Click on the "Enable Content" button that appears in the yellow security warning bar at the top of the workbook.
2. You should now see the userform and be able to interact with it.

Sales Data Analysis

Welcome to the Sales Data Analysis repository! This project focuses on analyzing sales data for a company that sells various products across different regions. The goal is to gain insights into the company's performance and provide actionable recommendations to improve sales and profitability.

Case Study Summary

The Sales Data Analysis project involves the following key steps:

1. Data Cleaning: The raw sales data is cleaned by identifying and correcting inconsistencies and errors. This ensures that the subsequent analysis is based on accurate and reliable information.

2. Data Aggregation: The cleaned data is then aggregated to create a summary of sales by product and region. This provides a consolidated view of sales performance, enabling a better understanding of the company's market reach.

3. Data Analysis: The aggregated data is analyzed to identify top-selling products, high-performing regions, and trends. Through this analysis, valuable insights are gained regarding the company's sales performance and areas of potential improvement.

4. Actionable Recommendations: Based on the data analysis, actionable recommendations are formulated to enhance the company's sales and profitability. These recommendations serve as guidance for the company's management to make informed decisions and implement effective strategies.