Data Analytics

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.

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. 

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.

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; '÷')

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.

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.

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.

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.

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.

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.

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.

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

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