Microsoft Excel Essentials for the Real Time World

Explore essential Microsoft Excel terminologies, including workbooks, spreadsheets, ribbons, tabs, toolbars, and key groups like clipboard and font, then learn to use bold, text color, and the quick access toolbar.

Learn core Excel terminologies by exploring the workbook, sheets, and cells—the active cell and formula bar—along with the name box and cell coordinates for rows and columns.

Master data navigation in Excel using scroll bars, arrow keys, page up/down, and ctrl+home to move through large worksheets quickly and locate any cell.

Master data selection in Microsoft Excel by using move tools, fill handle, and the selection tool; learn keyboard shortcuts like shift-drag, ctrl+A, and the corner triangle to select large datasets.

Master data entry and editing in Excel by creating a blank spreadsheet, entering daily expenses, and overwriting, deleting, and undoing cell data with keyboard and ribbon tools.

Discover how formulas and functions in Microsoft Excel drive basic and advanced calculations, using the equals sign, the sum function, and predefined argument order.

Apply formulas and functions in Excel to compute totals and quantities using addition, subtraction, multiplication, and division in a picnic scenario with students, food boxes, gift boxes, teams, and teachers.

Explore online delivery data in a spreadsheet, applying formulas to compute order value, discounts, and total revenue. Learn to use the fill handle to auto-fill calculations and derive key metrics.

Learn Microsoft Excel basics, including the sum function and autosum, selecting ranges with the equal sign, using autofill and fill handle to compute quarterly totals.

Explore average, minimum, and maximum functions in excel by calculating sales data from manager cell ranges, revealing the overall mean, the top performer, and the lowest performer.

Master absolute and relative references in Excel to lock fixed values with the dollar sign in a commission table.

Align data in Microsoft Excel using left, right, and center options, vertical alignment, wrap text, and rotate text to create clean, professional layouts.

Learn to align data using left, right, center, and vertical alignment to position headers and totals, and apply wrap text, rotate text, and merge and center for professional layouts.

Use the format painter from the home tab to copy font color, bold, and italic formatting to names, and create banded rows and design format tables.

Apply currency, accounting, percentage, and date formats in Microsoft Excel using the home tab and number tool. Adjust decimals and symbols to clearly present figures and dates.

Learn to use styles and themes in excel to streamline formatting, apply heading and column styles, and highlight totals with theme options.

Learn to use find and select in Excel to locate and replace data, find next, find all, and replace all, with an example changing ship mode from bus to plane.

Learn to use data filtering in excel with the filter tool and data tab. Isolate orders by account manager and ship mode, and apply top ten and greater than filters.

Learn how to sort data in Excel with the sort and filter tool, add levels for multi-criteria sorting, and organize by account manager and order priority using headers.

Explore conditional formatting in Excel to highlight data with rules like greater than, less than, and color scales, visualize top and bottom values, and apply data bars for clear analysis.

Learn to create and compare charts in Microsoft Excel, including pie, column, and line charts, using the Insert tab to visualize quarterly data and trends.

Learn to edit charts in Excel by using chart design options and the change type tool to switch between column, line, and bar charts, and customize colors to fit branding.

Edit charts in Excel by adding chart elements, naming the chart and axes, and applying colors, filters, and formats to highlight sales figures for Alice, Anna, and Deborah.

Move and resize charts in Excel by selecting data, inserting line, column, or pie charts, then use move tools or corner handles to place or resize charts.

Learn how to use count functions in Excel to tally numeric orders, handle alphanumeric data, and identify blanks, revealing 500 total orders and 169 missing records.

Explore data ranking in Excel by using the rank function with absolute references and descending order, visualize results with conditional formatting color scales.

Combine text in Excel using concat and the manual formula to form full names and generate email IDs. Adapt for different Excel versions and manage spaces with quotation marks.

Learn to clean and standardize text in Excel by using the upper, lower, and proper functions to fix mixed case data from forms and surveys.

Learn how to extract data from location codes in Excel using left, right, and mid functions to obtain floor numbers, unique IDs, and building direction.

Learn how the find function in Excel searches for substrings within a string, demonstrating case sensitivity, start position options, and how it returns the first match position.

Learn how to use the if function in Excel to perform logical tests, compare scores with operators like equal and greater than, and return true or false.

Master nested IF in Excel to handle multiple logical conditions, assigning pass or fail for scores above 50 and grading with A, B, and other thresholds.

Master vlookup in Excel to fetch prices from a table using lookup value, table array, and column index number, then apply exact or approximate match and calculate total revenue.

Learn how to apply Vlookup with approximate match to compute commissions from sales ranges, using ascending tables and absolute references.

discover how to create, rename, and delete name ranges in Microsoft Excel using the name manager.

Learn to create drop-down lists in Excel using data validation, define a list source such as marketing, finance, and HR, and name ranges for efficient data entry.

Learn to print Excel workbooks, choosing active sheet, entire workbook, or selection, and adjust orientation, margins, scaling, and page setup, using Ctrl+P for quick printing.

Learn how to use the and function in Excel to combine conditions and streamline real-time data analysis.

Master the Excel cell function in Microsoft Excel Essentials for the Real Time World to retrieve a cell's address, color, content, formatting, and references for dynamic data analysis.

Master the Excel mid function by specifying a starting position and length to extract a substring, noting that spaces count toward the result and can yield a web URL.

Discover how the not function in Excel flips true to false for single cells, and why it errors with words, while numbers like zero are treated differently.