Microsoft Excel Functions For Business

Explore Excel paste special options to paste values, formulas, and formats, and learn how to copy formulas, preserve references, and apply consistent formatting across worksheets.

Master Excel paste special operations to add, multiply, and divide values without changing formats; learn using values, currency formatting, and formulas to correct and format data.

Learn how to fill a serial number column in Excel when data has no index. Use the fill series tool (linear, start at 1, step value) to fill down.

Explore how subtotal differs from sum in Microsoft Excel and apply dynamic calculations to revenue by sales channels, excluding subtotals to get accurate totals for the organization.

Learn to use vlookup in Excel to look up values in a table, return data from a specific column, and choose exact or approximate matches, including named ranges.

Learn how to perform a horizontal lookup (hlookup) in Excel by transposing a dataset, naming the range Dataset, and using an exact match to retrieve distributor names and related revenue.

Explore lookup functions in Excel by using lookup value, lookup vector, and end result vector, and learn when to perform vertical or horizontal lookups for accurate results.

Explain the difference between exact match and approximate match in vlookup, showing how false returns precise results and true yields range-based outputs, with table locking and column index usage.

Explore how the match function in Excel returns the relative position of a lookup value, enabling exact or approximate matches and returning a row or column number for data lookup.

Explore nesting index and match functions in Excel to retrieve values from a dataset, demonstrate how to copy and lock references, and reproduce the same results without rebuilding rules.

Use the clean function in Microsoft Excel to remove unwanted symbols. Apply it to a cell and drag the fill handle to clean multiple entries.

Use the trim function in Excel to remove extra spaces from text in a dataset, producing neatly organized strings with single spaces between words.

Learn how to use Excel's substitute and if functions to replace product codes across a dataset, automate updates, and propagate changes without manual edits.

Learn how to convert numbers stored as text into real numbers in Excel using the Value function, so you can perform arithmetic and compute averages.

Learn how to use the right function in Excel to extract the last characters from text, such as phone numbers or area codes, and apply it across worksheets.

Discover how to use the mid function in Excel to extract a portion of text from a string by specifying the start position and the number of characters.

Explore how the left function in Excel extracts a specified number of characters from the start of a string to obtain the first two letters of a photo ID.

Learn to use the find function and the length function in Microsoft Excel to dynamically extract parts of a text string, and combine with left or right.

Master find, length, left, and right functions to extract numbers after the hyphen from product IDs, handling varying text lengths by combining length differences and position calculations.

Learn to extract the area code and number segments from phone strings in Excel using find, left, right, and LEN functions, with nested formulas adapting to varying digits.

Discover how the concatenation function in Microsoft Excel joins two or more text strings in one cell, with examples combining segments and countries such as Canada and Germany.

Learn data validation in Excel to restrict data entry, enforce date ranges, text length, and allowed lists, with custom error messages to protect data integrity.

Master advanced countifs in excel by defining multiple criteria ranges and criteria, count Montana sales by segments and online channels, and lock ranges for the multiplication matrix.

Explore advanced countifs with multiple criteria, building a multiplication matrix across segments, country, and online channels to count Montanan products sold by mid market and in Germany.

Master advanced sumifs techniques in excel by building multi-criteria revenue queries for Montana products across segments and online channels, using absolute references to lock criteria and ensure accurate results.

Learn to use the if and or functions in Excel to return a value when any condition is met, with examples across enterprise, small business, and channel partners segments.

Use the if and and/or functions in excel to test multiple conditions and return true or false; nest if statements to identify enterprise sales over 200,000 and output the product.

Master nested if logic in Excel to evaluate production cost and revenue. Build multi-level decisions using and conditions to return the product name or not satisfied.

Activate and use pivot tables in Microsoft Excel to quickly analyze data by dragging and dropping fields, producing sums, percentages, or differences to solve business problems.

Learn to query datasets in Excel using PivotTable, sorting by the sum of revenue to identify top distributors, Montana product performance, and segmentation by channels, units, and revenue.

Learn to use pivot table slicers and timelines in Excel to filter data and build dashboards, sorting revenue by distributor, segment, and country across monthly dates.

Learn how to use pivot table label filters in Excel to sort data, filter by text labels, and apply options like equals, does not equal, and begins with.

Learn to apply pivot table value filters in Excel to isolate revenue by country and product, using options like between, greater than, and does not equal to to refine results.