دانلود Udemy Office 365 Learn Microsoft Excel 2019 and Microsoft Power BI

 پیش نیازها:

• این دوره در اکسل 2019 ثبت شده اما کلیه نسخه های قبلی 2007،2010،2013،2016 و office 365 در این دوره کار می کنند
• دانلود رایگان Microsoft Power BI

• این دوره برای چه کسی است؟
• هر کسی بخواهد از مقدماتی تا پیشرفته بیاموزد ، این دوره مباحث مربوط به مقدماتی را شامل می شود
• هر شخصی می خواهد هوش تجاری را برای تجزیه و تحلیل داده ها و ایجاد داشبورد و گزارش ها بیاموزد ، قدرت مایکروسافت BI را از سطح پایه تا بالاترین سطح یاد بگیرد

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش آشنا می شویم :

Data Analysis in PivotTables (Creating Revenue Dashboard)

Sparklines (Line,Column,Win or Loss) and Data Bars

Waterfall Chart,Funnel Chart and Map Chart

People Graph,Sunburst Chart,Treemap and Bubble Charts

Stocks and Geography,Progress Chart

Analyzing Sales Data in Pivot Tables and Pivot Charts

Creating Excel Tables,PivotTables and PivotCharts

Data Validation and Inserting Comments

Analyzing Data in the Table

Analyzing Data with PivotTables

Analyzing Data with Business Intelligence (Power Queries and Trendlines)

Analyzing Data with Business Intelligence (Forecast Sheet)

Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)

Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)

Loading Website Data into Power Map(Power Query,Power Map)

Extracting Data from the Website(Power Query,Pivot Table)

Extracting Football Team Data from the Website(Power Query,Pivot Table)

Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)

Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)

Analyzing Business Data with Solver

Introduction to Excel

Calculations With Basic Formulas

Calculations with Simple Excel Functions

Formatting a Worksheet

Saving and Printing a Workbook

Project Calculations with Operators and Functions

IF and VLOOKUP Functions

Adding Column and Pie Charts in an Excel worksheet



Date and Time Functions in an Excel

Logical Functions in an Excel

Lookup and Reference Functions in an Excel

Adding Line and Combination Charts in an Excel

Text Functions in an Excel

Math and Trigonometry Functions in an Excel

Statistical Functions in an Excel

Engineering Functions in an Excel

Information Functions in an Excel

Database Functions in an Excel

Financial Functions:Borrow Money to Bank

Financial Functions:Invest Money in the Bank Saving Account

Financial Functioms:Build Future Income Statement of Company

Financial Functions:Calculate Depreciation of an Asset of Company

Financial Functions:Invest Money in Company

Basic Financial Examples(Learn Use of Operators ,-,/,*)

Microsoft Power BI

Microsoft Power BI:Create Global Store Sales Dashboard

Microsoft Power BI:Create Malaria Analytics Dashboard

Microsoft Power BI:Create Climate Change Report

Bookmarks Pane and Selection Pane

Editing and Visualizing Data

Extracting Data from the Website

Extracting Sales Data from the Website

Publish and Create Dashboard

New Quick Measure(Calculations Without Dax)

Custom Visuals