Google Sheets Expert | Excel | Data Analyst

Conditional formatting: Changes the appearance of a cell based on certain conditions, such as highlighting negative numbers in red. COUNTIF: Counts the number of cells that meet certain criteria, such as the number of vacation days employees used in a given month. Pivot tables: A tool for comprehensive data analysis. VLOOKUP: A basic Excel function. Concatenate: A basic Excel function. Text to columns: A basic Excel function. Remove duplicates: A basic Excel function. INDEX-MATCH and array formulas: Complex formulas. Advanced charting: A tool for dynamic data visualization. Data validation: A tool for error-free data entry.

Data Analysis: Proficient in data cleaning, validation, and statistical analysis. Google Sheets: Skilled in advanced functions (e.g., QUERY, VLOOKUP, INDEX-MATCH), scripting, and add-ons. Data Visualization: Experienced in creating charts, dashboards, and interactive reports using Google Sheets and Power BI. Problem-Solving: Capable of identifying trends, uncovering insights, and delivering innovative solutions to business challenges. Collaboration: Effective communicator, able to work cross-functionally and present findings to diverse audiences.

Attention to detail, proficiency with data entry software (like Excel), organizational skills, time management, ability to research and collect data, good communication skills, and a high level of concentration; essentially, the ability to input large volumes of data quickly and accurately while maintaining data integrity through careful review and proper organization.

Data transformation and cleaning, creating basic visualizations like charts and graphs, building simple reports, understanding data modeling concepts, and effectively navigating the Power BI interface to analyze and present data in a clear manner.