excel-learning

Welcome!

This repository contains projects that I have modified to improve and show off my skills in Excel. Before modifications are made, these project files come with basic formatting. Under each project I mention what I have changed in each file. The original project files came from the course Microsoft Excel - Excel from Beginner to Advanced and was made by Kyle Pew.

Excel Files:

Instead of committing Excel workbooks, I am going to share the projects I have via OneDrive.

Project 1:

This is my first project completed ever in Excel. While it does not contain a lot of data, purpose of this project was to use Visual Basic for Applications to activate a macro that users can click on and activate. You can download the file by clicking here.

Here is a few details about the modified workbook:

• Uses a VBA (Visual Basic for Applications) module for the following purposes:
  • Provide a GUI that the user can enter how they want to sort the records in the spreadsheet
  • Sorts the spreadsheet by division (east, north, west, and south)
  • Sorts the spreadsheet by category (advertisng, rent, maintence, etc.)
  • Sorts the spreadsheet by the total price made from previous months
• Has a button to easily use my macro
• Explains how to access the code for those who do not already know how to access VBA within Excel

Project 2:

The purpose of this project was to create a macro using VBA to create headers in the first row across all current and future worksheets in this workbook. You can download the file by clicking here.

Here is a few details about the modified workbook:

• Uses a VBA module for the following purposes:
  • Adds a new line and text above the data in a worksheet
  • Adds formating to the header
  • Allows us to add a header across all and future worksheets in the workbook
• Uses a button to easily use my macro
• Explains how to access the code for those who do not already know how to access VBA within Excel

Project 3:

The purpose of this project was to organize mutliple worksheets into one sheet with one click (a macro using VBA). All while formatting and summing the totals. This also works across all current and future worksheets, as long as there are no extra columns. You can download the file by clicking here.

Here is a few details about the modified workbook:

• Uses a VBA module for the following purposes:
  • Adds tables on a new worksheet based on the data from all other previous worksheets
  • Sums the totals of each table
  • Formats each table
• Explains how to access the code for those who do not already know how to access VBA within Excel
• Uses a button to easily use my macro

Project 4:

This project was the first where the excel worksheet was not made by Kyle Pew. In this project, I have utilized tab delimited text files (provided by Kyle Pew) and imported them via VBA. This is so consumers can import files that were already formated into Excel without having to manually enter in the information. The worksheet and data can be downloaded here.

Here is a few details about my workbook:

• Uses a VBA module for the following purposes:
  • Creates new worksheets based on the tab delimited text files chosen
  • Creates a basic table format from the data
• Explains how to access the code for those who do not already know how to access VBA within Excel
• Uses a button to easily use my macro