Last Update: 7/2020Duration: 8h 3m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 4.16 GBGenre: eLearning | Language: English

Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights
What you'll learn:
Get hands-on experience with 4 groups of skills that needs each data analyst - Excel, SQL, Statistics, and Power BI
Learn MS Excel for cleaning, preparing, calculating and analysing data
Learn how to write advanced Excel formulas by SUBTOTAL, SUMIFS, COUNTIFS, AVERAGEIFS, VLOOKUP, INDEX, MATCH and other 50+ functions
Learn Pivot Tables so you can quickly get insights from your data
Learn Statistical Analysis in MS Excel by Data Analysis ToolPak including Descriptive statistics and Linear regression
Learn how to perform A/B testing and what is P-value
Start using MySQL - the #1 Database Management System
Learn how to write complex SQL queries to obtain useful information from the database
Learn Microsoft Power BI for analysing and visualizing data
Learn how to connect Power BI to an Excel file and MySQL database and create interactive dashboards for these datasets
Put all 4 groups of skills together for identifying insights and trends based on real-life data sets
Requirements:
MS Excel 2010, 2013, 2016, 2019
Other softwares used in this course are open sources
Only the passion for data analysis
Description:
Join to over 5,000 students and learn Excel, Statistics, SQL, and Power BI in one course to analyze data, identify trends, design visualizations, and drive business decisions with real‐world data sets.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 13 lectures (56m) | Size: 327.6 MB

Basics of Earthquake Eeering, Seismic Analysis Methods, Seismology & Seismic Risks of Built Environments
Basics and general concepts of seismology, earthquake eeering and seismic risks
Earth structure and layers, plate tectonic, continent movements
Fault types and mechanism
Seismic waves and seismograph and earthquake record
Earthquake epicentre and locations
Earthquake scales
World seismicity
Phenomena during and after the earthquake
Seismograph key parameters
Gutenberg-Richter law
Response spectrum
Seismic Analysis Methods
Earthquake risk and parameters
Effect of earthquake on built environment and human
Effect of earthquake on buildings
Earthquake mitigation measures
Structural analysis and physics in a basic level.

Last Update: 10/2021Duration: 3h 9m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.93 GBGenre: eLearning | Language: English

Learn to Setup, Configure, and Administer EC2 Instances on AWS.

Last Update: 10/2021Duration: 7h 53m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 3.8 GBGenre: eLearning | Language: English

Tally ERP 9 With GST, Tally Accounting , Inventory management, Payroll Management, Bank Reconciliation, Tally with GST
What you'll learn:
What is Accounting

Last Update: 10/2021Duration: 3h 21m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.83 GBGenre: eLearning | Language: English

Vlookup,Excel Formulas and Functions ,Excel, advanced excel ,excel ,Basic Excel, Essential Excel, Excel Bners,
What you'll learn:
How to write basics formulas and perform calculations from scratch
Learn the most popular Microsoft Excel functions for bners
Identify formulas and functions and know the difference between the two.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 53 lectures (4h 21m) | Size: 2 GB

A practical or hands-on approach on how you can create office documents to suit your needs
You will be able to start Ms Word application and understand its environment
You will be able to create word Documents from scratch and work with them
You will be able to edit and format text and pages in your documents
You will be able to create and work with layouts in your documents
You will be able to create and work with tables
You will be able to create and work with your own graphics and designs
Basic knowledge of using a windows operating system interface like Windows 10 or any other windows
Ensure you have Ms Word installed on your laptop or computer via Microsoft Office package (e.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 28 lectures (3h 3m) | Size: 1.53 GB

A practical or hands-on approach on how you can create simple publications & designs for your business and related work
You will be able to start Ms Publisher application and understand its environment
You will be able to create and design simple publications from scratch
You will be able to create, format and manage text in a Publication
You will be able to working with Layouts and tables in a Publication
You will be able to create your own unique designs within your publication
Basic knowledge of using a windows operating system interface like Windows 10 or any other windows
Ensure you have Ms Publisher installed on your laptop or computer via Microsoft Office package (e.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 31 lectures (3h 23m) | Size: 1.69 GB

A practical or hands-on approach on how you can create powerful Presentations
You will be able to start Ms powerPoint application and understand its environment
You will be able to create and work with Presentations and Slides
You will be able to work with, edit and format text in your Presentation
You will be able to work with layouts in your Presentation
You will be able to create and work with Tables
You will be able to create and work with Graphics and Designs
You will be able to create Slide Designs, Shows, Transition and Animations
Basic knowledge of using a windows operating system interface like Windows 10 or any other windows
Ensure you have Ms PowerPoint installed on your laptop or computer via Microsoft Office package (e.