Learn Excel for Business

Explore the Excel environment for 365 and 2019, opening the app and navigating the home, insert, and view ribbons to create a blank workbook and use formulas.

Learn to adjust columns and rows, auto-fit and wrap text, and format cells including font size, color, alignment, currency, dates, times, and tables, for clear business spreadsheets.

Use the quick analysis tool to apply conditional formatting fast by dragging across cells, choosing data bars or color representations, and applying a greater-than rule; easily clear formatting when finished.

Apply Excel's data validation tool to identify numbers outside a defined range, circle invalid data, and highlight values beyond one to fifteen to guide quick data quality checks.

Learn to compute sum and average in Excel using multiple methods, including auto sum, formula bar, and quick analysis totals. Discover practical steps to select data and generate results instantly.

Learn to use logical functions in Excel, including and, or, and if statements, to build tests and determine pass or not approved outcomes.

Apply absolute value, power, and square root functions in Excel, using abs to convert negatives, power for exponentiation, and sqrt for roots across data ranges.

Learn how to use the ifs function to perform multiple logical tests and assign values by numeric ranges in sales data by country, labeling outcomes as weak, moderate, or strong.

Learn to apply the sumif function for conditional sums, setting a range and sum_range to total values that meet a status criterion (good or bad) across large datasets.

Transpose a range in Excel to switch columns to rows, then use isblank, iserror, and iserr functions to check for blank cells and various errors.

Learn how to use essential Excel statistical functions such as average, max, min, median, and count variations (countA, count, count blank) to analyze accounting data and numerical sheets.

Verify print area with page break preview to keep data on intended pages. Select active sheet printing, margins, orientation, and fit to one page, or save as a pdf.