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 data entry in a worksheet, including selecting cells, overwriting values, and saving with shortcuts and format options like excel 97–2003 and pdf.

Learn to select data in Excel using mouse, keyboard, or touch—from a single cell to column or data and type ranges—then copy, cut, and paste for quick data manipulation.

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.

Apply conditional formatting in Excel to highlight cells using rules, such as values greater than a number or within a range. Use icon sets to flag data with symbols.

Master practical cell formatting in Excel for business, including hiding and inserting columns or rows, applying built-in styles, standardizing widths, and using split view and conditional formatting.

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.

Learn to group data in Excel by selecting rows or columns and using the group feature to create blocks that can be hidden or shown with plus and minus signs.

Learn to locate and replace text across an Excel data sheet using find and replace, including Control F, Find Next, Find All, and Replace All across sheets in the book.

Learn to use spell checking in Excel sheets and other Office products to review and correct misspelled words, then finalize and share the document with others.

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 create and manage hyperlinks in Excel to link cells to websites, folders, documents, or emails, and navigate between sheets to boost interactivity in your workbooks.

Learn how to use the V look up, a vertical lookup, with a table array and column index to pull customer name and price by order number using exact match.

Learn how to use horizontal lookups with lookup tables to pull emails and names by ID, using exact-match and exploring vlookup and indexing concepts in Excel.

Learn to build and manipulate Excel formulas, perform sum and average calculations, and master array formulas using ranges, named arrays, and per-element operations to display results.

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 link cells across sheets in Excel by building formulas that multiply or divide values from sheet one and sheet two, using the equals sign and cell references.

Master Excel logical functions and if statements to build semi-automated rules that test values with greater than, less than, and equal comparisons, generating dynamic outputs.

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.

Diagnose and trace formulas in Excel by inspecting the formula bar and color-coded references to reveal how totals are built from linked cells and spot errors.

Discover how to apply rounding and integer formulas in Excel to format numbers quickly, including rounding to digits, converting to integers, and finding the nearest even or odd values.

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.

Activate analysis toolpak and solver in Excel to run ANOVA and other data analysis tools within a dataset.

Create and customize charts in Excel to visualize data, from bar and line charts to 3D styles, using sample income and expenses across year one and year two.

Prepare and publish your workbook for distribution by checking accessibility and compatibility across devices and Excel versions, and removing hidden data to ensure a professional, error-free delivery.

Learn to export Excel documents to other formats, especially PDF, using save as or print to PDF, with options for active sheets, entire workbook, and fit sheet on one page.

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.

Protect workbooks and worksheets in Excel using password protection and user permissions. Learn to encrypt a workbook, shield individual sheets, and tailor allowed actions for secure sharing.