Generative AI for Business Leaders
Advertising with Meta
How Google does Machine Learning
دوراتنا
Microsoft Excel مقدمة إلى تحليل البيانات باستخدام
فى نهاية المشروع ده , هتقدر تحدد و تستخدم أساسيات تحليل البيانات باستخدام Microsoft excel.
-
Course by
-
Self Paced
-
2 ساعات
-
عربي
Crear un Informe Financiero con Microsoft Excel
Al final de este proyecto, podrá completar un informe financiero con Microsoft Excel, compuesto por una página de transacciones, un estado de pérdidas y ganancias y un balance general. Aprenderá cómo ingresar sus transacciones comerciales e interpretar los datos presentados en el estado de pérdidas y ganancias. También aprenderá sobre los componentes de un balance general y comprenderá mejor cómo se puede utilizar un informe financiero para ayudar a rastrear y presentar la información financiera de su empresa.
-
Course by
-
Self Paced
-
4 ساعات
-
الإسبانية
Introduction to Microsoft Excel
By the end of this project, you will learn how to create an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that works like a database. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. Excel is organized into rows (represented by numbers) and columns (represented by letters) that contain your information. This format allows you to present large amounts of information and data in a concise and easy to follow format.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Custom & Conditional Formatting in Microsoft Excel
At the end of this project, you will be able to customize your formatting in Microsoft Excel. You will also be able to use basic conditional formatting to ensure a seamless use of Microsoft Excel and to highlight important sections of your sheet. Being able to use custom and conditional formatting in Microsoft Excel will allow you to make sense of the data quickly. This allows you to visualize your data and make it easier for you and for others to understand the data. This becomes more important the more data is contained in the sheet.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Introduction to Microsoft Excel
By the end of this project, you will learn how to create an Excel Spreadsheet by using a free version of Microsoft Office Excel.
-
Course by
-
Self Paced
-
2 ساعات
-
الإنجليزية
Introduction to Data Analysis using Microsoft Excel
In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data.
-
Course by
-
Self Paced
-
2 ساعات
-
الإنجليزية
Create a budget with Microsoft Excel
In this project, you will learn how to create a budget using Microsoft Excel. This program is terrific for working with numbers and tables and creating budgets. It is a program that facilitates our work to keep everything in order. You will complete different tasks to understand and use the Microsoft Excel tool.
Excel contains many hidden tools that we will discuss along with this project. You can learn about various available formula options. We'll talk about settings, formulas, income and expense entry, numbers, organization, colors, and letters.
-
Course by
-
Self Paced
-
3 ساعات
-
الإنجليزية
Forecasting Models for Marketing Decisions
How will customers act in the future? What will demand for our products and services be? How much inventory should we order for the next season? Beyond simply forecasting what customers will do, marketers need to understand how their actions can shape future behavior. In Developing Forecasting Tools with Excel, learners will develop an understanding of the basic components of a forecasting model, how to build their own forecasting models, and how to evaluate the performance of forecasting models.
-
Course by
-
Self Paced
-
12 ساعات
-
الإنجليزية
Preparing Data for Analysis with Microsoft Excel
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. No prior skills are needed to be successful in this course. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis.
-
Course by
-
Self Paced
-
19 ساعات
-
الإنجليزية
Data calculations in Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, will get access to Microsoft Excel, you will create a table with data that you will later be able to manipulate to calculate sums, average amounts, percentages, and also calculate with certain criteria. Your new skills will help you efficiently manipulate data and operate with formulas that can help make more efficient management decisions in the future.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Create a Simple Project Timeline in Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, get access to Microsoft Excel, define a project, understand what elements need to be identified and documented before creating a project timeline, and also understand the importance of a project time. Your new skills will help you track your project timeline both for personal and professional purposes.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Create a Mortgage Calculator in Excel
By the end of this project, you will learn how to create a mortgage payment calculator in an Excel Spreadsheet by using a free version of Microsoft Office Excel. Excel is a spreadsheet that is similar in layout as accounting spreadsheets. It consists of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. While a mortgage calculator helps you to see how extra payments effect your principal amount. We will learn to create a budget both automatically and manually, step by step.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Introduction to Predictive Modeling
Welcome to Introduction to Predictive Modeling, the first course in the University of Minnesota’s Analytics for Decision Making specialization. This course will introduce to you the concepts, processes, and applications of predictive modeling, with a focus on linear regression and time series forecasting models and their practical use in Microsoft Excel.
-
Course by
-
Self Paced
-
12 ساعات
-
الإنجليزية
Getting started with Azure IOT Hub
In this 1-hour guided project, you will create an IoT hub & an IoT device in Azure and use a Raspberry Pi web simulator to send telemetry data to the IoT hub. You will then create an Azure Cloud storage account to store the telemetry data and also create a Stream Analytics job to fetch the data in a CSV file. In the final task, you will analyze and visualize the temperature and humidity telemetry data through line charts and area charts using Microsoft Excel online.
-
Course by
-
Self Paced
-
3 ساعات
-
الإنجليزية
Get Started with Spreadsheet Applications: Excel
Spreadsheet applications are an essential part of productivity at work and school. Understanding how to use spreadsheet apps such as Microsoft Excel can make you a more efficient and valuable worker. In this mini-course, you will learn the essentials of working with spreadsheet apps. You will learn how to open, save, share, and print spreadsheet files, move around a worksheet, and enter and edit data. This course will teach you how to use formulas, functions, charts, and data, and it will also explain how to work collaboratively with online spreadsheets.
-
Course by
-
Self Paced
-
5 ساعات
-
الإنجليزية
Charts, Pictures, Themes, and Styles in Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, get access to Microsoft Excel, and will create a workbook with charts, pictures, themes, and styles. Your new skills will help you manage information in Microsoft Excel in the most efficient way.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Using Basic Formulas and Functions in Microsoft Excel
Have you started using spreadsheets like Excel and want to learn how to write formulas and functions to perform simple data analysis? In this project, you will learn about the general format for writing formulas and functions in Excel to perform analysis on the sales data from a sample company. In this analysis, you will calculate total sums of profits, you will learn how to use functions to analyze the popularity of the items sold and you will also learn how to calculate averages and percentages of monthly profits.
-
Course by
-
Self Paced
-
3 ساعات
-
الإنجليزية
Overview of Data Visualization in Microsoft Excel
After finishing this project, you will have learned some basic rules about data visualization and can apply them whenever you create charts. In present times, one can find data visualization in a wide range of fields. Businesses show graphs to report on revenue, police departments create maps of crimes in their jurisdiction, and on the website for the city hall, you can likely find visual comparisons of people who moved to the city and those who left the city. For this reason, it is important for a lot of people to know the basics of data visualization.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Building Candlestick Charts with Microsoft Excel
By the end of this project, you will create a candlestick chart with open, high, low, and close data from the stock market, and you will also set up an auto-refresh function to get the live data. Your new skills will help you create an informative candlestick chart in Microsoft Excel to reflect trends in the stock market.
-
Course by
-
Self Paced
-
1 ساعات
-
الإنجليزية
Create a Simple Gantt Chart using Microsoft Excel
By the end of this project, you will be able to create a simple Gantt chart to manage your next project. You will utilize the free online version of Microsoft Excel to create a Gantt chart from scratch. This Gantt chart will give you a better idea of how bar charts and conditional formatting work. This guide will incorporate some Excel functions to teach you how to use conditional formatting to make your chart and data interactive.
-
Course by
-
Self Paced
-
3 ساعات
-
الإنجليزية
Create a Financial Statement using Microsoft Excel
By the end of this project, you will be able to complete a financial statement with Microsoft Excel, composed of a transactions page, profit and loss statement, and balance sheet. You will learn how to enter your business transactions and interpret the data presented in the profit and loss statement. You will also learn about the components of a balance sheet and will have a better understanding of how a financial statement can be used to help track and present financial information for your company.
-
Course by
-
Self Paced
-
3 ساعات
-
الإنجليزية
Work Smarter with Microsoft Excel
This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting.
-
Course by
-
Self Paced
-
20 ساعات
-
الإنجليزية
Bayesian Statistics: From Concept to Data Analysis
This course introduces the Bayesian approach to statistics, starting with the concept of probability and moving to the analysis of data. We will learn about the philosophy of the Bayesian approach as well as how to implement it for common types of data. We will compare the Bayesian approach to the more commonly-taught Frequentist approach, and see some of the benefits of the Bayesian approach. In particular, the Bayesian approach allows for better accounting of uncertainty, results that have more intuitive and interpretable meaning, and more explicit statements of assumptions.
-
Course by
-
Self Paced
-
12 ساعات
-
الإنجليزية
Getting Started with SAS Programming
This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data.
-
Course by
-
Self Paced
-
25 ساعات
-
الإنجليزية
Excel Basics for Data Analysis
Spreadsheet tools like Excel are an essential tool for working with data - whether for data analytics, business, marketing, or research. This course is designed to give you a basic working knowledge of Excel and how to use it for analyzing data. This course is suitable for those who are interested in pursuing a career in data analysis or data science, as well as anyone looking to use Excel for data analysis in their own domain.
-
Course by
-
Self Paced
-
12 ساعات
-
الإنجليزية