Become an Expert in Excel & Google Sheet Formula & Functions

Master basic arithmetic in Excel using additions, subtractions, multiplications, and divisions with formulas, then apply sum, average, max, and min to a cell range while observing the order of operations.

Learn to write and edit Excel formulas by starting with =, using multiply and sum functions to compute totals, switching to average, and adjusting ranges via the formula bar.

Master Excel formulas by using relative, absolute, and mixed cell references to improve efficiency and accuracy when copying across cells, with dollar signs locking references.

Master the basics of sum, average, min, and max functions in Excel to quickly total ranges, compute averages, and identify the smallest and largest values for data analysis.

Learn how to use the count and counta functions in Excel to quickly analyze data, counting numeric cells, non-empty cells, and items like sales and product names.

Master conditional logic with the if function in Excel, including true/false tests, nested and chained ifs, and practical grade calculations.

Master concatenate and textjoin in Excel to combine text, handle ranges, apply delimiters, and ignore empty cells for efficient data manipulation.

Master left, right, and mid functions in Excel to extract text from beginnings, ends, or centers, using find and length to isolate usernames before the at symbol and domains after.

Become an expert in Excel and Google Sheets formula and functions by mastering date, today, and now to manage dates, timelines, and time-sensitive calculations.

Learn to create and use named ranges in Excel to make formulas more readable, accessible across the workbook, and easier to extend in functions like sum and vlookup.

Explore array formulas in excel to perform calculations across ranges in one step. Enter with ctrl+shift+enter and apply examples like squaring a1:a5 and summing across ranges.

Master Excel financial functions like present value, future value, net present value, and internal rate of return to analyze investments and make informed financial decisions.

Learn to create pivot tables, drag fields to rows and columns, and summarize sales with sums and averages. Experiment with different field combinations to slice and dice data for insights.

Learn to filter and analyze data in Excel using slicers and pivot tables linked to regions and product category, with slicer settings to preserve your filtering and analyzing setups.

Discover how Power Query in Excel extracts, transforms, and loads data from multiple sources with a user-friendly interface, loading from tables or ranges and creating custom columns with AMP.

Learn to integrate Power Query results with Excel functions to perform advanced analysis, using sumif formulas to calculate totals by category after loading cleaned data into Excel.

Audit formulas in Excel by tracing precedents and dependents to map data flow, then use iferror and error functions to handle divisions by zero and other errors.

Explore trace precedents and dependents to visualize data flow in excel, understand inputs and outputs with arrows, and assess how changing values impacts related cells.

Master Excel error checking and correction techniques using built-in tools, formulas auditing, and common errors like division, value, reference, and name errors to ensure accurate, reliable spreadsheets.

Learn to speed up large Excel workbooks by optimizing formulas: choose appropriate functions, limit volatile calculations, use absolute references, and named ranges for faster recalculation.

Explore how Excel's formula autocomplete speeds up building formulas by suggesting functions, guiding arguments, and enabling easy use of name ranges and cell references.

Master essential Excel formula shortcuts for faster writing and copying, including starting formulas with =, using autocomplete, and handling relative and absolute references with dollar signs.

Explore how to customize Excel calculation options to optimize performance, including automatic vs manual calculation, F9 recalculation, workbook-level recalculation before save, and maximum iterations with error checking.

Master essential math functions in Google Sheets: sum, average, max, min, and count, to quickly total numbers, find averages, identify peaks and lows, and count numeric cells.

Master Google Sheets logic with and, or, and if functions to test conditions, nest decisions, and return true or false, boosting data analysis and automated decisions.

Learn to apply text functions in Google Sheets—lower, upper, proper, and concatenate—to standardize case, join text with spaces, and format names, titles, and addresses efficiently.

Master the left and right functions in Google Sheets to extract characters from the start or end of text, using product codes as examples.

Learn to create line, area, bar, and pie charts in Google Sheets to visualize data, customize colors, and compare categories.

Learn to use vlookup and hlookup in Google Sheets to search with a search key, define range and index, and choose exact or approximate matches for vertical and horizontal lookups.

Explore how to use Xlookup in Google Sheets to search a range, return a related value, and handle not found with exact or approximate match and search modes.

Import data from the web and HTML tables into Google Sheets using the import HTML function. Choose table indices and explore the XML approach for more complex HTML data.

Learn to automate repetitive tasks in Google Sheets by recording macros, applying formatting, assigning shortcuts, running and managing macros, and testing in a copy to prevent data loss.