+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Microsoft Excel - Data Analytics Course (/Thread-Microsoft-Excel-Data-Analytics-Course--165867)
Microsoft Excel - Data Analytics Course - Farid - 09-18-2023
![[Image: 6YCZDF.9aymwh57rl0p.jpg]](https://i.im.ge/2023/09/17/6YCZDF.9aymwh57rl0p.jpg)
The Ultimate Microsoft Excel Data Analytics Course
Published 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.79 GB | Duration: 4h 15m
This course will teach you advanced Excel techniques all aimed at helping you make sense of the numbers in your business
What you'll learn
Learn and Understand Data Manipulation using Excel
Learn How to Create Formulas to Help you Analyze Data
Learn and Understand Data Cleansing
Learn and Understand Tables in Excel
Learn various ways to model data for businesses
Build impressive tables and combine datasets using Excel's built-in functionality
Learn basics of Pivot Tables and Charts
Clean and prepare your data
Create a basic Excel Pivot Table and format numbers in it
Use multiple fields and dimension, and methods of aggregation
Create Pivot Charts based on Pivot Table data
Learning Power Query, Power Map and Power Pivot
Requirements
You have an attitude to learn while having fun :)
Basic Excel knowledge is helpful but not required
Description
Welcome to this course. Microsoft Excel is one of the easiest to use data analysis tools you will ever come across. We need to analyze data these days since we live in a very data-driven world. Therefore, data is important in any business, whether you are looking for trends or forecasting future business needs. As there is a lot of importance placed on data analysis, you must have the relevant skills to analyze data effectively. Microsoft Excel has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. Its simplicity and powerful features has made it the go to tool for all your data needs. Complex operations with Excel, such as creating charts and graphs, visualization, and analyzing data make it a great tool for managers, data scientists, financial data analysts, and those who work closely with data. Learning data analysis and will help you bring your data skills to the next level. We'll start with the basic topics in Microsoft Excel. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. You will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.In this course, you'll learn:Learn and Understand Data Manipulation using ExcelLearn How to Create Formulas to Help you Analyze DataLearn and Understand Data CleansingLearn and Understand Tables in ExcelLearn various ways to model data for businessesBuild impressive tables and combine datasets using Excel's built-in functionalityLearn basics of Pivot Tables and ChartsClean and prepare your dataCreate a basic Excel Pivot Table and format numbers in itUse multiple fields and dimension, and methods of aggregationCreate Pivot Charts based on Pivot Table dataLearning Power Query, Power Map and Power PivotAt the end of this course, you'll learn the skills required to be able to clean the data, put it in the Pivot Table, analyse the data efficiently, and keep it updated with a single click.
Overview
Section 1: Welcome
Lecture 1 Introduction
Section 2: Getting Started
Lecture 2 Introduction
Lecture 3 Data Manipulation - Learn How to Sort Data
Lecture 4 Data Manipulation - Learn How to Filter Data
Lecture 5 Data Manipulation - Learn How to Create a Chart to Manipulate Data
Section 3: Microsoft Excel - Learning Data Cleansing
Lecture 6 Introduction
Lecture 7 Learning Data Cleansing - Dealing With Duplicate Records
Lecture 8 Learning Data Cleansing - Learn How to Change the Case
Lecture 9 Learning Data Cleansing - Learn How to Replace Text
Lecture 10 Learn How to Remove Non Printing Characters & Spaces
Lecture 11 Learning Data Cleansing - Learn About Numbers Standardized
Lecture 12 Learning Data Cleansing - Learn How to Deal With Date & Time Issues
Lecture 13 Learning Data Cleansing - Learn How to Merge & Split Data Columns
Lecture 14 Learning Data Cleansing - Learn How to Rearrange Columns and Rows
Lecture 15 Section Summary
Section 4: Learning Tables in Microsoft Excel
Lecture 16 Introduction
Lecture 17 Understanding Tables - Formatting Your Tables
Lecture 18 Learn How to Manage Rows & Columns
Lecture 19 Understanding Table Data - Sorting & Filtering
Lecture 20 Learn How to Use the Totals Row
Lecture 21 Tables in Excel - Learn How to Add a Calculated Column
Lecture 22 Understanding Table Data - Learn How to Add Charts & Pivot Tables
Lecture 23 Learning Data Entry & Editing
Lecture 24 Filtering Your Data
Lecture 25 Learn About Advanced Filtering
Lecture 26 Section Summary
Section 5: Microsoft Excel - Learning Pivot Tables
Lecture 27 Introduction
Lecture 28 Learn About Recommended Pivot Tables
Lecture 29 Learn How to Rename Column Headings
Lecture 30 Learn How to Change The Data Function
Lecture 31 Learn How to Move a Pivot Table
Lecture 32 Understanding the Report Filter Option
Lecture 33 Pivot Table - Sorting and Filtering
Lecture 34 Learn How to Refresh a Pivot Table
Lecture 35 Pivot Table - Numbers
Lecture 36 Learning Pivot Table Styles
Lecture 37 Learning Multiple Fields
Lecture 38 Pivot Tables - Grand and Sub Totals
Lecture 39 Pivot Tables - Filtering Columns & Rows
Lecture 40 Pivot Tables - Additional Options
Lecture 41 Pivot Tables - Data Slicer
Lecture 42 Pivot Tables - SQL Server Database
Lecture 43 Section Summary
This course is for anyone who works with Microsoft Excel even if you've never used data analytics, Pivot Table and Pivot Charts
Microsoft Excel - Data Analytics Course (644.32 MB)
KatFile Link(s)
RapidGator Link(s)