Microsoft Excel Functions, Formulas, Analysis, & Dashboards

learn about the structure and components of spreadsheet cells, columns, and rows.

discover keyboard shortcuts to efficiently navigate and add columns and rows in a spreadsheet.

explore how to format cells in a spreadsheet for better data presentation.

understand how to use the autofill feature to quickly fill in data.

master basic mathematical functions to perform calculations in Excel.

practice using Excel on real datasets to reinforce your skills.

learn how to remove duplicate entries from your data.

find out how to remove unnecessary spaces from your data.

perform a spell check to ensure accuracy in your spreadsheet.

learn how to find and replace specific data in your spreadsheet.

discover methods for replacing blank cells in your data.

explore how to use proper fonts to enhance the readability of your data.

learn techniques for merging data within spreadsheet cells.

understand how to split text into separate columns.

master the process of sorting data in a spreadsheet.

learn how to transpose data to switch rows and columns.

explore the Flash Fill feature for automatic data entry.

understand how to use Vlookup for searching data within tables.

learn to use Hlookup to find data across rows.

discover how to use Index and Match for more flexible data lookups.

learn how to consolidate data from multiple sources.

explore how to append data using Power Query.

learn how to manipulate dates by extracting day, month, and year.

discover how to manipulate dates to display the name of the day and month.

learn to manipulate dates to find the day of the week and week of the year.

learn how to calculate the day of the year in excel.

discover how to find the quarter of the year using excel functions.

explore dynamic functions for today's, tomorrow's, and yesterday's dates.

learn how to calculate age based on date of birth in excel.

understand how to add conditional columns using the IF function.

explore the use of nested IF statements for complex conditions.

learn how to use IF and OR functions to create logical tests.

discover how to apply IF and OR logic across multiple columns.

practice using IF and multiple OR conditions in excel.

learn how to use freeze panes for better data navigation in excel.

discover how to apply filters and advanced filters to your data.

explore conditional formatting to visually enhance your data.

learn how to use subtotals for organizing and summarizing data.

understand how to count entries based on a single criterion using COUNTIF.

learn how to use COUNTIFS to count entries based on multiple criteria.

discover how to sum values based on a single condition using SUMIF.

explore SUMIFS to sum values based on multiple criteria.

get introduced to the fundamentals of data analysis in excel.

learn how to summarize data by a specific parameter.

explore how to add parameters for drill down and drill up analysis.

learn how to break down information by specific columns.

understand how to filter data within reports effectively.

explore value field settings to customize data analysis in excel.

learn how to work with dates organized in rows in excel.

understand how to group data effectively in excel.

discover how to compile all your data onto a single sheet.

explore how to use slicers to filter data visually.

learn about creating and using timelines in your analysis.

get introduced to dashboards and create your first chart.

delve deeper into various chart options for your dashboard.

compile data from different sources onto one sheet for dashboards.

add a timeline or time slicer to your dashboard for better data visualization.

learn how to add and adjust slicers within your dashboard.

explore how to incorporate trendline charts into your dashboards.