Mastering Excel 365: Your Complete Beginner’s Guide

Explore the basics of Excel 365 by understanding workbooks, worksheets, and cells. Learn to navigate with the cursor, edit data, and use formulas, copy, and autofill to handle grids efficiently.

Learn the fundamentals of Excel 365 by exploring workbooks and worksheets, renaming tabs, adding new sheets, rearranging tabs by dragging, and saving your file in Excel format.

Explore worksheets within a workbook, learn to rename, add, hide, unhide, move, and color-code sheets to keep your Excel 365 projects organized.

Explore the basics of Excel cells as containers for values, formulas, and formatting, and learn how the cursor guides actions—from selecting cells and ranges to autofill and auto-size.

Master the Excel cell, the basic unit for entering, editing, copying, and moving data, and understand how columns and rows create references like A3.

Master Excel mouse pointers to navigate and edit efficiently: learn white plus for selection, black plus for autofill, double-click edit mode, and resize arrows for columns and rows.

Select a cell to edit using typing, double-click, F2, or the formula bar; press enter to confirm or escape to revert, and formulas start with equals.

Learn to edit data in Excel quickly and accurately in Excel 365 by replacing a cell's content, editing in place, and inserting line breaks for multi-line entries.

Learn to edit Excel 365 formulas quickly, fix errors by correcting cell references, and update totals when inserting new rows.

Learn to copy and paste data in Excel 365 using right-click or Ctrl+C/Ctrl+V, then accelerate replication with the autofill tool and the drag handle that recognizes patterns and dates.

Learn to copy and paste data in Excel, including preserving formatting and using the fill handle. Discover pasting values only to keep data without formulas for reports.

Learn to use autofill in Excel to automatically enter sequences, dates, days of week, and months with the fill handle, saving time and boosting productivity.

Customize your Excel workspace to boost productivity by hiding gridlines and headings, splitting the view, freezing panes, and opening a new window to compare sheets side by side.

Customize the Excel toolbar to streamline your workflow by adding or removing commands, using undo and repeat for repetitive tasks, and learn the three-dots menu and Mac shortcut.

Create and customize buttons in Excel by enabling the developer tab, inserting a button named run, and formatting control settings, including font style, size, color, to improve workflow.

Customize Excel 365 by using the status bar for instant aggregations like sum, average, and count, and tailoring the quick access toolbar and ribbon.

Customize the status bar in Excel 365 by right-clicking the bottom bar to display totals, counts, averages, min, and max for your selected data.

Customize Excel 365’s interface by adjusting the quick access toolbar, ribbon, themes, and status bar to streamline workflow and reveal real-time insights.

Master Excel 365 formatting by navigating the format, number, and alignment panels to beautify data, with quick access via menu bar, right-click, or Ctrl+1, plus wrap text and merge cells.

Select a data range, open format cells, and adjust number formats, font, fill, borders, and alignment to format your Excel sheet and highlight the header row for a readable table.

Format numbers in Excel for dates, revenue figures, and percentages using format cells, custom date formats, thousand separators, and center alignment to create clear, professional sheets.

Align numbers, names, departments, and notes in a clean Excel panel with centered, left, or right alignment, merge cells when needed, and add color to emphasize key parts.

Master formatting fundamentals in Excel 365 by using the font panel to adjust types, sizes, styles, colors, and borders, and apply panel fills to highlight data.

Elevate your data presentation by applying panel font and font styling in Excel, using bold, italics, underlines, and color coding to highlight key numbers and improve readability.

Learn to apply panel borders in Excel to add structure and readability to tables. Outline cells, rows, or columns with customizable styles, colors, and add or remove borders as needed.

Color cells, rows, and columns with the Excel fill panel to highlight data and improve readability, using standard or custom colors and no fill when needed.

Lock cells and hide formulas with panel protection in Excel to safeguard data and share results without revealing calculations. Use the format painter to apply consistent formatting across selected cells.

Learn to lock and unlock cells, use the format cells protection, and protect the sheet with a password to prevent accidental edits and keep data safe in shared Excel workbooks.

Use the formatting toolbar to bold headers, apply italics, and center content for readability. Color-code status with green for approved and red for attention to make the sheet visually organized.

Master formatting in Excel 365 by using Format Painter to copy styles and conditional formatting with rules, data bars, color scales, and icon sets, plus paste special and transpose.

Learn to use the format painter in Excel 365 to quickly copy font size, color, alignment, and styles from one cell to others, saving time.

Learn to apply conditional formatting in Excel to highlight values greater than 1000, identify duplicates, and use color scales to visualize data distribution.

Master the paste special feature in Excel to paste values, paste formatting, and transpose data for flexible, cleaner spreadsheets.

Master data management in Excel 365 with data validation, drop down lists linked to named lists, and powerful filtering and sorting to organize and protect data.

Control data entry in Excel using data validation to restrict scores to 1–10 and dates between May 12 and May 31, preventing errors and ensuring reliable spreadsheets.

Create simple drop down lists in Excel using data validation to restrict data entry to a predefined department list, ensuring consistency, reducing errors, and enabling interactive, user-friendly forms.

Learn to create dynamic drop-down menus in Excel 365 by defining named lists and using data validation, then master filtering and sorting, including color-based sorting, to streamline data analysis.

Learn to create dynamic drop down menus in Excel 365 using named lists and data validation. Update automatically when you edit source list, keeping your data entry clean and adaptable.

Learn to filter data in Excel by selecting the full table, using the data tab filter, and choosing United States or China to focus analyses across thousands of rows.

Sort data in Excel by selecting all data including headers, then use the data tab to apply filters and sort smallest to largest or largest to smallest.

Master advanced sorting techniques in Excel 365 by adding levels for multiple criteria, including headers, and grouping rows or columns to improve readability.

Learn to sort data in Excel by selecting a range and using the data tab's sort option to organize by revenue or date.

Learn to sort rows by multiple criteria in Excel 365, first by country then by revenue, using the sort dialog and Add Level to create layered orders.

Group data in Excel to organize worksheets with collapsible sections you can hide or expand via the data tab, then ungroup to restore full visibility.

Hide and unhide columns, rows, and worksheets to control what data appears. Use header right-click or home tab visibility to reveal hidden items and tidy presentations.

Learn to hide and unhide columns and rows in Excel, keeping your sheets tidy and professional by selecting items, right-clicking, and choosing hide or unhide.

Unhide columns and rows quickly by selecting adjacent columns or rows and right-clicking to unhide. Keep your workbook organized and access all data when needed by revealing hidden content.

Hide and unhide worksheets in Excel to keep large workbooks organized; right-click a sheet tab to hide, and use unhide via the dialog box to reveal hidden sheets.

Master how to print in Excel by configuring page setup, orientation, scaling, margins, headers and footers, and sheet protection for clean, accurate, professional prints.

Master Excel print setup by selecting the correct orientation and defining the print area. Learn to fine-tune scaling, margins, and page layout to print data exactly as intended.

Learn to set up print margins in Excel 365 by choosing orientation (portrait or landscape) and applying normal or narrow presets to produce clear, well-organized printouts.

Mastering Excel 365 covers customizing headers and footers in page layout, with logos, dates, file paths, and page numbers; set print area and repeat top rows and left columns.

Learn to add headers and footers in Excel printouts via the page setup, using header and footer tabs, predefined options or custom content like page numbers, dates, and titles.

Learn to customize headers and footers in Excel printouts beyond defaults using the Page Setup header/footer tab, adding the course name, your name, dates, and page numbers on every page.

Master Excel 365 basics by learning to set print area and print titles in the page setup, defining exact cell ranges, repeating headers, and ensuring clean, professional printouts.

Explore printing mastery in Excel 365, including gridlines, headers, color options, page break order, and protection features to preserve data with read only settings, comments, and cell errors.

Protect your Excel workbook before printing to prevent unauthorised edits, by using the Review tab to enable Protect Workbook, set and store a password, and unlock when needed.

Protect individual worksheets before printing to keep data safe in workbooks with multiple sheets by using the review tab to protect sheet and set a password.

Explore Excel’s chart types and learn to craft visuals that tell your data story, from selecting data to using the insert tab and refining design, filters, and data series.

Create charts in Excel from selected data using the Insert tab, choosing column, line, or pie options to visualize trends and compare values for informed decisions.

Explore the building blocks of an Excel chart, including the data series, value axis, category axis, and legend, and learn to create visuals using insert, layout, and data labels.

Explore the main components of an Excel chart, including the chart title, the axes, data series, legend, and grid lines, and learn how they influence data presentation.

Select your data range, open the insert tab and charts group, then choose a chart type to have Excel generate a visual chart that makes data easy to read.

Master Excel 365 charts by adding, removing, and editing chart elements to tailor visuals, emphasize key data, and improve readability with clear titles and professional presentation.

Stylize Excel charts for readability with predefined styles and color schemes, and manage data with chart filters, by adding or removing series, and handle hidden data and null values.

Learn to adjust chart styles in Excel by selecting a chart, using the design tab to change chart type and colors, and tailor axes, legends, and data series for clarity.

Learn to filter chart data in Excel 365 without altering the original data, using the Select Data tool to display specific products or months.

Learn to manage Excel 365 charts by adding or removing data via the data selection settings, adjusting data sources and series, and filtering months like January to May.

Reorder data series and mix chart types for clearer visuals, then apply advanced techniques like reciprocal axes, colored bands, broken axes, tertiary axes, and average lines.

Reorder data series in Excel 365 charts to highlight key information by using Select Data, moving a series up, and applying changes for an updated chart.

Explore Excel 365's advanced chart formatting to fine-tune charts with background colors, borders, shadows, and reflection effects, while customizing data labels and axis titles for professional, report-ready visuals.

Enhance Excel 365 charts by adding axis titles, data labels, and legends; customize colors and gridlines to boost readability, clarity, and visual impact.

Master Excel 365 by understanding formulas and functions, learning cell references, operators, and brackets, and troubleshooting nested formulas to transform raw data into actionable insights and dynamic calculations.

Learn to filter chart data in Excel 365 without altering the original data, using the Select Data Source tool to display specific products, categories, or months and compare multiple series.

Master relative, absolute, and mixed references and Excel operators—plus, minus, divide, multiply, percent, ampersand, caret—along with equals, greater than, less than, and not equal.

Learn how to use cell references in Excel 365, including relative, absolute, and mixed references, to keep formulas accurate when copying across cells.

Discover the four operator groups in Excel 365 formulas: arithmetic, comparison, text concatenation, and reference operators, with examples such as +, -, *, /, ^, :, and &.

Learn to use parentheses effectively in Excel 365 formulas to control the order of operations and ensure accurate results. Group calculations with parentheses to adjust outcomes and improve reliability.

Explore built-in Excel 365 functions that speed up calculations with arithmetic and logical comparison tools. Learn basic, essential functions to automate tasks, reduce errors, and work more efficiently with spreadsheets.

master excel 365 formula skills by learning the sum, min, max, and average functions to calculate totals, extremes, and averages across cell ranges.

Explore how to access the full library of Excel 365 worksheet functions using the insert function dialog, view categorized formulas with descriptions and syntax, and apply them to your data.

Learn how to use the sum function in Excel 365 to total a range of cells quickly and accurately, whether totaling vertical columns or multiple rows.

Master min and max functions in Excel 365 to identify highest and lowest values in a data range. Learn to apply these formulas across cells using the fill handle.

Use the average function in Excel 365 to calculate means quickly. Select a range like C7:E7, press enter, and drag the fill handle to apply to other rows.

Explore the basic chart building blocks—data series, value axis, category axis, and legend—and learn how to create and customize an Excel chart with the insert tab and chart elements.

Learn to use the IF function in Excel 365 to classify student averages as pass or fail based on a simple condition, then copy the formula down the column.

Learn to use the countif function in Excel 365 to count cells based on criteria. Apply it to count scores seven or above across math, literature, and English.

Learn how to use the sumif function in Excel 365 to sum values by a condition, with a Vietnam student example and fixed ranges using dollar signs.

Explore how the subtotal function uses function_num and range inputs, ignore nested subtotals, account for hidden rows, and learn vlookup basics in Excel 365.

Master Excel 365's subtotal function to calculate sums or averages that update only for visible, filtered data, by writing the formula and selecting the appropriate function number and range.

Master the vlookup function by understanding its parameters—lookup value, table array, index num, and range lookup—and learn exact and approximate matches with absolute references.

Master how to use Vlookup in Excel 365 to find a student's score by name. Learn about the leftmost name column, table array, and using false for an exact match.

Master vlookup and its horizontal counterpart, hlookup, to retrieve data across rows, learn exact and approximate matches, and unlock seven levels of nested formulas with sum and if.

Learn to use the HLOOKUP function to search the first row and return a value from a lower row in horizontally arranged data, such as retrieving an employee's average score.

Explore common Excel error values in formulas, including division by zero, cell name, null, number error, reference, and value mismatch, and learn quick troubleshooting to diagnose and fix worksheets.

Master nested formulas in Excel 365 by combining average and if to classify students as good or not good based on average scores in math and literature.

Learn to diagnose common excel display errors from incorrect data or unexpected formula results. Wrap formulas with the iferror function to replace errors with no result.

Explore real-time collaboration with shared workbooks, import external data, and master tools like text to columns, split window, freeze pane, pivot tables, and pivot chart, plus macros.

Discover how to share an Excel workbook with colleagues, set permissions, add users, and send a personal message to enable real-time collaboration.

Enable the share workbook feature to collaborate on the same Excel 365 file. Add the command to the quick access toolbar and allow changes by multiple users.

Import data from files into Excel 365 with Get Data, preview, and load into your worksheet; transform the data and choose table, pivot table, or pivot chart.

Import data from external sources in Excel 365 using Get Data from the data tab to load a workbook's sheet and avoid manual input errors.

Mastering Excel 365 teaches how to split a single column into multiple columns using text to columns, with delimited or fixed width options and comma, space, or tab delimiters.

Master Excel 365 by using text to columns to split full names into first and last names, choose delimited with space, and prepare data for reporting and analysis.

Master the split window and freeze pane features in Excel to view multiple areas of a large dataset, scroll each pane independently, and keep headers or key columns visible.

Master the split window in Excel 365 to view headers and data simultaneously, adjust four panes from the view tab, and boost data comparison, accuracy, and productivity.

Learn to use freeze panes in Excel 365 to keep headers and key identifiers visible while scrolling, by freezing the first column or a row via the view tab.

Understand how split window and freeze panes enhance Excel 365 data navigation. Scroll independently with split windows and keep headers visible with freeze panes.

Master pivot tables in Excel 365 to quickly summarize, analyze, and visualize large data sets, using filters, regions, and max summarization for data driven decisions.

Learn to create pivot tables in Excel 365 to summarize, filter, and analyze large data sets, organizing fields into rows, columns, and values for insights.

Learn to create a pivot table in Excel 365 to filter, summarize, and compare large data sets by dragging fields into rows and values.

Discover how to change pivot table data summarization in Excel 365 by adjusting the value field, selecting sum, count, or average, and arranging region in rows for insights.

Identify maximum transaction value with a pivot table in Excel 365, drag names to rows, add transaction amount to values, and set the summary to max to reveal top performances.

Select a cell in the pivot table and open the PivotTable Analyze tab in Excel 365. Enable the classic layout and format values as percentages using Value Field Settings.

Master macro recording in Excel to automate repetitive tasks using VBA, then save and replay actions—like applying conditional formatting to highlight values over 100 in seconds.

Learn how to use macros in Excel 365 to record formatting steps—such as borders, column widths, and number formats—and replay them with one click across sheets and workbooks.

Learn how to use Excel macros in 365, including recording actions, managing macros in the View tab, naming macros, assigning shortcuts, adding descriptions, and understanding security measures blocking macros.

Record a macro in Excel 365 to automate formatting with one click. Name the macro, assign a shortcut, start from the view tab, format, and stop recording to reuse later.

Run a previously recorded macro in Excel 365 to apply formatting quickly and consistently, selecting the macro from the view tab and clicking run.

Boost your Excel efficiency by mastering keyboard shortcuts, from f1 help to ctrl a and ctrl v, and navigate data quickly with the data range jumper.

Improve your Excel 365 efficiency by mastering essential keyboard shortcuts that replace mouse clicks, enabling faster formatting and common tasks. Practice keystrokes, such as Ctrl+B for bold, to streamline workflows.

Master essential Excel 365 navigation and editing shortcuts, from returning to A1 and the last data to switching between workbooks and using built-in help.

Explore how the F1 key opens the Excel 365 Help Hub for official tutorials and tips. Learn to search topics like formatting and charts to boost productivity.