Excel Genius Kids: Fun & Easy Learning

Explore the Excel main screen and ribbon, navigate cells, columns, and rows, and jump to a specific cell like z10. Add sheets and link data across columns and rows.

Master Excel's file features by creating or opening worksheets, saving or save as, and setting print options. Learn to browse directories and rename files, then share via email.

Create and label an Excel worksheet by adding data in titled columns for student name, origin, favorite foods, and age, starting at the first column to keep data series clear.

Learn to control and resize columns and rows in Excel using drag, auto-fit by double-clicking, and right-click options for column width or row height, including applying changes to multiple selections.

learn how to insert and delete columns and rows in excel, using right-click, the control and plus method, or the ribbon, and move data between areas with copy-paste.

Learn to hide and unhide columns or rows in Excel to control visible data without deleting it, using right-click and saving a new version before sharing.

Master copy, cut, and paste in Excel using right-click, the home ribbon, or keyboard shortcuts (Ctrl+C, Ctrl+X, Ctrl+V) to move or duplicate data in a main table.

Format Excel tables by adjusting font type and size, applying bold, italic, underline, adding borders, and using fill or text colors with alignment for a neat, professional look.

Learn to apply borders in Excel by selecting a range and choosing border types, from bottom to outside, thick or double, transforming a table from light to bold borders.

Learn to wrap text in a cell to display long headlines across multiple lines. Highlight the headlines and apply the wrap option to see a single line become two lines.

Resize columns to 35 and rows to 20, delete cells, and enter data to standardize formatting. Master all-direction alignment, including vertical top, center, bottom, and horizontal left, center, right.

Set text direction from left-to-right to right-to-left, and apply indents to create parent and child groups such as countries and cities, making lists more professional and organized.

Master how Excel formats numbers, currencies, percentages, and dates using comma style, decimals, and currency options, and learn to format cells through the format cells dialog.

Discover how to use the format painter as a magic pen to copy formatting from a selected column, row, or cells to new areas, saving time when formatting multiple columns.

Discover how to apply ready table formats in Excel, pick from multiple design options with a click, and confirm the table range for use across multiple tables.

Master time-saving data classification with Excel's conditional formatting to highlight below 80 as low grades, apply color scales and data bars, and spotlight top ten or top five values.

Explore how to use Excel formulas and equations from simple to complex across cells, sheets, and files, with practice and Excel's guided guidelines.

Demonstrate how to use the sum formula in excel to total grades across subjects, with steps to enter, drag to extend the range, and press enter.

Master the max formula to obtain the maximum number from a selected range, as shown with math 92, eyesight 98, physics 92, and chemistry 95, then drag to other subjects.

Learn how to use the min formula in Excel to obtain the minimum value from a data range, apply it to each subject, and drag the formula across cells.

Learn how to use the average formula in Excel to compute average grades across subjects, enter the formula, select a range, and format decimals.

Learn how to use the count formula to tally data in a range, illustrated by counting students in a class, ensuring the range contains numbers and excludes text.

Master calculating percentages in Excel by computing each student’s share from four subjects, totaling 400, using sum and a fixed total with absolute references, and formatting results as percentages.

Learn to join data from two cells with a dash to display a student's name and origin, then drag the formula to apply it to all rows.

Apply the if formula in Excel to assign a letter grade, showing F when grades are less than 75, and drag the formula across other cells.