Complete Microsoft Excel with AI – Beginner to Advanced

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.

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 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.

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.

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.

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.

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 hide and unhide columns and rows in Excel, using right-click and the home format visibility tools, and recognize hidden versus deleted data.

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.

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.

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.

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.

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.

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.

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 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.