إنشاء لوحة تحكم للبورصة باستخدام أوراق جوجل from Coursera

هل تساءلت يومًا عن كيفية تسجيل أسعار الأسهم المتغيرة دائمًا لشركات مختلفة في لوحة معلومات موجزة؟

أسواق الأسهم العالمية هي أنظمة بيئية تحتوي على العديد من البيانات المتغيرة مثل أسعار أسهم الشركات والأحجام والعملات. يراقب التجار والمصرفيون والمستثمرون وغيرهم كيف تتفاعل هذه الأسواق مع الأخبار المتغيرة ، والتي يمكن أن تؤثر في النهاية على محافظهم الاستثمارية.

بنهاية هذا المشروع ، ستكون قادرًا على إنشاء لوحة تحكم للمخزون باستخدام جداول بيانات Google. ستستخدم الصيغ المضمنة في جداول بيانات Google للتوصل إلى البيانات الحديثة التي تم تداولها في بورصة نيويورك (NYSE) ، واستخدام تصور البيانات لتلخيص نقاط بيانات متعددة في مخططات ورسوم بيانية لتسهيل فهم كيفية أداء أسهم معينة. فترة معينة.

ملاحظة: تعمل هذه الدورة التدريبية بشكل أفضل للمتعلمين المقيمين في منطقة أمريكا الشمالية. نعمل حاليًا على توفير نفس التجربة في مناطق أخرى.

What's inside

Syllabus

إنشاء لوحة تحكم للبورصة باستخدام أوراق جوجل

ستكون قادرًا على إنشاء لوحة تحكم للمخزون باستخدام جداول بيانات جوجل للتوصل إلى البيانات الحديثة التي تم تداولها في بورصة نيويورك (NYSE)

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Uses a real-world example of stock prices from NYSE to make learning more meaningful

Projects of this nature are commonly used in the financial sector, making this course highly relevant to stockbrokers and financial managers

Suitable for beginners who are new to visualizing stock data and manipulating it using spreadsheets

Reviews summary

Data visualization for stocks

This course teaches learners how to set up a dashboard to view real-time stock market data using Google Sheets. It has been rated 4.6 stars on average by students, with most reviewers finding the course to be valuable and well-taught.

Highly recommended for beginners

"Highly recommended for beginners..."

"..."

Well-organized and clear content

"The course is well-organized and the content is clear."

"..."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in إنشاء لوحة تحكم للبورصة باستخدام أوراق جوجل with these activities:

Review Basic Statistics

Show steps

Ensure you are familiar with the key concepts of statistics to enhance your understanding of stock market patterns.

Browse courses on Statistics

Show steps

Revisit concepts of mean, median, and standard deviation.
Practice using a statistical software package, such as SPSS or R.

Stock Market Simulation

Show steps

Engage actively with stock market concepts by simulating real-world trading experiences.

Show steps

Choose an online stock market simulator platform.
Create a virtual portfolio and make investment decisions.
Monitor your portfolio's performance and adjust strategies accordingly.

Analyze Historical Stock Data

Show steps

Develop your analytical skills by examining historical stock data and identifying patterns.

Show steps

Download historical stock prices from a data provider.
Clean and visualize the data using a spreadsheet or data visualization tool.
Apply technical analysis techniques to identify trends and patterns.

Three other activities

Expand to see all activities and additional details

Show all six activities

Follow Industry Experts

Show steps

Stay up-to-date on market trends and insights by learning from experienced professionals.

Show steps

Subscribe to newsletters and blogs of reputable financial analysts.
Attend webinars and conferences hosted by industry experts.

Join a Stock Market Discussion Group

Show steps

Connect with other learners and share knowledge and perspectives to enhance your understanding of stock markets.

Show steps

Identify a discussion group or forum focused on stock market analysis.
Actively participate in discussions, ask questions, and share your insights.

Tutor Beginner Stock Market Investors

Show steps

Consolidate your understanding of stock markets by teaching fundamental concepts to others.

Show steps

Offer to tutor beginners interested in learning about stock market investing.
Prepare lesson plans and materials to effectively convey concepts.
Provide guidance and support to students, answering their questions and helping them apply knowledge.

Career center

Learners who complete إنشاء لوحة تحكم للبورصة باستخدام أوراق جوجل will develop knowledge and skills that may be useful to these careers:

Management Consultant

Management consultants help businesses improve their performance by providing advice on strategy, operations, and technology. They use data and analytics to identify and solve problems. This course can help you develop the skills and knowledge you need to become a successful management consultant. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Management Consultant

Business Analyst

Business analysts help businesses improve their performance by identifying and solving problems. They use data and analytics to make recommendations about how to improve processes, products, and services. This course can help you develop the skills and knowledge you need to become a successful business analyst. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Business Analyst

Data Analyst

Data analysts use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. This course can help you develop the skills and knowledge you need to become a successful data analyst. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial analysts provide investment advice to individuals and institutions. They use their knowledge of the financial markets and economic trends to make recommendations about which stocks, bonds, and other investments to buy or sell. This course can help you develop the skills and knowledge you need to become a successful financial analyst. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Financial Analyst

Quantitative Analyst

Quantitative analysts use mathematics and statistics to develop trading strategies. They work in a variety of industries, including hedge funds, investment banks, and asset management companies. This course can help you develop the skills and knowledge you need to become a successful quantitative analyst. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use mathematics and statistics to assess risk and uncertainty. They work in a variety of industries, including insurance, finance, and healthcare. This course can help you develop the skills and knowledge you need to become a successful actuary. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Actuary

Investment Banker

Investment bankers help companies raise capital by issuing stocks or bonds. They also advise companies on mergers and acquisitions. This course can help you develop the skills and knowledge you need to become a successful investment banker. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Investment Banker

Portfolio Manager

Portfolio managers manage investment portfolios for individuals and institutions. They make decisions about which stocks, bonds, and other investments to buy or sell in order to achieve the desired investment goals. This course can help you develop the skills and knowledge you need to become a successful portfolio manager. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Portfolio Manager

Risk Manager

Risk managers identify and manage risks that could impact an organization. They work in a variety of industries, including finance, insurance, and healthcare. This course can help you develop the skills and knowledge you need to become a successful risk manager. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Risk Manager

Financial Planner

Financial planners help individuals and families plan for their financial future. They provide advice on investments, retirement planning, and estate planning. This course can help you develop the skills and knowledge you need to become a successful financial planner. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Financial Planner

Auditor

Auditors examine financial records to ensure that they are accurate and compliant with laws and regulations. They work in a variety of industries, including accounting, finance, and government. This course can help you develop the skills and knowledge you need to become a successful auditor. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Auditor

Tax Accountant

Tax accountants prepare tax returns for individuals and businesses. They also advise clients on tax laws and regulations. This course can help you develop the skills and knowledge you need to become a successful tax accountant. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Tax Accountant

Forensic Accountant

Forensic accountants investigate financial crimes, such as fraud and embezzlement. They work in a variety of industries, including law enforcement, accounting, and finance. This course can help you develop the skills and knowledge you need to become a successful forensic accountant. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Forensic Accountant

Compliance Officer

Compliance officers ensure that organizations comply with laws and regulations. They work in a variety of industries, including finance, healthcare, and manufacturing. This course can help you develop the skills and knowledge you need to become a successful compliance officer. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits.

See salaries and explore the career path for Compliance Officer

Trader

Traders buy and sell stocks, bonds, and other financial instruments on behalf of clients or for their own account. They use their knowledge of the financial markets to make quick decisions about when to buy and sell in order to maximize profits. This course can help you develop the skills and knowledge you need to become a successful trader. You will learn how to use Google Sheets to track stock prices, create charts and graphs to visualize data, and use formulas to calculate returns and profits. This course may also help you prepare for the Series 7 exam, which is required for all traders who work with clients.

See salaries and explore the career path for Trader