Nana Firdausi A.

ALT My progress in learning data analysis. Week 2: Tech on Campus. This week I explored Date lookup sheet using the *Fill Series* tool, which allowed me to generate a continuous list of calendar dates from *1/1/2015 to 12/31/2018*—a total of *1,461 days*. These exercises improved my skills in data cleaning, formatting, and setting up structured lookup tables. I now better understand how to prepare and organize data for analysis efficiently in Excel.

ALT This week, I learned how to efficiently manage and organize data in Excel using the Flash Fill feature. Week 2 - Exercise 3 : Tech on Campus. The focus was on simplifying data by merging two separate columns into one column. Then, using Excel’s Flash Fill (Ctrl + E), I automatically filled the remaining cells in the column with full names. This significantly saved time and reduced manual effort. After reviewing and confirming the results, I deleted the original columns to keep the dataset cleaned and more compact. Finally, I used the new Full New column to locate the Customer ID of Walter Prince, which was not there because the name Walter Prince isn't in the Sheet. This exercise helped me understand how Flash Fill improves data preparation and keeps lookup sheets more efficient.

ALT Sure! Here's a simple and clear essay about your progress in learning data analysis using Excel, based on the image: --- *My Progress in Learning Data Analysis Using Excel* As I continue developing my skills in data analysis, one of the most valuable tools I've been learning to use is Microsoft Excel. The screenshot above reflects part of my journey and growth. It shows how I’ve applied various Excel functions to organize and analyze raw data effectively. In this particular file, I worked with an "Orders" dataset. I began by filtering the data to focus on specific entries and understand how different filters can help narrow down large datasets. I also sorted the data by several fields, such as dates and product categories, to identify patterns and trends. To improve the dataset’s readability, I formatted certain columns — such as "Order Date" and "Days for Shipment" — to ensure the data was clean and properly structured. This helped make the analysis smoother and more accurate. O