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 to use the transpose option in Microsoft Excel to switch data from horizontal to vertical (and vice versa) with paste special, including practical steps and examples.

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.

Learn how to lock cells in Excel to apply a five percent revenue growth across months, using absolute references and the F4 shortcut while dragging formulas.

Multiply price and quantity to generate revenue combinations in a multiplication matrix, using cell locking with absolute references to fill the table efficiently.

Explore how subtotal delivers dynamic calculations for sums, counts, and averages, and compare it with standard sum when filtering data and using named ranges for revenue.

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 how to use the lookup function in Excel to perform vertical and horizontal lookups, matching a value with a table and returning country, distributor names, or sales channels.

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 the index function in Excel as the opposite of match, using rule numbers and column headers to retrieve country names from a dataset.

Discover how to nest index and match in Excel to retrieve revenues by rule numbers and populate tables.

Learn how to automate index and match in Excel to dynamically determine column numbers, lock references, and fill large datasets efficiently.

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 clean and split a single-column dataset in Microsoft Excel using the text to column feature, selecting the delimited option and identifying common delimiters.

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 to clean text with the clean function and use Excel's remove duplicates to keep a single record per unique value for accurate data analysis.

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.

Learn to use left, right, and mid functions in Excel to extract area codes and phone numbers, and automate updates across a dataset for dynamic, accurate results.

Explore text formatting in Microsoft Excel by applying upper, lower, and proper case functions to a sample distributors dataset, and learn how to drag formulas across cells.

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.

Learn how to use the countifs function to count data by specifying a criteria range and a criteria, with case-insensitive matching and comparison operators across products and segments.

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.

Discover how to use the sumifs function in Excel to sum revenue by product with criteria ranges and exact or range-based conditions.

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 build an advanced sumifs formula to compute revenue from content produced by government segments in Canada across online sales channels, using multiple criteria, named ranges, and locked references.

Learn how to use the IF function in Excel with logical statements to test revenue against a 200000 target, returning true/false and concatenating the segment and country when met.

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 create pivot tables in Excel to summarize revenue by distributor and by country and sales channel, using drag-and-drop to arrange fields and calculate sums.

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 value options to summarize data: switch between sum, average, count, max, and min, display percentages of grand total, and drill into details.

Explore pivot tables in Excel and learn to create calculated fields that compute 10 percent of total revenue, producing a new savings column.

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 to sort pivot tables in Excel to identify top 10 distributors by revenue or units sold, and to reveal bottom five performers using value field settings and dropdown filters.

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.