excel - a spreadsheet - learn simple

Select a worksheet area by clicking and dragging, and use control plus arrow keys to navigate to the edge of data for calculations.

Master worksheet areas and calculations in Excel by selecting columns and regions, formatting cells (currency, dates, time, percentage), and performing copy-paste operations to manage data.

Learn how to perform basic Excel calculations using formulas with the equals sign, arithmetic operators, and cell references, and extend formulas down for consistent results, including percentage calculations.

Learn to manage columns, perform data organization, and create formulas for simple calculations in Excel through the lab assignment.

Learn how to use cell references in Excel, including absolute and relative references, and build formulas to perform calculations across rows and columns.

Master cell references in Excel by learning how to copy formulas down, perform monthly sums and balancing, and calculate commissions from sales data.

Explore data analysis in excel from a lab assignment by examining earnings and balance statement, tracking monthly deposits, commissions, and product sales for a single customer in a bank.

Learn to enter and manage formulas in Excel using the formula bar, perform arithmetic such as multiplication and sums, copy and drag formulas, and reference cells and tables.

Master basic Excel calculations using the formula bar, apply sum and other functions, select ranges, copy formulas across columns, and compute net balances such as income minus expenses.

Explore the formula bar in Excel, learn to select multiple values with the Ctrl key, avoid duplicates in calculations, and build formulas with functions to compute totals across data.

Learn to use the formula bar to build basic Excel formulas, calculate discounts, multiply values, and fill cells by dragging.

Customize the Excel toolbar and ribbon by adding commands and buttons. Explore the main components—tabs, groups, buttons, and dialog boxes—and work with formulas and functions in worksheets.

Explore the home tab in excel, including applying borders, adjusting border lengths, and managing column data and headings to refine layout.

Explore the home tab features in excel to adjust cell alignment, orientation, and margins, and practice applying center alignment and vertical options.

Explore the home tab in Excel by navigating to calculations, analysis, data collection, accounting, and profile options, with emphasis on normal view and practical data handling.

Explore how to apply conditional formatting in Excel to highlight values using thresholds (greater than, less than, between, equal to), show arrows, and use top and bottom rules plus averages.

Master the home tab essentials for Excel: convert data to a range, insert or delete cells, and add rows or columns to adjust your worksheet.

Use the home tab to adjust row height and column width with click-and-drag or the format menu. Learn to hide or unhide columns and manage cell size and visibility.

Learn to manage data in columns, select cells, and create duplicate copies within Excel's home tab. Discover how to protect data with a password and unlock cells to customize access.

Learn to use the home tab to insert and copy formulas, understand serial number concepts, and apply basic Excel functions with practical examples.

Learn to use the home tab to apply conditional formatting and highlight the highest value in a data set, as part of Excel for beginners training.

Explore Excel essentials by inserting images, charts, maps, and embedded objects; create dynamic dashboards and visually rich reports.

Learn to use the insert tab to create a table, sort data by date, filter results, apply formulas, and format with color to keep data automatically updated.

Master page layout in Excel for beginners, learn how to set up layouts, adjust page scaling, and manage pages for clear, well-organized spreadsheets.

Master page layout in Excel for beginners by identifying areas and regions, organizing content across multiple pages, and applying practical formatting to improve clarity.

Explore the data tab in Excel to sort, filter, and import external data from web sources, and use text to columns with delimiters to split data.

Explore the data tab and use Scenario Manager to create, edit, and compare multiple scenarios across years, generating scenario summaries and reports.

Explore the data tab and complete a scenario lab assignment, practicing how to create and run scenarios.

Discover how to use the data tab to consolidate data from several ranges into one summary report, then create a blank sheet and place the consolidated results on sheet five.

Master data validation in Excel by setting criteria to control data entry, including minimum and maximum values and date rules like today minus seven days.

Explore data validation in Excel's data tab, learn to create custom lists and formula-based rules, and manage lists and arrays to enforce input constraints.

Learn how to use the data tab to create subtotals and group data by region, summarize product totals, and view grand totals for easy analysis.

Explore the data tab in Excel to apply subtotals and grouping to invoice records, including invoice number, date, and product name, through a hands-on lab assignment.

Explore how to protect Excel worksheets by locking cells and using passwords to prevent accidental or deliberate changes. Learn how to enable, verify, and manage sheet protection to safeguard data.

Explore the view tab in Excel to manage print area, page layout, and print settings, preview outputs, adjust margins, and create custom views for accurate printing.

Explore how to use the view tab in Excel to show or hide columns, scroll horizontally, and freeze a key column so it stays visible while navigating data.

Learn how the Excel file menu protects workbooks with passwords, controls worksheet permissions, saves and prints, adjusts page setup, and exports or emails files.

Explore Excel functions and their categories, from mathematical and statistical to financial and engineering, and learn how predefined formulas like sums operate on ranges in day-to-day tasks.

Explore mathematical functions in Excel, focusing on using range and criteria within formulas, including less than 200 and equal amount scenarios, with hands-on range selection.

Master multiplication, addition, and range operations in Excel to perform mathematical functions. Build skills in working with columns, calculating product, quantity, and profit.

Master mathematical functions in Excel, including rounding to the nearest multiple of significance, floor and ceiling, absolute value, remainder, and modulo operations, with practical examples.

Learn to apply Excel mathematical functions such as round, round down, log, tangent, sine, and the even integer function, with practical rounding and base examples.

Explore mathematical functions in excel to compute total stock and total value of products by category, and calculate the grand total across all categories in a lab assignment.

learn to use mathematical functions in excel via lab assignment by calculating total commissions for sales at or above 50000 with an 87 percent rate, and for sales below 50000.

apply mathematical functions in excel through lab assignment 3 to compute beans stock, including under 200 million, spray-painting stock, oil products sales volume, and total commissions.

Explore how to use statistical functions in Excel to compute conditional averages with single or multiple criteria across data ranges.

Discover how to use Excel's statistical functions to find maximum and minimum values. Apply index and match for lookups, and understand logical values (0 or 1) and numeric data.

Explore statistical functions in group c, including count, counta, countif, and countifs, using ranges and criteria to analyze employee data such as salaries, unions, and seniors.

Explore a beginner excel statistics lab analyzing employee data: totals by hobby, salary 30000 or more, senior status, and union employees 6000 or more using confidence calculations.

Engage with statistical concepts through lab assignment 2, analyze averages and interpret results to practice data analysis in Excel for beginners.

Explore how logical functions in Excel use if, and, or to check conditions, perform data comparisons, and return results based on true or false outcomes.

Hone basic Excel calculations through a logical lab assignment on commissions, percentage rates, category-based allowances, and related value computations in practical exercises.

Explore how date and time functions in Excel help beginners calculate today, current date, days between dates, year extraction, and weekday numbers using 360-day year conventions.

Explore financial functions in Excel, focusing on the payment function to calculate loan payments with constant payment, monthly or quarterly schedules, over a set number of installments, including interest.

Learn to calculate loan payments using Excel formulas for monthly, quarterly, and weekly schedules, and interpret outputs across different terms and payment frequencies.

Set up Excel charts from air data to visualize comparisons and trends using the x-axis categories, and create visuals like pie charts.

Explore how to set up and customize Excel charts, including adding axis elements, data labels, and legends. Adjust colors, layouts, and axis formatting to present clear, polished visuals.

Create and tailor Excel charts using columns, lines, bars, and areas, adjust X-axis to visualize data trends. Format data series and compare months of data to gain insights from charts.

Create and customize an Excel chart by aligning data on the horizontal axis, adjusting units, and configuring the line across columns to show minimum and maximum values and trends.

Explore pivot tables in Microsoft Excel to quickly summarize large data, transform columns into rows, and group or filter data by country, creating a new sheet for your pivot reports.

Pivot table 2 teaches creating a three-column layout to summarize data, compute total sales by region and by year, and display regional and yearly totals.

Explore pivot charts in Excel and learn how they rely on a pivot data source to analyze sales with different chart types; adjust year and region filters to compare performance.

Explore pivot chart in Excel to display items, inventory, lists, categories, and country data for beginners.

Create and filter pivot charts with slicers to explore regional sales by city and category, summarize items and grand totals, and compare performance across regions.

Learn to build and interpret pivot charts in Excel, organize data, track timelines, and label tables for clearer data analysis.

Participate in a lab assignment that works with given data, formats data, and builds a timeline to strengthen beginner Excel skills.

Learn to automate repetitive tasks in Excel by recording macros with built-in commands or VBA, and create templates with headings and formulas to run on new sheets.

Learn to record a macro in Excel to automate calculations, including the calculated formula for price discovery, discounts, tax, and enterprise totals.

Explore macro lab assignment in Excel, using formulas to fill salary statement columns, compute basic allowances and net pay.

Master the vlookup function in Excel by using lookup values, ranges, and table arrays to retrieve exact or approximate matches, illustrated with practical item sales examples.

Explore how to combine index and match functions in Excel to perform accurate lookups across table ranges. Practice with examples to retrieve values from specified rows and columns.