Complete Microsoft Excel with AI – Beginner to Advanced

Explore how Microsoft Excel serves as a spreadsheet tool for organizing, analyzing, and visualizing data, offering data management, charting, formulas, and automation to support decision-making across business, finance, and education.

Explore freelance and career opportunities with Excel, from data cleaning and dashboard automation to financial reporting, across departments, with flexible remote work and strong earning potential.

Discover multiple ways to open Excel, including the start button, all applications, the search button, pinning to start, and the run command via Windows R, choosing the most convenient option.

Explore the Excel startup screen to create or open workbooks with blank, templates, or recent and cloud options, while managing accounts, themes, autosave, and add-ins.

Explore the Excel application window, including ribbons and tabs such as home, insert, page layout, formulas, data, and review, and master quick access bar, autosave, formula bar, and name box.

Learn to maximize workspace in Excel by showing and hiding the ribbon: double-click to minimize, use full screen for more rows, or show tabs only.

Improve efficiency in Excel by customizing the quick access toolbar to open files, create new workbooks, attach files as attachments, and draft an email, along with print and sort commands.

Explore the status bar in Excel, including ready status, macros recording, accessibility checks, view modes (grid, page layout, page break), and zoom controls.

Define workbook and worksheets, and identify columns, rows, and cells. Learn how to navigate, name cells like F8 and J14, use ranges, and create and rename sheets.

Learn to save a new Excel workbook by naming the file, choosing the .xlsx extension, and using save or save as, with autosave and Ctrl+S for quick saving.

Learn to close and reopen an Excel file using the close button, escape, or Ctrl-F4, then open from recent files or browse cloud locations like OneDrive or SharePoint.

Master essential excel shortcuts to speed up work, including ctrl n for new workbook, ctrl s to save, and alt f4 for closing all windows.

Learn to enter data in Excel by typing into cells, create a header, and track attendance for employees with names and monthly columns (Jan, Feb, Mar) in a new workbook.

Enter attendance data in Excel and observe right-aligned numbers versus left-aligned text. Identify numbers stored as text and convert them to numbers to enable sums.

Enter dates in Excel; typed dates convert to date values stored as serial numbers, right-aligned, and you can apply short, long, or custom formats with now for date and time.

Learn how to use Excel formulas, starting with equals, to sum values and reference cells like B6 and B7. The lesson demonstrates copying formulas and verifying totals such as 413.

Explore relative and absolute cell references in excel, and fix references with dollar signs using F4. See how copying formulas moves or locks cells like E12 to ensure correct percentages.

Learn the bodmas rule and the order of operations in Excel formulas, using brackets to control calculations for accurate results, demonstrated with a 10+5*2 example.

Learn the structure of an Excel function: start with the equals sign, name the function, and supply parameters or arguments using the formula bar, insert function, or fx button.

Master the sum function in Excel by summing a range like B6 to B11 and seeing the result. Use different insertion methods to create the sum formula.

Learn to use Excel's max and min functions to find the largest and smallest values in a range, and select the correct range without blanks.

Learn to use the average function in Excel to compute the arithmetic mean of a data range, demonstrated with attendance figures and a contrast to the sum divided by count.

Explore how the count function in Excel tallies numeric cells in a range, skipping non-numbers, and combine it with sum to compute an average by dividing sum by count.

Explore AutoSum in Excel: sum across noncontiguous ranges with Ctrl, use Alt-Equals for quick totals, and leverage autofill to extend formulas and switch to average or other options.

Learn to move and copy data across sheet boundaries or files using drag-and-drop, cut and paste (ctrl x/v), or copy and paste (ctrl c/v), with undo via ctrl z.

Learn how to insert and delete rows and columns in Excel using mouse options and keyboard shortcuts, including selecting rows with shift+space, selecting columns with ctrl+space, and inserting with ctrl+shift+plus.

Learn how to adjust column width and row height in Excel by selecting columns or rows, dragging with the two-headed arrow, and using auto-fit for precise sizing.

Learn how to hide and unhide columns and rows in Excel, using right-click and the home format visibility tools, and recognize hidden versus deleted data.

Rename worksheets in Excel to organize data by meaningful tab names, such as attendance or board mass, and use tab colors to group related sheets.

Delete a worksheet with caution, since undo does not recover a deleted sheet. Recover by closing without saving or using version history, then learn to move or copy sheets.

Learn how to duplicate, move, and copy worksheets within or across workbooks, using drag or right-click options, and how to hide and unhide sheets.

Learn to format data by changing font colors and styles, including bold, font size, and underlines, and apply theme or custom colors for presentable spreadsheets.

Apply background and header cell colors in Excel using the paint fill color tool, adjust the font color, and extend color to all selected cells.

Learn how to apply borders to headers and data, choose borders, thickness, color, and style, and remove borders. Also customize grid lines, formula bar, and headings in view options.

Format numbers in Excel using currency and accounting formats, adjust decimals, and explore custom cell formatting for salary data and negative values.

Learn how to format values as percentages in Excel using the percent button in the home numbers group, converting 0.5 to 50% and adjusting decimal places with increase or decrease.

Apply the format painter to quickly paste only the formatting across cells, including header style, font color, and bold, by clicking format and optionally double-clicking to extend across ranges.

Apply predefined cell styles from the Home tab to format headers and cells, adapt colors with themes, switch to normal style, and use ctrl d to copy formulas down.

Merge cells in Excel to create a single header from seven columns using merge and center, with the name box showing the first top-left cell (such as B2) after merging.

Master conditional formatting in Excel by applying predefined rules, creating custom formats, and using data bars, color scales, and duplicate highlighting to visualize data clearly.

Learn how to insert images and illustrations in Excel, using pictures, stock images, or online sources, with place over cell or over cells, crop, resize, and shapes.

Insert shapes in Excel to create hyperlinks and navigate between sheets, linking to the board mask sheet, then format color, style, and text.

Insert SmartArt in Excel via insert, illustrations, SmartArt to create hierarchy and other layouts; edit text, resize, and apply colors with the SmartArt design menu.

Learn to insert a screenshot in Excel by using insert, illustrations, and screenshots, including screen clipping to capture and insert images. Then transition to charts.

Create and customize charts in Excel to visualize large data sets, using recommended charts, insert options, and chart design and format menus.

Master Excel chart customization by editing chart elements such as the chart title, y-axis and x-axis labels, data labels, data table, legends, and gridlines, then apply styles and filters.

Explore the chart design ribbon in Excel, including add chart element, quick layout, color changes, switch row and column, select data, and moving charts to new sheets.

Explore the format ribbon in Excel to customize chart area and series with solid colors, gradients, and shadows using the format selection pane.

Learn to create and format a pie chart in Excel by selecting the right data (employee name and total) and displaying names with percentages for clearer insights.

discover how to print in excel, using the file print option to choose active sheet or entire workbook, set orientation, margins, scaling, and page fit for clear printouts.

Explore print options in Excel, including print active sheet, print entire workbook, and print selection, and learn page setup basics like orientation, scaling, margins, gridlines, and header/footer.

Explore page layout view in excel to preview prints, adjust margins, orientation, size, print area, and header and footer.

Explore Excel templates, pre-designed files from the Microsoft community that speed up setup, support data tracking with charts and formulas, and enable custom templates for reuse.

Explore how to access and choose Excel templates via file, new, filter by planning, budgets, and charts, and save as a future template.