Complete Microsoft Excel Master Class.

Microsoft Excel enables calculations, visualizations, dashboards, and automation through VBA across Windows, Mac, and Android, including optimization, statistics packages, regression, forecasting for supply chain demand.

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 to create a new file template in Excel, customize data, edit numbers, work with charts, export templates, and close the file.

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.

Learn the sumproduct formula in Excel to calculate the total amount by multiplying quantities by prices and summing the results across items.

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

Learn to use the index formula to retrieve a student's name by position in a 50-student list, by specifying row and column indices and understanding the intersection.

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.

Apply the and formula to evaluate conditions for a pay hike. Assess whether years at the company exceed five and the performance rating exceed eight to determine eligibility.

Learn how to use the if formula in Excel to perform a logical test on student marks, flagging results based on a 50-point threshold.

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

Master date and time formulas in Excel by learning how to calculate the number of days between dates and use start and end dates for accurate duration calculations.

Apply font formatting, borders, colors, and alignment, and master number and currency formats in Excel to create clear, professional spreadsheets.

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.

Explore conditional formatting in Excel, applying color schemes, icons, and data bars to numbers, using rules to highlight highs and lows from 10 to 190.

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.

Learn how to insert comments in Excel, review them, and edit or delete comments. View all comments across a sheet and manage them to keep your workbook clear.

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 to freeze panes in Excel to keep headers and key rows or columns visible while scrolling. Unfreeze when needed and adjust the view for large data sets.

Learn to customize views in Excel to display only selected fields like name, designation, and location, while hiding others for managers or strangers.

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.

Master data visualization with column charts and bar charts, learn how to insert, format, and customize charts, add data labels and chart titles, and read data at a glance.

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.