Microsoft Excel for Business Professionals

Learn how to build basic Excel formulas with the equal sign, operands, and operations, follow order of operations, use cell references, and explore functions and the insert function.

Explore basic Excel formulas for business data: format cells, compute totals, averages, and counts, and link cells to build dynamic dashboards with formatting and freeze panes.

learn how to copy and paste in excel, use paste special to paste values, formulas, or formats, and apply comments and data validation to manage hardcoded results and formatting.

Learn how relative references adjust when you copy and paste formulas, and how absolute references lock rows or columns with dollar signs to fix constants like a 54 percent rate.

Learn to manipulate data in Excel by calculating profit or loss from market values and purchase costs, using formulas, locking cells, and subtotals with filters.

Learn to use the if function and sumifs to sum purchase costs by criteria, such as bonds and corporate bonds, with quick checks using count if and average if.

Discover how to use vlookup to search the leftmost column of a table and return a value from a chosen column, with exact-match options and error handling.

Learn to manipulate Excel data with custom inputs using left and right to extract digits, month conversion for purchases, sumif for totals, and concatenate to create unified lookups.

Discover how pivot tables summarize and analyze data in Excel, using fields, filters, and layout options to compute sums by security type and time period.

Explore specific Excel formulas for accounting, finance, and marketing, focusing on pivot tables, lookups, and criteria-based data extraction to solve real business data needs.

Explore Excel finance functions like IRR, NPV, present value, and PMT. Navigate four scenario tabs to learn input of cash flows, application of discount rates, and loan payment calculations.

Learn to turn monthly marketing data into clear visuals by creating formatted tables and charts in Excel, with subtotals, colors, axis labels, and automatic updates.

Explore using Excel to perform common accounting functions. Learn to calculate total assets, liabilities, revenue, expenses, and net income from a trial balance using sum formulas and criteria.

Learn how to build and document work papers in Excel for taxes and client work with clear references, tab naming, and headers so peers can follow calculations with fewer questions.

Choose a professional font like Georgia, adjust column widths, align numbers, and apply currency formatting and subtotals to create a clean, professional Excel workbook.

Learn to label spreadsheets with clear titles, headers, and sheet names (sales revenue 2015), insert rows and columns, and apply bold, italics, alignment, and color fill for clear presentation.

Master referencing as a core best practice for work papers, naming tabs and tracing calculations to clearly show data sources.

Explore conditional formatting in Excel to highlight cells by criteria, such as unpaid invoices and text matches. See real-time updates and labeling to ensure clear work papers.

Master Excel functions such as average, subtotal, and pivot tables, plus shortcuts for copy-paste, autofill, and moving formulas, and navigate with control bracket, page up/down, and absolute/relative references.

Master key data analytic formulas and functions, including lookups, for business analysis. Learn work paper preparation with clear references and earn a completion certificate for achieving 70 percent.