Excel for Business Life, From Beginning to Advanced

Learn Excel fundamentals for beginners: understand workbooks, sheets, cells, and formulas, perform basic calculations with sums and auto-sum, format data, and use core menus for common tasks.

Learn to format cells in Excel using autofit for columns, long date format, United States dollar currency, and merge and center; apply alignment, rotate text, and format painter.

Create and rename ship sheets, link cells to ships and external pages, and use hyperlinks and buttons for easy navigation; hide, delete, and color-code sheets as part of worksheet properties.

Master Excel sorting to organize data by country, alphabetically, by total sales, or by color. Apply sorting to the whole table using the data menu, right-click, or custom lists.

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.

Explore data filtering in Excel, using data field and combo boxes to refine by country, city, categories, products, and sales, with text, color, top/bottom, and between options.

Learn to filter payments by dates using date filters in Excel, including today, yesterday, tomorrow, this week, year-to-date, and between any two dates, with sorting oldest to newest.

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.

Create and use custom lists in Excel to manage workers, HR data, and store contacts with automatic name filling. Save these lists on your computer for reuse across workbooks.

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.

Create and work with pivot tables in Excel by converting data to a table, setting data sources, refreshing results, and customizing layouts, colors, timelines, and subtotals.

Create and use a pivot table with a calculated field for net income margin. Compute net income divided by total sales to reveal margins by product type and sales channel.

Merge multiple tables into a single pivot table by creating relationships in the data model to analyze sales data across customers, products, channels, and customer types.

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.

Master Excel text formulas to combine names, extract substrings, and format case, plus clean and split data with text to columns, find, substitute, and trim spaces.

Learn how to use Flash Fill in Excel 2013 to split names, format phone numbers, create emails, and auto-complete data with correct capitalization.

Explore statistical formulas in excel, mastering sum, count, sum if, count if, and average if, plus and/or logic and fixing ranges with f4 for country and product data.

Explore date and time functions in Excel, convert dates to numbers, add or subtract days and hours, calculate last days of months, and compute workdays with holidays.

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.

Create a local vlookup formula that searches two tables (or a second sheet) and uses an if statement to handle not found or error results.

Master advanced filter functions in Excel to filter by complex criteria, copy results elsewhere, and compute sums, averages, max, and min on the filtered data.

Master the Excel formulas menu to insert common functions, preview arguments, and perform calculations like average or total using criteria and data fields.

Learn to apply Excel data validation to restrict input, enforce lists for cities and categories, validate dates and prices with min and max, and show input messages and alerts.

Explore how to apply conditional formatting in Excel to highlight trends and outliers with color scales, data bars, and icon sets; manage rules, top/bottom picks, and duplicates or unique values.

Master goto special to identify blanks, constants, formulas, and errors, then manage visible cells, copy only visible data, and delete shapes or objects while applying conditional formatting in Excel.

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.

Master Excel data consolidation by combining multiple lists or balance sheets, matching item names, and summing numbers across sources with reference, headers, and lookup methods.

Explore how watch windows and trace cells in Excel help model financial scenarios, link calculations, and compare shifts across multiple windows, including DCF, WACC, and financial statements.

Learn to protect Excel worksheets by locking and unlocking cells, enabling password protection, and configuring who can edit, select unlocked cells, and change formats.

Protect the workbook structure with a password, restrict access to data sources, pivot tables, and dashboards, and encrypt the password to keep resources hidden from customers.

Learn to configure Excel print settings using page layout and page break previews, adjust margins and orientation, and set headers, footers, and page numbers.

Explore the relationship between pdf and printer settings, illustrating how saving a document as pdf mirrors printer options and print preview across pages.

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 creating and customizing pie chart graphs in Excel for business data, including 3-D pie charts, data labels, legends, and formatting options.

Learn how to create picture graphs in Excel by replacing columns with pictures, adjusting gaps and axis options, and customizing shapes and colors to visualize data.

Explore creating in-cell graphics in Excel using conditional formatting, repeat functions, and sparkline line charts; customize colors, highlight highs and lows, and export visuals to PowerPoint.

Learn to use goal seek in Excel to find production quantity needed for target profit, using break-even analysis with fixed costs, unit costs, and revenue per product.

Explore building a two-variable data table in Excel to model net profit as production quantity and unit price change. Use what-if analysis with row and column inputs and color-coded results.

Learn to use Excel solver to maximize net profit by deciding standard and luxury computer production within RAM, hard disk, and inventory constraints, with integer nonnegative limits.

Learn to maximize profit by selecting production quantities of tables and chairs under machine capacity constraints and integer requirements, using Excel solver.

learn to build a transportation model in Excel solver, set up production capacities, supply and demand constraints, and minimize total cost to find the best integer solution.

Explore scenario analysis in Excel using the scenario manager to define changing cells, create multiple scenarios, and compare results like target price, market capitalization, and DCF.

Explore Excel's cut, copy, and paste options, including paste special for formulas, values, formatting, comments, data validation, and links, plus transpose and array formulas.

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.

Learn to fix headers in Excel by freezing panes, selecting the intersection of rows and columns, and using the View menu to keep headers visible while scrolling.

Explore the view menu in Excel to create custom views, adjust zoom, freeze and split panes, and arrange and synchronize scrolling across multiple workbooks for side-by-side comparison.

Create a combo box in Excel to link data and drive dynamic charts with the offset function, and add a trendline with its equation, r-squared, and forecast future values.

Learn to create and link a spin button and combo box in Excel, set min, max, and increment, and drive animated charts through connected cells.

Create a scroll bar in Excel to adjust values and charts, with min, max, and increment. Include page change, link the control, and use a spin button for price updates.

Learn to draw and edit shapes in Excel, create boxes with rounded corners, copy and align items, connect with lines and connectors, group objects, and build a project management chart.

Learn to fix formulas in Excel using the F4 key, lock column or row references with dollar signs, and copy formulas across cells, including multiplication chart and a data table.

Learn how to build a custom user defined menu in Excel, including adding copy-paste values, shapes, comments, and chart options, and managing menu items via customize options.

Use Excel to watch film by inserting media controls and a media player, linking to a movie file via properties and the movie's folder path.

Discover how the indirect function pulls data from other sheets by using cell addresses and sheet names, with practical examples like a stock market and balance sheet data.

Learn to shuffle data in Excel by adding a random column with RAND(), fill down, and sort by that column to randomly reorder rows while keeping data intact.