Data Analysis

DIPLOMA COURSE
Featuring  Microsoft's Dany Hoter

567+ students already enrolled


Enroll

Start Learning

with recommended videos

Learn with videos, on how you can easily create spreadsheets from templates or on your own and use modern formulas to perform calculations. Create accounting information including payroll, journals, stock reports, trial balance as well as balance sheet. Use a table to filter, sort and see totals.

Get a better picture of your data. Easily create forecasts to predict trends with just a click. Connect to your trusted Power BI data sources. Discover Power BI tables available to you through the data types gallery and connect to live, trusted data coming directly from Power BI. Get insights in Excel 2021 version.

Learn with the Microsoft's Dany Hoter and other Data Professionals. Learn in your mobile phone watching 10+ Professional videos. Complete Excel quiz and get your certificate. Use this form to apply. Scroll down to start learning.

Click on the buttons below to start now

Module 1:1

Data Analysis in Excel

Module 1:2

Data Analysis in Excel

Module 2:1

The Excel Data Model

Module 2:2

Data analysis using Excel 2016

Module 3

Importing Data from a CSV file

Module 4

Data analysis using Excel 2019

Module 4:1

Importing data from database

Module 4:2

Importing data from multiple files

Module 5:1

Creating and formatting measures

Module 5:2

Using Advanced DAX Functions

Module 6:

Importing data from Excel report

Module 7

Visualizing data in Excel

Module 8:1

Using Excel with Power BI

Module 8:2

Power BI Mobile app

Module 9

Excel Data Analysis: Sort, Filter, Pivot Table & Formulas

Module 10

Microsoft Excel 2021 Advanced Tutorial

Complete the Data Analysis quiz for evaluation

Complete these 10 evaluation questions so we can use to process your certificate

1. ____ appear at the bottom of the Excel window.





2. Another name for a pre-programmed formula in Excel is





3. Excel is a program that is used to prepare a





4. Which term is used to join the selected cells in to one cell?





5. Which of the following Excel charts represents only one value for each variable?





6. A formula in Excel always begins with an ____





7. What is the extension of saved file in MS Excel?





8. Which command is used to close the window of Excel?





9. What is the total region surrounding the chart?





10. What is the pictorial representation of worksheet data?





Get your certificate

Now that you have modified your skills with Data Analysis in Excel, you can pay for your certificate.

Contact us

WHATSAPP

+234 901 599 2500

CALL

+234 705 560 0725

EMAIL

rtsonlineeducation@gmail.com

ADDRESS

48, Omuaroan street, unity estate, Egbeda Lagos. Nigeria, Africa.


© Ransford  Global Institute