Excel for Business Life, From Beginning to Advanced

Learn how to sort a table from left to right in Excel, preserving the leftmost column, applying multi-level sorts by country, city, and category, and using transpose to switch orientation.

Convert your data to a table and customize its design, colors, and total row options. Use slicers and pivot tables to filter data, analyze totals, averages, and other functions.

Learn to remove duplicates in Excel by copying and pasting columns, using the remove duplicates feature to display unique country names, and create unique two-column combinations for accurate calculations.

Learn to use subtotal and data groups in Excel to sort by country and city, calculate total sales and averages, and manage grand totals, summaries, and page breaks.

Learn to build and analyze data with pivot tables in Excel, including creating tables, arranging fields, sorting, grouping dates, slicing with slicers, and visualizing results with pivot charts and dashboards.

Learn to build formulas in Excel by starting with equals, referencing single cells or ranges, and using operators like plus, minus, and multiply. Use sum with comma or range syntax to total values, and connect formulas across sheets and workbooks, noting that changes update automatically.

Learn how the subtotal function calculates sums, averages, minimums, and maximums on filtered data, showing only visible values, and why it differs from standard sum in sales analysis.

Master lookup functions in Excel, including VLOOKUP, HLOOKUP, and INDEX–MATCH, with exact-match options and vertical or horizontal table strategies, and learn how data validation and sorting affect results.

Learn to pull external data from websites and text files into Excel, create live links to Word and PowerPoint, and refresh or update data across work documents.

Explore name manager in Excel to define and edit names for cells and ranges. Replace spaces with underscores, and use these defined names in formulas for clearer, scalable calculations.

Create and customize Excel charts and graphs using the insert menu; choose line, bar, pie charts, adjust axes, titles, labels, legends, and data tables, and save chart templates for reuse.

Create and customize column graphs in Excel, manage multiple data series, add data labels and chart titles, adjust axes and legends, and switch chart types for clearer visuals.

Explore how the F4 key repeats the last action in Excel, including inserting columns, formatting changes, and repeating operations across selections, while noting function key behavior.