###Transitioning into Tech💻 Since I've demonstrated my happiness and contentment in the business world, I know a lot of people are wondering why I decided to make the transition into technology. This is because I think that developing my technological talents and fusing them with my business acumen will set me apart in the job market and provide me with flexibility. In addition, I've developed a strong interest in technology and a curiosity about how the modern world operates. Modern life is powered by technology in every way. The quality of life is enhanced by technology. It makes things simpler and relieves tension and stress. I'm an inquisitive individual who wants to know everything there is to know. That was my original motivation for standing out: I also want to make a significant contribution to the world in my special way. Technology has, in my opinion, substantially enhanced the corporate environment, and the combination is excellent. Even though I am aware that it will take a lot of time and effort for me to become an expert, I am committed to being a part of it.

###Current Learning Journey🏃 🕐Project Management##: Project management was the first course I took on Udemy. It taught me a lot of things. It gave me a lot of insight into how to better organize tasks at work, particularly when utilizing a Gantt chart. Although I didn't learn this in the classroom, I will be able to apply it and perform unclear duties flawlessly in the future thanks to the additional information I received from that course.

💻Python###: I went on to enroll in a Python course right away. I'll admit that at the time, I found this course to be overbearing. The concepts and methods were somewhat unclear for me as a novice. Despite my achievement in finishing the course and receiving a certificate, there are still many ideas and methods that I find difficult to grasp. At the first hint of trouble, I became terrified and started looking for solutions. I came onto the concept of "personal projects”. ​​For someone like myself who is just starting, personal projects are the finest approach to improving learning. This way I can move forward and continue to develop as a Python programmer. I'll be posting my practice attempts here so other programmers may see them and provide feedback. I'm quite receptive to ideas and will be fully committed to this cause.

😆Excel: I'm taking a Microsoft Excel course right now on Udemy. Not long after finishing my Python course, I started this one. I'm taking this course because I think Excel knowledge is crucial. I'm not aware of this fundamental ability. It will be of tremendous use to me in the future while handling management initiatives as well as in areas such as data analysis, financial analysis, technical sales, etc. An increasing amount of areas demand proficiency with Excel, and I'm glad I'm learning it. It's inevitable for a beginner to encounter difficulties. Many ideas are difficult for me to understand, so I've created a checklist of the ones I find difficult to tackle along the road. I'll also post some of my failed attempts at using Excel here for comments.

###What I’ve learned so far👓### ❤️Patience and resilience are the two most valuable lessons I have learned thus far on this journey. Deciding to set out on an unfamiliar journey is not simple. At first, I was nervous and avoided making the choice repeatedly. Later, I concluded that the emotion was just a part of it and that this was an investment that would pay off for me in the years to come. As someone who always aims to be the best they can be, I found the conclusion to be rather familiar. Self-improvement is always a wonderful idea. Throughout my learning process, I have encountered difficulties with a variety of ideas and approaches, but I have decided to persevere. I often feel overpowered, but I always stop, take a break, and keep going. I've accepted the path and am aware that perseverance and patience are crucial qualities that will help me get through it and achieve flawless outcomes in the process.

Additionally, this approach has taught me to be open and honest. Given that I was still a beginner, I had extreme anxiety and felt under tremendous pressure to develop my abilities before putting myself out there, but perfection is a myth. Should I pretend to be someone I'm not to learn from my mistakes? How will those who are more skilled than me get in touch with me to share advice and pointers that will help me advance? After realizing this, I decided that being transparent was the best course of action, which is why I have decided to accurately and completely document my journey.

##What I plan to work on👷 This is an outline of skills that I plan to acquire in the upcoming months. I will use this as a guide as I learn, and I am completely aware that things take time. I have no intention of rushing the process. As time goes on, it will also be updated and modified.

###Roadmap for My Learning Journey***

🗒️Short-Term Goals (Next 1-3 Months)*** 💻Excel***:

1. Master Basic Formulas and Functions: Focus on mastering essential formulas like VLOOKUP, SUMIF, and logical functions (IF, AND, OR).
2. Create a Personal Budgeting Spreadsheet: Build a simple budgeting tool to manage personal finances, incorporating basic formulas and charts.
3. Build an Interactive Dashboard: Develop a dashboard to visualize data, using pivot tables, charts, and slicers for dynamic reporting. 📓Python***:
4. Write Simple Scripts for Automation: Start by writing small scripts that automate repetitive tasks, such as renaming files or sending automated emails.
5. Analyze Data with Python: Learn to use libraries like pandas for basic data manipulation and matplotlib for simple data visualization.
6. Develop a Basic Calculator: Create a command-line calculator that handles basic arithmetic operations. 🕴️Business-Tech Integration***: 😸Course: Data Analysis with Excel & Python: Enroll in a beginner course that introduces data analysis using both Excel and Python, helping to bridge your business and tech skills.

🗒️Medium-Term Goals (Next 4-6 Months)*** ##Excel:

1. Explore Advanced Data Visualization Techniques: Dive deeper into Excel’s advanced charting features and learn to create complex, multi-layered charts.
2. Learn Power Query: Start using Power Query for data extraction, transformation, and loading (ETL) tasks, making it easier to work with large datasets.
3. Build a Sales Dashboard: Develop a dynamic sales dashboard that tracks KPIs and sales performance across multiple regions or products. 📉Python:
4. Manipulate Data with Pandas: Get comfortable with pandas for more advanced data manipulation tasks, such as data cleaning, aggregation, and merging.
5. Create a Web Scraping Script: Write a Python script that scrapes data from websites and stores it in a structured format for further analysis.
6. Develop a Simple Web Application: Use a framework like Flask to build a basic web app that allows users to input data and see results on a webpage.

📊 SQL:

Learn Basic SQL Queries: Start by learning how to retrieve and manipulate data with SQL queries using SELECT, WHERE, JOIN, and GROUP BY. Integrate SQL with Python: Learn how to use libraries like SQLite3 or SQLAlchemy to interact with databases using Python scripts. Build a Simple Database and Query It: Set up a small database, such as a customer sales database, and write queries to analyze the data. 📉 Python & Data Integration:

Manipulate Data with Pandas: Get comfortable with pandas for more advanced data manipulation tasks, such as data cleaning, aggregation, and merging. Create a Web Scraping Script: Write a Python script that scrapes data from websites and stores it in a structured format for further analysis.

📝Business-Tech Integration: Course##: Business Analytics with Python: Take a course that focuses on applying Python to solve business problems, such as forecasting, trend analysis, and optimization. Course**: Financial Modeling and Valuation: Enhance your Excel skills by learning to build financial models that can be automated or enhanced with Python.

📝Long-Term Goals (6+ Months)## Excel & Python Integration**:

1. Automate Excel with Python: Combine your skills by using Python to automate complex Excel tasks, such as generating reports, updating data, and performing repetitive analysis. Develop a Comprehensive Business Data Analysis Project: Undertake a project where you analyze real business data using both Excel and Python and present your findings in a comprehensive report or dashboard.
2. Create an Excel Add-In with Python: Develop a custom Excel add-in using Python that adds new functionality to Excel, tailored to solve a specific business problem.
3. Advanced Python Projects:
4. Build a Data-Driven Web Application: Create a full-featured web app that uses Python to process, analyze, and visualize business data in real-time.
5. Explore API Integration with Python: Learn to work with APIs to integrate external data into your projects, such as financial data, weather data, or social media feeds. Develop a Machine Learning Model for Business Forecasting: Use Python’s machine learning libraries to build a model that predicts business outcomes, such as sales forecasting or customer segmentation.

🕴️Business-Tech Integration: Course: Data Science for Business Leaders: This course focuses on the application of data science techniques to drive business decisions, combining your technical skills with strategic thinking. Course: Advanced Excel for Financial Modeling: Take an advanced course that focuses on Excel’s role in financial modelling, incorporating automation and integration with Python. Continuous Learning 😄Ongoing Learning: I'm dedicated to lifelong learning as both technology and business procedures advance. This roadmap will be updated frequently as I reach goals and find new development opportunities. My ultimate objective is to combine my expertise in modern technology with my education in business administration to provide creative solutions that benefit the corporate community.

Excel Projects📓

1. Personal Budget Spreadsheet*** Objective: Create a simple spreadsheet to track your monthly income and expenses. Skills Learned: Basic formulas (SUM, AVERAGE), cell formatting, and simple charts. Steps: List all income sources and expenses in a table. Use the SUM function to calculate total income and expenses. Create a pie chart to visualize the distribution of expenses.

2. Task Tracker[] Objective: Build a task tracker to manage daily tasks and deadlines. Skills Learned: Data entry, conditional formatting, and basic date functions. Steps: Create a table with columns for task name, due date, and status. Use conditional formatting to highlight overdue tasks. Experiment with TODAY() and DATEDIF() functions to calculate the remaining days.

3. Simple Sales Log[] Objective: Develop a basic sales log to track items sold and total revenue. Skills Learned: Data organization, basic arithmetic formulas, and simple data analysis. Steps: Set up a table with product names, quantity sold, and price per item. Use formulas to calculate the total revenue for each product. Create a basic bar chart to visualize sales performance.

Python Projects

1. Basic Calculator[] Objective: Create a command-line calculator that can perform basic arithmetic operations. Skills Learned: Basic Python syntax, user input, and arithmetic operations. Steps:[] Write functions for addition, subtraction, multiplication, and division. Allow the user to input two numbers and an operation. Display the result to the user.

2. Simple Number Guessing Game Objective: Develop a game where the computer picks a random number, and the user has to guess it. Skills Learned: if-else statements, loops, and random number generation. Steps: Use the random module to generate a random number. Prompt the user to guess the number, providing feedback if they’re too high or too low. Continue looping until the user guesses correctly.

3. Grocery List Manager Objective: Build a program to manage a simple grocery list. Skills Learned: Lists, loops, and basic input/output operations. Steps: Allow the user to add items to the grocery list. Display the list after each addition. Include an option to remove items or clear the list entirely. If you have any tips, resources, or opportunities, feel free to reach out! I’m excited to continue this journey and to learn from others who were once at my level!

Contact Details: Email: [email protected] LinkedIn: https://www.linkedin.com/in/onyinyeajoku