# آشنایی با تحلیل داده با اکسل برای مبتدیان

Introduction to Data Analysis using EXCEL for BeginnersPublisher: UdemyAuthor: Symon HeDuration: 11:17:58Link:https://www.udemy.com/business-data-analysis-excel/Learn to apply the important concepts and techniques in data analysis using Excel.Do any of the following apply to you?

Watch This First
2 Lectures
03:20
Watch this first.  Depending on your background with Excel and data analysis, we'd recommend different strategies for taking this course.
Watch this first
Preview
01:14
02:06

Jumpstart
5 Lectures
27:17
Video games anyone? We introduce the data set we'll be working with in this quick introductory example.
Jumpstart Overview
Preview
04:55
In this example, we see that simple built-in EXCEL formulas and functionality can make for quick analysis of numerical data.
Jumpstart Part 1
08:49
We take the sample data a bit farther--how do we calculate sub totals?  We use the conditional functions in EXCEL.
Jumpstart Part 2
06:22
Having new calculations is helpful but sometimes the best way to show case your analysis is through visualization (aka using charts).  We introduce you to two basic charts here.
Jumpstart Part 3
06:48
Quick Reminder
00:23

Getting Acclimated with EXCEL - Foundations
13 Lectures
40:11
Section overview to go over the topics we'll cover in this section, which includes the Excel user interface, common keyboard shortcuts, basic functionality that all analysts working with Excel should know.
Getting Acclimated Section Overview
00:27
In this lecture, we'll go over the Excel user interface and it's different components to get you familiar with it all before we really start to play with things.
EXCEL User Interface
Preview
05:21
In this lecture, we explore how to add data to, delete data from, and edit data inside a cell in Excel.
Adding, Deleting, and Editing Data in a Cell
03:01
While we will be introducing many more Excel keyboard shortcuts in this course, we'll show you a few of the easier ones in that are frequently used in Excel
Introduction to Keyboard Shortcuts
01:51
In this lecture, we explore some Excel keyboard shortcuts designed to help you navigate through a worksheet more efficiently.
02:34
We will look at the use of keyboard shortcuts to selecting cells with EXCEL.
Data Selection Keyboard Shortcuts
02:20
In this lecture, we look at how to insert and delete rows or columns in EXCEL, which you'll be doing quite often conducting data analysis in EXCEL.
Inserting and Deleting Rows and Columns
04:21
When the data inside the cells aren't showing up correctly, chances are the column or row sizes are not the right size. In this lecture, we'll look the useful autofit option in EXCEL.
Auto Fit Row and Column Size
01:31
Sometimes, you may want to look at multiple places within a dataset that is too far apart for for the entire data set to show on screen.  When this happens, you may want to use the freeze pane or split view options in EXCEL.
Freeze Panes and Split Boxes
04:32
There are many things a numbers can represent so when you're dealing with number in your dataset, having the right formatting can help avoid confusion.
Formatting Numbers
07:24
The simple cell in EXCEL may appear simple but in fact it has many formatting options that can add visual clarity to your analysis.
Formatting Cells
04:03
Sometimes, not all of the data needs to be shown.  In those situations, grouping and hiding select cells could make an otherwise clunky spreadsheet more manageable.
Grouping and Hiding Rows or Columns
01:57
In this lecture, we walk you through how to add a couple of very useful Excel Add-Ins that are useful for analysis.
00:49
To quiz you on what you've learned in this section
Quiz #1
6 questions

Basic EXCEL Formulas & Functions - Foundations
15 Lectures
01:29:45
Section overview to go over the topics we'll cover in this section, which includes useful math, logical, and finance functions that comes with Excel.
Basic Excel Formulas & Functions Section Overview
00:32
Doing simple math operations in EXCEL is very easy and straight forward. In this lecture we look at the operations as well as two commonly used built-in functions.
Basic Math Functions in Excel
04:48
We looked at the SUM and COUNT functions previously, now we look at their conditional counterparts, SUMIF and COUNTIF functions in EXCEL.
Conditional Math Functions
06:13
In this lecture, we look at more of EXCEL's built-in math functions: MIN, MAX, and AVERAGE functions.
MIN, MAX, and AVERAGE Functions
05:51
In this lecture, we introduce to you the logical operators and the logical IF, AND and OR functions in EXCEL.
Logical Operators and Functions
08:55
One of the most basic building blocks to understanding how to write your own formulas for manipulating and analyzing data is cell referencing.  In this lecture we look at how you can anchor cell references in EXCEL.
Anchoring Cell References and Name Ranges
Preview
09:14
Without a built in conditional MIN and MAX functions, we look at how using array functions in EXCEL can help us create our own DIY versions of MINIF and MAXIF functions.
Array Functions
05:03
In this lecture, we take start a short digression into the world of finance by exploring the set of internal rate of return (IRR) functions available in EXCEL.  We look at what these functions calculate and each of their limitations when used.
Internal Rate of Return (IRR) Functions
Preview
09:17
Continuing our exploration from the finance world, we look at the concept of the Net Present Value (NPV), what it means, how it's calculated, and how to use the NPV function in EXCEL.
Net Present Value (NPV) and Cash Multiple
13:09
Whenever you're looking at data with a time component (e.g. sales), you'll likely be looking at growth rates to help understand your data.  One common growth rate metric is known as the Compound Annual Growth Rate (CAGR).  We look at how it's calculated in this lecture.
Compound Annual Growth Rate (CAGR)
03:26
In the world of finance, we often deal with debt, like a mortgage on a loan.  In this lecture, we'l show you how to use EXCEL's built in functions to construction an amortization table.
Loan Amortization Table
03:28
As you get more sophisticated with your formula building, it's very easy to make mistakes.  But EXCEL has a very useful tool for auditing your formulas.
Formula Auditing
04:47
In this lecture we look at a keyboard shortcut alternative to the copy and paste functions in EXCEL and not the minor differences in the results.
Fill Commands
04:10
Some EXCEL functions are designed to give you useful information, rather than to calculate something.  In this lecture, we look at the very useful IS functions.
IS Functions
04:17
When working with numbers, you'll often find yourself wanting to round the results of the values.  In this lecture, we explore how to use the ROUND functions in EXCEL.
Rounding Numbers
06:35
Quiz #2
1 question

Text, Times, and Dates Data Formats - Foundations
15 Lectures
01:02:04
Section overview to go over the topics we'll cover in this section, which includes a deep dive in to how you'll be interacting with three very important data formats that you'll encounter when running analysis in EXCEL.
Text, Times, and Date Data Formats Section Overview
00:26
In this lecture, we look at how EXCEL stores and interprets text, times, and date data in cells.
How EXCEL Treats Text, Times, and Dates Data
04:52
Often, you'll be working with text that is inconsistently or improperly cased.  However EXCEL provides ready functions that can help you change the case of text easily.
Changing the Case of Text
02:32
In this lecture, we'll look at how you can combine strings of text together in EXCEL.
Combining Strings of Text Together
02:23
Instead of combining strings, sometimes we may want to cut a substring from an existing string of text.  In this lecture, we look at the various options available in EXCEL for doing this task.
Cutting Substrings from a Text
05:10
In this lecture, we look at how to use the FIND function for more advanced text search and manipulation in EXCEL.
Using the FIND Function
05:29
Continuing our series on dealing with text in EXCEL, we look at how you can search for and extract a specific string inside a longer text.
Searching for Specific Text in Data
05:37
In this lecture, we look at EXCEL's very useful feature that allows you to easily split a text into multiple columns using various delimiters.
Splitting a Text Field into Multiple Columns
03:51
Often times, date values in datasets could be stored as text values rather than more useful numeric values.  In this lecture, we look at how you can convert text formatted dates into numeric dates.
Converting Dates from Text into Values
03:05
In this lecture, we look at how to add and subtract date values in EXCEL.
05:14
In this lecture, we explore how to leverage date data to compile both monthly and annual totals in EXCEL.
Compiling Monthly and Annual Totals
04:43
In this lecture, we look at how to conduct a day of the week analysis.
Conducting Day of the Week Analysis
04:06
Often, when you have both date and time data, it is helpful to combine them together.
Combining Date and Time Data
03:40
In this lecture, we look at why time data is a bit more tricky to deal with than date data and how to add and subtract time values.
05:39
In this lecture, we how we can do an hour of the analysis on time in EXCEL.
Conducting Hours of the Day Analysis
05:17

Introduction to Statistics in EXCEL - Foundations
8 Lectures
45:11
Section overview to go over the topics we'll cover in this section, which includes an overview of core statistical concepts, statistical functions in EXCEL, and how to use them.
Introduction Statistics in EXCEL Section Overview
00:22
In this lecture, we go through a brief overview of the most relevant concepts in statistics for conducting data analysis in EXCEL.
Brief Overview of Statistics
03:35
In this lecture, we look at the three most common statistical averages--the mean, median, and mode.
Mean, Median, & Mode
08:39
In this lecture, we look at percentiles and percentilerank in EXCEL.
Percentile and PercentileRank
06:03
In this lecture, we're going to explore frequency distributions and how to use them in EXCEL.
Frequency Distributions
06:40
You can't talk about statistics without understanding standard deviation and variance.  In this lecture, we'll break down these concepts so you'll know exactly what their corresponding functions in EXCEL are doing.
Standard Deviation and Variance
06:11
In this lecture, we'll give you a first introductory taste of how to look at trends in datasets in EXCEL.
Trends in Data
07:18
In this lecture, we go over correlation and how to calculate and interpret it when running analysis of a dataset in EXCEL.
Introduction to Correlation
06:23

Handling Data in EXCEL
12 Lectures
01:02:35
Quick overview of the various data functions and topics to be covered in this section.
Handling Data Overview
00:37
Lookup with VLOOKUP
04:16
Lookup with HLOOKUP
02:26
Name Arrays for Reuse and Readability
03:22
Group Records with Nested IF Statements
04:20
Avoid Errors with IF and ISNUMBER
05:39
Create Dropdown Lists for Filtering
09:27
Create Unique Lists
04:49
Fast Lookup with INDEX and MATCH
10:00
Multi-Condition Lookup with DSUM
06:23
Create Rankings with SMALL and LARGE
05:26
Multi-Condition Lookup with INDEX and MATCH
05:50

Pivot Tables
9 Lectures
01:10:11
Insert a Pivot Table
06:38
Prepare Data for Pivoting
09:10
Learn to Pivot a Table
09:35
Group Rows and Columns
05:24
05:28
Modify Output Values for Insights
08:25
Insert Calculated Fields
08:16
Sort, Filter and Slicer
08:54
Handle New Data in Pivot Tables
08:21

Introduction to Charts in Excel
15 Lectures
01:26:50
Quick intro for this section on charts in Excel
Intoduction to Charts in Excel Overview
00:30
Why even use charts?  Using charts can help you communicate the insights and trends in your data that you just can't otherwise.  In this lecture, we'll look at examples of each of the chart types we'll cover in the section.
Why Use Charts Anyway?
10:11
In this lecture, we use sample data and build out a line chart from scratch in EXCEL.
Line Chart
04:52
In this lecture, we use sample data and build out pie charts from scratch in EXCEL.  We'll also see why you should use other charts in place of pie chars whenever possible.
Pie Charts
05:35
In this lecture, we use sample data and build out a bar chart from scratch in EXCEL.
Bar Chart
03:54
In this lecture, we use sample data and build out a simple column (clustered) chart from scratch in EXCEL.
Column Chart - Clustered
06:26
In this lecture, we use sample data and build out a stacked column chart from scratch in EXCEL.
Column Chart - Stacked
05:36
In this lecture, we use sample data and build out a 100% stacked column chart from scratch in EXCEL.
Column Chart - 100% Stacked
05:40
In this lecture, we use sample data and build out a combination chart in EXCEL using both a column chart and a line chart.
Combination Chart
02:24
In this lecture, we use sample data and build out an area column chart from scratch in EXCEL.
Area Chart
04:21
In this lecture, we use sample data and build out a scatter plot chart from scratch in EXCEL.
Scatter Plot
03:12
In this lecture, we use sample data and build out a bubble chart from scratch in EXCEL.
Bubble Chart
05:19
In this lecture, we use sample data and build out a gantt chart from scratch in EXCEL.
Gantt Chart
04:15
In this lecture, we use sample data and build out a bullet chart from scratch in EXCEL, which is really a combination of three different charts on two different axises.
Bullet Chart
Preview
09:16
In this lecture, we use sample data and build out an advanced waterfall chart from scratch in EXCEL.
Waterfall Chart
15:19

Case Study: Crytocurrency Data
5 Lectures
49:13
In this intro lecture, we look at a quick introduction to cryptocurrencies and what questions we'll look to answer in the case study.
Cryptocurrency Case Study Overview
03:06
In this lecture, we download and organize the data to prep it for analysis.
Getting and Prepping the Data
12:53
In this lecture, we analyze the bitcoin and S&P500; data and see what the two datasets could tell us how the two compare in terms of their investment returns.
Bitcoin vs S&P500
Preview
13:32
In this lecture, we extend our analysis to include two additional cryptocurrencies--Ethereum and Litecoin.
Ethereum, Litecoin, & Bitcoin
08:38
In this lecture, we take a quick look at whether moving averages could give us additional insight into the data.
Introduction to Moving Averages
11:04
3 More Sections

آیا می خواهید برنامه نویسی موبایل را با بهترین تکنولوژی شروع کنید؟

به کمک این دوره آموزشی که توسط مدیر سایت گیت تدریس می شود به راحتی اپلیکیشن های Android و iOS و Windows Phone بسازید.

تمامی مباحث از مقدماتی تا پیشرفته آموزش داده می شوند و شرکت کنندگان دوره به مدت نامحدود پشتیبانی می شوند.
برای اطلاعات بیشتر و استفاده از دوره روی لینک زیر کلیک نمایید:

آموزش برنامه نویسی چندسکویی موبایل

آیا می خواهید طراحی وب را به صورت حرفه ای یاد بگیرید؟

در این دوره آموزشی طراحی وب را در قالب بیش از 72 ساعت آموزش تصویری فارسی فرامیگیرید.
در این دوره HTML5 | CSS3 | Javascript | Jquery | Ajax | Bootstrap4 | PHP | MYSQL | SQL Server | Wordpress آموزش داده می شود.

تمامی مباحث از مقدماتی تا پیشرفته آموزش داده می شوند و شرکت کنندگان دوره به مدت نامحدود پشتیبانی می شوند.
برای اطلاعات بیشتر و استفاده از دوره روی لینک زیر کلیک نمایید:

دوره آموزش طراحی وب

حجم فایل: 1.64GB