Topics Covered Throughout the Year
Brief Bio
A brief bio is a short summary that introduces a person by highlighting key information about them. It’s usually just a few sentences long and focuses on the most relevant details for the context.
Logo
A logo is a visual symbol or design that represents a brand, organization, product, or individual. It often includes text, images, or a combination of both and is a key part of brand identity.
Favicon
A favicon is a small icon associated with a website. It usually appears in browser tabs, bookmarks, address bars, and browser history next to the site’s name. A favicon is a small detail that plays a big role in usability, branding, and credibility.
Excel Topics Throughout the Year
Addressing
Absolute
Absolute addressing keeps the cell reference fixed even when the formula is copied. It is commonly used when a constant value is needed in multiple calculations.
Relative
Relative addressing changes cell references when a formula is copied to another cell. It is useful when the same calculation is repeated across rows or columns.
XLookup
XLookup searches for a value in a range and returns a matching result from another range. Its benefits include greater flexibility, easier formulas, and the ability to look up values in any direction without errors from column changes.
Filter Function
The Filter function in Excel extracts data that meets specific criteria from a range or table. Its benefits include quickly displaying only relevant information and making data analysis more efficient.
Pivot Tables
A Pivot Table in Excel is a tool that summarizes, organizes, and analyzes large amounts of data quickly. Its benefits include easily spotting trends, comparing values, and creating dynamic reports without changing the original data.
Excel Part of Final Project
My data consists of the current 50 US governors, including their name, age, gender, and political party. To obtain my data I used Google Gemini.
Questions I Investigated
What is the median age of each person?
Out of all 50 governors, how many are Democrats compared to Republicans?
What is the youngest age? What is the oldest age?