Complete Excel Functions - From Beginner to Mastery

Master essential Excel basics in a practical crash course, starting from a blank workbook and data entry to formatting, formulas, and quick analytics like sum, average, revenue, and profit.

Learn to create and tailor charts in Excel using the Insert tab, choosing bar, line, area, and combo charts to visualize revenue, expenses, and profits.

Learn to organize multi-year data in Excel by duplicating sheets, renaming them by year, and building a master sheet that sums profits across years with cross-sheet references.

Learn to build a simple income statement in Excel by tracking expenses and income with color-coded categories, totals, and a pie chart to visualize where money comes from.

Learn to build a productivity chart in Excel that tracks time across Unreal Engine, development, guitar, and YouTube, converts minutes to hours, and uses a diary to improve focus.

Track expenses in Excel by listing items and costs, sum to show total spent, and visualize where you’re spending your money.

Explore Excel functions for managing product lists, including depreciation and inventory, and master lookup techniques with choose, vlookup, index, and match to retrieve colors and car options.

Use the if function to categorize six products by price, assigning depreciation for prices over 500 and inventory items for prices under 500, with three arguments.

Nest and or functions within reference formulas to evaluate multiple conditions inside an if statement, demonstrating customer-specific outcomes for price, type, and capacity.

Explore how to use the choose function, vlookup, index, and match to fetch colors and door counts from a table based on color codes.

Master the vlookup function to fetch a color code from a source table by matching the color as the lookup value, using the correct column index and an exact match.

Explore Excel logic and lookup functions, including the if function with price thresholds and the and/or tests, then master choose, index, match, and vlookup for exact lookups.

Master aggregate data in excel using sum and subtotal for shop figures. Learn to compute min, max, and averages, forecast values, and assess investments with net present value.

Learn to use the sum function to total six shops' sales over six months and tailor the range as needed, then apply the subtotal function by retail and B2B types.

Learn to calculate the minimum, maximum, and average sales for six shops in Excel using min, max, and average functions, and apply conditional formatting to color extremes red and green.

Forecast values with the forecast linear function, projecting the next three months of shop sales from six months of data, and extend to three years of customers from five years.

Learn to generate net present value in Excel with the npv function, using a seven percent discount rate and a cash flow sequence that includes initial investment and yearly inflows.

Explore sum and subtotal to aggregate data, compare min, max, and average with conditional formatting, forecast sales and customers using forecast linear, and assess investments with npv and discount rate.

Explore date and time functions in Excel by mastering date formatting, calculating payment terms and credit days, and predicting day of the week for future holidays.

Master date manipulation functions in Excel to compute due dates by adding payment terms to invoice dates. Use today to calculate credit days.

Build a holiday calculator in Excel to project New Year's Day, Independence Day, and Christmas Day across years, using date formulas and custom formatting to show weekday names.

Master date functions and formatting for invoices and debt collection, using Today to compute total credit dates, and split, reformat, and concatenate date data for holiday planning.

Split a column into multiple columns with the text to column tool, then replace text, join names, generate emails, and handle errors using informational and hyperlink functions.

Learn to split textual data in excel with text to columns, using delimited options and comma or hyphen delimiters, to create first and last name columns.

Learn to manipulate textual data in Excel by using functions such as length, proper, left, right, and mid to extract and format characters.

Learn to clean up text in Excel by using the replace function to remove characters, replace hyphens with spaces, and make the title column show only the title.

Combine first name and last name into a full name with a space using concatenate or ampersand, then create emails in the first name dot last name format.

Learn to evaluate and resolve common Excel errors, including division by zero, value, name, not available, and ref errors, using VLOOKUP and IFERROR for robust worksheets.

Use the hyperlink function to build navigational menus within an Excel worksheet, linking detail sheets to a main menu and adding button shapes to return home.

Explore Excel text and information functions, learning text to columns, left/right/mid extractions, upper formatting, concatenation, and replacement to build emails and navigation menus via hyperlinks while handling common errors.

Filter and sort transaction data using column drop-downs, target criteria like salesperson, product line, and date, then freeze headers and remove duplicates to streamline turnover analysis.

Learn to filter in Excel using the data tab and filter button to view specific records by salesperson, date quarter, and product line.

Sort a table in Excel without messing up the data by using single and multi level sorts, prioritizing turnover and date with headers to align oldest to newest.

Freeze rows or columns in Excel to keep the headline visible while scrolling, using freeze panes, freeze top row, and freeze first column, then unfreeze as needed.

Explore how to remove duplicates in Excel to reveal unique product lines, count invoices, and extract maximum values per salesperson by using the data tab and the remove duplicates tool.

Learn how to use Excel filters and sorts on columns, apply freeze panes for large tables, and remove duplicates to reveal unique values and summarized lists.

Master essential Excel functions like count and countif, create an inventory dropdown, use isnumber and search, apply conditional formatting to overdue rows, and build an invoice template from scratch.

Master count, counta, and countif to tally numbers, non-blank cells, and criteria-based counts in a customer database, including USA customers.

Create a dropdown list in Excel via data validation using inventory as the source, copy it across cells to prevent entry errors, extend the range, and use input messages.

Use isnumber and search together to identify iron in invoice numbers, then extract the point of sale and serial number with left, right, and search for secure text parsing.

Format rows based on overdue days using conditional formatting to color invoices red, orange, or green, driven by a formula comparing today’s date to due dates.

Create a from-scratch invoice template in Excel. Use data validation for customer dropdowns and vlookup with iferror to fetch VAT, address, and city, and compute due dates from payment terms.

Master count, counta, and countif functions, and build drop-down lists for reliable data entry. Use left and right text extraction, conditional formatting, and VLOOKUP with IFERROR to generate dynamic invoices.