Complete Microsoft Excel Master Class.

Learn the basics of Microsoft Excel, detailing the toolbar and ribbon, how to hide and reveal them, selecting cells, the name grid, inserting cells, and viewing formulas.

Explore how an Excel cell handles data types by showing how numbers, text, and boolean expressions are stored and identified, and how each type is aligned.

Learn how to use the max function in Excel to identify the month with the highest seats across different scenarios, by applying a range and comparing monthly data.

Explore the average formula in Excel using real monthly sales data from June, February, and March. Practice using the average function and basic formatting concepts, including conditional formatting.

Explore the sum formula in Excel by totaling monthly sales for five salespeople, analyze totals across months, and apply conditional formatting to highlight top figures.

Apply the large formula to identify the nth largest value in a data set, using a data validation dropdown from 1 to 10 and absolute references.

Master the rand between formula in excel to generate random numbers between a bottom and top value, such as 100 to 200, quickly filling ranges.

Learn how to apply the round formula in Excel to round numbers to two decimal places, see how values change, and control rounding across all entries.

Use the rank formula in Excel to identify the highest physics score, demonstrating how to apply fixed ranges and determine top scorers.

Explore how the or formula in excel determines a 5 percent raise based on either five years of service or a performance rating of eight or greater.

Master countif and countifs in Excel by evaluating multiple criteria such as designation, location, and basic pay to count vice presidents and other roles.

Explore conditional formatting in Excel with practical rules for numbers, top/bottom items, ranges, and text and date conditions, using color scales, data bars, and icons to visualize data.

Discover how to make Excel speak your data aloud, enable the speak feature from quick access options, and apply it to case studies for quality checks and readable outputs.

Master the text to columns feature to split text into two columns by a delimiter, using spaces and other separators to separate names, countries, and phrases.

Explore fill and advanced filling techniques in Excel, including fill series, formatting control, custom lists, and Flash Fill to automate months, weekdays, and patterns.

Learn how to insert and delete rows and columns in Excel, add new columns, and manage formatting to maintain your sheet's structure.

Learn how to insert and use hyperlinks in Excel to link to sheets, documents, websites, and emails with a single click, boosting navigation and efficiency.

Learn to create and customize tables and advanced tables in Excel, apply styles and color headings, and perform core calculations like sum, average, count, max, min, and standard deviation.

Learn how to apply data validation in Excel by setting a numeric range with a minimum of 50 and maximum of 200, plus input and error messages to guide users.

Learn to remove duplicates in Excel by selecting a data range, using data remove duplicates to isolate unique designations and locations, and verify the resulting unique values for data processing.

Create a drop-down list in Excel using data validation and a source, and use it in dashboards to enable changes in the dashboard.

Learn to format the column chart in Excel within the complete Microsoft Excel master class by adding data labels, applying colors, and adjusting formatting for readable visuals.

Create and format a pie chart from a quarterly sales dataset, building a dashboard that visualizes sales shares. Use a dropdown to update insights, highlighting Carnival as the highest seller.