Practical Microsoft Excel: Excel Beginner To Advanced 2025

Explore how regional settings affect Excel formulas, including decimal separators and argument separators (comma vs semicolon), and learn to adapt formulas across different locales for accurate results.

Learn to use the sum, average, min, and max functions in MS Excel to total, average, and identify the highest and lowest values in a data set.

Explore the sum if function to add numbers only when a condition is met, such as totaling people on ships from Holland.

Use the airplane factory as the context for upcoming exercises, guided by a humorous dialogue about romance, and download the attached file for use in the next video.

Apply core Excel skills to compute average and total gross monthly income, sum only employees with more than seven years of experience, and count nonempty data cells.

Learn to compute average monthly income, total monthly income, and sums for employees with more than seven years of experience using sum if, then use count to detect missing data.

Master the if function in Excel by building logical tests, returning values when true or false, with numeric and text criteria examples showing how to apply rules.

Explore nested if functions in Excel by building a three-tier weight class: heavy (>1000 kg), normal (500–1000 kg), and light (<500 kg), using an inner if to determine the label.

Apply the end function to validate multiple conditions and use nested if logic to assign bonuses (100, 500, 1000) based on years of experience in Excel.

Conclude the Excel functions section and transition to visualizing data with Excel, using the Battle of Waterloo as a context during a road trip from Amsterdam toward Paris.

Create and compare bar charts in MS Excel to visualize apple and corn harvest per hour across teams. Add axis titles and layer multiple data series for a richer view.

Create a pie chart in Excel to compare revenue from corn, onions, and apples, then add data labels and percentage values for clear amounts and shares.

Learn to add a secondary axis in MS Excel to compare apple and corn prices clearly, and set axis titles and a legend for clarity.

Create and interpret a scatter plot in Excel to assess relationships between two variables, using apple price and onion price as examples.

Visit the Atomium in Brussels, compare it to the Eiffel Tower, and use the attached Excel file to analyze visitors for a tourism assignment.

Create a two-line chart in Excel showing regular visitors and school-trip visitors over time, add a secondary axis, and apply a logarithmic scale to the school-trip data.

Create a two-series line chart in Excel from a blank sheet, add axis titles and a legend, then use a secondary axis and a logarithmic scale for regular visitors.

Visualize distribution of visitors by nationality using the provided data file, compare group versus solo visitors, and explore the relationship between regular visitors and school trip visitors with charts.

Explore how a box plot summarizes central tendency, spread, and outliers. Read the median, quartiles (Q1 and Q3), whiskers, and potential outliers to interpret data.

Explore niche charts in MS Excel that are less common than pie and bar charts but offer powerful options for specific data scenarios.

Compare two products across five dimensions using a radar chart in Excel, such as size, firmness, sweetness, looks, and sourness, to see which performs better.

Learn to create and read candlestick charts in MS Excel, where each candle represents a data point showing high, low, open, and close, with color indicating price movement.

Create box plots in Excel to compare Belgian and non‑Belgian visitors' budgets, interpreting variance, medians, and outliers. Learn to select data, insert a box and whisker chart, and analyze distributions.

Arrive in Paris and analyze data from a downloadable file attached to the video, exploring the data content of Napoleon, the third's apartment tour within the Louvre backdrop.

learn to create pivot tables in excel to summarize employee data—hours, tasks, and incidents—by dragging fields to rows, columns, and values for quick totals and breakdowns.

This lesson guides you through building a two-stage pivot table in Excel to total tips by employee and by task, using francs as the unit.

Learn to create pivot charts from pivot table data in Excel, showing hours worked by employees, adding data labels and axis titles, and breaking hours by tasks with design options.

Create an Excel model to compute music expenses with a 50 francs show-up fee plus 8 francs per hour, then use goal seek to fit a 100 francs budget.

Learn to use the solver add-in in Excel to optimize event profit by adjusting tickets, price per ticket, decoration, and personnel costs, with constraints guiding realistic outcomes.

Learn to use Excel Solver to optimize a party budget: fix personnel costs at 250, target profit 10,000, require integer tickets, and price per ticket at least 200.

Learn how Pearson product moment correlation quantifies the linear relationship between two variables using scatter plots, interpret r from -1 to 1, and recognize outliers and non-causality.

The lecture demonstrates creating a scatter plot and adding a trend line in Excel to quantify how temperature affects soup demand, revealing a negative relationship with a 0.93 R-squared.

Took a different route through Luxembourg. The car broke down near a roadside shop and restaurant, forcing a five-hour wait, while a local mechanic ordered a replacement part.

Learn to build interactive dashboards that display the most vital car parts business data on a single, actionable page, helping you run a dashboard-driven organization.

Analyze a sales data file with customer details, products, sales units, unit price, revenue, and lead time definitions; distinguish returning from first-time customers and understand how these figures are calculated.

Create an Excel dashboard by converting data to a table and building pivot tables: lead time by government and non-government customers, and revenue by customer type and product.

Create pivot tables to split lead time and revenue by customer type and product, then build pivot charts and an interactive dashboard with axis titles.

Create an interactive Excel dashboard by placing two pivot-chart graphs on a dedicated dashboard sheet, then connect slicers and a timeline to filter both charts simultaneously.