Learn Microsoft Excel Basics Fast

Begin your Microsoft Excel basics with the getting started guidance, exploring ideas and how to use Excel effectively.

download a dataset for statistical learning, locating the iris dataset and related high risk datasets, and save them to the d drive.

Learn how to read csv files in microsoft excel to work with datasets as part of microsoft excel basics.

Apply borders to table cells by selecting lines and using the border button, highlighting the grid to organize data clearly in Excel.

Track sales data and tally results using basic Excel features. Apply quick, practical data entry to monitor sales performance.

Learn how to underline cells, highlight your selections, and use the clear button to reset formatting in Excel.

Change text color in Microsoft Excel and apply highlighting, while noting color options and limitations.

Learn how to change a phone setting by selecting the item and clicking the button to apply the change, then confirm the update.

Learn how to apply and customize borders in Excel by selecting cells and using the border button to apply the chosen border style.

Learn how to change cell colors in Microsoft Excel to format a table, applying color changes to selected cells and understanding how color affects table appearance.

Master Microsoft Excel basics fast and learn line styles to format spreadsheets, while the caption emphasizes changing our lifestyle.

Learn to change the line color in Excel and select a line color, such as gray, to customize your worksheet appearance.

Learn how to use autosize in Excel to fit cell content by highlighting cells and double-clicking.

Explore left align in Microsoft Excel to understand basic cell alignment for clear data presentation.

Master center align in Microsoft Excel by highlighting cells and using the center button to center text.

Learn how to highlight cells and apply right align in Excel, with options to align left, center, or right to improve data presentation.

Merge and align cells to center content and improve layout in Excel, applying basic techniques to balance data across the worksheet.

Format cells in Excel by setting decimal places, applying currency or percentage formats, and customizing borders, protection options, and other cell properties.

Discover how to apply conditional formatting in Microsoft Excel to highlight cells, use rules such as top or bottom percent, greater than, or above average, and add color scales.

Format data as tables in Excel to turn a raw dataset into organized, readable tables for easier analysis.

Learn how to change cell styles in Microsoft Excel, apply formatting across multiple cells, and use undo options to manage changes efficiently.

Learn the difference between formatting as tables and formatting as cell styles, using tables to create dynamic dashboards and organize data, while normal cells stay standard.

Learn how to use the sum function in Excel to perform calculations on a table, exploring popular functions and applying the sum to a first column.

Learn to use the average function in Microsoft Excel and apply it to every cell. See how to average across cells in Excel.

Learn how to use the min function in Microsoft Excel to identify minimum values in your data, including days and salary figures, for quick insights.

Learn how to use the max function in Excel to find the maximum value by entering =MAX(...) and pressing enter.

Learn how to calculate correlation in Microsoft Excel, identify the correlation between two data columns, and interpret the resulting value in your spreadsheet analysis.

Learn to use Microsoft Excel to calculate variance from data and present the variance of a variable.

Learn how to calculate standard deviation in Microsoft Excel using example data and straightforward steps to apply the formula.

Learn how to calculate a cutoff in Microsoft Excel, apply equal cuts, and use available files to practice entering data and executing the steps.

Master skewness in Excel basics by learning how to calculate distribution shape through practical classroom prompts and data exercises.

Learn how to use VLOOKUP in Excel to look up a value in a table and return the corresponding fifth column value, using the first occurrence.

Learn how to use the countif function in Excel to count cells in a range that meet a specific criterion, such as values equal to a chosen item.

Master the Excel if function by building conditional formulas, learning when to use absolute references with dollar signs, and using drag to copy formulas across a table.

Explore a broad set of Excel functions and formulas to perform calculations. Learn average, maximum, financial, logical, date and time, and information compatibility functions to boost your skills.

Master the find and replace feature in Microsoft Excel to locate values and update data quickly. Learn practical steps to search and replace data within Excel.

Learn how to sort data in Microsoft Excel by making a selection, highlighting cells, and sorting from smallest to largest.

Apply filters in Excel to control which rows and columns display, using the data tab, and handle missing values.

Learn how to insert and customize a line chart in Microsoft Excel, including formatting borders, shapes, line styles, and chart design options.

Learn to insert a bar chart in Excel, customize colors and styles, adjust chart data, and explore Mac design options to enhance your workbook visuals.

Learn to create and format a pie chart in Microsoft Excel, including 3D pie charts, borders, and transparency adjustments.

Learn how to insert a scatterplot in Excel by selecting two data series and using the setup options to create a scatterplot.

Learn to insert and customize a combo chart in Microsoft Excel, applying formatting options to visualize multiple data series with coordinated axes.

Create a pivot table from a data table, set fields as columns or rows, add values, and apply filters to summarize data patterns.

Learn how to insert a pivot table and pivot charts in Excel, manage data ranges, and summarize values with sums using fields.