Who is this for: Anyone learning data analytics, and anyone working with Microsoft Excel.

What it is: Data analytics is **the science of analyzing raw data to make conclusions about that information**. Data analytics help a business optimize its performance, perform more efficiently, maximize profit, or make more strategically-guided decisions.

Comprehensive Data Analytics classes with detailed and instructor-led sessions designed to help you learn the fundamental skills you need in learning how to gather and clean raw data sets. Analyze raw data, visualize them and generate actionable insights with these data.

What You’ll Learn: At the end of this lesson, you’ll learn;

- How to analyze a given data set using Excel
- How to visualized a given data for analysis.
- What is SQL and ow to use SQL to analyze a given dataset.
- what is PowerBI and how to use PowerBI to analyze data.

1

Office and Excel Overview

In this introductory lesson, learn all you need to know to use Excel and Microsoft Office. This lesson will expose basic Excel skills needed for data analysis and understanding how to wrangle and analyse data using Excel.

2

Week 1: Quiz Questions

Office & Excel Overview

Here is a few quiz questions to further enhance your learning and understanding of the concept of this lesson, please select from the list of options provided.

3

Week 1: Assessment

1

Sort & Filter, Concatenation I

What it is: Sorting is a feature in MS Excel that helps you organize data. You can sort a text column in alphabetical order (A-Z or Z-A). We can sort a numerical column from largest to smallest or smallest to largest. While the FILTER function allows you to filter a range of data based on criteria you define. Play. In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (""). The word CONCATENATE means to join or combine. The CONCATENATE function in Excel is used to combine the text from different cells into one cell.

2

Basic Text and Cell Formatting, Basic Arithmetic Function II

What it is: In Excel, the format cells is used to modify the formatting of cell numbers without modifying the actual number. With the help of the format cells, we can change the number, alignment, font style, Border style, Fill options, and Protection. Arithmetic functions are operators are used to perform basic mathematical operations such as addition, subtraction, multiplication, and division. The four basic arithmetic operations in Mathematics, for all real numbers, are: Addition (Finding the Sum; '+')Subtraction (Finding the difference; '-')Multiplication (Finding the product; '×' )Division (Finding the quotient; '÷')

3

Week 2: Quiz Questions

You're Almost Done!

Here is a few quiz questions to further enhance your learning and understanding of the concept of this lesson, please select from the list of options provided.

4

Week 2: Assessment

1

Data Validation, Cell Referencing & Conditional Formatting I

What it is: Data validation means checking the accuracy and quality of source data before using, importing or otherwise processing data. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing. Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5. Each cell in an Excel worksheet has a unique address. Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

2

Data Validation, Cell Referencing & Conditional Formatting II

What it is: Data validation means **checking the accuracy and quality of source data before using, importing or otherwise processing data**. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing. Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5. Each cell in an Excel worksheet has a unique address. Conditional formatting can help make patterns and trends in your data more apparent. To use it, you **create rules that determine the format of cells based on their values**, such as the following monthly temperature data with cell colors tied to cell values.

3

Data Validation, Cell Referencing & Conditional Formatting III

**checking the accuracy and quality of source data before using, importing or otherwise processing data**. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing. Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5. Each cell in an Excel worksheet has a unique address. Conditional formatting can help make patterns and trends in your data more apparent. To use it, you **create rules that determine the format of cells based on their values**, such as the following monthly temperature data with cell colors tied to cell values.

4

Week 3: Quiz Questions

You're Almost Done!

Here is a few quiz questions to further enhance your learning and understanding of the concept of this lesson, please select from the list of options provided.

5

Week 3: Assessment

1

Data Visualization & Conditional Functions I

What it is: Data visualizations in Excel are **representations of numerical data in a visual format**. You can organize data in a spreadsheet into a more accessible and organized format like a line graph, Gantt chart or bar graph. A conditional function **performs an action or calculation based on a test of data using an IF statement**. Use a conditional function to provide a TRUE or FALSE result to highlight or filter out data based on specific criteria. Conditional functions can be used with any data type.

2

Week 4: Quiz Questions

You're Almost Done!

3

Week 4: Assessment

1

Data Search and Extraction : Vlookup, Hlookup, Index I

Data extraction is the process by which researchers obtain the necessary information about study characteristics and findings from the included studies.

2

Data Search and Extraction : Vlookup, Hlookup, Index II

3

Week 5: Quiz Questions

4

Week 5: Assessment

Please, login to leave a review